PROFESSIONAL SUMMARY:

• Over 9 years of extensive experience in IT that includes Database/BI Development and support.
• Extensive experience in analyzing, designing, and developing database applications, reports, data analysis using MS SQL Server, Azure Data factory (ADF), SQL Server Integration Services, SQL Server Reporting Services; and SQL Server Analysis Services (SSIS, SSRS, SSAS).
• Experience in Data Extraction and Transforming and Loading (ETL) using Azure data factory (ADF), SSISpackages to manageSQL Serverdatabases andSQL Serverobjects between instances ofSQL Server
• Strong in SQL Server DDL, DML skills with understanding of writing efficient queries and troubleshooting complex queries
• Expertise in Enterprise Reporting includes generating reports using linked reports, sub reports and filters, charts in SQL server reporting services (SSRS).
• Created Worksheets using Window function, playback functionality, Data Blending and Conditional Formatting. Expertise in generating reports using SQL Server Reporting Services (SSRS) and MS Excel spreadsheets and Power Pivot.
• Proficiency in creating different types of reports such as Parameterized, Cascaded, Dynamic, Linked, Drill - through, Drill-down reports, Sub reports and formatting them using SSRS.
• Worked on Informatica PowerCenter10.2/9.5 to create new mappings, variable and parameter and workflows.
• Expertise in writing complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs) etc.
• Experience in tuning the performance of stored procedures and large T-SQL Queries using Clustered indexes, and database activities like maintenance and performance monitoring and tuning using tools such as Index Tuning Wizard, SQL Profiler and other troubleshooting and monitoring tools.
• Experience in Data Marts, Data warehouse, Data Modelling like Dimensional Data Modelling, Star Schema Modelling, Snowflake Modelling, FACT and Dimensions Tables, OLTP Relational Schema and OLAP Dimensional Modelling, process/data modelling using Erwin.
• Develop Reports using Microsoft Power BI.
• Trained and having thorough knowledge on JAVA.
• Great at working and coordinating with the Developers, Requirements analysts and Users, onsite-offshore coordination.
• Excellent interpersonal communication skills and technical documentation skills.
• Exceptional ability to quickly master new concepts and capable of working in teams as well as independently.

TECHNICAL SKILLS:

Databases: Azure SQL, MS SQL Server 2016,2014,2012, 2008, Oracle DB, Teradata

Data extraction, cleansing, transformation and loading: Azure Data factory (ADF), SQL Server Integration Services (SSIS), SQL Server Analytic Services (SSAS), DTS, Informatica.

Business reporting: SQL Server Reporting Services (SSRS), Tableau, Power BI and excel based Ad-hoc reporting

Operating Systems: Win 8/7/XP/2003/2000 MS DOS.

Miscellaneous: Toad, Visual Studio, MS-Office, Excel and extractor, Jira, Migration Tool, Java

Languages: MS SQL, PL/SQL, T-SQL.

PROFESSIONAL EXPERIENCE:

Confidential, NC

Sr. ETL/SQL Developer (Cyber Security)

Responsibilities:

• Developing Azure Pipelines using Data movement data transformation logical activity.
• Created many types of Linked services and Integration runtime (IR).
• Created and schedule Triggers.
• Created Mapping Dataflow activity.
• Migrated cloud Files to SQL Database.
• Involved in designing and creating Tables, Views, complex Stored Procedures, and Indexes using T-SQL.
• Wrote stored procedures and User Define Functions (UDFs) to be used in the ADF and SQL scripts.
• Creating and maintaining/modifying T-SQL queries, tables, views, stored procedures, and functions that are required for front end business logic

Confidential, Atlanta, GA

Sr. ETL/SQL Developer

Responsibilities:

• Developing SSIS Packages using Control flow task, Dataflow task, Sequence container, Look Up Values & implementing rules provided by Business in the mapping document.
• Creating and scheduling SQL Server agent jobs and alerts for daily, weekly, monthly.
• Worked on SSIS package Migration Process from SQL Server 2008 to SQL Server 2012.
• Involved in modifying existing SQL Server objects like Tables, Views, Functions, stored procedures.
• Involved in designing and creating Tables, Views, complex Stored Procedures, and Indexes using T-SQL.
• Wrote stored procedures and User Define Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Creating and maintaining/modifying T-SQL queries, tables, views, stored procedures, and functions that are required for front end business logic
• Created Clustered indexes and Non-Clustered indexes and optimized queries using an execution plan.
• Creating and scheduling SQL Server agent jobs and alerts, scheduled reports for daily, weekly, monthly.
• Communicating with various users’ groups, research teams, and Business Intelligence teams to gather information for the requirements.
• Developing DATA MOVEMENT ENGINE(DME) dynamic Packages for ETL purpose to implement rules provided by Business in the mapping document.
• Production Support worked on Bus tickets, Data Migration, and Employee System Mapping.

