SUMMARY

• 8+ years of extensive experience in implementing Data warehouse solutions using SQL server suite of products (SSIS/SSRS/SSAS).
• Having experience in working different versions of SQL Server 2005/2008R 2/2012/2014.
• Worked in various domains Telecom, Retail, Banking and Insurance.
• Sound understanding on Dimension modeling, Star schema, Snowflake schema, MDX queries, SQL Profiler
• Experience working with huge databases in the volumes of Terabytes.
• Expert knowledge and extensive experience using SQL Server Integration Services (SSIS) to perform ETL and data integration processes.
• Experience in building SSIS packages involving ETL process, extracting data from various heterogeneous sources like flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating SSAS cubes
• Experience in building SSRS reports from cubes in Analysis services.
• Experience in T - SQL programming like creating complex Stored Procedures, Views and functions
• Experience in providing Logging, Error handling by using Event Handler for SSIS Packages.
• Proficient in generating reports and dashboards using Power BI Desktop tool.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler
• Expertise in query performance using execution plans for complex queries in SQL Server.
• Experience in creating ad-hoc reports by using Report Builder in SSRS.
• Having knowledge in using data modeling tool like Erwin.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Having experience as a developer in Microsoft .NET technologies using Visual Studio.NET, C#, ASP.NET, ADO.NET
• Working in SCRUM & Agile Development methodology
• Good experience in handling multiple projects with Offshore - Onshore model and efforts estimation for the DW and BI applications.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS

Programming Languages: C#, VB.NET

Querying Language: T-SQL, MDX, PL/SQL

Web Technologies: ASP.NET, ADO.NET, HTML, DHTML, CSS, JavaScript, XML

Tools: & Utilities: Visual Studio, SQL Server Management Studio, Toad

Database: MS SQL Server 2005/2008/R2/2012, Oracle 11g/10g

Version Control: Microsoft VSS, TFS

BI: MSBI Stack (SSIS,SSRS, SSAS), Power BI, Cognos, Tableau

Designing Tools: Microsoft Visio

Operating Systems: Windows 9x/2000/XP, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Cedar Rapids, IA

Sr.SQL Developer/ MSBI Developer

Responsibilities:

• Gathered requirements and designed solutions.
• Created ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Performed data analysis and reported the findings to the business team
• Versioning of SSIS packages with VSS tool.
• Production Support of Existing SSIS/ETL Packages.
• Designed and Implemented the SSIS Process to load data from FLAT FILES, EXCEL, XML Files and other Databases.
• Designed the ETL packages to support the incremental, historical data loads using SSIS.
• Created complex Stored Procedures, functions, views for application using T-SQL.
• Responsible for Scheduling and Maintenance of Jobs using Control-M.
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Responsible for creating reports using SSRS on Real Estate Datawarehouse.
• Developed detail and summary reports that are having Drill through, grouping and Drill down features.
• Working with QA team on the Defects assigned and Test Case review.
• Monitor Job Scheduling activities and create Implementation and back out plan documents for the deployment
• Participate in UAT with end users to provide them technical guidance and data set up needs.

Environment: MS SQL Server 2014, SSIS, SSRS,Windows 7, Visual Source Safe, Control-M.

Confidential, Philadelphia, PA

Sr.SQL Developer/ MSBI Developer

Responsibilities:

• Gathered requirements and designed solutions.
• Created ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Performed data analysis and reported the findings to the business team
• Versioning of SSIS packages with TFS tool.
• Production Support of Existing SSIS/ETL Packages.
• Designed and Implemented the SSIS Process to load data from FLAT FILES, EXCEL, XML Files and other Databases.
• Designed the ETL packages to support the incremental, historical data loads using SSIS.
• Created complex Stored Procedures, functions, views for application using T-SQL.
• Responsible for Scheduling and Maintenance of Jobs using SQL Agent.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
• Designed and implemented facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2012.
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Responsible for creating reports using SSRS on Cubes.
• Develop and maintain the daily/weekly status report and provide the same to Higher Management
• Working with QA team on the Defects assigned and Test Case review.
• Monitor Job Scheduling activities and create Implementation and back out plan documents for the deployment
• Participate in UAT with end users to provide them technical guidance and data set up needs.

Environment: MS SQL Server 2012, SSIS, SSAS, Power BI, MS Excel, Windows 7, TFS.

Confidential, Salt Lake City, UT

SQL Developer

Responsibilities:

• Involved in designing and implementing database applications using MS SQL Server 2012 and Business Intelligence (BI) tools to support transactions and business decision-making.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations necessary.
• Modified the existing SSIS Packages to improve the performance of data load.
• Worked on several transformations in Data Flow including Derived-Column, Script task, Slowly Changing Dimension (Using SSIS Controls), Lookup, Data Conversion, Conditional-Split and many more.
• Successfully migrated SSIS packages from development to test and Production environments using SSIS Configuration files and deployment wizard.
• Responsible for creating reports based on the requirements using SSRS 2012.
• Developed Cross-Tab, Drill-down, Drill Through, Crystal Reports and Sub-Report using RDL. Promoted RDL’s to Reporting Service Server.
• Developed the cubes using SQL Server Analysis Services (SSAS).
• Experience working with Multi-Dimensional Expression (MDX) statements and functions to create complex calculations.
• Created user defined hierarchy in dimensions.
• Deployed the generated reports from SSAS cubes on to the server.
• Used Subscriptions and Snapshots to set up Push based Report Delivery.
• Hands on Job Scheduling of SSIS Packages through SQL Server Agent.

Environment: MS SQL Server 2012, SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services), MS Excel, Windows XP Professional, TFS.

Confidential, Tampa, FL

MSBI Developer

Responsibilities:

• Involved in moving the data from old legacy system to new sources based on the given specifications and requirements.
• Involved in designing and implementing database applications using MS SQL Server 2008R2 and Business Intelligence (BI) tools to support transactions and business decision-making.
• Involved in development of web application using C#, ASP.NET, Javascript and AJAX.
• Involved in defect resolution that includes modification C# Code.
• During the ETL operation data has to be moved to different sources based on the category and make necessary changes.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations necessary.
• Modified the existing SSIS Packages to improve the performance of data load.
• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks etc. during Staging, before loading the data into different sources.
• Successfully migrated SSIS packages from development to test and Production environments using SSIS Configuration files and deployment wizard.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services
• Experience working with Multi-Dimensional Expression (MDX) statements and functions to create complex calculations.
• Created user defined hierarchy in dimensions.
• Evaluated database performance and performed maintenance duties such as tuning, backup,restoration.

Environment: .NET 3.5 Framework(C#,ASP.NET,ADO.NET), Visual Studio 2008,MS SQL Server 2008R2, SSIS, SSAS, SSRS, MS Excel, Windows XP Professional, TFS.

Confidential

SQL Server Developer

Responsibilities:

• Involved in design and development of application according to the requirements using ASP.NET with business logic implemented using C#.
• Implemented server side and Client side validations using ASP.Net and Javascript.
• Created stored procedures, views, indexes and joins as needed.
• Involved in Performance Tuning of databases to optimize existing applications and processes.
• Designed databases, tables, SQL functions, triggers in SQL Server 2005.
• Responsible for database development in SQL Server 2005, worked on T-SQL functions and SQL syntax.

Environment: ASP.Net, C#, XML, HTML, Java Script, Microsoft SQL server 2005, Windows NT.