TECHNICAL SKILLS

Primary Skills: BI/Data Warehousing (ETL and OLAP/OLTP Reporting), Data Modellings and Data Architects, Expertis, database design and Integration.Knowledge and Implementations of various AWS services such as Redshift, RDS, SES, Lambda etc.

Operating Systems: Unix(AIX), Windows XP, Window 7/8/10

Languages: PL/SQL, HTML, DHTML

ETL Tools: Informatica 8.6/9.5, BODI/BODS 11.X, IBM Datastage 7.5. Oracle Data Integrator 11.X

OLAP & Other Tools: IBM Cognos 8 Transformer, Assent, DPCA Tools, Essbase 7, HP Service Desk, PL SQL Developer, IBM Tivoli job scheduler, Rally, Terada SQL Assistant 12, Putty, Citrix Portal, Cisco VPN, Toad for DB2/ SQL Server, Squirrel for DB2, Toad for Oracle, ERWIN, Control M Scheduler 7.0.00( Control M Desktop, Control M Enterprise Manager.

Reporting Tools: Cognos 10.1,Cognos 8.4, Cognos 8.2, Cognos 8.3, Business Objects XI, SQL Server Reporting Services (Oracle 10g), Universe Designer,Web Intelligence, Micro Strategy 9.4

Scripts: Unix Shell Scripts, Batch Scripts

Databases: Oracle 9i/10/11/12C, MSSQLServer 2005/2008/2012/2016, IBM U DB2, Teradata

Configuration Tools: Microsoft Visual SourceSafe, IBM Clearcase

Documentation: MS Office and MS Visio 2010, Open Office

PROFESSIONAL EXPERIENCE

Confidential

ETL Technical Lead/Architect

Responsibilities:

• Support for Callidus Cloud based application and Issue management by Net Suite Application.
• Primary Contact for Current State Commission Systems for Incentive Comp Application.
• Control M Jobs Planning, Designs, Modifications, Testing and Migrations to Various environments.
• Executions, monitoring and management of ETL resources supplied by Vendor Accenture.
• Change management and Code deployments planning and support during prod deployments for ETL and Control M environments.
• Design and Development of new ETL datamodel based on dimensional Approach for ICA application.
• Handling and guidance to team for all Production Incident and Problems for ICA applications.
• New ETL development via using Informatica 8.6/9.5 version.
• ETL migration for finance department from Informatica 7.1 to Data Integrator 11G.
• Enhancement to existing Workflow/Sessions/Mappings for performance bottlenecks.
• Performance Improvement for ICA application.
• Identifies operational/functional gaps and assigns corrective tasks.
• Provides production visibility and issue awareness during quarterly releases.
• Onsite/Osffshore team management and work distribution and coordination IDC development center in India. .
• Informatica metadata and other corresponding code migrations from one environment to other environment for UAT/SIT/Prod enviornment .
• Database objects Tables/Oracle Package/Views/Synonyms/Grants & migations.
• Performance tuning of various Oracle objects based on client request of other downstream dependent applications.
• End to End code deployment and migrations from Dev to Test and Stage, Production Environment.

Confidential, Jacksonville, Florida

ETL Tech Lead

Responsibilities:

• Design and Development of new ETL datamodel based on dimensional Approach.
• Handling all Production Incident and Problems for CDM applications.
• New ETL development via using Informatica 9.0.1 version.
• Creation of Autosys Job script and management for all types informatica jobs dependency.
• Enhancement to existing Workflow/Sessions/Mappings for performance bottlenecks.
• Performance Improvement for Comliance Data Model and Associate Investment Monitoring applications.
• Identifies operational/functional gaps and assigns corrective tasks.
• Provides production visibility and issue awareness during quarterly releases.
• Onsite/Osffshore team management and work distribution and coordination.
• Informatica metadata and other corresponding code migrations from one environment to other environment for UAT/SIT/Prod enviornment .
• Database objects Tables/Oracle Package/Views/Synonyms/Grants migations.
• Performance tuning of various Oracle objects based on client request of other downstream dependent applications.
• Emergency CAB approvals for Sev1, Sev2 issues and normal approvals of all sev 3 issues.
• Root Cause Analysis of Sev1, Sev 2 Issue and provide the work around solutions.

Confidential, Jacksonville, Florida

ETL Tech Lead

Responsibilities:

• Data Stage ETL job monitoring for MDQIIS & HLDW applications that support the integration and standardization of data from multiple operational sources(System Of records) into conformed environment.
• Responsible for Referencial Data Repository(RDR), CLEAR, CSI, ALS sources published files availbility based on defined frequency( Daily, Weekly,Monthly) into File Staging Layer by pull or push scenario.
• Data Migration from FSL layer into Relational Staging Layer by data stage jobs kicked by autosys job scheduler.
• Provides production visibility and issue awareness during quarterly releases.
• Understanding the current various BI applications for Disater & Recovery Process setup
• Preparing the various Disaster Recovery Document.
• Change Advisory Board Management meeting status reporting.
• Meeting with various application managers for data lineage work.
• Handling all Production Incident and Problems for BOA Home loan applications.
• Change Management for production incidents, Expedites decisions for emergency changes and operational recovery procedures.
• Autosys Jobs(CMD, BOX, File Watcher) management and jobs status (On HOLD, ON ICE, KILL Job, START Job, OFF HOLD, OFF ICE, FORCE START for all types dependency.
• Provide communications notiifcations to senior Technology executives for problem awareness.
• Identifies operational gaps and assigns corrective tasks.
• Responsible for conducting October 2011 disaster recovery exercise for Richmond data center.
• Coordination with various teams for dependent activity.
• Preparation and updation of Technical Recovery Plan document.
• Design and development of SharePoint portal for October 2011, Disaster Recovery Exercise.
• Defect Management for DR Exercise and publishing to internal SharePoint portal for LOB reviews.
• Preparation of various Defect Reports, Metrics for senior management review.
• Primary contact to conducting Disaster Recovery Exercises for various Midrange applications.
• Data Lineage for Informatica Applications