SUMMARY

• Around 12+ years of experience in IT, as MS SQL Server Developer in Windows environment.
• Extensive experience with SQL Server 2016,2014,2012, 2008R2, 2008, 2005 and worked extensively on BI Tools like Integration services (SSIS), Reporting services (SSRS) and Analysis Services (SSAS).
• Experience on Azure Data factory (ADF), Azure Data Lake (ADL), Azure Data warehouse and worked on creating ADF Pipelines, ADL Analytics or U - SQL Jobs.
• Expertise in Database design, Entity Normalization & Database Creation, Maintenance, Monitoring.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2016/2014/2 /2000. Expert in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Extensive experience in T-SQL (DDL, DML, DCL), Views, Stored Procedures, Cursors and Triggers.
• Experienced in Extraction, Transformation and Loading (ETL) process using Data Transformation Services (DTS), MS-SSIS, Informatica Power Center application tools.
• Experience in creating Configuration files to deploy the SSIS packages across all environments.
• Wide experience in Creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Expertise in creating OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS.
• Experience in developing management reports using SSRS (SQL Server Reporting Services), Power BI.
• Strong experience in creating Ad Hoc Reports, Parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SQL SSRS.
• Experience in Confidential SQL 2008/2005 Server migration from SQL Server 2000, Integration Service (SSIS), Reporting Service (SSRS).
• Developed mappings using connected/unconnected lookup, router, joiner, expression, filter, sequence generator transformations.
• Developed packages using lookup, aggregator, Derived Column, Sort and Conditional Split transformations.
• Developed and migrated informatica XML objects across environment
• Excellent understanding and implementation knowledge of Software Development Life Cycle.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.
• Worked on GIT, Team Foundation Server, Visual Studio online and the application lifecycle tools associated with it (source control, test manager, release management).
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies and participated in sprint planning, retrospective, estimates etc.

TECHNICAL SKILLS

ETL (Extract Transform Load) Tools: Azure Data Factory, SSIS, SQL Server Management studio, SQL Server Data Tools 2012, SQL Server Business Intelligence development studio (BIDS), Informatica Power Center 9.5/9.1, DTS, BODS

Reporting/Analysis Tools: Power BI, SSRS, SSAS, Crystal Reports XI

Data Modeling: Erwin Tool, MS Excel

Databases: Azure Data warehouse, Azure Data Lake, SQL Azure, SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , Oracle 11g\10g\9i, MS Access, DB2.

IDE Tools: Visual Studio.Net 2005/2008/2010/2013 , Visual Studio Online

Tools: & Scheduler’s: TOAD, SQL Developer, Informatica Scheduler, Unix Cron Job, Control M Scheduler, Serena Team Track, Quality Center, Rally, Jira (Agile Tools).

Programming: SQL, T-SQL, PL/SQL, Unix Shell Scripting, C, C#, VB

Operating System: Windows 10/8/7/ Vista /2003/XP, Unix

Source Control Tools: Team Foundation Server (TFS), GIT

PROFESSIONAL EXPERIENCE

Confidential, Sanjose, CA

Sr. Azure SQL Developer

Responsibilities:

• Worked closely with the Product Owner to gather the requirements.
• Created various T-SQL Tables, Views and performed complex transformations to generate the Dimensions and facts.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on publishing the transformed data to azure SQL data warehouse.
• Worked on unit testing and Data validation of the Stored Procedures.
• Experience in designing and developing Business Intelligence solutions on Operational Data Store (ODS), Azure SQL Data Warehouse (ADW), SQL Server On Premises.
• Created Data factory pipelines to extract data from different sources like AzureDB, Azure SQL data warehouse etc.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS and BODS.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from SAP ECC, CRM Systems, Oracle etc..

Environment: SQL Azure Database, SQL Server 2016/2014, Azure DataFactory, Azure DataLake, Azure SQL Data warehouse, TFS, GIT, MS Excel, Visual Studio 2015, SAP, Oracle 11g.

Confidential, Redmond, WA

Sr. Azure BI Developer

Responsibilities:

• Worked on Proof of concepts(POC’s) on azure technologies like Azure Data factory, Azure DataLake, Azure Data warehouse.
• Created Data factory pipelines to extract data from different sources like Cosmos, Azure SQL, On-Prem SQL Server, flat files etc.
• Created various U-SQL jobs to test the compatibility of technology ADL Analytics.
• Created various ADL Analytics tables using U-SQL and performed complex transformations to generate the Dimensions and facts.
• Worked on publishing the transformed data to azure data warehouse.
• Worked on unit testing and Data validation of the U-SQL jobs.
• Worked on building PowerPivot DAX reports, PowerBI reports from SSAS Tabular Cubes.

Environment: SQL Azure Database, SQL Server 2016/2014, Azure DataFactory, Azure DataLake, Azure Data warehouse GIT, MS Excel, SSAS Tabular Cube, PowerBI.

Confidential, St. Louis, MO

Sr. SQL BI Developer

Responsibilities:

• Work closely with business users to congregate and comprehend requirements.
• Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel.
• Created cross validation rules to ensure mapping accuracy.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage, partitions and aggregations.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Worked on Performance tuning the existing SSAS cubes/ SSIS Packages/ Stored Procedures and optimizing the MDX queries which are used in the Reporting.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Coordinating post-implementation events such as testing.

Environment: SQL Azure Database, SQL Server 2014/2012, SSIS, SSAS, SSRS, GIT, SSDT 2012, VBScript, XHTML, XML, MS Excel, Windows 2005/2008/2012 Server.

Confidential, Redmond, WA

Sr. SQL BI Developer

Responsibilities:

