PROFESSIONAL SUMMARY:

• More than 8 years of professional experience in SQL & Microsoft Business Intelligence (SSIS, SSRS, SSAS) and have extensive Knowledge on Data Warehousing (DW) primarily on Healthcare, Financial and insurance domains.
• Performance Tuning, trouble shooting of SQL and SSIS
• Expertise in Storedprocs,Functions,Triggers using T - SQL
• Solid understanding of full SDLC with Agile.
• Experience in Relational database design.
• Expertise in Mortgauge, healthcare, Insurance domains
• Experience in setting up of ETL environments(Dev/QA)
• Knowledge on Ralph kimball, Bill Inmon DW methods.
• Knowledge on star schema,snow flake schema
• Extensive experience on MSBI (SSRS 2008\r2\12, SSIS 2008\r2\12\14, SSAS and MS-SQL server (2008\r2\12).
• Extensive experience on handling transactional databases like SQL Server and oracle.
• Expert in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services (SSIS) with .NET.
• Expertise in writing complex stored procs to process huge volume of data according to business requirements.
• Expertise on retrieving data from tables using Joins, stored procedures, Functions and dynamic SQL.
• Achieved best performance for SQL& SSIS using synchronous Transformations, Fast parse, execution plan, Index tuning wizard and SQL profiler.
• Delivery of business intelligence solutions and ongoing hands-on development and maintenance of SQL Server data warehouse.
• Work directly with various businesses users to design and implement ad-hoc queries and reports, create and provide system support as needed.
• Good knowledge on Report server admin activities like setting permissions to team members, configuring standard and data driven subscriptions to send end users on weekly\monthly basis.
• Experienced in performing database activities like backup, recovery, installing software, setting permissions to users, deploying SQL code to prod environment and setting up new environment on new servers.
• Extensive experience in Designing and implementing SSIS packages to migrate huge amount of data from different sources in to a data warehouse using SSIS.
• Good knowledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
• Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.
• Hands on experience in scheduling and deploying reports on report manger/ SharePoint portal.
• Hands on experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduling SSIS Packages.
• Expertise in Deployment of SSIS packages using deployment utility, SSIS catalog and SQL server.
• Implemented Logging, Event handler for error handling, Custom Logging for SSIS Packages to track errors and to load accurate data into destination.

TECHNICAL SKILLS:

• SQL,T-SQL,PL/SQL(Oracle)
• SSIS,SSRS,SSAS(2008/R2/12/14)
• C#.Net,VB.Net,MDX
• ER Studio
• JIRA, ASANA
• VSS,TFS
• Excel, Share point
• SQL DBA,QNXT

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. MSBI Developer

Responsibilities:

• Analyzing BRD, FSD docs provided by business to understand requirements.
• Installed necessary software’s to setup DEV environment (SQL server, BIDS, Oracle client, TFS).
• Created complex stored procedures, functions using joins, temp tables, Cte’s, table variables to retrieve data from Data Warehouse to SSRS reports according to Business requirements.
• Extract, transform and loading data into data warehouse using Data Flow Task and Control flow task
• Troubles shoot and Debug SSIS packages to resolve data issues occur in reports.
• Designed and created SSIS packages according to Business requirements
• Performance tuning, troubleshooting and optimization of SSIS packages and SSRS reports on DEV/QA/Prod Environment.
• Daily status meeting with PM’s and IT director to discuss about project status and pending issues.
• Involved in all phases of SDLC like requirement gathering, converting business requirements into technical requirements, reports and packages development using T-SQL/PL/SQL coding, unit testing of code and communicating with testing tem to resolve bugs.
• Test and validate ETL Packages and Reports to ensure accuracy and quality of data.
• Coordinating with offshore team to get things done on time.
• Reviewing reports, ETL packages created by team members and giving suggestions for better solutions.
• Created and Maintained different versions of SQL code, Dtsx packages and Report rdl’s in TFS.
• Daily Status meeting with offshore team to discuss about development status, addressing any roadblocks/bottlenecks raised during development phase in order to get things done on time.
• Implemented Error handling using SSIS Error handling mechanism to notify the errors to Dev team in order to resolve data issues on time.

Environment: SQL Server 2008 R2/12,Oacle T-SQL, SSRS 2008/R2/12,SSIS 2012, Windows 7,Share Point, windows server 2008,TFS,Tableau

Confidential, Los Angeles, CA

Sr. SSIS Developer

Responsibilities:

• Gathering, Analyzing requirements BA and implementing ETL process to load data.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Performed design, code reviews and analyzed execution plans.
• Fixing reporting bugs and SSIS job failures in prod environment to load the data into destination systems effectively.
• Involved in incremental loading of data warehouse using various transformations to make transactional db and Data warehouse in sync.
• Performed Type-2 slowly changing dimension to maintain the history of the dimensions, which improved the performance of data load.
• Performance tuning, troubleshooting and optimization of ETL packages and reports.
• Weekly status meeting with team members and tour director to discuss the progress of the project.
• Deployed ETL packages on server and scheduled jobs through SQL Agent to load data from transactional database to Data ware house.
• Deploying reports on Repot manager and providing security permissions to users according to business request.
• Given KT sessions about existing packages to new team members.
• Created technical documentation of developed packages to share knowledge to new team members.
• Design, develop and support all extraction and integration processes (ETL).
• Implemented Auditing and error handling to ensure Data Quality in the ETL process.
• Implemented end to end packages that include variables, parameters, expressions, Script task, Script component using C#.
• Deploying reports on Repot manager and providing security permissions to users according to business request.

Environment: SQL Server 2012 /14,T-SQL, SSRS 2008/R2/12,SSIS 2012, Windows 7,Share Point, windows server 2008

Confidential, Los Angeles, CA

Sr. SSIS Developer

Responsibilities:

• Communicate with the Business Analyst and Data Analyst to fully understand requirements.
• Reviewing code and point of contact to any MSBI technical issues.
• Analyzed, Designed debugged and reviewed complex stored procedures using Transact SQL.
• Participate in daily stand ups and weekly status reporting.
• Scrum meeting with manager and team members for every 2 weeks to track current status and to improve existing process efficient.
• Debugging and resolving data issues while loading data into data warehouse.
• Deployed SSIS packages to SSDB through SSIS catalog from SSDT.
• Performed Audit tables, Loggings, Error notifications to resolve production issues quickly and to maintain data quality.
• Created and maintained documentation for every SSIS packages and reports including business process.
• Created drill down, drill through, sub reports and linked reports using MS SSRS 2012 as well as managed the subscription of the reports.  .
• Developed 25 medium and complex tabular, drill through, sub reports based on client’s request in the span of 8 months period.
• Deploying reports on Share point and providing access to members.
• Creating linked reports to original report and creating subscriptions to send reports to end users on monthly basis.

Environment: SQL Server 2012, T-SQL, SSRS 2012,SSIS 2012\14, Windows 7,Share Point, PL/SQL

Confidential, Richardson, Texas

Sr. SSIS/SSRS Developer

Responsibilities:

• Created complex ETL packages using SSIS for Extracting, Cleansing, Transforming, Integrating and Loading data in to Data Warehouse.
• Getting data from Confidential vendors in txt file format(members and claims information), converting data into required format using SSIS package with lookups, conditional split, Multicast, Row count, Oledb transformation, script task and for each loop and various tasks and loading data into different client instances.
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008\r2 and 2012.
• Enhancing and debugging existing SSIS packages and maintaining source code in TFS.
• Created Audit tables, loggings, Error handling to maintain data quality while loading into data warehouse.
• Created and scheduled jobs in DEV and QA environments for testing purpose before moving code into PROD environment.
• Conduct ETL code reviews with the System Architect and Business Analyst to ensure code meets quality standards as well as meets requirements.
• Integrated TFS with SQL data tools to manage MSBI stack packages properly in DEV, QA and PROD environments using check in and checkout and have maintained history for every minor change.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Optimized the performance of complex source queries and stored procs with the help of execution plan and Database Engine Tuning Advisor to fetch data fast from source systems.
• Developed large number of standard and customized reports using  SSRS  for data feeds and for Reports on server.
• Monitoring scheduled jobs raising incidents in Asana (project management tool) and resolving issues with in time to avoid interruption of business.
• Created SSRS customized reports like tabular, matrix, drill down, drill through using ssrs tools, expressions on top of cube to fetch the data very fast and to deliver reports to end users on monthly basis without delay.

Environment: MS SQL Server 2008R2/12, SSRS, SSIS, SSAS, Windows 8, Asp.net, QNXT

Confidential, London, U.K

Sr. MSBI Analyst

Responsibilities:

• Used SSIS tool for Extracting, Cleansing, Transforming, Integrating and Loading data in to target database.
• Getting data from vendors in excel format, converting data into required format using SSIS package with lookups, conditional split, Multicast, Row count, Oledb transformation, script task and for each loop and various tasks and loading data into different client instances.
• Direct interaction with client regarding business requirements and converting requirements into technically
• Given KT sessions on SSIS and SSRS to new joiners.
• Creating the incidents and solving incidents raised by pm’s in JIRA ticketing tool.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitoring Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
• Implemented SSIS loggings in packages to store and analyze the errors occurred while running jobs.
• Implemented Xml configuration and sql server configurations to make packages more dynamic.
• Involving in doing BI testing for the reports/ETL implemented by other team members.

Environment: MS SQL Server 2008, SSAS, SSRS 2008 R2, SSIS 2008 R2, Windows 2003/2008, Asp.net

Confidential, Manchester

MSBI Developer

Responsibilities:

• Primarily responsible for developing Packages in SSIS as per Business Rules.
• Developed various packages to extract the data from SQL Server Database and Flat files, Excel files.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Extensively used Transformations like Derived Column, Data Conversion, Conditional Split, Audit, Aggregate, Lookup, Multicast, pivot, ole db transformations, and union all.
• Developed Reports in the form of Matrix, Table and Chart using SSRS.
• Used Control Flow Tasks like for each Loop Container, Execute SQL Task, Bulk Insert task and Data Flow Task.
• Used different destinations like OLEDB Destination, Flat file destinations and different sources like Flat file, OLEDB and Excel Source to load data.
• Implementing ETL logging and Configuration for Packages.
• Scheduling the ETL Packages Using SQL Server Agent
• Creation of Drilldown, Drill through reports in SSRS, scheduling the ETL Packages Using SQL Server Agent.

Environment: MS SQL Server 2008, SSRS, SSIS, Windows 2003/2008/vista

Confidential

SQL & BI Developer

Responsibilities:

• Requirement gathering, Analysis, Understand the business requirements and specifications.
• Analyzed and understood the claims and new policies of client data in data warehouse.
• Given KT on SSIS and SSRS to new team members.
• Using SSIS tool for Extracting, Cleansing, Transforming, Integrating and Loading data in to
• Created Reports/Dashboards using SSRS tool.
• Created and deployed SSIS packages to Development, QA and Production environments.
• Participated in load monitoring Periodically
• Involving in Unit Test Cases and Defect Fixing.
• Also involved in doing BI testing for the reports/ETL implemented by other team members.

Environment: MS SQL Server 2005, SSRS 2005, Windows 2003/2008/XP