SUMMARY:

• More than 8 years of IT experience in the Data Warehousing, ETL, Business Intelligence, OLAP, Data Analysis, Design, Development, Implementation, Testing and troubleshooting of DW, BI, Database applications. Strong emphasis on user requirements gathering and business rules, technical and data analysis and leading the projects from end to end. Coordinating with IT in migration process, training, presenting BI solution to users, documenting test plans, user requirements, functional, technical specifications, creating and maintaining project plans.
• Good experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center, Power Mart.
• Hands on experience with developing complex mappings using varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re - usable transformations.
• Good experience in analysis of source systems, building staging area & designing target systems.
• Experience in data sources like Oracle, Fixed Width and Delimited Flat Files etc.
• Knowledge in using BI Tools like Business Objects XI R2/6.x/5.x to build user defined queries and reports
• Good experience in Oracle 8i/9i/10g/11i and Teradata databases, Remedy and Tivoli.
• Excellent analytical and logical skills and possess excellent presentation skills with a strong desire to achieve specified goals.
• Good team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.5.1/9.1/8.6.1./8.1/7.1/6.2/5.1, Informatica Data Quality (IDQ) and Informatica Data Explorer.

Data Modeling: Star-Schema Modeling, Snowflakes, FACT & Dimension Tables

Databases: Oracle 9i/8i/10g/11i, Teradata

Business Intelligence: Business Objects XI R 2/6.0/5.1/5.0, Business Objects Designer, Crystal Reports.

Programming Languages: SQL,PL/SQL, Unix Shell Scripting, C, Java, VBScript, Visual Basic 6.0/5.0/4.0, HTML 4.0, DHTML

Environment: Windows NT 4.0, Win 95/98/2000, Unix, Linux, Toad, Nexus Query Chameleon, SQL Assistant, Remedy, Tivoli.

PROFESSIONAL EXPERIENCE:

Confidential,San Ramon,CA

Sr. ETL Developer

Responsibilities:

• Gathered business requirements and data specifications from business partner for Auto Loans Module.
• Analyzed the metadata document and data mapping document provided by business users and created tech specs and test cases documents based on it.
• Developed ETL/Informatica mappings and performed unit testing by executing the test cases.
• Performed code review and technical documentation walkthroughs.
• Worked as a release coordinator for QA/UEDW/PEDW migrations and migrated successfully to all environments.

Environment: Informatica Power Center 9.6.1, Oracle 11i, UNIX, TOAD, SQL developer, Windows, Remedy, Tivoli.

Confidential, Pleasanton, CA

ETL Developer

• The CaPDR-California Pharmacy data repository is intended to meet the needs of the reporting community. It was intended to minimize disruption to the California regions’ analytical processes and to continue support for the critical business functions that they provide, as the California regions transitioned from their regional legacy applications to the new ePIMS solution.
• CaPDR has ePIMS (Electronic Pharmacy Information Management System), POS (Point of Sale) and PBM (Pharmacy Benefits Management) data. ePIMS and POS data is sent by the PDW team to the landing zone. PBM has 3 vendors: MI (Med Impact), OPTUMRX and Catamaran and the data is sent by the PBM team to landing zone. From landing zone, the data is extracted using informatica tool and stored in CaPD Repository.
• Designed ETL framework and created ETL design document as per the business requirements.
• Created ETL data mappings with required transformation logic, sources and targets.
• Conducted design review and data mapping walk-throughs with team.
• Developed Informatica mappings, transformations, reusable objects by using mapping designer, and transformation developer in Informatica Power Center 9.1.0
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence generator, Update Strategy, Lookup, Joiner and Source Qualifier transformations.
• Optimized the performance of Sessions and Mappings.
• Assisted junior developers in coding and triaging issues.
• Worked on production support activities including checking the daily loads, helping users in understanding the data and answering their questions.
• Enhanced existing code as per the business requirements and solved production data issues reported by the users.

Environment: Informatica Power Center 9.5.1, 9.1.0, 8.6.1, IDQ, Oracle 11i, UNIX, TOAD, SQL developer, Windows, Remedy, Tivoli.

Confidential,SFO, CA

ETL Developer

• Analyzed business requirements with the management and converted them into project documentation and created process flow diagrams.
• Worked on the migration of compensation trade objects from FITEQ PROD database to AMPSMIS PROD database to decommission the FITEQ PROD database.
• As a part of the migration project, designed and developed the User Maintained tables instead of having the information getting loaded into the tables from spread sheets.
• Converted the Informatica logic by developing the SQL Scripts and retired Informatica workflows.
• Worked on tuning the crystal reports queries to improve the performance and pointing to the UM tables wherever necessary.
• Created user manuals for UM tables and trained users on how to use those tables.
• Provided support to fixed income users by answering their questions and resolving their issues related to compensation trades reports.
• Handling adhoc requests from legal / compliance related to fixed income positions / transactions by querying data warehouse using teradata.

Environment: BOXI - R3, Crystal Reports, Informatica Power Center 8.6.1, Teradata, Oracle 11i, UNIX, Nexus Query Chameleon, Teradata SQL Assistant, Windows.

Confidential,San Jose,CA

Programmer Analyst

• Involved in analyzing business requirements with the management and converted them into project documentation.
• Developed Informatica mappings, transformations, reusable objects by using mapping designer, and transformation developer and mapplet designer in Informatica Power Center 8.1.1
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Business objects Upgrade from BO6.5 to BOXIR3:
• Involved in Business Objects report testing.
• Tested and validated BOXI - R2 reports and compared the results to BO 6.5 version.
• Tested BOXI-R3 reports and compared the results to BOXI-R2 and BO 6.5 version.

Environment: Informatica PowerCenter 8.1.1, Oracle 9i/8i, UNIX, BO 6.5, BOXI - R2, BOXI - R3, Oracle11i, TOAD, SQL*Plus, Windows, UNIX.

Confidential,San Ramon,CA

ETL Developer

• CCPM is tool for Call Center Performance Management for AT& Confidential business analysis team. The CCPM program is intended to aggregate data from various systems with a comprehensive set of tools for reporting to improve business operations and individual performance. Implementing this program will allow AT& Confidential to analyze data, from the employee to enterprise level, across functional perspectives such as operations, sales, quality and customer care.
• Contributions:
• Developed code and provided application code support (e.g., root cause, bug fixes) to meet business requirements.
• Used technical expertise to translate business requirements into detailed functional designs, conducted walk-throughs, and obtains sign-off.
• Worked on optimization and performance tuning of the Sessions and Mappings.
• Assisted in architectural design efforts and in post-implementation support of systems.
• Created user or technical documentation as appropriate.

Environment: Informatica PowerCenter8.6.1, Oracle11i, TOAD, SQL*Plus, PL/SQL, SQL*Loader, Windows, UNIX.

Confidential,Santa Clara, CA

Software Engineer

• SPM (Services Project Manger) Reporting
• Professional Services uses the Services Project Manger (SPM) App Exchange extension to Sales Force dot Com (SFDC) to enter and track project costs for brocade’s non employee field personnel. As a member of Professional Services group got involved in building reports which helped the business to measure project profitability.
• Interacted with business analysts and end users to identify and develop business requirements and transform them into technical requirements.
• Developed new Informatica mappings by extracting data from Salesforce.com using various transformations like Lookup, Update Strategy, Joiner, Aggregator, Router, Expression, Filter and Source Qualifier transformations.
• Worked on optimization and performance tuning of the Sessions and Mappings.
• Tuned the SQL Queries using Hints, Indexes and Explain Plan concepts for query optimization for better performance.