PROFESSIONAL SUMMARY:

• Experienced MS Business Intelligence Developer with 8+ years of experience working with BI applications such as SSMS, SSIS, SSRS, SSAS in Development, Test and Production Environments. A wide experience working in different industry domains such as healthcare, finance, service and insurance.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2016/2014/2012/2008 R2/2008.
• Actively participated in gathering of User Requirement and System Specification.
• Proficient in using Tables Joins - Inner, Left, Right, Full Outer Joins and creating highly complex queries.
• Excellent in creating SSIS packages for ETL (Extracting, Transforming and Loading) of data using various types of sources and destinations - OLEDB, Flat File, CSV file, XML files, Excel, Web Services.
• Proficient to use Tasks (SSIS) in Control Flow, Data flow to define and manage Package execution.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for SSIS packages and SSRS reports.
• Hands on experience of using various Transformations- Lookup, Conditional Split, Derived Column, Merge, Merge Join, and Fuzzy Look up, Multi Cast, Union, and Audit for transform source data.
• Experience in creating Jobs, Alerts, and SQL Mail Agent for schedule Packages.
• Experience of deploying SSIS project in Integration Services Catalog.
• Knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
• Expertise in developing various SSRS reports - Grouped Reports, Multi Grouped Reports, DrillDown, Multi-Drill Down, Cascading, and Parameterized.
• Expert in creating Visual reports such as Tables, Matrix, and Pie, all kinds of Charts, Maps, Indicator, and web reporting by customizing URL Access.
• Deployed and configured the reports in the Report Server.
• Experienced in building and Deploy OLAP Cubes using SSAS for Star Schema.
• Created SSRS and Power BI reports sourcing from SSAS s Multidimensional OLAP and Tabular model cubes with MDX and DAX.
• Experience in Query Optimization techniques, Performance tuning, Execution plans.
• Great skills in gathering requirements analyzing and prioritizing them.
• Worked closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues.
• Involved in all phases of SDLC (Software Development Life Cycle) which includes RUP, Agile and Waterfall methodologies, from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

SKILL:

MS SQL Server 2014/2012/ 2008, SQL Server Integration Services (SSIS), MDS 2012, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, SAP Business Objects, Microsoft Excel.

TECHNICAL SKILLS:

OS: Windows 2000, Windows Server 2003, Windows server 2008

Databases: SQL Server 2014/2012/2008/2005/2000 , PL/SQL, Oracle 11g/8.0i, Microsoft Access 2000/8.0 Teradata14.0, SAS,Oracle (8i/9i/10g),MDS 2012

Languages: C,PL/SQL, TSQL, DB2, MYSQL, DHTML, VB.NET, ASP.NET, .NET Frame Work,C#, Phyton

Scripting Languages: HTML, XML, Java Scripting, VB Scripting

Web Tools: C#.Net, ASP.Net,VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script

ETL & Reporting: SSRS 2005/2008/2012/2014 , SSIS 2005/2008/2012/2014

Hardware: IIS 6.0/5.0/4.0

Version & Defect Control: Microsoft TFS, MS VSS, Synergy, HP Quality Center & Jira

Others: AWS,MS Office, Erwin, Crystal Reports XI, Visio, Microsoft Business Intelligence Studio, Service Oriented Architecture (SOA) SQL Server Notification Services, SQL Server 2000/2005 Analysis Services (SSAS), Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects

PROFESSIONAL EXPERIENCE

Sr. SQL/ETL Developer (SSIS, SSRS, SSAS)

Confidential, Pasadena, California

Responsibilities:

• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Identified the dimension, fact tables and designed the Data - Mart using Star schema.
• Wrote Stored Procedures and Functions for better performance and flexibility.
• Deployed SSIS packages into various Environments (Dev, QA and Prod) using Deployment Utility.
• Coordinated with Users in different testing phases.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB and SQL client.
• Data transformation from different data sources to SQL Server.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Applied conditional formatting in SSRS to highlight key areas in the report data Used Report Builder to do Ad-hoc Reporting.
• Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and Snow Flake Schema) using SSAS.
• Involved in Dimensional Data Modeling and Cube Partitioning in SSAS and enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions using SSAS.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Developed Multidimensional Objects (Cubes, Dimensions), designed Dimensional Modeling and created Hierarchies using SQL Server Analysis Services (SSAS).
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Worked on various DAX expressions in Power Pivot based on the business requirement.

