SUMMARY:

• Over 17 years of experience in Information Technology, including systems analysis, requirements definition, features prioritization, software design/implementation, operational management, systems maintenance/support, product documentation/, software development life cycle, etc.
• Successful track record of launching complex software integration and data warehouse projects, team building/mentoring, relationship/organizational/people management, resources/risk management, budget management
• Strong communication/presentation skills, leadership skills, customer - focused, detail-oriented, and high sense of responsibility and time/delivery commitments
• Excellent knowledge and hands on implementation integrating different SaaS applications using informatica cloud and on-premise
• 13 years of experience in Informatica (Ver 7 - 10) and Oracle Database (11,10g, 9i, 8i)
• 3 year of experience in informatica cloud (Certified Cloud Data Integration Specialist)
• Experience in all phases of integration (Data Profiling, Data Cleansing, Data Migration, Data Synchronization, Master Data Management) starting from requirements analysis into design, development, deployment and production support across various platforms (Dev., Test, QA and Production)
• Highly proficient in Informatica ETL (On-premise/Cloud) architecture, administration, development & trouble shooting
• Have expertise in tuning techniques for higher performance

PROFESSIONAL EXPERIENCE:

Confidential

Integration Architect

Responsibilities:

• Work with Chief Architect, Security, Salesforce Architect, Business Analyst to understand the legacy systems and come up with an integration plan
• Establish best practice, naming conventions, design, code and unit test informatica cloud and PowerCenter task across Dev., Pre-Prod environments and deploy to production
• Manage a team of 3 developers to meet the deadlines
• Reporting to Vice President on a weekly basis about the progress of the project

Confidential

Lead Informatica Cloud (Independent Consultant)

Responsibilities:

• Work with Business Analyst and Salesforce Architects to identify the integration needs to support move to Salesforce
• Design, code and unit test informatica cloud tasks across Dev., UAT, Pre-prod environments and finally deploy to Production
• Design, code and unit test informatica cloud real time tasks across Dev, UAT, Pre-prod environments and finally deploy to Production
• Perform User Maintenance activities in salesforce (roles, profiles, permission sets, etc.)
• Perform configuration changes using salesforce declarative functionality (Object creation, field validations, page layout etc.)

Confidential

Lead Informatica Cloud (Independent Consultant)

Responsibilities:

• Work with Business Analyst and Salesforce Architects to identify the integration needs to support MDM Cloud effort in SFDC
• Identify customers and create Beans and Master Beans in MDM cloud
• Implement the MDM cycle to create the Golden Record.
• Design, code and unit test informatica cloud tasks across Dev., UAT, Pre-prod environments and finally deploy to Production
• Perform POC on SalesForce and Service-Now integration using Web Service (ResT/ SOAP) calls
• Implement SalesForce and Service-Now integration using Web Service via Informatica Cloud
• Implement Oracle EBS and Amazon Redshift integration via Informatica Cloud
• Use unix script to capture the audit data and purge/clean the data by calling it from session task
• Excellent knowledge of MDM concepts - survivorship, best version records etc.
• Experience integrating the MDM System with other systems, using data interfaces
• Worked on ETL load (Cloud Design Mapping) for Landing the data in MDM
• Integrating the MDM Solution with Third Party Data Quality Tools for Data Cleansing and Matching (Address Doctor)

Confidential

Lead Informatica/ETL (Independent Consultant)

Responsibilities:

• Work closely with customers to understand the data migration need
• Perform detailed data analysis to understand the source system data
• Participate in reviewing/creating of the data warehouse data model
• Design high level ETL process and data flow from source system to DW
• Create source to target data mapping document for ETL processes
• Create physical Database objects including fact tables, dimensions, staging, views
• Develop and unit test Informatica ETL processes for optimal performance
• Develop and unit test Unix scripts for pre and post loading processes
• Develop Hadoop (Hive) scripts to create source files for ETL process
• Performance tuning Informatica ETL mappings and report queries
• Work with QA Lead and test engineer and review high level ETL design, source to target data mapping document and be the point of contact for any ETL related questions
• Coordinate ETL and database development work with offshore ETL developers and conduct code reviews
• Scrum master for sprints (3 week cycle)

Confidential

Lead Informatica/ETL

