PROFESSIONAL SUMMARY:

• Over 8+ years of extensive experience in database design, development, and administration with MS SQL Server versions 2016/2014/2012/2008 R2 using SSIS, SSAS, SSRS in Financial, Retail, Insurance, and Banking industries.
• Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
• Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources.
• Worked withT-SQL, DDL,andDMLScripts and established relationships between tables usingPrimary KeysandForeign Keys.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• In depth Knowledge inER ModelingandDimensional modeling(Star and Snowflake Schema) building Dimension, Data marts and Fact tables.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experienced in System testing, unit testing and UAT for deployed reports and dashboards in Tableau UAT, QA and Production environments.
• Expert in transforming data from different source (CSV, Flat Files, Excel) to SQL Server databases.
• Experience working with ActiveX data Objects.
• Good Knowledge with VBA Excel.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS)
• Good Knowledge on creatingscorecardsanddashboardsusing POWER BI Dashboard Designer and integrated them with SharePoint Web Services.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS 2012.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS:

SQL Server/BI Tools: SQL Server Management Studio (SSMS), MS Visual Studio 2010/2008, Business Intelligence development Studio (BIDS), Export & Import (DTS), Query Analyzer, SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), SharePoint 2010/2007,Power BI

Databases: MS SQL Server 2017/ 2016/2014/2012/2008 R 2/2008/2005/2000, MS Access, Oracle11g/10g/ 9i

Languages: T-SQL, PL/SQL, C#, VB.Net,HTML, CSS, XML, VBA Excel

Operating Systems: MS-DOS, Windows 10/ 7/XP / 2000/2003/2008 Server

Database Design Tools and Data Modeling: MS Visio 2008/2011, ERWIN r7/r4/r3.5, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

Database Tools and Utilities: SQL Server Management Studio, Enterprise Manager Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor

Version Control Tools: VSS, Sub version, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis MN

Data Engineer

Responsibilities:

• Perform System and Requirement Analysis, design and writing technical design documents and test plans.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• Worked on creating SSIS packages to upgrade SQL Server 2015 to SQL Server 2016.
• Design and develop mappings, sessions and workflow.
• Design and develop SQL Server Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Develop the application based ons enterprise architecture framework, which includes Understanding and implementing the Enterprise Architecture Best Practices, Guidelines and Standards, ETL framework and Enterprise Scheduling.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).

Confidential, Parisppany NJ

Senior SSIS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experienced in creating complex SSIS packages using proper control and data flow elements.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in and support and also have experience in incremental data loading.
• Helping the client design, build, stabilize and deploy a Microsoft Business Intelligence solution for a large 40 million record flat file using SQL Server, SSIS.
• Employed error handling techniques and promoting parallelism.
• Created of SQL Agent jobs to schedule package runs.

Confidential

Sr MS BI Developer

Responsibilities:

• Perform System and Requirement Analysis, design and writing technical design documents and test plans.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• Worked on creating SSIS packages to upgrade SQL Server 2015 to SQL Server 2016.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Design and develop mappings, sessions and workflow as per the requirement
• Design and develop SQL Server 2008 Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Develop the application based ons enterprise architecture framework, which includes Understanding and implementing the Enterprise Architecture Best Practices, Guidelines and Standards, ETL framework and Enterprise Scheduling.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Creation of Roles in Model using DAX Formulas to define the User Security in Cube.
• Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS in SSIS and T-SQL (SQL Server).
• Review code delivery and manage the version in Team Foundation Server.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Technical Documentation and Perform reviews, design and data manipulation.
• Production Support and resolving the issues.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

