SUMMARY

• About 9 years of experience in Data Warehousing. Involved in design of complex ETL solutions, data - migration strategy, data modeling and end to end implementation of DWBI applications.
• Proficient in SQL Server2008/2012, SSIS, SSRS.
• Expert in designing and implementing relational database model as per business needs
• In-depth knowledge of Transact-SQL (DDL, DML) and distributed queries.
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Excellent command of writing ad-hoc queries utilizing Dynamic SQL and BCP utility.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Experience in Importing Data from various data sources like Excel, Oracle, DB2 and Flat file using SSIS. Involved in transformation of OLTP data to the Data Warehouse.
• Created complex SSIS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Flat Files/Excel Sheets to SQL Server/Teradata and vice versa.
• Experience in creating Error Logging, Error Handling, Alerts, SQL Mail Agent, and scheduling SSIS Packages using SQL Agent Job.
• Well versed with concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables, Entity-Relationship model.
• Expertise in generating reports using SSRS 2008. Good understanding of Drill Through, Drill Down and Cascading Parameterized reports.
• Proficient in ERWIN 7.2 for data modeling.
• Good exposure in Oracle, Teradata and Datastage.
• Good hands on experience in UNIX Shell Scripting.
• Experienced in Manufacturing and Energy & Petrochemicals domains.
• Extensive client interaction in finalizing requirements, functional specifications and in all other phases of SDLC. Well aware of different stages of SDLC and has experience of working in Development and Maintenance of applications.
• Excellent communication and Presentation skills.
• Possessing a keen desire to learn new things and willing to take challenges. A complete team person, result-oriented, hardworking, confident individual with great problem solving skills; A Quick learner and able to adapt to new technologies with ability to take new roles in minimum time and with little training.

TECHNICAL SKILLS

Database: Server 2005/2008/2012 , Oracle 9i, 10g, Tearadata

GUI: Sql Developer, Rapid SQL, SQL Assistant and Toad, Visual Studio 2008

ETL: SQL Server Integration Service (SSIS 2008 R2/2012) Datastage, BODS

Reporting: SQL Server Reporting Services (SSRS 2008 R2/2012), Hyperion IR reporting

Data Modeling: ERWIN 4.0 and ERWIN 7.2

Office Tools: MS-Office, MS Excel, MS PowerPoint, MS Outlook, MPP

Configuration Management Tools: Team Foundation Server (TFS), VSS.

Development Tools / Languages: UNIX Shell Scripting, SQL - stored procedures, Bteq

Hardware / Operating Systems: Windows 2008, Windows XP, Unix.

Middleware: Tibco

Others: HTML, XML, Ticketing tool - Remedy

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

SQL Developer

Responsibilities:

• Interaction with BAs, End users to finalize the Master Data Requirements.
• Data Analysis- Write queries using inner join, left outer join, right outer join, self-join, using group by and partition by clauses to determine the nature of the data at the source system. Provide more feedback about the data and suggest solution to the business users.
• Create Source-To-Target Mapping documents.
• Logical and Physical Data Model creation using Erwin.
• Extensive use of Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions.
• Create Database Objects like Tables, Stored Procedures, Views and Custom Views.
• Create Datastage ETL jobs Framework to pull data from PIPE delimited sequential files (with UTF-8 encoding) from SAP and load into Teradata database.
• Use SSIS packages to pull data from Oracle, Excel spreadsheet, CSV files and load into Teradata database. Use of data conversion transformation to change the excel data to Non-Unicode.
• Use Script Component to create a surrogate key value for some specific set of data.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, and Script Task.
• Worked on creating connections to Oracle database and load data to TD.
• Sessions with Business Users during UAT.
• Setting up the Production Implementation Plan.
• Post go-live support and enhancement for the ETL and database objects.

Confidential, Bakersfield, CA

Responsibilities:

• Requirement gathering session with Business Analysts and End Users.
• Create Functional and Technical Specs.
• Create Source to Target mapping and data-lineage document.
• Conceptual Data Model in Erwin, review with Business Unit Architects.
• Design Logical/Physical model in ERWin for the enhancements for the web application- Blocked Wells.
• Define data types, Constraints, Indexes, Schemas in the Database. Defined storage parameters for the objects in the Database.
• Create tables, views, indexes for the new enhancements.
• Define Fact and Dimensions like - Factless Fact, Aggregate and Summary Fact.
• Design the Data Mart defining Entities, Attributes and relationships between them.
• Writing T-SQL scripts.
• Create complex stored procedure to automate daily steam volumes from 1YWM to EC. This helped Confidential to decommission the 1YWM system which was due the year before.
• Use of CTEs, RANK() function in the Stored Proc.
• Use of transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, Merge Join, Sort, Union All, Multicast, Oledb command and Data Conversion in SSIS to load data into ODS and FDS.
• Tuning and Optimization of T-SQL Queries.
• Create SSRS reports to export the data anomalies.
• SSRS report scheduling with Subscriptions.
• UAT support and Deployment help.
• Knowledge Transfer to the Application support

