| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidate Candidate's Name
Address: Street Address
Phone: PHONE NUMBER AVAILABLELinkedIn: LinkedIn ProfileSummarySenior Data Integration and Migration Consultant. with over 15 years of expertise in full life-cycle data warehousing, ETL development, and data integration. Proven ability to lead teams, deliver projects on time and within budget, and optimize performance. Extensive experience in various industries including retail, healthcare, banking, and telecommunications.Technical Skills Software & Tools: Informatica PowerCenter, IICS, DataStage, SSIS, SSRS, Pentaho, SQL*Plus, Toad, Trillium, SQL Loader, ESP Scheduler, Control-M, AutoSys, TFS, AWS S3 & EC2, JFROG Artifactory , IBM UrbanCode-Deploy (UDEPLOY),JIRA Operating Systems: HP-UX, AIX, Sun Solaris, Windows NT, VMS, MVS Databases: Oracle, Teradata, SQL Server, MySQL, Netezza, Informix Languages: C, PL/SQL, MSSQL, Pro*C, Korn Shell, Perl, COBOL, PythonEducation Master of Science in Computer Science - City University of New York (CUNY) Bachelor of Engineering in Electronics Engineering - IndiaProfessional Certifications Teradata Certified Master Brainbench Certification in Oracle PL/SQLProfessional ExperienceTEKsystems Inc. ETL Consultant- Data Engineer.
May 2021 April 2024 Developed and maintained ETL processes for various projects using Informatica PowerCenter, Informatica IDQ and Informatica Integrated Cloud Service (IICS). Automated ETL processes with shell scripts and Python. The focus of this project was to automate the daily cleansing of data and maintain backups for future use and historical purposes.
Worked on major data migration projects using Informatica PowerCenter (v10.2 / IICS and IDQ on following projects. Pratt and Whitney had no automated process to identify anomalies and cleanse the F10/F16 aircraft engine data that was input to a Jet Engine Maintenance Management Application. Also, created Python programs to apply business rules after reading data from EXCEL files using Python and loading them to Database tables. Developed a process to report on Daily Rejected Transactions and Withdrawals and Deposits at PNC Bank. The final output was loaded to XML and SFTP d to relevant Provider locations. Used JFROG Artifactory and IBM UrbanCode-Deploy (UDEPLOY) to migrate objects to the production environment Worked on a major Data Integration project for Availity Inc. Requirement was to Store Health Insurance data and Provider Data within a Data Repository and provide Integrated data after applying several business rules in XML format to relevant Insurance companies. Databases: SQLSERVER, ORACLE, MYSQL File Systems: EXCEL, XML, DELIMITED FILES. EXCEL SPREADSHEETS Tools and Technologies: Informatica PowerCenter V10.2, IICS, Informatica IDQ, Korn shell, Python, SQLBank of New York Mellon ETL ConsultantAug 2020 Jan 2021 Worked with business teams to understand the context diagrams and analyzed and sourced data elements for various corporate finance and treasury applications. Developed ETL applications using Informatica PowerCenter, Teradata, and Oracle PL/SQL. Assisted data Analysts to understand the data element traceability from Source to Target systems Databases: ORACLE, TERADATA Tools and Technologies: Informatica PowerCenter V10.2, Korn shellVerizon Data Solutions Engineer/SpecialistSept 2019 Aug 2020 Led data migrations and recoding of mappings for the integration of XO Telecom into Verizon. Recoded and Migrated a portion of the application from DataStage to Informatica Mappings for a highly visible project due to acquisition of XO telecom by Verizon. Developed ETL workflows using Informatica PowerCenter and IICS. AWS (EC2, S3) Configured EC2 and used S3 capabilities as a file watch mechanism to trigger loads to Snowflake Database as a POC. Assisted Data Analysts to understand the data element traceability from Source to Target Systems. Tools and Technologies: IICS, Informatica PowerCenter V10.2, Korn shell Converted existing SSIS packages with XO Telecom to Informatica mappings. Databases: ORACLE, SQLSERVER, NETEZZAUSAA Texas ConsultantJuly 2019 Sept 2019 Developed financial reporting extracts using DataStage. Tools and Technologies: DataStage 11.3, Korn shell Databases: ORACLE, SQLSERVERInfosys Lead Consultant US, Data Solutions Engineer/SpecialistFeb 2019 July 2019 Enhanced and maintained data warehousing applications. Developed ETL processes for reporting and compliance.Provided data attribute traceability for Auditors for several applications. Mentored a group of 4 engineers
Tools and Technologies: Informatica PowerCenter, Korn shell Databases: ORACLE, SQLSERVERBank of America Assistant Vice President, Development LeadDec 2016 Feb 2019 Led ETL projects for the Global Data Provisioning Point group. Developed applications using DataStage and Informatica PowerCenter
Scheduled jobs using Autosys. Created and deployed several Informatica Mappings/ Workflows for the Global Compliance and Corporate Security Group. The group controlled all project Budgets and security Regulations for the Bank.
Tools and Technologies: DataStage 11.2, Informatica PowerCenter, Korn shell Databases: ORACLE, SQLSERVER, DB2Solera Inc. Lead Data Solutions EngineerJan 2016 April 2016 Established ETL standards and processes for the Dallas division. Enhanced performance and integrated data using Informatica PowerCenter. Tools and Technologies: Informatica PowerCenter, Korn shell, JMS Queue Databases: ORACLEXO Telecom (TEKsystems Inc.) Lead DeveloperApril 2013 Jan 2016 Led the development of ETL processes for data integration and reporting. Developed SSIS packages and real-time sales dashboards. Tools and Technologies: DataStage Informatica PowerCenter, Korn shell Databases: ORACLE, Netezza, SQLSERVERPepsiCo Inc. Contractor, Data Management OrganizationJuly 2012 April 2013 Migrated and cleansed data for the US Foods division using Informatica PowerCenter. Tools and Technologies: Informatica PowerCenter, Korn shell, COBOL, Korn Shell Scripts Databases: ORACLE, Netezza, SQLSERVERBaylor Health Care System (Ness Inc.) Contractor/Technical LeadDec 2011 July 2012Led ETL development and maintained business operations within defined SLA.Various Short-Term ContractsOct 2007 Dec 2011 Worked with companies like Aviva, Interstate Batteries, JP Morgan Chase, and PepsiCo on ETL development and data warehousing projects.Visa StatusU.S. CitizenReferences: Available upon request |