• Work closely with business users to congregate and comprehend requirements.
• Preparation of documentation for all the requirements and enhancements to reports.
• Provided Design documents for offshore and has been an On-Shore Offshore Coordinator and has been a lead for about 8 resources at off shore.
• Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel.
• Created cross validation rules to ensure mapping accuracy.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Azure, SQL Server 2014 using T-SQL.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Coordinating post-implementation events such as testing.

Environment: SQL Azure Database, SQL Server 2014/2012, SSIS, SSAS, SSRS, TFS, VSO, SSDT 2012, VBScript, XHTML, XML, MS Excel, Windows 2005/2008/2012 Server.

Confidential, Richmond, VA

Sr. SQL Developer (SSIS/SSRS)

Responsibilities:

• Work closely with business users to congregate and comprehend requirements.
• Preparation of documentation for all the requirements and enhancements to reports.
• Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source, Oracle and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Migrating the needed data from Oracle, MySQL in to HDFS using Sqoop and importing various formats of flat files in to HDFS.
• Migrated ETL jobs to Pig scripts did Transformations, even joins and some pre-aggregations before storing the data onto HDFS.
• Implemented Partitioning, Dynamic Partitions, Buckets in HIVE.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Created cross validation rules to ensure mapping accuracy.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Involved in SSAS Tabular cube (DAX) development.
• Designing, Creating & maintenance of Reports in SSRS.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2012 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Worked on DQS tasks like Creating Knowledge Base, Domain rules, Setting Term base Relationships etc..
• Data migration (import & export/BCP) from different sources to SQL Server.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2008R2/2012, SSIS, SSRS, SSAS, DTS, VSS, VBScript, XHTML, XML,MS Access, Windows 2005/2008 Server, Oracle 11g, IIS5.0, 6.0, 7.0.

Confidential, Erlanger, KY

Sr. ETL Developer

Responsibilities:

• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), MS Excel Spreadsheet to SQL Server 2008.
• Designed ETL packages for different data sources (XML, SQL Server, Flat Files).
• Scheduled the DTS package for data migration from legacy system to MS SQL 2008.
• Designed dynamic DTS Packages to transfer data between servers, load data into database, and archived data file from different DBMS.
• Experience in designing and developing Business Intelligence solutions on Operational Data Store (ODS), Global Data Warehouse (EDW), Data Marts / Decision Support Systems
• Converted existing SSIS packages into informatica mapping/Sessions/Workflow.
• Extensively worked on Power Center client tools: Repository Manager, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor to extract, transform and load data.
• Developed mappings using connected/unconnected lookup, router, joiner, expression, filter, sequence generator transformations.
• Developed packages using lookup, aggregator, Derived Column, Sort and Conditional Split transformations.
• Developed and migrated informatica XML objects across environment.
• Performed unit testing during the migration process between SSIS and informatica.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Created Linked-Servers among different operational systems.
• Copied large amounts of data across servers using BCP and DTS.
• Used DTS packages to schedule batch processing of jobs.
• Developed tables, stored procedures, triggers, cursors, views and indexes for the design specifications
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Created Views and Index Views to reduce database complexities for the end users.
• Experience in designing ER diagrams and mapping the data into database objects.
• Using Erwin, Prepared logical data models in support of integrated financial management and reporting requirements.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS 2008.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
• Developed many asp.net web applications using SQL Server and C#, to provide solutions for companywide needs.
• Published dashboards on an intranet site using SharePoint Server.
• Configured Report Model for developing ad-hoc reports by the end-users.
• Uploaded reports on to the report manager and organized them into folders.

Environment: SQL Server 2005/2008/2008 R2, DTS, MS SQL Server Reporting Services, MS SQL Integration Services, MS SQL Analysis Services, T-SQL, PL/SQL, MS Excel, MS Access, Visual Studio 2008, ASP.Net, C#, ADO.Net, Oracle 10g, Informatica 9.5.

Confidential, NV

Sr. SQL BI Developer/ Sr. SQL Server Developer

Responsibilities:

• Dynamically supported business users for given requirements and developed the reports accordingly.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2008.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Developed ETL mappings to transfer data from some of the Access, Flat files.
• Developed, deployed and monitored SSIS Packages.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created data sources, connection strings and defined the datasets for generating the report.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Migrated some Crystal reports to SSRS reports.

Environment: SQL Server 2005/2008, SSIS,SSAS, SSRS, VSS, VBScript, XHTML, XML, C#, ASP.Net, Windows 2000/2003 Server, IIS5.0, 6.0, 7.0, Crystal Reports.

Confidential

SQL Server Developer

Responsibilities:

• Closely worked with end-users to analyze, understand and gather report requirements.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Developed and created the new database objects like tables, views, index, stored procedures and functions, advanced queries and also updated statistics using query Analyzer and Enterprise Manager on the existing servers.
• Migrated all DTS packages to SL Server Integration Services (SSIS) and modified the package according to the advanced features of SQL Server Integration Services.
• Converted logical database design into physical schema using the balanced normalization in 2nd and 3rd Normal forms for highest performance.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries.
• Developed reports using SSRS, used table control, matrix control for cross tab reports.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Developed the front end screens in C# .Net using Visual Studio.
• Worked on ADO.Net to access data from database.
• Developed reports using SSRS.
• Wrote queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Extensively used SQL Server Reporting Services and Report Builder Model to generate custom reports.
• Wrote and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Handled issues like data correction and resolved error handling.

Environment: SQL Server 2005, SSIS, SSRS, VSS, VBScript, XHTML, XML,C# .Net, ASP.Net, Windows 2000/2003 Server, IIS5.0, 6.0, 7.0.