SUMMARY:

• 13+ years of experience as Technical Architect, Solution Designer, Lead Developer, Module & Production Support Lead, in areas of Data warehouse and OLTP Application Development, Enhancements and Production Support.
• Extensive hands - on experience in creating new Data Model strategy for large application migration, well verse with implementation of SDLC phases - Requirement and Gap Analysis, Data Veracity Analysis, ETL Development, Data Migration strategy, Quality Reviews.
• Domain knowledge span across Finance & Banking, Energy and Utility, Pharma and Healthcare with 8+ years working at clients’ location.
• Additional responsibility includes managing team of 20+ resources, project assignments, annual appraisals, RFP and Solution building, budgeting, responsibility of P&L for individual functional areas, identify and achieve strategic growth area for account.

TECHNICAL SKILLS:

Primary Expertise: Datastage 11.3/8.5, Information Power Center 8.6, PL/SQL, SQL, Siebel EIM

Secondary Expertise: Hadoop 2x, Hive, Pig Latin, HBASE, MapR

Knowledge of: REST API, Mongo DB, Oracle Real-time Decision Analytics, Apache Spark stack

Scripting Languages: Unix, Perl

Scheduler: Autosys, Tivoli

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead, Solution Designer, Lead developer

Tools: Infosphere Datastage, Quality Stage, Siebel EIM, Hadoop 2.x, Autosys

Responsibilities:

• Role - Architect & Solution Designer, Lead Developer
• Initiation of Projects, understand High Level Requirement & resource assessment
• Project Planning, milestone settings
• Participate in Business grooming session, understanding process flow/ functional details
• Reviewing BRD and FRD, Draft solutions
• Lead Solution design calls along with Client SME and technical leads
• Design Sign-off by Enterprise architecture team
• Create Low level design for optimum solution, prepare Technical design document
• Data analysis and in corporate feedback into system design, review High Level design and adjust as per requirement
• Design Datastage batch Job, create sources and targets. Transform Data
• Implementation of batch Job and Siebel EIM scripts. Address Data cleansing using Qualitystage component of Infosphere stack
• Set up data archiving into Hadoop cluster
• Connect internal and External REST services to extract data/ upload data
• Create supporting store procedures, and data elements and objects
• Comprehensive Unit testing and guiding QA team with functional overview of batch component
• Create value-add tools for client - Parallel Development Repository comparator, Crash log Analyzer
• Mitigate Operational Issues & Team Management

Confidential

Solution Designer

Tools: Infosphere Datastage, Informatica, Siebel EIM, Business Object

Responsibilities:

• Role - Lead Developer
• Key part of project was to understand existing functionality and data flow, match and compare against new data model.
• Prepare batch requirement documents, mapping document and gap analysis.
• Work with Client SMEs to identify and propose solution for identified gaps
• Prepare list of redundant jobs for retirement, derive phased plan & obtain sign-off from business
• Create Batch Requirement FRD, develop data migration strategy
• Design the ETL platform in Informatica - set standards, naming convention, folder structure
• Create Technical design document (TDD)
• Development of new ETL Jobs - workflows, session & Mapping, sources, targets, configure repository settings
• Define standards for repository migration and code deployment.
• Connect internal and External SOAP services to extract data/ upload data
• Team management - task assignments and monitor and review the progress
• Internal Code review to ensure quality and standards
• Planned release of transformed ETL jobs to support UI functionality - ensure zero downtime
• Comprehensive Unit testing and guiding QA team with functional overview of batch component

Confidential

Migration Lead

Tools: PL/SQL, Putty, WinSCP, Toad 9.0, Siebel EIM, Informatica

Responsibilities:

• Create a migration plan, Impact & Risk Analysis
• Regression Testing of individual script for production deployment
• Milestone tracking, Release Activity and communication
• SLA Reporting

Confidential

Production Support Lead, Incident Manager

Tools: Informatica, Business Object R3, Remedy, PL/SQL

Responsibilities:

• Incident Manager, end-to-end ownership of high severity incidents
• Host ‘war room’ for critical incidents involving multiple vendors & stakeholders
• Monthly SLA reporting, help team with 3rd Line Incident resolution
• Create and execute continuous Service Improvements Plan (SIP)
• Requirement gathering for user enhancements & prioritization
• Client expectation management
• Technical troubleshooting & solution
• Application onboarding

Confidential

Team Lead, Team member

Tools: Informatica, SQL Server 2003, Peregrine ticketing tool

Responsibilities:

• Set up Process for Incident Management
• Queue monitoring and Technical solutions, Data feed maintenance
• Maintaining common mailboxes for Globally 700+ users
• Ownership of SLA adherence
• Environment & Application set up on fleets and its maintenance
• Client expectation management
• Transition & Application Onboarding

Confidential

Team member

Tools: SQL Server 2003, Peregrine ticketing tool

Responsibilities:

• Incident Queue monitoring and address Technical queries
• Apply data fixes and when required through change control
• Prepare scripts for E-statement generation
• Troubleshoot issue with E-statement process
• Gather requirements for Statement modification