SQL Developer
Resume:
Naga Divya Mundru
adqbdd@r.postjobfree.com
Objective:
To obtain a challenging position as BI Developer that would increase business productivity of the organization & in turn enhance my skills & competency.
Professional Summary:
Over 7 years of Experience in Data Warehousing and Business Intelligence applications design, development and maintenance of Integration services (SSIS), SQL Server Reporting Services (SSRS).
Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2005/2008/2012/2016.
Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T-SQL, relational database models, data dictionaries, and data integrity.
Strong ability in creating SQL server Reports using SSRS 2005/2008/2012/2016.
Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
Technical Skills:
Business Intelligence Tools : SQL Profiler, SSRS, SSIS, SSAS, Informatica Power Center 9.6.1, Tableau
Programming Languages : T-SQL, PL-SQL, C/C++
Applications : MS Excel, MS Access, MS Office
Operating System : Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS
Databases : MySQL, MS SQL Server 2005/2008/2012/2016 and Microsoft Access
Testing Tools : Visual Studio.Net
Experience:
Client: LUMEN, Dallas, TX July 2021 – Present
SQL Developer
Responsibilities:
Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team, and Development team.
Experience in the database design process and data modeling process.
Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
Create SSIS packages that involved a variety of transformations such as Slowly Changing Dimension, lookup, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
Develop, Code Review, fixed bugs, test, and deploy SSIS packages using SQL Server 2016/2014/2012/2008 Business Intelligence Development Studio.
Gathering Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge, and Subscription reports.
Developing reports with consistent drill-down functionality including Drilldown report and Summary report.
Part of the Agile/Scrum team and participated in Standup, grooming, planning, and retrospective meetings.
Designing logical and physical data models for star and snowflake schemas using Erwin.
Develop and modify triggers, packages, functions, and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
Wrote SQL, PL/SQL, SQL plus programs required to retrieve data using cursors and exception handling.
Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Built complex queries using SQL and wrote stored procedures using PL/SQL.
United Health Group, Hyderabad, India Oct 2019 – Feb 2021
Reporting Analyst
Responsibilities:
Worked on an up-gradation Project, which involves upgrading the existing SQL 2008 SSRS reports to 2016.
Design and develop stored procedures, queries and views necessary to support SSRS reports
Develop new reports and perform maintenance of existing reports
Worked closely with the onshore team in finding solutions to arising problem
Deploy and schedule reports using SSRS to generate all daily, weekly and monthly reports
Worked on Consolidation project (Consolidating SSRS reports based on business)
Responsible for ongoing maintenance and change management to existing reports and Optimize report performance in SSRS-2008.
Modified existing dashboards as per new requirements in Power BI.
Recreated reports from MS Excel to Power BI.
Developed analytics solutions by defining and translating business requirements into dashboard &reporting solutions and implementing them within Microsoft Power BI Desktop and visualizations
Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
Involved in dealing with the backend data retrieval team, data mart team to guide the proper structuring of data for Power BI reporting.
Added required measures, calculated columns, keeping unnecessary columns hidden from reporting view in Power BI application.
Worked and joining the queries and merging the tables in Power BI.
Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel
Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
Generated Monthly, Yearly, Quarterly and daily reports in Power BI.
Responsible for SQL Query performance tuning/ Optimization.
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
Worked on delivering the Production reports on daily basis.
Worked on an upgradation Project, which involves the existing SQL 2012 SSIS to 2016.
Worked on generating dashboards in Tableau server using various data sources.
Employer: TEKsystems India, Hyderabad, India July 2019 – Sep 2019
Client: United Health Group
Reporting Analyst
Responsibilities:
Worked on an up-gradation Project, which involves upgrading the existing SQL 2008 SSRS reports to 2016.
Design and develop stored procedures, queries and views necessary to support SSRS reports
Worked closely with the onshore team in finding solutions to arising problem
Deploy and schedule reports using SSRS to generate all daily, weekly and monthly reports
Responsible for ongoing maintenance and change management to existing reports and Optimize report performance in SSRS-2008
Responsible for SQL Query performance tuning/ Optimization.
Worked on delivering the Production reports on daily basis.
Client: Community Care of North Carolina, Raleigh, NC July 2018 – Feb 2019
ETL/BI Developer
Responsibilities:
Design, develop and Unit Test ETL processes as applicable.
Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
Work with the Data Development and Database Administration teams to analyze and debug issues with ETL processes and apply fixes adhering to operating environment practices.
Create design specifications (High level and Low-Level Design documents and enhance Physical data Models as required).
Critically analyze batch processing performance and suggest improvements where appropriate.
Participate in peer code review sessions and document code and design artifacts as necessary.
Create SSIS package configurations, involved in SSIS performance, SSIS logging/audits, SSIS transformations, and SSIS debugging/troubleshooting.
Collaborate with Quality Analysts on system, performance and user acceptance testing as well ITIL team members on release and change management as required.
Responsible for SQL Query performance tuning/ Optimization.
Client: DentaQuest, Milwaukee, Wisconsin June 2016 -July 2018
SQL/BI Developer
Responsibilities:
Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
Created SSIS packages for File Transfer from one location to the other using FTP task.
Worked on a up-gradation Project, which involves upgrading the existing SQL 2008 SSIS packages to 2016 SSIS packages.
Developed utility libraries for database access using ADO.Net, file storage and logging using data stream, and notifications using SMTP clients.
Developed C#.NET scripts for SSIS packages.
Exposure to Informatica B2B Data Exchange that allows to support the expanding diversity of customers and partners and their data with capabilities that surpass the usual B2B solutions.
Worked with the B2B Operation console to create the partners, configure the Partner management, Event Monitors and the Events.
Exposure to Informatica B2B Data Transformation that supports transformation of structured, unstructured, and semi-structured data types while complying with the multiple standards which govern the data formats.
Used major components like Serializers, Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats.
Extensively used Informatica Power Center 8.6 to extract data from various sources, which included Flat files, Sql server, Oracle, Ms-Access and XML.
Extensively used Informatica Client tools-Designer, Workflow Manager, Workflow Monitor and Repository Manager
Developed ETL mappings industry healthcare standards.
Involved in creating Mappings using Mapping and Session Parameters in the mappings and workflows to eliminate hard coding wherever possible.
Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Table, Matrix etc.) in Power BI according to the requirements.
Created Page Level Filters, Report Level Filters and Visual Level Filters in Power BI according to the requirements.
Extract transform, and load data using Power BI, Power Query, SQL.
Developed custom reports and deployed them on server using SQL Server Reporting Service (SSRS).
Good knowledge in creating Drill-down, Parametrized and Sun-Reporting using RDL.
Environment: MS SQL Server 2008, SSRS 2008, Informatica Power Center 9.6.1, Infomatica B2B, Data Transformation studio 4.0, MS Access, SSIS, C#, .NET, Windows 8 Professional
Horizon Advanced Systems, Dallas, TX June 15 – May 2016
MS BI Developer
Responsibilities:
Created SQL server Analysis Projects using MS SQL Server 2012.
Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
Good knowledge in creating Drill-down, Parameterized and Sub-Reports using RDL.
Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
Responsible for Query optimization and Performance tuning.
Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
Dulles Geotechnical Materials and Testing Services, Richmond, VA Mar 15- May 15
Staff Engineer
Responsibilities:
Provided preliminary geotechnical recommendations for foundation designs, pavement foundations and ground improvement techniques as a consultant for TAXIWAY “M” RELOCATION-RIC project in Richmond area.
Preparing project reports and geotechnical recommendations for the clients.
Enter the soil sample and survey results, including shape, location, elevation, and land features into database by writing queries.
Created reports that helped in analyzing the soil strength from the data entered by the surveyors in the system.
Graduate Assistant, Office of Financial Aid Jan13 - Dec 14
Cleveland State University, Ohio
Imaging, indexing and document management using On Base (Enterprise Content Management System).
Creating and editing various forms using Microsoft Publisher.
Update and maintain billing records and documentation everyday.
Generated reports that helped in analyzing the student intake for every semester, the number of students opted for course.
Generated financial reports for the departments to check the available funds for scholarships or any kind of financial aid.
Education:
MS, Civil and Environmental Engineering, Cleveland State University, Cleveland, Ohio, GPA 3.8/4.0 - 2014
B.E, Civil Engineering, Osmania University, India, GPA3.8/4.0 – 2012
Contact this candidate