SUMMARY:

• Confidential has 10+ years of professional experience IT especially in Data warehousing and Business Intelligence domains
• Possess very good exposure in global delivery model by collaborating with business stakeholders across geographies
• Possess expert knowledge in Data Warehousing domain
• Possess very good knowledge in Dimensional Model as well as Data Model
• Possess expert knowledge in ETL Architecture
• Possess good experience in designing ETL framework
• Possess good knowledge in MicroStrategy reporting as a developer on public objects
• Hands on experience in Waterfall model as well as Agile Model execution using JIRA
• Possess sound experience in SDLC end to end implementation
• Optimize ETL codes (Mappings, Workflows) and SQL Queries for tuning performance
• Hands on experience in configuration management
• Execute projects in CMM level 5 standards
• Involve in RFPs for solutions and estimations
• He has worked for top - notch customers for various domains

TECHNICAL SKILLS:

ETL Tool: Informatica PowerCenter (7.1.3, 8.1.1, 8.5.1, 8.6.1, 9.1, 9.5)

Reporting Tool: MicroStrategy 9.4

Database: Oracle, SQL Server, Teradata

Operating System: Windows (98/2000/2003/ XP/2008/2010)

Scheduling Tool: UC4 Scheduler

Script: Shell script (UNIX)

PROFESSIONAL EXPERIENCE:

Confidential

Technologies: Informatica, Oracle, Unix, UC4 Scheduler

Technical Lead

Responsibilities:

• Requirement elicitation and assessment
• Conduct impact assessment and determine size of effort based on requirements
• Develop full SDLC project plans to implement ETL solution and identify resource requirements
• Design application architecture with a framework of unanimous scheduling platform to migrate the schedule from platform-based execution which scales up from batch-based schedule to event-driven schedule architecture
• Develop UC4 jobs, Job Plans and Events
• Promote UC4 Jobs to the higher environments and provide hands on guidance to other team members
• Develop mappings, sessions, workflows
• Re-design ETL (existing workflows) execution to optimize performance
• Coordinate SIT and UAT
• Collaborate with business and stakeholders to resolve issues

Confidential

Technologies: Informatica, Oracle, Unix

Technical Lead

Responsibilities:

• Worked in global delivery model
• Requirement elicitation and assess requirements for completeness and accuracy
• Determine if requirements are actionable for ETL team.
• Collaborate with business across geographies and stakeholders to develop architectural requirements
• Create application architecture document
• Develop full SDLC project plans to implement the product
• Lead ETL requirements and design
• Assist offshore team to develop Spotfire solution as an UI application
• Develop ETL codes (Mappings, Sessions, Worklets, Workflows)
• Coordinate SIT and UAT
• Collaborate with business and stakeholders to resolve issues
• Production Deployment

Confidential

Technologies: Informatica, Oracle, Unix

Technical Consultant

Responsibilities:

• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture
• Perform as leading role in shaping and enhancing overall ETL Informatica architecture
• Identify, recommend and implement ETL process and architecture improvements
• Assist and verify design of solution and production of all design phase deliverables

Confidential

Technologies: Microstrategy, Teradata

BI Engineer

Responsibilities:

• Worked on Agile Methodology
• Develop datasets, reports and report documents
• Support SIT & UAT for defect fix
• Implementation support

Confidential

Technologies: Data stage, Teradata

ETL Consultant

Responsibilities:

• Requirement Analysis
• Create Technical Architecture Document
• Code development & unit testing
• Code integration based on load dependencies
• Adhere to the quality standards practiced by the client in terms of compliance, code standards and data quality
• Support SIT & UAT for defect fix
• Deployment & validation

Confidential

Technologies Informatica Power Center 9.1, Oracle 11G

ETL lead

Responsibilities:

• Team Management (Development as well as Maintenance)
• Code development for complex design & testing
• Code integration based on load dependencies
• Code review for functional validation
• Support SIT & UAT for defect fix
• Production Deployment
• Provide warranty support

Confidential

Technologies: Informatica Power Center 9.1, Oracle 11G

ETL lead

Responsibilities:

• Create technical architecture document
• Team Management
• Design mappings end to end flow
• Involved in code development & testing
• Do code integration based on load dependencies
• Coordination with SIT Team for defect fixing
• Perform functional and data validations in the mapping and sessions based on the specification document
• Adhere to the quality standards practiced by the client in terms of compliance, code standards and data quality
• Do code review
• Create Implementation Plan
• Deployment & warranty support

Project Scheduled Railway Project (SRP)

Confidential

Technologies: Informatica Power Center 8.6.1, SQL Server

ETL Sr. Developer

Responsibilities:

• Actively contribute in requirement analysis
• Create design documents (Master design document & detailed design) as per business requirement
• Mentoring team members
• Create test cases (Unit Testing & SIT)
• Code development & testing
• Code integration based on load dependencies
• Create reusable objects to avoid repetitive effort and to meet schedule adherence
• Coordinate with SIT Team for defect fixing
• Perform functional and data validations in the mapping and sessions based on the specification document
• Adhere to the quality standards practiced by the client in terms of compliance, code standards and data quality
• Do code review
• Implementation & warranty support

Confidential

Technologies: Informatica Power Center 8.5.1, Oracle 10G, UNIX Scripts

ETL Developer

Responsibilities:

• Actively contribute to requirement analysis in the project
• Code development, performance tuning and defect fixing
• Coordinate with SIT Team for defect fixing as well as QA team for defect tracking as well providing the fix
• Perform functional and data validations in the mapping and sessions based on the specification document
• Adhere to the quality standards practiced by the client in terms of compliance, code standards and data quality
• Do gap analysis by reviewing mapping specification documents for each interface to ensure the business rules are highly unambiguous
• Extensively worked in QA team
• Create QA test cases in accordance with the specification document as well as execution

Confidential

Technologies: Informatica 8.1.1, Oracle 9i, UNIX Scripts

ETL Developer

Responsibilities:

• Actively contribute to the design aspects as well as requirement analysis in the project
• Code development & Unit testing
• Written shell scripts to automate the source file check process
• Schedule Informatica Workflows for the entire project as per the business flow
• Actively involved in production rollout
• Warranty support

Confidential

Technologies: Informatica 8.1.1, Oracle 9i, UNIX Scripts

ETL Developer

Responsibilities:

• Requirement analysis
• Understanding the Design doc / Specification doc and transform into technical docs
• Design Low level design document (Md.200 Technical Design document)
• Code development and testing of mappings and workflows as per UTC
• Perform integration testing by integrating data with an upstream application data
• Code migration from DEV to higher environments and go alive
• Supported SIT and UAT

Confidential

ETL Developer

Technologies: Informatica 7.1.3, Oracle 9i

Responsibilities:

• Requirement analysis
• Designed Low level Design Documents
• Code Development
• Created Unit Test Cases
• Done unit testing as per UTC
• Created modules and chains to schedule the ETL loads in APPWORX scheduling tool