SUMMARY

• Dynamic professional with 10 years of IT experience in Application Development, Implementations and Testing. With nearly 8 years in Data warehouse Development, Analysis and support, Business Intelligence (BI).
• Technical expertise in ETL methodologies, Informatica 9.x/8.x/7.x - Power Canter, Informatica IDQ, Power exchange, Toad, Control - M, Cron, Tivoli.
• Worked with other ETL tools like DataStage 8.5, SSIS-2005 (MSBI)
• Experience in converting DataStage, SSIS jobs to Informatica
• Expertise in configuring and working with Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modelling.
• Extensive experience with Relational Database Management Systems (RDBMS) including Triggers, PL/SQL Stored Procedures, Packages.
• Migration of legacy data to oracle using SQL*Loader and UTL FILE utilities
• Have profound working knowledge on SQL, PL/SQL, Performance tuning, DBA activities.
• Worked extensively on XML and web services for Data Integration.
• Good knowledge on Unix Shell Scripting, Python and Perl.
• Worked in Projects with Data Warehousing, Data integration, ETL conversions, Divestitures.
• Good Exposure in SCM, OM, HR and Finance Business Domains
• Excellent communication, interpersonal and analytical skills, Quick learner and adaptive to new and challenging environments.
• Exposure in various business processes of many fortune companies. Outstanding Organizational Skills, Work Ethic and Drive to Succeed.
• Worked and guided teams in on-site offshore model.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, IDQ, DataStage 8.5, SSIS

Databases: Oracle11g/10g, Teradata 14/13, DB2, MS SQL Server 2008/2005, My SQL.

BI Tools: Cognos 8.4.1 (Framework manager and Report Studio).

Programming: UNIX Shell Scripting, SQL, T-SQL, and PL/SQL, Python, Perl, Java

Environment: Windows 2008 R2/2000/NT, Sun - Solaris, IBM-AIX, HP-UX

Data Modeling: Erwin

Other Tools: TD SQL Assistant, Fast load, Tpump, TPT, Fast Export, Toad, Forms 6i, Quality Center, Remedy, HPSM

Scheduling Tools: Autosys, TWS, DAC, cron

PROFESSIONAL EXPERIENCE

Confidential, Lake Oswego, OR

Sr ETL Developer / Lead

Responsibilities:

• Understanding the design and processing of the Data Integration and DWH.
• Development of Technical specs, mapping documents.
• Need to implement the Data Quality rules requested by business in the incoming transformer stages.
• Unit testing and integration testing
• Code reviews and technical design reviews of offshore developers.
• Development of Mapping, workflows in Informatica.
• Deployments of reusable transformation/sessions and UDF and migration activities in various environments DEV, TUT, UAT
• Responsible to develop the required shell scripts for input and output file and archival management.
• Performance tuning of mapping and also SQL queries used in Stored procedures and other pre and post SQL, SQL overrides.
• Designed and implemented a swap view procedure to make the fact available while loading, making it available to reporting layer.
• Implemented parallel execution using multiple instance execution.
• Develop scripts of data loading reconciliation stats and make them available in operational reports.

ENVIRONMENT: & TOOLS: DataStage 8.5, Informatica Power Center 9.5/9.1, Teradata, Oracle 11g, IBM AIX UNIX, SQL Developer, SQL Assistant for TD, Fast Export, Fast Load, Cognos .

Confidential, Denver, CO

Sr Application Developer / Lead

Responsibilities:

• Design and development of MTD and Returns Data Warehouse
• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Extract data from heterogeneous sources like Oracle, SQL Server, SAP, SalesForce and Legacy systems
• Create detailed Technical specifications for Data Warehouse and ETL processes.
• Review to ensure coding and design standards are met
• Work allocation to team members.
• Tune the performance of queries.
• Create the complex XML Splitter to split the XML
• Work with web services to extract RMA data from different vendors.
• Data Profiling and Analysis.
• Implement the Data Quality rules of Confidential for all the incoming feeds from various vendors to standardize the data quality.

