SUMMARY:

• Confidential has over all 15 years of IT experience with 12 years of extensive experience in INFORMATICA with experience in ETL Architect, solution Architect, Analysis, Design, Development, Implementation, Administration and Maintenance of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server on Windows and Unix/Linux Platforms in Various verticals such as Insurance, Retail, Healthcare. Involved in Project Management and Coordination, Project Schedule, Status reports, Project Tracking, Risk Management, Resource management & Team Management, Interview/SO Allocation process, supporting the activities related to the preparation of business proposals.
• He has rich experience in Agile projects with hands on experience in conducting Scrum daily standup, planning and clearing the Product backlogs, and coordinating the Sprint activities. Rich experience in standardizing the Bi - weekly change management releases, each delivered on time with high quality and completed within budget.
• Confidential is a fully committed professional with a razor sharp focus on project timelines and outcomes, with an ability to work in a multi-cultural team environments. He has also repeatedly demonstrated the project leadership qualities to work in time/budget critical projects to consistently meet the project/release goals committed to the business teams. He has initiated and actively supported many automation initiatives within the Sprint to rapidly increase the speed to deliver the IT systems to business.

TECHNICAL SKILLS:

Databases: - Oracle 10g/11g/12g,DB2,Netezza,SQL Server

Languages: - PL/SQL, Perl, Python

Incident Management: Service now

Modeling Tools: Microsoft Visio, CA ERWin 7.3,ER Studio

PM Tools: MS Projects 2010, Agile Scrum - Jira, MS SharePoint and MS Office

Operating systems: - Linux, UNIX, Windows (3.x, 95, NT, 2000, XP)

Tools: - Informatica Powercenter 8.x,9.x and 10.x, Power exchange, Power Center Data Analyzer, Informatica Data Explorer Client 8.6, Informatica Metadata Manager, Informatica Admin console, Informatica Developer, Informatica Data Quality (IDQ), Informatica B2B,Hadoop

Other Utilities: -Tidal, Autosys, SVN, Putty, HP QC

PROFESSIONAL EXPERIENCE:

Confidential, Lexington, MA

ETL Architect

Responsibilities:

• Led a team for all requirement gathering and implementation.
• Led a group of technical onsite developers and support team during the project deliverables.
• As collaborate with business and technical SME's to identify data integration requirements and interface non-functional requirements
• Update the Technical specification for the ETL batch integration layer including data models and ETL processes.
• Develop Data Models and ETL Components in close collaboration with other teams.
• Involved ETL enhancements for existing /new jobs to create the XML files from existing Crownweb CMS database.
• Designed database models including creation of tables, referential integrity, keys and constraints.
• Fix the defects and implement change requests in the interfaces through various stages of Vendor integration testing, QA and UAT testing.
• Involved in daily stand-ups, backlog grooming, sprint planning, retrospectives, etc.
• Initiated product backlog and developed user stories with clear acceptance criteria
• Provide UAT support for the data validation process
• Provide Implementation support with deployment plans and environment validation strategies.
• Change management/Implementation plan thru CR tickets for completed JIRA sprint tasks.
• Interact with infrastructure, release management, change management, QA, Database Administrator and related internal teams.

Confidential

Project Manager

Responsibilities:

• Led a team of Onsite and Offshore Designers, as of the new Data population architecture.
• Led a group of technical on-shore and off-shore developers and support team during the project deliverables.
• Design the overall data integration framework architecture for the CDF future state incorporating the different interfaces, processes and recommended integration patterns.
• Designed and mentored multiple batch and real time processes, which were used by many other applications outside the platform.
• As collaborate with business and technical SME's to identify data integration requirements and interface non-functional requirements
• Create High level and low level technical design for the ETL batch integration layer including data models and ETL processes.
• Data profiling done using the IDQ
• Develop Data Models and ETL Components in close collaboration with other teams involving ODS and MDM.
• Developed ETL jobs to create the XML/JSON files from existing CDF MDM/ODS & CIDB customer tables.
• Designed database models including creation of tables, referential integrity, keys and constraints.
• Developed B2B process for sharing the Acxiom inbound/outbound files.
• Upload the design details in Confluence for design discussions and for approvals.
• Fix the defects and implement change requests in the interfaces through various stages of Vendor integration testing, QA and UAT testing.
• Plan and coordinate activities with Offshore and participate in daily scrum calls with status updates.
• Involved in daily stand-ups, backlog grooming, sprint planning, retrospectives, etc.
• Initiated product backlog and developed user stories with clear acceptance criteria
• Provide UAT support for the data validation process
• Provide Implementation support with deployment plans and environment validation strategies.
• Change management/Implementation plan thru CR tickets for completed JIRA sprint tasks.
• Interact with infrastructure, release management, change management, QA, Database Administrator and related internal teams.

Confidential, El Dorado Hills, CA

ETL Architect

Responsibilities:

