HARITEJA MADHUKURI
Dover
Summary
Having 8+ years of experience in Information Technology with regards to development and implementation. Experience the concepts like SDLC and RDLC in real time projects/stories. Experience in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert. Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling. Extensive experience in designing and developing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries and Dynamic SQL queries etc. Experience with Database Management (RDBMS) concepts and expert knowledge of designing relational Databases according to business requirements. Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL. Worked on the design of star and snowflake schemas. Experience in BI Development and Deployment of DTS, SSIS packages from T-SQL, MS-Access, Excel. Expertise in Performance tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations, Optimization, Data integrity and Statistics by using SQL Profiler. Involved in developing the .Net scripting in SSIS. Worked on SSRS and Tableau reports and Expertise in What-If Analysis using Excel, Power Pivot Reports and Drill through Dashboards using Warehouses and OLTP Connections. Excellent knowledge in creating Databases, Tables, Stored Procedure, SQL Joins, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL. Experienced in interacting with stakeholders/customers, gathering requirements through conversations, and workshops. Good at collaboration and interpersonal skills and can work as individual as well as a team player. Gathering and analyzing business requirements, work with technology team to recommend and implement best approaches to deliver business solutions. Defining business processes, identifying, and analyzing risks using appropriate templates and analysis tools along with operating procedures.
Overview
10
10
years of professional experience
Work History
Technical Lead
Vidhwan Inc dba E-Solutions
06.2021 - Current
- Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan
- Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
- Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support
- Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc
- Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files
- Developed data model, SQL Coding, SQL Query tuning process and Schemas
- Customers provide us the information through System One and from there data will get loaded into our database tables through the ETL packages that were scheduled to run every night
- Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages
- Used Configuration Files in SSIS to ease the process of moving the packages across servers
- Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column
- Developed packages in SSIS with error handling
- Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations
- Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages
- Created Package Configurations to deploy packages from development to production server
- Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in SQL Reporting Services (SSRS)
- Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS)
- Creating SSAS cubes using both Tabular model and Multidimensional model to analyze data from different sources
- Worked extensively on Creating, designing, and developing data models
- Also developed and prepared a schedule for a new data warehouse
- Prepared plans for all ETL (Extract/Transformation/Load) procedures and architectures
- Experienced in Monitoring and tuning data loads and queries prior to production deployment to avoid performance issues
- Analyzed large databases and recommend appropriate optimization for the same
- Administered all requirements and design various functional specifications for data
- Evaluated all codes and ensured that the quality of all project deliverables
- Monitored data warehouse work and provide subject matter expertise
- Worked on new reporting tool BIRST for creating templates and Subscriptions for different customers based on the requirements from the customer
- Used the tool BIRST to create, generate and distribute the reports to the customers which includes both Standard Report Templates and Custom Report Templates
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements
- Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
- Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning
- Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
- Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
- Created Regression test scripts to validate the results and created the test cases
- Tested the code by writing re-usable Unit Testing Scripts and TDD Scripts
- Worked with the customers to understand their report requirement and created Business Requirements Document (BRD) based on their expectations and also updated ALM (Application life cycle management) tool with the business requirements before starting the development
- Extensively Used Informatica Designer as an ETL tool to extract data from legacy source Disability Reporting System (DRS) to Target system
- Extensively worked on migration project where we migrated all the data from Liberty to Lincoln which involves SQL Server migration from 2016 to 2019
- Worked on migrating the ETL packages to Lincoln where we have various types of packages such for S1(System One) ETL, Claims, Leaves, Billing Center, Sybase etc
- Used Visual Studio 2017 & 2019 to build Report RDL’s using SQL Server Reporting Services and to create/modify ETL packages using SQL Server Integration Services
- Also Used Visual Studio for Code Check-in, comparing and merging the code to GIT
- Worked on GIT Lab for maintaining Code and did daily code check-ins by creating branches and merged branches to master branch post deployment
- Trained on migrating the SQL data using transactional replication and in AWS DMS (database migration services) and validating the source and destination tables by creating the tasks to validate them
- Trained in AWS S3 and EC2 instances and storing the data
- Worked on TFS version control to check-in the code and have used the merging branch techniques
- Also used GITLAB after post Integration
SQL BI Developer
Business Intelligence Solutions Inc
03.2019 - 06.2021
- Programming and implementing new functionality for Liberty Mutual Insurance software applications including design, design reviews, coding, code reviews, unit testing, and configuration/release management
- Primary responsibilities include writing Stored Procedures, Packages, Triggers, Ad-hoc queries, Process documentation
- Troubleshoot and optimize the performance of Stored Procedures and Packages
- Develop technical designs, specifications and other project artifacts
- Participate as a member of Project Development team to develop functional and technical specifications
- Developing SQL Server based applications using industry standards, specifically SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Analyzes business processes, workflow, database requirements, user requirements and existing business application functionality
- Design, develop and test the solution to ensure the data loads from source to target adhering to the standard requirements and adhering to, support and continuously improve processes
- Perform root cause analysis on all processes and resolve any production issues and validate all data and perform routine tests on all interfaces and provide support to all applications Providing detailed effort estimates to team and project managers
- Performing peer code and design reviews
- Developed Automation using SSIS Packages to extract data from various sources using CSV, Excel and Text file from Client servers and through FTP
- Created the Debug, Unit and regression test scripts to validate the results and to create the test cases
- Deployed the reports and SSIS packages in Dev and QA environment as well as created the deployment document for deploying the reports and the SQL code in staging and production environment
- Worked in Agile methodology, attended daily scrum meetings, updated the status on User Stories and provided story point estimation for user stories and hours for tasks
- Worked on the New Reporting Tool BIRST for subscriptions for many number of customers in a simpler manner
- Maintained the ALM (Application Life Cycle management) Tool for Business level requirements and for preparing notes for development
- Created SSRS reports based on the client requirements and scheduled meetings for producing Test cases based on the business requirement
- Created simple and complex stored procedures at Batch level processing for multiple subscriptions based on the requirement
- Actively participated in Methodologies like Scrum (Daily stand ups to give the progress of the work for the week) and Sprint for two weeks and Agile monthly
- Scheduled meetings with business lead to get the requirements for the stories to be done and maintained JIRA Dashboard to track the status of the work, capacity of the team and Burn down charts
Application Developer (SQL Server)
TechnoVision Solutions LLC
06.2018 - 03.2019
- Programmed and implemented new functionality for Liberty Mutual Insurance software applications including design, design reviews, coding, code reviews, unit testing, and configuration/release management
- Primary responsibilities include writing Stored Procedures, Packages, Triggers, Ad-hoc queries, Process documentation
- Troubleshoot and optimize the performance of Stored Procedures and Packages
- Developed technical designs, specifications and other project artifacts
- Participate as a member of Project Development team to develop functional and technical specifications
- Developing SQL Server based applications using industry standards, specifically SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Analyzes business processes, workflow, database requirements, user requirements and existing business application functionality
- Design, develop and test the solution to ensure the data loads from source to target adhering to the standard requirements and adhering to, support and continuously improve processes
- Perform root cause analysis on all processes and resolve any production issues and validate all data and perform routine tests on all interfaces and provide support to all applications Providing detailed effort estimates to team and project managers
- Performing peer code and design reviews
- Created the Debug, Unit and regression test scripts to validate the results and to create the test cases
- Deployed the reports and SSIS packages in Dev and QA environment as well as created the deployment document for deploying the reports and the SQL code in staging and production environment
- Worked in Agile methodology, attended daily scrum meetings, updated the status on User Stories and provided story point estimation for user stories and hours for tasks
- Worked on the New Reporting Tool BIRST for subscriptions for many numbers of customers in a simpler manner
- Maintained the ALM (Application Life Cycle management) Tool for Business level requirements and for preparing notes for development
- Created SSRS reports based on the client requirements and scheduled meetings for producing Test cases based on the business requirement
- Created simple and complex stored procedures at Batch level processing for multiple subscriptions based on the requirement
- Actively participated in Methodologies like Scrum (Daily stand ups to give the progress of the work for the week) and Sprint for two weeks and Agile monthly
- Scheduled meetings with business lead to get the requirements for the stories to be done and maintained JIRA Dashboard to track the status of the work, capacity of the team and Burn down charts
Programmer Analyst (Data Base)
Damian Consulting Inc
05.2017 - 06.2018
- Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data
- Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area
- Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database
- Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages
- Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code
- Created SSIS Packages to integrate data coming from Text files and Excel files
- Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio
- Created SSIS packages to validate, extract, transform and load data to data warehouse databases
- Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column
- Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent
- Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
- Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks
- Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions
- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
- Created different Power Pivot reports as per the client requirement
- Experience in creating Multidimensional cubes using SSAS and designing DW schemas
- Worked on Filtered Views, views and Base table integration between different Source systems
- Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts
- Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis
- Document new SSIS packages and Train Senior Analyst on basic SSIS concepts
- Interacted with vendors, developers and customers to manage the business requirements
- Verified business requirements and functional specifications.
Programmer Analyst (Back End)
Sri Software Solutions
01.2017 - 04.2017
- Developed complex Stored Procedures and views by using T-SQL to generate various Drill-through reports, parameterized reports and linked reports using SSRS
- Developed, deployed, and monitored SSIS Packages
- Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and also defined roles and privileges to implement business rules and control access to database
- Worked with internal departments to provide associated deliverables required for successful completion of development and maintenance assignments
- Gathers user requirements and translates them into functional application units
- Works with central Web Team, internal content owners, or external contractors to develop application solutions
- Writing and modifying application code in a variety of languages (.Net Stack – C# and SQL Server mainly), following department procedures and standards
- Assisting in design and development of new database, troubleshoot programming problems, reading and interpreting application code
- Maintaining all source code in centralized source code management tool
- Developing and maintaining quality procedures and documentation
- Installed, configured, managed and monitored SQL Server 2008/ 2012 in development and QA environments
- Involved in performance tuning and writing stored procedures, triggers based on the business requirement using SQL Server
- Scheduled jobs daily through SQL Server Agent and once data are good then the data is sent to the production
- Reviewed & Tested packages, fixing bugs using SQL 2012 Business Intelligence Development Studio.
Programmer Analyst (Back End)
Glorian Inc
08.2016 - 12.2016
- Installed, configured, managed and monitored SQL Server 2008/ 2012 in development and QA environments
- Involved in performance tuning and writing stored procedures, triggers based on the business requirement using SQL Server
- Scheduled jobs daily through SQL Server Agent and once data are good then the data is sent to the production
- Reviewed & Tested packages, fixing bugs using SQL 2012 Business Intelligence Development Studio
- Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML
- Automation of all SSIS package/project deployments via SQL scripts to minimize the human errors
- Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process
- Extracted the data and transformed them by using different transformations based on the business demand in SSIS
- Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environment
- Extracted Data by Power Query from external sources and modified the data based on the required format in excel and created SSIS packages to load excel sheet from PC to database
- Deployed the reports and SSIS packages in Dev and QA environment as well as created the deployment document for deploying the reports and the SQL code in staging and production environment
- Worked in Agile methodology, attended daily scrum meetings, updated the status on User Stories and provided story point estimation for user stories and hours for tasks
- Use various latest tools from SQL Server 2016 like Query store, live query statistics, SQL trace, Profiler, DB Engine tuning wizards to help maintain the SQL Server health and boost the performance by optimizing/refactoring the legacy code to provide faster and better results to business entities
- Created SSRS reports based on the Customer’s specifications and created dashboards and visualized the data in such a way that the customer is satisfied and deployed the reports in the report server
- Created various technical documentation, Business requirement gathering, and analyzed data, developed and built SSIS Packages and SSRS reports
- Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database
- Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports
- Responsible for Creation and Maintenance of Analysis Services objects such as cubes, dimensions.
SQL Server Developer
Innovation Communication Systems Ltd
08.2013 - 12.2014
- Developed complex Stored Procedures and views by using T-SQL to generate various Drill-through reports, parameterized reports and linked reports using SSRS
- Developed, deployed, and monitored SSIS Packages
- Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and also defined roles and privileges to implement business rules and control access to database
- Developed back-end routines using SQL, PL-SQL, and Stored procedures, Packages to check data integrity
- Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area
- Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database
- Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages
- Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code
- Created SSIS Packages to integrate data coming from Text files and Excel files
- Interacting with Onsite people, Taking clarifications regarding applications
- Analyzing the requirements and discussed with managers and leads on the functionality
- Involved in Creation of database, tables, stored procedures, triggers, and user defined functions for dealing with Employer’s data
- Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation
- Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting
- Tested and analyzed relational and OLAP data
- Enforced different business constrains and rules using triggers and check constraint.
Education
Master of Science -
State University of New York (SUNY)
New Paltz, NY05.2016
Bachelor of Technology -
Jawaharlal Nehru Technological University Hyderabad
04.2014
Skills
- SQL Server 2008/2012/2016/2017
- C
- C#
- ASPNET
- MSBI 2008 (SSIS and SSAS)
- SQL Server Reporting Service (SSRS)
- Excel Power pivot
- Power BI
- Microsoft Azure
- Tableau
Timeline
Technical Lead
Vidhwan Inc dba E-Solutions
06.2021 - Current
SQL BI Developer
Business Intelligence Solutions Inc
03.2019 - 06.2021
Application Developer (SQL Server)
TechnoVision Solutions LLC
06.2018 - 03.2019
Programmer Analyst (Data Base)
Damian Consulting Inc
05.2017 - 06.2018
Programmer Analyst (Back End)
Sri Software Solutions
01.2017 - 04.2017
Programmer Analyst (Back End)
Glorian Inc
08.2016 - 12.2016
SQL Server Developer
Innovation Communication Systems Ltd
08.2013 - 12.2014
Master of Science -
State University of New York (SUNY)
Bachelor of Technology -
Jawaharlal Nehru Technological University Hyderabad
Similar Profiles
Juretta ColemanJuretta Coleman
Patient Access Representative at Vidhwan IncPatient Access Representative at Vidhwan Inc
Baldomero GonzalezBaldomero Gonzalez
Public Sector Manager at UBEO Business Services Dba Core Business SolutionsPublic Sector Manager at UBEO Business Services Dba Core Business Solutions
Brian MoffettBrian Moffett
President- Fluid Power and Systems at Process Control Solutions, LLC dba Impact AutomationPresident- Fluid Power and Systems at Process Control Solutions, LLC dba Impact Automation