SUMMARY

• 7+years of Professional experience as an ETL Developer working on SQL server, Business Intelligence tools, Database Design, Data Modeling and Data warehousing projects. Worked extensively on SQL server management studio, SQL server 2017/ 2016/2014/2012/2008 R2 and BI tools such as SSIS, SSRS, SSAS, Power BI and tabular data modeling including MS solutions like MS EXCEL., DB2, and MS Access Database.
• Proficient in designing ETL package using the methods for slowly changing dimensions type 1, 2, and 6.
• Strong in Design and develop ETL and Data Quality mappings to load and transform data from source to DWH using PowerCenter.
• Worked on all aspects of the ETL pipeline, as well as aggregated and reported on operational system metrics, using Microsoft BI stack like SQL Server, SSIS, SSRS and SSAS.
• Expertise in building complex ETL packages using varied and complex data sources and merging them into a single data model.
• Publishing Power BI Desktop reports created in Report view to the Power BI service.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals
• Skilled in project management using the Jira Ticketing tool.
• Complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS.
• Experience in Optimizing Cubes using SQL Server Analysis Services (SSAS).
• Strong in database creation, maintenance, monitoring, backups and recoveries using SQL Server Agent , Import/Export Wizard and Maintenance Plans.
• Advanced reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross - Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Transform data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Proficient in gathering Business Requirements from business stakeholders, analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining.
• Exceptional leader with excellent interpersonal skill, communication finesse and Team management skill with strong expertise in analyzing the requirements and preparing the specifications document based on the requirements.

TECHNICAL SKILLS

RDBM/Databases: MSSQL Server 2016/2014/2012/2008 R2, Oracle 8i & 9i, MS Access, Microsoft Azur

Programing Languages: T-SQL, PL/SQL, C, MDX, Python, C

Data Modeling: FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling and De-Normalization Techniques

BI Tools: Visual Studio (SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), SQL Server Reporting Services (SSRS)), Microsoft Power BI, Power Pivot, Power View, Power Query, Power Map, Tableau.

Tools/Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, Visual Studio Team Foundation Server (TFS).

Application Packages: MS Office, Microsoft SharePoint Server (MOSS)

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Data Engineer/MSBI Developer

Responsibilities:

• Developed and modified ETL processes and workflows that load data for the data warehouse using ETL tools (transitioning from SSIS to Azure integration technologies) and SQL code.
• Built robust and scalable data integration (ETL) pipelines using SSIS, T-SQL, and C#
• Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.
• Interfaced with other technology teams to extract, transform, and load data from a wide variety of data sources.
• Performed database testing on data warehouse by using complex SQL queries in SQL Server to validate data.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Performed loading and transforming of large sets of structured, semi structured and unstructured data
• Developed and designed the different visualization charts like line charts, Pie charts, Maps, Tiles, Cards, Images, Tables, Bubble and Scatter Plots, Key Performance Indicators using Power BI.
• Used Power BI with DAX for developing reports and KPI’s for the organization and departments.
• Involved in requirement gathering for the Power BI dashboards and help end user understand the feasibilities in the reports.
• Created data modeling (ER Diagrams), designed mockups and object class modeling to develop business architecture for rapid and controlled application development.
• Built / supported Health Claims Data Warehouse
• Participated in designing and development of software using agile development practices
• Implemented code check-in/check-out and managed multiple versions of complicated code within GIT.
• Created technical documentation and code comments based on industry standards.
• Used different transformations like SFTP Task, Script task, Fuzzy Lookup, Derived column, File System Task, Conditional split, Multicast transformation, pivot etc., using SSIS.

Environment: SQL Server 2017, SSIS, SSRS, SSAS, Visual Studio 2017/2015, GIT, T-SQL, Import/ Export Tools, MDS, DQS, Power BI, MS Access.

Confidential, MN

MSBI Developer

Responsibilities:

• Worked on creating dimensional models using star schema and snowflake schema.
• Designed Facts and Dimensions that supports the business requirements and reporting needs.
• Created ETL packages with different data sources (SQL Server, Oracle Source, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
• Worked on Creating SSIS Packages to load the files from SFTP Path on daily basis.
• Created SSRS inventory management reports, focused on findings to save company millions of dollars in Client members Performance Health management by providing Incentive, Claims, Biometrics file feeds.
• Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses (since stored procedures passes the whole block at one time).
• Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer.
• Created a job to send the HL7 files to the clients as per the changing requirements.
• Worked on Creating, Modifying and updating the Views and Functions.
• Modified the existing stored procedures to get the new functionality depending on the client requirement.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Worked on Views, CTE's, schemas, permissions issues with client/server database design.
• Written Calculated Columns, Measures, and Queries in Power BI desktop and also Tabular model to show good data analysis techniques.
• Worked on creating Power BI Dashboards using tabular model.
• Data Visualization development using Tableau to create complex, and innovative dashboards.
• Notify admin team for changes in user, user groups, and scheduled instances for reports in Tableau reports.
• Migrated SSRS Reports from Reporting Server 2012 to 2017
• Created and Deployed reports using SSRS and configuring the SQL Server Reporting Server

Environment: SQL Server 2017, SSIS, SSRS, SSAS Visual Studio 2017/2015, TFS (2015).

Confidential

ETL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in Development and Production environment for SQL Server 2008R2.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Defined relationship between tables and enforced referential integrity.
• Created Power BI reports and Dashboards based on the requirement of the client.
• Worked on troubleshooting, resolving, and escalating Power BI issues
• Implemented Database design and Administration of SQL based database.
• Established connectivity to database and monitored systems performances.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Performance tuning and monitored both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data & worked extensively in T-SQL for various needs of the transformations while loading the data.
• Participated in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.

Environment: SQL Server 2008R2, Windows server, Enterprise Manager, SQL Profiler, SQL Query Analyzer, DTS, T-SQL.

Confidential

SQL Developer

Responsibilities:

• Efficient response to database events in a production environment & performance monitoring in cluster administration of mission critical databases for SQL Server
• Provided the application support 24/7 to the applications and delivered enhancements and customizations
• Identified and resolved database performance issues, database capacity issues.
• Performed the Backup and Restore
• Maintained database consistency with DBCC at regular intervals
• Ensured all database environments (Development, Staging, QA and Production) are in sync
• Maintained High Availability such as Log Shipping, replication and Mirroring as a database disaster recovery technique
• Created Database Maintenance Plans for the Performance of SQL SERVER, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Applied latest and greatest service packs in SQL Server

Environment: SQL Server 2005 / 2008 with clustering, T- SQL, Windows 2003, BCP, Enterprise manager, Query Analyzer, Replication, Mirroring, Log shipping