Sr. BI Developer

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
• Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
• Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user accepting testing (UAT) to improve overall quality of the application. Created complex stored procedures using dynamic SQL and CTE.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Experience in performance tuning, processing and deploying the cubes.
• Using SQL Server Integration Services (SSIS) to design and maintain ETL Solutions.
• Generated Reports using Global Variables, Expressions and Functions for the reports usingSSRS2010, 2012, 2017.
• Participating in defining ETL strategies, preparing transformation rulesand mappingdatafrom source to target
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Designed and developed efficientSSISpackages for processing fact and dimension tables with complextransformations.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
• CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Experienced using Visio database design.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints
• SQL Server Index Maintenance and Performance Tuning for Large Tables
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Experienced working with Autosys scheduler for reporting and monitoring jobs.
• Experience inETL Data Warehouseenvironment. Created Jobs inSSISand was responsible for ETL job scheduled to run daily.
• Designing and implementing a variety ofSSRSreports such asParameterized,Drilldown, Ad hoc and Sub-reports using Report Designer andReport Builder based on the requirements.
• DesignedSSRSreports withsub reports, dynamic sorting, defining data source and subtotals for the report.
• Developed, monitored and deployedSSISpackages.
• CreatingReportsas per user requirements usingSQL Server Reporting Services 2012.
• Written complexT-SQLqueries and created Stored Procedures, Triggers, Functions and Views using SQL Server 2017, 2016, 2014, 2012.
• Experience in SQL DBA.

Environment: MS SQL Server 2008 R2/2012,2014,2016,2017 Excel 2010, Microsoft Integration Services (SSIS), Microsoft Reporting Services (SSRS), Visual Studio 2010, Windows 7, PowerShell, ASP.Net, C#, UNIX

Confidential, Philadelphia PA

Sr. MSBI Developer

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
• Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
• Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables
• Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target.
• Monitored transformation processes using Informatica Workflow monitor.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Designed and developed efficientSSISpackages for processing fact and dimension tables with complextransformations.
• Experience in different level of testing(Functional,Integration,Regression,System,Soap,Rest API,Smoke UAT and Web Testing
• Built KPIs in tabular model cubes based on the end user requirements.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
• CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• SQL Server Index Maintenance and Performance Tuning for Large Tables
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Used Script task to write custom code using C#
• Experience inETL Data Warehouseenvironment. Created Jobs inSSISand was responsible for ETL job scheduled to run daily.

Environment: MS SQL Server 2008 R2/2012, Team Foundation Server, Microsoft SharePoint Server (MOSS 2007), Crystal Reports, SQL Server Integration Services (SSIS), C#, SQL Server Reporting Services (SSRS), Visual Studio 2010, Windows 7,T-, Erwin v8.0, ASP.Net, C#.

Confidential

SQL Developer/BI Developer

Responsibilities:

• Worked on Migration from SQL Server 2000/2005 to SQL Server 2008R2 and SQL Server 2012.
• Worked on upgrading SQL Server 2000 and 2005 databases to SQL Server 2008 R2 and SQL Server 2012.
• Experience in moving data from heterogeneous data sources to SQL Server usingDTS/SSIS.
• Experience in Bulk Copy (BCP), Script task and Script component for complex SSIS transformations.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad hoc, Sub Reports and created report subscriptions.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variablesParameters Expressions and Functions for the Business Users
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server
• Analysis Services(SSAS).
• Participated in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL
• Server Analysis Services (SSAS).
• Migrated DTS packages into SSIS packages.
• Experience in working and fixing defects on upgrades to systems from SQL Server 2005 to SQL server
• 2012.
• MS SQL Server Configuration,Performance Tuning, Client-Server Connectivity, Query OptimizationDatabase Maintenance Plans and Database Consistency Checking DBCC commands.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Experience inCreating and Updating Clustered and Non-Clustered Indexesto keep up the SQL Server
• Performance
• Worked with test and production teams to Promote Stored Procedures, SSIS packages and Reports into production.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and end users.

Environment: SQL Server 2012/2008R2 Enterprise Edition, Windows Enterprise Server 2008R2, IIS 7.5, C#, SSRSSSIS, Excel 2007/2010