SUMMARY

• Over 10 years of experience in technical architecture, data modeling, proof of concept, requirement study, system analysis, testing and development of decision support systems.
• Experience in working and conceptual knowledge of SQL, PL/SQL, Transact SQL, UNIX Shell Scripting and HTML.
• Experience in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL, Transact SQL and PL/SQL.
• Experience in using Informatica Power Center to design data conversions from wide variety of source systems and in Performance Tuning of sources, mappings, targets and sessions.
• Experience in using Talend Data Studio to design and develop data conversations from different source systems using both Open Source and Enterprise Edition.
• Experience in Performance Tuning & Optimization of SQL Queries and Procedures using Explain Plan, SQL Trace, & optimizer hints.
• Experience in Database, Data warehousing (ETL) environments and excellent knowledge of star and snowflake schemas and data modeling.
• Experience with relational databases (Sybase, Oracle, SQL Server).
• Experience in all phases of Software Development Life Cycle (SDLC) such as Project Requirement Study, high level design, low - level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning.
• Experience working with Onside-Offshore model.

TECHNICAL SKILLS

ETL Tools: Informatica 8.0/8.6/9.0, Talend Open Studio for Data Integration 5.1, Birst Tool, Oracle Data Integrator (ODI) and SAS 8.2

Databases: Oracle 8i/9i/10g/11g, SYBASE IQ 12/12.6, SQL Server 2008 and MS Access

Reporting Tools: OBIEE 10x, SSRS, Business Objects XI

Languages: SQL, PL/SQL, T/SQL, UNIX Korn Shell Scripting, C, Java, XML and HTML

Query Tools: TOAD 9.5, SQL Navigator, SQL Developer, WINSQL, isql plus and SQL* PLUS

Data Modeling: E.R.Studio Data Architect, Sybase Power Designer

Version Control/ Others: MS Visual Source Safe, Ultra Edit and WS FTP/ MS Office Suite / Power Builder 7.0, PVCS Dimensions 9.1.0, GIT, Jira, Tortoise SVN

PROFESSIONAL EXPERIENCE

Technical Lead

Confidential, Des Moines, IA

Responsibilities:

• Created conceptual diagrams for the overall process in visio.
• Created logical and physical models for the new extract process in Sybase Power Designer.
• Created technical specification documents and source to target mappings for development.
• Developed the extraction, transformation and load processes using Informatica power center to data from legacy system to Facets.
• Designed mappings using Filter, Expression, Aggregator, Joiner, Sorter, Rank, Source Qualifier, look up, Update strategy and Router transformations.
• Developed unix korn shell scripts to execute the Informatica workflows.
• Monitored incremental and full load of data extraction through Informatica.
• Developed Slowly Changing Dimensions Type 2 SCD by introducing audit columns using Informatica.
• Mentoring the junior developers and interns on the team.
• Created parameters and variables for the reusable sessions.
• Mentored Business Objects XI developer is building Universes.
• Developed processes to parse XML files and load them into Database using Informatica.
• Involved in Code reviews and determining Informatica standards for Mappings/Sessions/ Workflows.

Sr. Data Analyst ETL Data Architect

Confidential, Urbandale, IA

Responsibilities:

• Worked with the business to understand the requirements and performed data analysis to identify the gaps in the requirements.
• Reverse Engineering the existing reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Produced conceptual, logical and physical data models based on business needs using E R studio data architect.
• Worked with Database Administrators, Business Analysts and Report Developers to conduct design reviews and validate the developed models.
• Created Source to Target Data mapping documents for the existing database and new database to help the report developer to help in their development process.
• Actively involved in analyzing and data profiling/data cleansing the source data to load into target tables.
• Developed and modified database objects including tables (DDL), views, and User defined Functions, SQL Queries, stored procedures, stored functions and packages using PL/SQL.
• Developed several data transformation jobs to extract data from sales force and zuora into the target system using Talend open studio.
• Performance tuned SQL queries in SSRS reports to work without lag.
• Used Talend open studio to extract data directly from salesforce and Zuora using Talend native connectors and used various components to load data into target tables.
• Modeled data base objects to support Birst ETL tool to upload the data into the Birst cloud system and generate reports.
• Created reports in Birst to support the business requirement
• Created Test Cases and Helped testing team in performing Smoke and Regression Testing.
• Created Ad-Hoc reports using SQL and Talend open studio.
• Involved in product support for the data warehouse, SSRS, and OBIEE.