• Generating the NPE support status reports for Client meetings.
• Worked as NPE support lead for onsite/offshore incident fix deliverables.
• Verify the details of the incident and collect and analyze related information.
• Attempt to replicate and verify the issue to confirm it is an incident or not.
• Determine whether or not the incident is related to a known error or from existing issue. Work with Problem Management to diagnose any new problem to fix.
• Attempt workarounds or published solutions (eg. - Rebooting the server or tool)
• Coordinate the diagnosis and resolution tasks with other support groups via SMS assignments.
• Worked on Change Management tickets for change requests/incident deployments.
• Record in SMS the investigation / Diagnosis steps that are taken
• Proceed to the Resolution and Recovery phase when possible or escalate to Lead for further investigation and diagnosis by contacting the appropriate third party vendor or supplier and logging a ticket with them.

Confidential, El Dorado Hills, CA

Technical Lead

Responsibilities:

• As Technical Lead, the main responsibilities included coordination with the Facets Analysis, Clients and gathering the user requirements
• Responsible for Business meeting, conversion of business rules into technical specifications
• Assigned the work to development team by creating the individual tasks and updating the status to the project managers.
• Leading the team in implementing all deliverables for every release, Defects fix, CR Implementations.
• Responsible for Code and design documents review.

Confidential, El Dorado Hills, CA

Technical Lead

Responsibilities:

• As Technical Lead Coordination with the Facets Analysis, Clients and gathering the user requirements
• Responsible for Business meeting, conversion of business rules into technical specifications
• Assigned the work to development team by creating the individual tasks and updating the status to the project managers.
• Leading the team in implementing all deliverables for every release.
• Responsible for Code and design documents review.

Confidential, El Dorado Hills, CA

Technical Lead

Responsibilities:

• As Project Lead the main responsibilities included coordination with the Facets Analysis, Clients and gathering the user requirements
• Responsible for Business meeting, conversion of business rules into technical specifications
• Assigned the work to development team by creating the individual tasks and updating the status to the project managers.
• Leading the team in implementing all deliverables for every release.
• Responsible for Code and design documents review.

Confidential, Detroit, MI

Technical Lead

Responsibilities:

• As Project Lead main responsibilities is involving in BRD and Requirement Analysis, Involving in Project Estimations and Resource Plan.
• Coordination with the client and gathering the user requirements
• Preparing the Project plan and Resource plan for Development Activities.
• Assisting the systems analysts in source data analysis and in creation of the functional specification documents.
• Participated in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Responsible for Business meeting, conversion of business rules into technical specifications
• Leading team in implementing all actions required to deploy an application
• Responsible for the Code Review of the team and also for the migration of the code

Confidential

Technical Consultant

Responsibilities:

• As Technical Lead, the main responsibilities included Design; Review the Process, Performance Tuning, Error Handling and Implementation of Best Practices.
• As Administrator User support, folders management, administration using Informatica Administration Console, upgrade, activities such as starting / stopping server as well as analysis/design/development/ testing activities as part of different development Projects on Informatica PowerCenter environment.

Confidential

Sr. Developer

Responsibilities:

• As Project Engineer, Involved in Design, Development, Testing and Production Implementations.
• Prepared Requirement Interface and Requirement Analysis Document, Data Source Mapping Document, High Level Design Document, Low Level Design Document and Component Test Cases. Also Developed Stored Procedure in Oracle.

Confidential, St Simi Valley, CA

Sr. Developer

Responsibilities:

• As Project Engineer, Involved in Design, Development, Testing and Production
• Development process - From Low Level Design, Developing the Mapping/Test plan/Test cases/Self and Peer Review/Defects tracking and Fixing.
• The dependencies tracked and accordingly the component execution order has been prepared and executed.
• Scheduling the execution of the component according to the requirement.

Confidential

Sr. Developer

Responsibilities:

• As Project Engineer, Involved in Design, Development, Testing and Production Implementations.
• Prepared ETL Mappings Specifications,Test Cases, Developed ETL Mappings, Co-ordinating with offsite teams on development / maintenance projects and Status Reporting on a daily/ weekly Basis

Confidential

Software Engineer

Responsibilities:

• As Senior Developer Involved in Design, Development, Testing and Production implementations.
• Design & Formatting various Reports, Charts using various Data Providers like Universe, Text Files, Excel Sheets etc for Analysis purposes. Gap analysis for designing and building reports.
• Resolving loops with aliases and traps. Ad-hoc reporting, providing security at user level. Creating Reports for various levels. Placing a proper Business Objects security like Login UserId and Password for restricting access to data and BO modules.

Confidential

Software Engineer

Responsibilities:

• As Programmer involved Development, Testing and Production Implementations.
• Configuring the Data warehouse on Business Objects by building the universe using Designer module.
• Interacted with users and database designers to get required information for report design processes and implemented optimization techniques to enhance performance of the queries dynamically generated by Business Objects.
• Generate reports as per the user requirements.
• Create users and assigned privileges using supervisor module.

Confidential

Sr. Programmer

Responsibilities:

• As Senior Developer Involved in Design, Development, Testing and Production implementations.
• As Designer involved Design and Development
• Involved in Inter unit Transfer, Quality Inspection, Despatch entry Module
• Design & Formatting various Reports, Charts using various Data Providers like Universe, Text Files, and Excel Sheets etc for Analysis purposes. Gap analysis for designing and building reports.
• Resolving loops with aliases and traps. Ad-hoc reporting, providing security at user level. Creating Reports for various levels. Placing a proper Business Objects security like Login UserId and Password for restricting access to data and BO modules.