Confidential, Houston, TX

Responsibilities:

• Requirement Gathering with BAs and Business Users.
• Work with the Allegro-Aligne Product architects from the Vendor end to understand the Product architecture and propose suggestions for ETL framework.
• Design ETL framework for data-migration.
• Create mapping tables to map legacy Reference data to the new system.
• Write T-SQL scripts for business rules/ adhoc requests.
• Understand Allegro database components and process.
• Create SSIS ETL packages to pull and convert data from multiple legacy system databases (Oracle, SQL server, Spreadsheets etc.
• Use transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, Merge Join, Sort, Union All, Multicast, Oledb command and Data Conversion to load data into different allegro modules.
• Pulled data from Excel spreadsheet, CSV files and loaded into oracle database. Used data conversion transformation to change the excel data to Non-Unicode.
• Used Script Component to create a surrogate key value for some specific set of data.
• Write data validation scripts in SSIS to check referential integrity and other data anomalies.
• Automated the process of generating the SQL to disable/enable PK, FK dynamically in SSIS.
• Performed Unit Testing and Integration Testing.
• Set up correct and clean data in different schemas for different business groups to use and validate during UAT.
• Co-ordinate with all the dependent vendor teams during the implementation window.

Confidential, Denver, CO

Responsibilities:

• Interaction with the end users to understand the requirements and to provide suggestions which is best suited for their business.
• Design of the data model and architecture.
• Preparation of the technical specification documents and sign off meeting with clients.
• Creation of SSIS packages to pull data from QLM database(Oracle) to load into Dodd Frank database (SQL server)
• Use of several staging tables to suit the complex business rules and to spread data accordingly.
• Use of transformation like Conditional Split, Union ALL, Derived Column, Sort, Merge Join, Lookup, Data Conversion to load data into the tables.
• Used Lookup transformation extensively to handle the SCD-2 scenario.
• Integration of SSIS with .NET, created a SQL agent job to run this SSIS package, wrote a Stored Procedure to call that SQL agent job. On the button click event .NET UI will call this Stored Proc.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used a Web Service Task to call a web-service with no security. For a Secured Web service to send emails, wrote a Script Task to call it.
• Implement Event Handlers and Error Handling in SSIS packages and notify process results to various user environments.
• Work with the business users team for User Acceptance testing and ensuring that all the UAT test cases are successful
• Deploy SSIS packages on test and production servers.
• Onsite Coordination with end-users and offshore team.

Confidential, Houston, TX

Responsibilities:

• Interaction with BAs, end users to understand the requirements, business specification and sign off meeting with clients.
• Decision making in design of the tables, SSIS packages and reports.
• Understanding of the Tobin Land System data mart.
• Used Conditional Split, Union ALL, Derived Column, Sort, Merge Join, Lookup and Data Conversion to load data into the warehouse.
• Used SQL agent job and scheduled the SSIS package to run at every 4 hours interval to load tables for a particular report.
• Used Excel Source, Flat File Source to pull data from given Source systems and loaded them into Staging. Used SSIS to call the stored procedure to do the reconciliation.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins, using CTEs.
• Used Indexes properly to make sure data retrieval is faster.
• Designed and deployed SSRS reports with Drill Down, Drill Through and Drop down menu option and Cascading Parameterized and Linked reports.
• Automated Report Output Delivery in SQL Server Reporting Services Using Subscriptions.
• Development, bug fixes during UAT of the queries, stored procedures, SSRS reports, SSIS packages.
• Production implementation of the reports, packages, applications.

Confidential

Responsibilities:

• Requirement Analysis, creation of unit test cases, technical specification document, co-ordination with onsite personnel and adhere to quality processes.
• Develop tables, views, indexes, joins, custom views & materialized views.
• Work on issues, small enhancements of SSIS packages and Datastage jobs .Worked extensively on SSIS transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.
• Writing complex T-SQLs with self-join, sub-query and co-related sub query. Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
• Optimize performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Work on Teradata utilities BTeq, TPump etc.
• Creation of Unix shell script to integrate the functionality of data extraction and FTP to a different server.
• Communication with clients and source application team members.
• Provide solutions to the problem tickets.
• Carry out production implementation of development teams.
• Create and maintain process guidelines and knowledge repository.