SUMMARY:

• Having 7+ years of extensive experience in Microsoft Business Intelligence SSIS(ETL tool), SSAS, SQL Server 2017, T - SQL, Oracle
• Created Stored Procedures, Functions, and Indexes, Views, Joins and T-SQL code for applications.
• Worked on writing complex T-SQL queries joining multiple tables to provide adhoc reports to end users.
• Managed indexes and optimized queries by using execution plan for tuning the database.
• Worked on performance tuning and Optimization of queries using SQL Profiler
• Designed and developed data models for the data warehouse using star and snowflake schema.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Worked on creating High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert , Merge, lookup, Expression, Execute SQL Script, File system task and union all .
• Implemented error handling using Event handlers
• Scheduled and executed SSIS Packages using SQL Server Agent jobs ..
• Experience in developing Tabular and Multidimensional reporting
• Experience in creating Named calculations, Named queries, Calculated measures
• Created hierarchies between the attributes and defined attribute relationships
• Deploying cubes to Analysis server
• Experience writing simple MDX queries
• Involved in Unit, System testing and Integration testing using HPQC tool
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Interacted with clients to understand business requirements and implemented the same.
• Performed Demo to end users, provided end user support in case of any issues in understanding the data in report.
• Effective debugging skills in case of any data discrepancies, provided the root cause and fix
• Effective in working independently and collaboratively in teams.
• Team leader with good communication and problem solving skills.
• Proficient in handling responsibilities such as compliance to best practices & standards, technology mentoring, code review and assisting team members.

TECHNICAL SKILLS:

Programming Languages: T-SQL, MDX, SQL, PLSQL

Database: SQL Server 2017, Oracle 10g

Tools: SSIS ETL tool, SSAS, SSMS, SQL Server Agent

Operating Systems: Windows 98,2007,XP,Linux

PROFESSIONAL EXPERIENCE:

Confidential

Technology used: SSIS, SSAS, SQL server 2012

Responsibilities:

• Created complex SSIS packages using proper control and data flow elements.
• Created Technical design specification documents based on the functional design documents and the physical data model.
• Supported data extraction from legacy systems into flat files for loading into Nucleus data warehouse
• Responsible to Migrate Data from multiple sources like flat file and Excel to OLAP systems
• Used different types of transformations for data conversion, sorting and cleansing the data from different sources.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi-dimensional objects Cubes using SQL Server Analysis Services (SSAS).
• Wrote simple MDX queries to query the deployed cube in analysis server.
• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
• Query Optimization and Performance tuning.
• Performed backup/ restore, database objects such as tables, procedures, constraints, Indexes and views.
• Participated in various meetings and discussed enhancements and modification request issues.

Confidential

Technology used: SSIS Sql Server 2012, SSMS, SQL Server agent

Responsibilities:

• Worked on importing the flat files from source to landing area, then staging, Preload and then to the data warehouse
• Implemented error handling framework to validate the incoming data against the standards.
• Implemented SCD2 and SCD1 mappings.
• Defined Parameters and variables to generalize the mapping to run for different schema, source, target etc.
• Implemented Fact less fact table to handle m: m relationships between the tables.
• Implemented User defined functions validate and to handle null data.
• Worked on loading data from two or more Relational transactional tables to a single reporting tables as SCD1

Confidential

Technology used: SSIS, T-SQL, SQL server 2008, SQL Server Agent

Responsibilities:

• Worked on implementing SSIS packages to load OLTP Database to SDE and SIL tables
• Implemented multiple SSIS Transformations while loading data to SIL tables which include Lookup, Expression, conditional split, OLE DB Destination, OLE DB Command task
• Involved in writing SQL queries, complex stored procedures, triggers, views, constraints, joins, DDL, DML and user defined functions (UDF) to implement the business logic.
• Designing and creating SQL Server tables.
• Analyze end user database needs and provide efficient solutions
• Performed unit testing with multiple test cases .
• Performed system testing using HPQC tool
• Responsible for handling discussions with the client and proving them the required adhoc reports on need basis
• Provided end user support in case of report data discrepancies

Confidential

Technology used: SQL Server 2008

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries
• Created documentation as required.

Confidential

Technology used: PLSQL, oracle

Responsibilities:

• Worked for various tracks like Security, Service Request Management.
• Analyzing and fixing the issues with the PLSQL Interfaces
• Responsible for processing the records coming from various data sources Involved in Processing of Data in TCA tables.
• Making enhancements in the interfaces according to the requirements.
• Worked on Oracle Apps 11i front end for scheduling concurrent programs, on Application Object library.
• Contributed in the Bug Fixes which are a part of Monthly Releases.
• Conducted UAT testing for the I2R during Releases User input test case generation.