SUMMARY:

• Over 5 + years of strong experience in the IT industry as a SQL Server Developer/BI Developer and solid experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Good experience with analysis, design, development, implementation, testing and support of Data Warehousing and Data Integration Solutions.
• Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expertise in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Excel and MS Access, CSV, Oracle & flat file.
• Experience in performance tuning the queries, creating indexes on tables for better performance.
• Experience in all Database Normalization rules on database objects for standard architecture.
• Experience in creating clustered and non - clustered indexes, delete and truncation on table to reset table schema.
• Experience in creating SSIS packages using Data Components, Task Components, Data converters, Data type converters, Validations, Workflows etc.
• Experience in design, code, test and debug custom SQL queries and generate reports using Microsoft SQL queries, SQL Server Management Studio and SQL Server Reporting Services
• Better understanding of data warehousing concepts.
• Prepared documents like Technical design document, Root cause analysis document and presentation materials describing analytic methods, observations and findings of analytics, and/or business logic flow employing MS office suite.
• Performed root cause analysis to identify data flow issues/system performance issues and/or data discrepancy issues and addressed issues as necessary and work with concerned team to implement correction plan.
• Direct interaction with business process owners to understand and provide solutions as per their needs across several client applications
• Extensively worked on SSAS Tabular model and multi-dimensional cube development and SSIS packages designing.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS).
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2008/2005.
• Hands-on in development of Drilldown Reports in SSRS and Generated daily, weekly and monthly reports for the department managers.
• Good experience with MDX and DAX to write scripts for SSRS reports and in SSAS Tabular model and helps to write advanced formulae in MS Excel as well.

TECHNICAL SKILLS:

Programming Languages: T-SQL, SQL, PL/SQL, Dynamic SQL, MDX, C.

RDBMS: MS SQL Server 2005/2008/2012/2014, MS Access 97/2000/2003, Oracle 8i/9i/10g, 11g/12c.

Design and Data Modeling: Star Schema/Snowflake Schema Modeling Relational, Fact& Dimensions tables, Dimensional and multi -dimensional modeling Physical & logical data modeling and De-normalization techniques, MS Access, MS Project.

Tools: and Utilities SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard.

Operating Systems: Windows XP to 10, Windows Server 2000 to 2012.

DWH / BI Tools: SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), SQL Server Integration Services(SSIS), Business Intelligence Development studio(BIDS), SQL Server Data Tools (SSDT), Visual Studio, SQL*Loader.

PROFESSIONAL EXPERIENCE:

Confidential, NYC

MSBI Consultant

• Developed SSIS Packages to Extract, Transform and Load data from Oracle database to SQL Server database tables.
• Merged the data using Merge components in SSIS from several data sources and transfer to the destination.
• Worked with various kinds of reports for Member, Provider Relations using SSRS and published these reports
• Worked on different kinds of Transformations in SSIS and processed Loads into Staging/ODS areas.
• Worked on migrating Legacy DTS Packages (ETL) to the new SQL Server Integration Services SQL (SSIS) format.
• Designed Complex SSIS packages interfacing SQL Server with Oracle 11g.
• Performed installation and configuration of SQL Server Reporting Services (SSRS).
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Involved in designing Parameterized Reports and also cascaded Parameterized Reports.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Extensive reporting skills using SQL Server Reporting (SSRS).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Responsible for SSAS Tabular model cube development as well.
• Analyzed the requirements and developed the cube in different versions such as Direct Query and In-Memory models.
• Worked on Performance optimization by moving specific source data from Oracle to SQL Server and incorporating multiple source method.
• Responsible for bugs fixing that get raised all through the testing phase, within the timeline provided. Ensured perfect quality and no re-occurrence by performing integration testing.
• Always cross verified the cube data by executing MDX statements, so that it is compatible for the SSRS as well as PowerBI reports development.

Environment: SQL Server 2016, SQL Server Management Studio 2016, Visual Studio 2015, SQL Server Data Tools (SSDT), HPALM tool (HP Application Lifecycle Management tool) and Team Foundation Server (TFS).

Confidential

MSBI Developer

• Analyzing the requirements and preparing technical design documents/ updating the existing documents as per the latest requirements.
• Responsible for resolving issues that get raised in the supporting applications within the timeline provided. Ensured that none of the solutions breached the committed timeline and are of perfect quality.
• Responsible for enhancing the code wherever required in the existing solutions as part of maintenance, which includes performance optimization.
• Developed new BI applications using ETL tool SSIS, Cube designing SSASmulti-dimensional model and SQL Server.Majorly part of Cube designing.
• Created the SSIS packages to extract financial metric data from formatted excel sheets to the system database.
• Used control flow elements and dataflow elements and several data converters to transfer data from any source including OLEDB source to destination element.
• Added several logics to divert the data from one source to several tables based on the business logic.
• Merged the data using Merge components in SSIS from several data sources and transfer to the destination.
• Created Views and Stored Procedures, Constraints and Indexes on the database tables.
• Created User defined functions and called from Stored Procedures.
• Expertise in building complex SQL Joins
• Modified queries and stored procedures and performed performance tuning to execute the query faster and efficiently.
• Tested SSIS Packages and reports
• Performed Unit testing, Integration testing, moving it to Production environment and data loading.
• Quality Assurance.
• Worked on Remedy tool for requirements and issue tracking.
• Worked on Team Foundation Server for source code management.

Environment: SQL Server 2008 R2/2012, SQL Server Management Studio 2008R2/2012, Visual Studio 2008/2010, Business Intelligence Development Studio (BIDS), Remedy tool, Team Foundation Server(TFS).