SUMMARY:

• Confidential Professional with more than 15 years of IT experience
• Worked primarily in banking, finance, sales, healthcare domains for various clients includes Confidential, Confidential, Group Health and others
• Strong experience in SQL Server with Business Intelligence (SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS))
• Extensive knowledge of relational and multi - dimensional data design and development including star schema, snowflake schema, cube design, ETL
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Expertise in writing complex SQL and creating Stored Procedures
• Extensively worked on Data Extractions, Transformations and Loading from various data sources like MS-Excel, Flat files to MS SQL Server using Confidential SSIS.
• Thorough knowledge of various SSIS objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Created SSIS packages to load various Dimensions and Fact tables based on complex business requirements.
• Configured Send Mail Task for sending automatic emails when a SSIS package is failed or succeed.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Excellent T-SQL development skills to query complex relational databases with the development of Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers
• Involved in troubleshooting issues in Production and UAT environments from WW users
• Proficient in extraction, transformation, cleansing, and loading data from heterogeneous data sources and flat files
• Executed few projects in agile methodology and possess detailed information about agile and scrum working model.
• Hands-on experience in POWER BI and AZURE includes U-SQL, COSMOS, AZURE DATALAKE
• Adapt to new tools and technologies in traditional BI space, Confidential Azure and Hadoop ecosystem

TECHNICAL SKILLS:

Data warehousing: SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), Informatica, Wherescape, DSS, Business Object, OBIEE, Tableau, Power BI, AZURE

Databases: SQL Server, TSQL, Sybase, Teradata, Oracle, Oracle EBS, PL/SQL, PostgreSQL, MS Access, SQL Azure

Programming Languages: C #, VB.net, Python, R, Java, C, COBOL, PASCAL

Operating System: Windows XP; Windows NT/Server 2003. Windows Server 2008

Tools: / Utilities: SQL Server Management Studio, Visual Studio - Team foundation Server, SVN, ALM, Source Depot, Visual Source Safe, Crystal Reports, MS VISIO, Service Now, COSMOS, ADL, ADF, Hadoop Hive

System Development: Requirements analysis, Design, Analysis; Coding and Testing

Scheduling Tool: SQL Server Agent

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Senior BI DEV

Responsibilities:

• Analysis of Project Requirements and functional specifications of the project.
• Understand customer requirement and translate it into appropriate solution.
• Creation and delivery of detailed technical presentations.
• Involved in design and development of SSIS (ETL) packages.
• Created SSIS packages to load various Dimensions and Fact tables based on complex business requirements.
• Understand and translate business needs into data models.
• Created conceptual, logical and physical data models using best practices.
• Optimize and update data models to support new and existing projects.
• Create Source to Target Mapping as necessary
• Designed and Developed SSAS Cubes
• Designed and developed SSRS Reports

Technologies: SQL Server, SSRS, SSIS, SSAS, Power BI, C#, Windows 2012, VSTS 2012, TFS

Confidential, Seattle, WA

Senior BI DEV

Responsibilities:

• Involved in discussions and meetings with customers for finalizing the scope of the project.
• Involved in analysis and design phase of the project.
• Understand customer requirement and translate it into appropriate solution.
• Design, Development, Unit testing, component integration, system integration testing and UAT test
• Updated existing SSIS packages according to business requirement changes.
• Involved in preparing Design documents.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles
• Establish design\coding guidelines and best practices.
• Analyzed long running queries and tuned the same to optimize application and system performance.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
• Created queries with Inner Join, Outer Join, Co-Related sub-query with String function, Mathematical function, Aggregate function.

Technologies: SQL Server, SSAS, SSRS, SSIS, Informatica, WhereScape, Service Now, SVN, ALM, Oracle EBS, OBIEE, Business Objects, Tableau

Confidential, Redmond, WA

Senior BI DEV

Responsibilities:

• Involved in exhaustive discussions with team regarding the requirement and converted the same into Design by coordinating with offshore team.
• Developed the SSIS packages which are adhered to coding standards and delivered the same with no deviation from requirements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations.
• Coordinated with onsite coordinator during the User Acceptance Test to make it success.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
• Created unit test cases for the SSIS packages and performed thorough Unit testing and involved in peer review.

Technologies: SQL Server, SSRS, SSIS, SSAS, Power BI, C#, Windows 2012, VSTS 2012, TFS, COSMOS

Confidential, Seattle

Senior ETL Engineer

Responsibilities:

• Created SSIS packages to load various Dimensions and Fact tables based on complex business requirements.
• Engaged in design and development of SSIS packages for data migration.
• Involved in troubleshooting issues in Production and UAT environments
• Provided the estimation details for enhancement related activities.
• Involved in Design, Coding and Testing of release/CRs.
• Engaged in design and development of SSIS packages for data migration.
• Involved in troubleshooting issues in Production and UAT environments from WW users

Technologies: Sybase, Teradata, SQL Server, Informatica, Crystal Reports, Business Objects

Confidential, Redmond

Senior ETL Developer

Responsibilities:

• Strong and proven ETL Expertise and the ability to retrieve, analyze and compare data across different sources system
• Expertise in Analysis, developing and Testing of ETL Applications and Reporting Solutions
• Create and Schedule SCOPE jobs and validate data from COSMOS to verify Data Extraction
• Create ETL/SSIS packages to load and validate data
• Participated in Daily Team Scrums and provided Status to Team Members and Reporting Manager
• Used MS Visio for Process Modeling, Process Mapping and Business Process Flow Diagrams
• Database Maintenance, Data load and validation pertaining to different tools
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.

Technologies: SQL Server, SSIS, SSRS, SSAS, C#, Windows 2008, VSTS 2010, TFS, WCF, Octopus, .NET, MS Product Studio, COSMOS, SCOPE, Power Shell

Confidential

Senior SQL Developer

Responsibilities:

• Interaction with client for requirements gathering
• Analysis of the specifications provided by the client
• DB Design and Development of backend scripts and Implement Replication
• Participate in Requirements and Reviews with Analysts, Architects, Testers
• Worked with Business Users during UAT and provided further analysis on their Defects

Technologies: SQL Server, C#, Windows 2003, Source Depot, SSIS, SSRS, .NET, MS Product Studio