PROFESSIONAL SUMMARY:

• 8+yrs of Data Warehousing ETL experience using Informatica Power Center, Teradata, Oracle, Business Objects, Erwin, SSIS & SSRS
• Experience in building Data Warehouses and Data Marts from a Technical and Functional perspective
• Solid experience with large - scale, distributed systems design and development with a strong understanding of scaling, performance and scheduling
• Proficient in data warehousing concepts - Star Schema, Snowflake Schema and Slowly Changing Dimensions
• Knowledge and design experience in Financial Services Logical Data Model (FS-LDM) and data modeling using ERWIN
• Perform business analysis and develop data flow diagrams and source mapping specifications.
• Expertise in developing ETL strategies for data integration from various data source systems into the corporate data warehouse using various tools of Informatica
• Extensive experience in developing complex mappings using different transformations like aggregator, sorter, expression, look up, update strategy, normalizer
• Expertise in troubleshooting, Debugging and resolving issues related to system performance, ETL applications, BI application and data integrity
• Proficient in writing B-t0065q, M-load, Fast-load, Fast-Export, TPump utilities in Teradata
• Proficient in working with SQL, PL/SQL to write stored procedures, Functions, Cursors, Triggers and Packages.
• Experience in writing shell script in UNIX
• Knowledge in creating the Universe, classes, objects and measures, Resolving loops using Alias and context, using @ functions(@prompt,@select,@aggregate aware,@where)
• Knowledge in using Break, Section, Ranking, Sorting, Alerter, Conditions, Drill, variables and functions in the web intelligence reports
• Excellent project management experience, with the ability to lead and handle multiple time-sensitive, cross-functional projects
• Exceptional communication and presentation skills. Demonstrated ability to clarify and summarize complex issues, leading to thoughtful recommendations and action plans
• Ability to effectively operate with high energy and flexibility in a fast-paced, constantly evolving team environment.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 6.X/7.X/8.X/9.X, Data Stage, SSIS

OLAP Tools: Business Objects 5.1/6.1/ XI R2,SSRS, SSAS

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

Languages: C, C ++, Java, VB, SQL, PL/SQL

Operating Systems: Windows 98/2000/XP/7, UNIX

Other Tools: Erwin 4.0, Toad, IBM Tivoli 5.3, Control M, Redwood Cronacle 6

Domain Knowledge: Sales, Inventory, Commercial Finance, Banking, Healthcare, Telecommunications, Vision Plus, Loans, Deposits

PROFESSIONAL EXPERIENCE:

Confidential

Lead ETL Developer

Environment: Informatica 8.6.1, Oracle, Business Objects XI R3, UNIX, Windows XP

Responsibilities:

• Assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of artifacts.
• Assessing requirements for completeness and accuracy and determine if requirements are actionable for the ETL team. Work with requirement providers to close issues and gaps
• Business requirement analysis, Impact analysis, gathering and getting clarified the requirements from business by attending and arranging frequent meetings
• Coordinate all aspects of the project with other teams, such as Data Architecture, Reporting, Quality Assurance, Support, Infrastructure as well as business owners and management
• Perform impact assessment and scope the size of the effort based on the requirements
• Architect the solution and ensure that it fits into the overall ETL/Informatica architecture at Client
• Ensure new features and subject areas are modeled to integrate with existing structures and provide a consistent view
• Gathering and documenting the technical and business meta data about the data as well as providing insight into the data itself by developing data flow diagrams and mapping specifications and Technical Design.
• Change management activities and estimation of LOE and preparation of Task Plan
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer and Mapping Designer
• Developed complex Informatica Mappings and Mapplets by using Reusable Transformations, SAP Bapi, Normalizer, Aggregator, Lookup, and Update Strategy.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level
• Successfully implemented ETL error handling and ETL audit process and generated automatic loading and error monitoring reports.
• Extensively worked with Slowly Changing Dimensions Type2 for Data Loads
• Improved data integrity, data load performance, and flexibility to add new sources.
• Responsible for Bug fixing, Trouble Shooting, improving ETL and System performance.
• Coordinate with the Quality Assurance team to plan and execute QA testing and resolve of any defects
• Testing by writing SQL test queries to test the data in Dev, Test and Prod environments
• Responsible to work with release management team to make sure proper code deployment.
• Handled various loads like Intra Day Loads, Daily Loads, Weekly Loads, Monthly Loads, and Quarterly Loads using Incremental Loading Technique
• For enhancements involved in production support duties to ensure all jobs run successfully to meet SLAs and also deliver the reports to users on time.

Confidential

Lead ETL Developer

Environment: Informatica 8.6.1, Oracle, Business Objects XI R3, UNIX, Windows XP

Responsibilities:

• Assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of artifacts.
• Business requirement analysis, Impact analysis, gathering and getting clarified the requirements from business by attending and arranging frequent meetings
• Ensure new features and subject areas are modeled to integrate with existing structures and provide a consistent view
• Gathering and documenting the technical and business meta data about the data as well as providing insight into the data itself by developing data flow diagrams and mapping specifications and Technical Design.
• Change management activities and estimation of LOE and preparation of Task Plan
• Distribute the work among the team and responsible for the delivery of the given modules on time.
• Extensively worked on complex ETL mapping by using Informatica SAP Bapi, Normalizer, Aggregator, Lookup, and Update Strategy.
• Responsible to work with release management team to make sure proper code deployment.
• In production support duties ensuring all jobs run successfully to meet SLAs and also deliver the reports to users on time.
• Job Monitoring, Scheduling and Fixing job failures on time.