Sr. Oracle ETL Lead

Confidential, West Des Moines, IA

Responsibilities:

• Involved in full life cycle development of the project and translated business requirements into data mart design.
• Improved data integrity by identifying and creating relations-ships between tables and developed strategies to extract data from input sources and load into relational tables.
• Developed and implemented new process control strategies to capture the bad data.
• Designed and developed technical ETL design specifications document for new and existing requirements.
• Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
• Used Informatica as an ETL tool for extraction of data from Source system which are populated to the staging area, the staging area being used to consolidate the data which are to be populating to the data warehouse area
• Developed and modified database objects including tables (DDL), views, and User defined Functions, SQL Queries, stored procedures, stored functions and packages as per the business requirements.
• Worked with version control tool Tortoise SVN to check in and check out the code for development and promotion purpose.
• Fine tuned the performance of the SQL quires and PL SQL jobs using oracle optimizer hints, partitioning the tables, creating/dropping Indexes and improves the run time of the cycles by implementing parallelism.
• Created ETL jobs and monitoring the jobs for special executions and supporting on-site technical support teams for any issues.
• Migrated code between Integrated Test, UAT and Production environment and worked closing with QA in testing the reports and fixing issues.
• Documented the changes done during system testing and created documents for training purpose.
• Performed Unit testing and Integration Testing for better results and performance.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Universe tuning by creating Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the Universes using Business Objects Designer.

Sr. IT Solutions Developer

Confidential, Des Moines, IA

Responsibilities:

• Coordinated with the business in gathering the detail business requirements and high level requirements.
• Used Informatica Designer to create mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
• Created Workflows and Sessions for each mapping that we are extracting from Source Systems to Staging areas, Staging areas to target.
• Developed and modified database objects including tables, views, and User defined Functions, SQL Queries, T-SQL, and stored procedures as per the business requirements.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Wrote UNIX Korn Shell Scripts for data parsing and to automate the manual report generation process.
• Worked with the Business to set up new universes in Business Objects for reporting purposes
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into DataMart using the Informatica PowerCenter.
• Developed and optimized of SQL queries to increase the performance using TOAD Explain Plan utilities.
• Defining Crontab Entries for Scheduling the Korn shell to run on weekly, monthly and quarterly basis.
• Used SAS PROCSQL utility to embed SQL code and generated reports for the business.
• Created indexes, dropped/restructured indexes with poor selectivity based on index usage report.
• Extensively used PVCS Version control for check in and checkout of SQL/SAS/KSH programs for development.

SQL Developer

Confidential - West Des Monies, IA

Responsibilities:

• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, and TOAD
• Worked on the optimizing of the queries to improve the performance of the database system.
• Troubleshooting database performance, tuning and capacity issues. Also designing, normalizing and creating databases and data models.
• Implemented new constraints in existing Triggers and programmed new triggers that were required for new data.
• Worked on SQL*LOADER to load data from flat files obtained from various facilities every day.
• Wrote quires to create external tables and access the data from the external files
• Responsible for troubleshooting the errors that occurred when the production group hit a roadblock.
• Developed UNIX Shell scripts to automate repetitive database processes.

Data warehouse Developer

Confidential - Louisville, KY

Responsibilities:

• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, and Indexes.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Worked on production support, and receive production calls, and working on trouble reports which are received from clients.
• Developed UNIX scripts to create FTP Jobs.
• Worked on SQL*LOADER to load data from flat files obtained from various facilities every day.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Analyzed and Optimized the SQL statements using ‘Explain plan’ and ‘tkprof’.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Developed User interface using Oracle Forms 10g and Reports 10g.

Environment: - Oracle 10g, PL/SQL, SQL*LOADER, SQL PLUS, TOAD, Developer Suite 10g (Forms, Reports), Business Objects, Windows NT 4.0/2000, Informatica 8.0, UNIX shell scripting

Research Assistant

Confidential - Edwardsville, IL

Responsibilities:

• Deigned and maintained graduate school website
• Maintained file maker pro database
• Created reports in excel file format.
• Designed a new interoffice system.
• Created ad-hoc reports out of the file maker data base.