SQL/SSIS Developer

Confidential, San Francisco

Responsibilities:

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up and Merge Join as required using SSIS.
• Developed SSIS packages for File Transfer from one location to the other using FTP task.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, Checkpoints and User Defined Variables for SSIS Packages.
• Working knowledge in creating Stored Procedures, Triggers, User - Defined Functions, Views, Indexes, User Profiles, Analytical Functions using T-SQL, SQL Server, PL/SQL.
• Developed queries via joining various tables to validate the data coming with different data discrepancies using existing fields and quantifying results with calculations.
• Created Cube in Tabular mode, created hierarchies in VS 2012 for Cube.
• Worked on Insurance, Policy and Commodity data.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Created stored procedure using nodes method to load XML file data into SQL server tables.
• Created packages using the various control flow task such as data flow task, execute SQL task,Execute package task, File System task.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2012
• Created logic and indexed tables/views/stored Procedures based on the business requirements
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Data migration from text files, SAS, DB2 , SAP and excels files to SQL server.
• Successfully created database diagrams and physical models for the project.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal process.
• Worked with Electronic Data Interchange (EDI) to exchange business documents.

SQL BI SSIS, SSRS Developer, Conversion-Data Analyst

Confidential, San Francisco

Responsibilities:

• Participated in design discussions with Database architects and Application architects.
• Worked on implementation of SQL Server Master Data Services 2012 to achieve reliable, centralized data for Accounting that can be analyzed, resulting in better business decisions.
• High Experienced in generating SSIS Packages/projects from various source s to specific destination by using Visual Studio 2012, building and scheduling jobs for ETL process.
• Developed SSIS packages to pull out, modify and load data from Oracle/SAP and SQL Server databases into Data Warehouse.
• Good knowledge on the dimension, fact tables and designing the Data - Mart using Star schema.
• Wrote Stored Procedures , Functions and expressions for better performance and flexibility.
• Deployed SSIS packages into various Environments (Development, Te s t and PROD) using Deployment Utility.
• Worked on creating SQL Server jobs and scheduled them to load data over nightly using SQL server Agent.
• Achieved successful results on performance based on execution plan and creating optimal logic using T -SQ L .
• Created Joins and sub-queries for complex queries involving multiple tables from different databases Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Created SQL server MDS 2008 We b App that integrates with Add-in Excel and right Sql Server database.
• Presented and supported Sales team on implementation of SQL Server MDS 2008 for MDM of Sales team.
• Strong Applications Development experience with back-end databases such as SQL Server, SQL MDS 2008, Oracle and MS Access using ADO/ADO.NET OLEDB and SQL client.
• Strong skills in transformation data from DB2 to SQL Server.
• Data migration from text files, DB2 , excels files to SQL server.
• Largely used T -SQ L in supporting Finance Team and constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Created and Designed Data Source and Data Source V ie ws and also configured OLAP Cubes (Star and SnowFlake Schema) using SSAS.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Had experience on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T -SQ L , scripts, stored procedures and views).
• Configured Dimensional modeling for End-User from Hierarchy perspectives.

SQL BI DEVELOPER

Confidential

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries using execution plan for tuning the database. Implemented different types of constraints on tables.
• Involved in database Backup and Restore.
• Created Clustered Indexes and Non - Clustered Indexes to increase the performance of database.
• Used Try catch and @@error for exceptional handling.
• Experienced solving issues raised by QA, UA for database.
• Created ER diagrams using Visio.
• Created V ie ws to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T -SQ L queries.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Created Joins and sub-queries for complex queries involving multiple tables from different databases
• Responsible for Data migration from SQL Server 2000 , 2005 to SQL Server 2012 Databases.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.