SUMMARY

• 6+ years of strong MS - SQL server and Business Intelligence BI Development working experience.
• Proficient in creating and using joins, Stored Procedure, Views, Triggers, schemas and Complex queries on SQL Server Management Studio (SSMS).
• Expert on installing and configuring MS SQL Server 2012\2014\2016\2019
• Hands on experience in configuring Reporting Service, Report manager and Report Server
• Expert on Configuring MS SQL Integration Service (SSIS) Catalogs
• Extensive experience in analysis, design and development of software applications in SQL Server.
• Experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and agile methodology.
• Extensive knowledge in ER Diagram & logical & physical data modeling using Oracle Data modeler.
• Hands on experience in designing de-normalized data warehouse using Star & Snowflake Schema.
• Expert in creating Dynamic SSIS Packages with Parameters, local and environmental variables, XML configuration and check points.
• Extensive experience in implementing event driven Error handlings, package logs.
• Hands on Experience on SSIS package development, deployment and scheduling.
• Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports, drill through reports and interactive reports using SQL Server Reporting Service (SSRS).
• Highly proficient in the use of T-SQL and PL/SQL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins.
• Experienced in creating custom columns and measures using DAX, developing Page level Reports, Dashboards, dynamic Navigation bars & Stories in Power BI.
• Experienced in Project management tools like Trello.

TECHNICAL SKILLS

Database Tools: SQL Server Management Studio, SQL Profiler, Query Analyzer, Visual Studio C#

ETL Tools: SQL Server Integration Service (SSIS) 2017/2016/2014/2012/2008 /2005

Data mining tools: SQL Server Analysis Service (SSAS) 2017/2016/2014/2012/2008 /2005

Reporting Tools: SQL Server Reporting Service (SSRS) 2017/2016/2014/2012/2008 R2/2005, Microsoft Power BI, MS-Access, MS-Excel, Report Server

Programming Tools: T-SQL, C#, C++

Web Technologies: HTML, DHTML, Java Script

Operating Systems: Windows 2010/2008 R 2/2007/2003/2000 Server (64/32 Bit), Linux

Other Tools: MS Office Suite (Microsoft Word, Power Point, Microsoft Visio), ERWIN, Oracle-SQL Data modeler, Amazon Web service AWS

PROFESSIONAL EXPERIENCE

ETL/SQL Developer

Confidential

Responsibilities:

• Worked in designing and optimizing various T-SQL database objects like tables, views, stored procedures, user defined functions, indexes and triggers.
• Enhance existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
• Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design and other Data Warehouse concepts.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup, for each loop container, sequence container, script task etc. for Data Scrubbing, data validation checks during Staging.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created SQL server configurations for SSIS packages.
• Responsible for creating reports based on the requirements using SSRS 2016.
• Designed, developed and tested the DataStage jobs using Designer and Director based on business requirements and business rules to load data from source to target tables.
• Established best practices for ETL jobs to ensure optimal performance, reusability, & restart ability.
• Defined the report layout and identified Datasets for report generation.
• Created different type of reports including Cross-tab, Drill-through, Drill-down, Sub reports and parameterized reports
• Scheduled the monthly/weekly/daily reports to run automatically.
• Created Packages to group logically related column types and to transfer data.
• Documented and delivered Functional Specification Document to the project team by using SQL Server.

Environment: SQL Server 2005/2008/2012 , Windows 2003 R2/2008 Server, Visual Studio C#, T-SQL, Excel, Oracle SQL Data modeler, LANs, WANs, VPNs

BI/SQL Developer

Confidential

Responsibilities:

• Created Queries in T-SQL, Stored Procedures and Views to store the data of clients, advisors using SQL Server
• Worked using integration services for transferring and reviewing data from heterogeneous sources like (Flat file, Excel, CSV, Oracle, MS Access).
• Designed and Developed complex SSIS packages for performing ETL process using SQL Server Integration Services.
• Worked on Data Mapping extensively.
• Worked in designing and optimizing various T-SQL database objects like tables, views, stored procedures, user defined functions, indexes and triggers.
• Responsible for Data Profiling to determine data integrity for transformation of Data from Source
• Worked on Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Designed dynamic visuals using Bookmarks, Slicers, custom tooltips in Power BI
• Published and Shared Power BI reports and Data models in Power BI workspaces
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the Multi-dimensional data warehouse.
• Monitored time taking queries with Performance Tuning to reduce the execution time and created packages in SSIS with error handling and tested the packages for Incremental Data Load & duplications.
• Analyzed data and generated different kinds of graphs, charts using Excel.

Environment: MS SQL Server 2012/2008R2/2005, Windows Failover Cluster, C#, Replication, Windows Server 2003, 2008R2 and 2012, JavaScript, Visual Studio 2008/2010/2012

SQL Developer

Confidential

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Created SQL server Reports using SSRS 2005 for the manager and the brokers involved and formatted the report layout for the requirement of the end users.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Extensively worked on creating SSIS packages and have used for each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Gathered business requirements and converted into SQL stored procedures.
• Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.

Environment: MS SQL Server 2012/2008R2/2005, SSRS 2005, SSIS, OLTP, Replication, Windows Server 2003, 2008R2 and 2012, JavaScript