Confidential

Data Architect

Environment: Informatica 8.6.1, Teradata 12.1, Business Objects XI R3, UNIX, Windows XP

Responsibilities:

• Worked as a Data Architect
• Assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of artifacts.
• Gathering and getting clarified the requirements from business by attending and arranging frequent meetings
• Ensure new features and subject areas are modeled to integrate with existing structures and provide a consistent view
• Gathering and documenting the technical and business meta data about the data as well as providing insight into the data itself.
• Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences.
• Perform business analysis and develop data flow diagrams and mapping specifications.
• Provide direction on parameters for construction of appropriate test cases for validation of ETL processes.
• Releasing the ETL specs as per the business rules and logic
• Assisting with testing by writing SQL test queries to test the data in Dev, Test and Prod environments
• Leading the team with the size of 3 and effectively getting the work from the team
• Develop, monitor and maintain the project plan, which will contain details of the schedule of the activities and their deliverables for each member of the team in a non-resource overloading fashion.

Confidential

ETL Lead/Project Lead

Environment: Informatica 8.6.1, Teradata 12.1, Business Objects XI R3, UNIX, Windows XP, IBM Tivoli

Responsibilities:

• Currently working in BAU(Business As Usual), (Production) support in the Issue fixing Team and supporting Confidential project
• Involved in the development, testing and go live phases of Confidential and moved into BAU support for Confidential
• Supporting defect investigation and fixes
• Assisting with build, test, and deploy activities
• To debug and modify the problems occurred in Teradata, UNIX.
• Performing testing work
• Gathering and getting clarified the requirements from business analysts by attending and arranging frequent meetings
• Responsible to document design /technical process and get sign of from Client
• Setup project environment in Development & Testing
• Leading the team with the size of 5 and effectively getting the work from the team
• Develop, monitor and maintain the project plan that will contain details of the schedule of the activities and their deliverables for each member of the team in a non-resource overloading fashion.
• Responsible to deliver the code on time to QA, Beta and Production environments
• Given extensive support to QA and UAT
• Responsible to get project UAT sign off and one time artifacts run
• Involved in raising and getting approvals for CR’s from client
• Developed B-teq scripts for loading the data from CB Indonesia to Confidential tables for AML and Fraud modules.
• Worked on Expression, Aggregator, Sorter, Router transformations to load the data into the AML tables.
• Worked on Control flow, Containers, Data flow, Variables and Configurations, Debugging, Error Handling and Logging to load the data into the Fraud tables.
• Worked on Copy Column, Derived Column Transformation, The Data Conversion, Conditional Split, Aggregate, Sort, Slowly Changing Dimension, Merge and Merge Join, Lookup Transformations
• Worked in Deploying and Managing SSIS Packages
• Proficient in universe development using Designer.
• Create complex interactive reports as well as ad-hoc queries (Deski, Webi).

Confidential

Team Lead/Developer

Environment: Informatica 8.6.1, Teradata 12.1, Business Objects XI R3, UNIX, Windows XP, IBM Tivoli

Responsibilities:

• Analyzing & reviewing the client’s source map specifications and involving the walk through phases for each module prior to development.
• Leading the team with the size of 5 and effectively getting the work from the team
• Responsible for the delivery of the given modules on time
• Involved in complete ETL life cycle of the project
• Given extensive support to QA and UAT
• Leading the team with the size of 5 and effectively getting the work from the team
• Responsible to document design /technical process and get sign of from Client

Confidential

Developer

Environment: Informatica 8.6.1, Teradata 12.1, Business Objects XI R3, UNIX, Windows XP, IBM Tivoli

Responsibilities:

• Analyzing & reviewing the client’s source map specifications and involving the walk through phases for each module prior to development.
• Responsible for the delivery of the given modules on time
• Involved in complete ETL life cycle of the project
• Given extensive support to QA and UAT
• Responsible to deliver the code on time to QA, Beta and Production environments

Confidential

Developer, Offshore coordinator

Environment: Informatica Power Center, Cognos Reportnet, Redwood Cronacle, Teradata

Responsibilities:

• Developed mappings for the dimensions and fact.
• Developed documents like UTP (Unit Test Plan), FMEA (Failure Mode and Effects Analysis), ETL Specification, Capacity Plan, Cronacle Setup, Teradata Performance.
• Developed the BTeq script, Job Chain.
• Configured and Scheduled the Sessions to effective load.
• Created and Run the Sessions to load the data from source to target database using Workflow Manager.
• Involved in different phases of the Project (M1, M2M3, M4, and M5).
• Validating the data in each phase.
• Extensively involved in different phases of migration of the project (From Dev to QA, From QA to Prod).
• Coordinated with the QA (Testing team) and the Prod team and resolved the Hii Logs and Issues during the migration phase of the Project.
• Worked on the enhancements and resolved the issues.

Confidential

Developer

Environment: Informatica Power Center, Business Objects, Oracle

Responsibilities:

• Developed various Mappings and Transformations using Informatica Designer.
• Developed complex Mappings using Expressions, Routers, Lookups, Rank, Filter, Aggregator transformations.
• Developed complex mappings using multiple sources and targets in different databases, flat and XML files.
• Created and configured Sessions to load the data from source to target database using Workflow Manager.
• Configured session properties and target options for better performance.
• Writing PL/SQL Functions, Procedures, Packages, and Triggers.
• Developing the reports using Business Objects