ENVIRONMENT: & TOOLS: Informatica Power Center 8.6, OBIEE, Oracle 10g/11g RAC, SQL Server 2005, Windows 2003, DAC, SQL developer, SAP, Sales Force, Sun OS UNIX/Linux, Control-M.

Confidential, RTP

Sr Application Developer /Lead

Responsibilities:

• Understanding the business and data requirements defining gaps in the business requirements.
• Create design documents including data samples, use case, key project assumptions, report samples, proposed ad hoc samples, data flows, and logical data models.
• Single point of contact for end to end delivery.
• Defining the Change Data Capture(CDC) strategy for various source systems
• ETL lead to coordinate requirements and analysis with Team and guide the team during Development and testing Phases.
• Develop understanding of source systems, business usage, DW transformation and business logic, data issues
• Design and Development of Informatica Mappings and Workflows.
• Create test scenarios and test cases in consultation with business team
• Participate in architecture and design activities to ensure data model and detailed design developed is in line with business needs.
• Working at all levels of business and technology organizations to communicate requirements.
• Coordinate with offshore team and taking care of deliverables from offshore

ENVIRONMENT: & TOOLS: Informatica Power Center 8.6, Shell Scripting, Perl, Oracle 9i/10g RAC, Sun OS UNIX / Linux, XCtrl

Confidential

Application Developer

Responsibilities:

• Understanding the requirements, design and developing of Informatica objects
• Creating design documents including data samples, key project assumptions, Load Report samples, and data flows
• Bridge the understanding between business and technical teams by developing rapport with the business teams and a deep understanding of data
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and unit tested the mappings.
• Creating the Process Orchestration Model and related UNIX scripts
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Used debugger to figure out data, mapping issues and troubleshooting Session, workflows using Session logs, Workflow logs.
• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Involved in Performance tuning of targets, sources, mappings and sessions
• Performance Improvement using advanced concepts in Informatica and Pl/Sql
• Developing Load Reports and creating value adds
• Worked on XML sources and targets.
• Extracting data from various DB like Oracle 9i, SQL Server, XML files and loading into Oracle Database

ENVIRONMENT: & TOOLS: Informatica Power Center 8.6, Shell Scripting, Oracle 9i, Sun OS UNIX/Linux, Redwood.

Confidential

Application Developer

Responsibilities:

• Design the LLDs(Low Level Designs) for each source database
• Create the mapping specification templates for extracting data for different Applications.
• Built jobs to Extract, Transform and Load data from and various databases using Informatica Power Center.
• Built reports based on Technical specification, performed Unit Test on jobs along with validations reports.
• Maintaining the Audit Repository database trimming, shrinking and backup
• Created shell scripts to FTP the files from enterprise systems
• Worked with testing team to understand the validation requirements to design mappings.
• Work with Functional team to make sure required data has been extracted and loaded.
• Handled deployment activities to Production.
• Responsible for overseeing the Quality procedures related to the project and also unit testing

ENVIRONMENT: & TOOLS: SQL, Pro*C, Brio, Oracle 9i, UNIX.

Confidential

Software Engineer

Responsibilities:

• Analysis and study of the system specially COLLECTIONS processing.
• Contacting users and understanding the real problem
• Understanding Change Requests (CR) and raising the same for Business.
• Amending the system as per faults founds or user requests.
• Unit testing of scripts to resolve the issue.

ENVIRONMENT: & TOOLS: SQL, PL/SQL, Pro*C, Oracle 9i, UNIX, Toad

Confidential 

Software Engineer

Responsibilities:

• Design and development
• Coding and documentation
• Review of Analysis and code
• Testing - unit testing
• User communication
• Responsible for overseeing the Quality procedures related to the project
• Bug fixing

ENVIRONMENT: & TOOLS: SQL, PL/SQL, Pro*C, Oracle 9i, UNIX, BO, Toad, Sun-OS