Responsibilities:

• Develop and maintain mapping, session and schedule workflows to load data into and out of EBS
• Develop ETL processes using Informatica, ETL control tables, error logging, auditing, data quality
• Applied data analysis, data cleansing, data matching, exception handling, reporting and monitoring
• Maintain versioning and migration in informatica environment
• Performance tuning on oracle and informatica workflows
• Manage a team of two on various resource management deliverables

Confidential

Lead Informatica/ETL (Independent Consultant)

Responsibilities:

• Apply Salesforce external key and relation objects concepts to create Informatica cloud task and migrate the same from Staging to Integrate and finally to production environment.
• Create Informatica cloud task flows to automate the loading process, using Webservices (WSDL’s) and native connectors.
• Create custom fields, external fields, validation rules in Salesforce.
• Use Salesforce dataloader.io to export, import and delete data in preparation for dry runs.
• Use workbench tool to run SOQL statements.
• Participate in daily scrum meetings. Reporting directly to client and Salesforce management.
• Validating data and creating error log issues for resolution from business using chatter.
• Act as a coach to train the client team to come up to speed on Informatica Cloud.

Confidential

Lead Datawarehouse

Responsibilities:

• Develop and maintain mapping, session and schedule workflows to load data into and out of clarabridge using informatica
• Develop ETL processes using Informatica, ETL control tables, error logging, auditing, data quality
• Applied data analysis, data cleansing, data matching, exception handling, reporting and monitoring
• Experience in versioning and managing/deployment groups in informatica environment
• Develop and maintain Clarabridge dataflows to process unstructured data
• Maintain Clarabridge security. Upgrade and setup new Clarabridge environments.
• Performance tuning on oracle and informatica workflows
• Co-ordinate scrum meeting and sprint planning /review on a monthly basis

Confidential

Sr. Datawharehouse Consultant

Responsibilities:

• Developed Lab, Pharmacy and Surgery modules using complex mapping using Informatica B2B real time application using Unstructured Transformation
• Used stored procedures and SQL scripts to add additional functionality
• Performance tuning on Oracle sql and Informatica workflows
• Documentation of the modules and unit testing
• Communicating and participating in client updates on a weekly basis

Confidential - San Francisco, CA

Technical Lead Informatica - Market Risk Management

Responsibilities:

• Act as technical lead and manage day-to-day IT operations to implement, support, and provide reporting and other solutions to business
• Ensure project deliverables are compliant with requirements, SOX controls, and other audit metrics
• Provide 24 x 7 operational and maintenance support to ensure all mission critical systems are stable at all times
• Communicate status reports for my direct reports/projects to managers periodically
• Designed, developed and maintained customer information systems, extraction, transformation and loading (ETL) solutions to operate on the UNIX/Oracle platform, using Oracle SQL, and PL/SQL
• Involved in designing Informatica mappings, sessions, workflows to extract data from source, transform and load to target database
• Involved in writing stored procedures and SQL scripts to add additional functionality to target database
• Carried out performance tuning and fixed bugs in Informatica interfaces and SQL scripts
• Produced documentation pertaining to analysis gathering, design decisions, table details, ETL delivered, user acceptance test results, migration to production, and post-implementation follow up
• Developed and implemented the coding of Informatica Mapping/Mapplet, Workflow/Worklet for the different stages of ETL.
• Proficient in designing and developing the various transformation logics by utilizing the expression, filter, joiner, lookup, router, normalization, rank etc.
• Debug the sessions by utilizing the session logs, analyzing the cache and commit levels.
• Performed Informatica code tuning on a regular basis.
• Performed unit testing and wrote queries in SQL to ensure the loading of the data.
• Developed and implemented the UNIX shell script to start and stop informatica objects using PMCMD commands.

Sr. Systems Analyst / Programmer

Confidential

Responsibilities:

• Coordinated project development activities with design leads, technical leads and end users
• Evaluated and recommended technical solutions to be used within the program
• Developed applications using client/serve technologies - PowerBuilder and Oracle

Consultant

Confidential

Responsibilities:

• Defined project requirements and functional specifications
• Evaluated and recommended technical solutions to be used within the program
• Developed applications using client/server technologies - PowerBuilder and Oracle