Confidential, VA

Sr. SQL/Informatica Developer

Responsibilities:

• Supported business users with loading Medicaid and Medicare data files into Oracle DB
• Data file is loaded into tables using Informatica and generic data validation rule are applied
• SQL scripting is used to cleanse data as per the business rules which varies with the data stream
• Validate the output from above steps
• Migrate the validated data set to Prod system.
• Provided an assistance in developing solutions that meet the business requirements.
• Worked on Informatica PowerCenter to create new mappings, variable and parameter and workflows.
• Worked on enhancing existing workflows, mapping and other Informatica configurations to enable loading of new data stream into Oracle data base.
• Modified existing SQL Server objects like tables, Views, Functions, stored procedures, Script.
• Published reports using Power BI.
• Created new SQL objects like tables, Views, Functions, stored procedures Server scripts.
• Expertise in Excel sheet like VLOOKUP, Pivoting, formatting.

Confidential, North Caroline

Sr. SQL/BI Developer

Responsibilities:

• Providing assistance in developing solutions that meet business requirements.
• Creating and maintaining/modifying T-SQL queries, tables, views, stored-procedures and functions that are required for front end business logic and report generation.
• Developing and maintaining/modifying complex T- SQL queries, stored procedures and SSIS packages to load the data into warehouse.
• Creating and maintaining SSIS package that use different control flow (Sequence Container, Execute SQL task, Script task, etc.) and data flow tasks required for business development using SSDT.
• Developing SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations. Performed ETL mappings and ETL task by using SSIS from sales database.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures.
• Developing various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Designing Reports as per the client requirements using Power BI (DAX/SSAS).
• Designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements using T-SQL, stored procedures in SSRS.
• Coordinating with front-end developers for implementing business logic in stored procedures, Triggers and functions using T-SQL.
• Working on all types of report types like tables, matrix, charts, sub reports etc.
• Creating and scheduling SQL server agent jobs and alerts, scheduled reports for daily, weekly, monthly.
• Communicating with various users’ groups, research teams, and Business Intelligence teams to gather requirements for the reports required by them based on current and existing patterns.

Environment: T-SQL, PL/SQL, MS SQL Server 2008/2008R2/2012/2016, Tableau, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows/ 2007/2008/2010 server SQL server 2008/2008R2/2012/2016

Confidential

SQL/BI Developer (Information Management & Reporting)

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirements, analyzing and designing software solution and database.
• Utilized querying relational databases using T-SQL and Microsoft SQL Server Integration Services to pull and integrate data from various sources. Involved in designing and creating Tables, Views, complex Stored Procedures and Indexes using T-SQL.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts. Created Clustered indexes and Non-Clustered indexes and optimized queries using execution plan. Extensively worked on tuning the queries to optimize performance
• Lead the implementation of ETL processes with SSIS packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, Text files, etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Created, Scheduled and Maintained Sql Agent Jobs related to data load and cube process jobs.
• Designed SSIS packages to transfer data across different platforms, validate data during transferring, and archived data files for different RDBMS
• Used various transformations in SSIS to load data from flat files and FTP to the SQL databases. Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• 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.
• Configuring the data flow, configuring the individual data flow elements and Monitoring the Performance of the Package. Developing various types of complex reports using SSRS
• Defined report layouts including report parameters and wrote queries for Drill down, Drill through reports as per business client's requirements using SSRS 2008.
• Created subscription of reports in different formats like pdf, excel to be executed automatically on daily, weekly and monthly basis, and also deployed and configured the reports in the Report Server. Translated analytic insights into concrete and actionable recommendations for business or product improvement Performance tuning and maintenance of report.
• Production application support

Environment: T-SQL, PL/SQL, MS SQL Server 2008R2 and 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ERWIN, Mainframes, DB2.