Manager Data
Resume:
MuthuKumar Manickam
Houston, Texas
**********@*****.***
PROFESSIONAL PROFILE
Muthu is a high performing full stack BI ETL Manager with 10 years of experience across diverse industries including Health Care, Banking and Retail. He has worked on multiple technologies that include ETL tools like Informatica Cloud/PowerCenter, DataStage, Database skills like Oracle, SQL Server, Teradata, Salesforce, Open source technologies like Hadoop, Python and BTEQ, Unix Shell Scripting. He is an expert in leading teams, establishing client relationships, production support roles, and cross-functional integration. He has remarkable problem solving, analytical, interpersonal and communication skills. He is a team-player and is committed to excellence. He is currently performing a full stack developer role with Hadoop, Python and Teradata using TDD and CICD approach. He is also leading Dev Ops implementation for the same Health Care client.
KEY STRENGTHS
Ability to learn and adapt quickly to new environments with skills at delivering multiple projects within budget, time line and within acceptable quality meeting customer commitments.
An amicable team player as well as an aggressive individual contributor.
Excellent verbal and written communication skills, including the ability to communicate effectively across all levels of the organization.
Strong competency to analyze new functionality and identify potential areas of impact, saving clients funding, time and resources.
Consistently recognized by company management for consecutively meeting and exceeding company standards and objectives. Noted in nearly all project evaluations as a reliable self-starter and an exemplary performer under pressure.
Proven success in comprehending requirements and delivering high quality solutions with in prescribed timeframes.
Challenge seeker who thrives when working in new, unexplored areas and high pressure engagements.
Chosen for several spot and applause awards throughout tenure in Accenture.
EDUCATION & CERTIFICATION
Bachelor of Engineering – Production Engineering-2008
Madras institute of Technology
Anna University, Tamil Nadu.
PROFESSIONAL EXPERIENCE
Accenture Services Private limited 06, 2008 - Present
BI ETL Project Lead
Performed multifaceted roles in Accenture which includes Informatica ETL developer (across all versions 8.x, 9.x) Informatica Cloud Support analyst, Teradata developer, Hadoop & Python Development lead, Operations/Release Manager and Business Value Creator.
Experience in building complex facts and dimension for Datawarehouse projects. Maintained the code in production
Performed the role of Dev-Ops Lead. Handled End to End Dev-Ops cycle.
Exposure to AWS technologies with infrastructure management using EC2, S3 Bucket & Cloud Formation.
Database experience includes Oracle, SQL Server, DB2, Netezza, and Teradata.
Exposure to UNIX Shell Scripting.
Performed performance tuning in Teradata/Informatica jobs to improve performance.
Actively participated in Data Modelling using Erwin Data Modeler.
Experience in application design and implementation of Business Data per business requirements with Health Care (including Facets), Banking and Financial Services Domains
Projects:
Cigna Healthcare –Implementation of Informatica ETL jobs, Conversion to Python ETL scripts using Teradata, Hadoop, Private Cloud and Dev Ops (Apr 2017- Present, Houston, Texas)
Perform the role of BI ETL Manager which includes guiding the team in converting Informatica ETL components into Python based Scripts hosted in Private Cloud servers.
Developed complex queries for data extraction from Hive tables.
Hands on experience in big data tools like Hive, Impala, Sqoop.
Optimized Teradata BTEQ scripts for better performance.
Involved in production issues and performed bug fixes in quick workaround time.
Handled the responsibility of Code movement across environments (Dev, INT, UAT, and PROD).
Involved in Continuous Integration and Continuous Deployment using Dev Ops tools.
Hands on Experience in Tortoise GIT and Intellij for versioning code.
Used Jenkins to build code packages from GIT and promote code to higher environments using Udeploy.
Understanding of existing system & technical components in Amazon Web Services.
Manage AWS servers and infrastructure using EC2, S3 & Cloud Formation.
Perform the role of Teradata First line support engineer to review peer team code and designs.
Interact with Change Control Board and Scheduling team in promoting objects to UAT and Production.
Supporting the production team in the warranty period of three months initially after implementation.
Wholefoods - Informatica Cloud Support lead with Salesforce administration (June 2015- Mar 2017, Austin, Texas)
Lead 12-member team performing Application Development & Support, by developing & maintaining complex ICS and ICRT jobs using Informatica Cloud.
Involved in development of Data Synchronization task, Mapping Configuration task, Data Replication tasks.
Involved in real time data processing including development of Processes, Guides, Service Connectors, and Connections. Includes monitoring of Informatica Cloud Processes.
Involved in performance tuning of Informatica Cloud Jobs.
Responsible for analysis, design and development of production fix components in Informatica Cloud & Salesforce.
Manage AWS servers and infrastructure using EC2, S3 & Cloud Formation.
Perform tuning of ICS & ICRT Jobs for long running task flows.
Responsible for understanding Use case development using Salesforce Application and understand data load from/to salesforce using Informatica cloud.
Understanding of existing system & technical components in Amazon Web Services.
Leading end to end development of Dev-Ops system using Bit bucket, Jenkins, New Relic and other technologies.
Bank of America – Informatica ETL Production Support Lead and Release Manager (July 2014 – May 2015, NYC, New York)
Worked as Migration Lead & Production Support lead for Informatica jobs running in production.
Includes interacting with clients and SME's to understand the business requirement to create design documents for quick fixes in production.
Handled the responsibility of Code movement across environments (Development, Stage, UAT, PROD).
Supported after Production Deployment during the guarantee period. Includes handling of resolving Production issues within SLA’s.
Guided the team in using Reusable components created in similar previous migration project & Led the team in successfully completing the project on time.
Effectively handled client change requests by proposing and supporting the design, development and testing of solutions, including ensuring that change requests entrance criteria and documentation is complete, conducting impact analysis and following through on execution of changes.
Created & maintaining documents like Production Issue tracker, Production Job status tracker & Run book to reduce KT time, tickets resolution time.
Have set up and lead the Complete Support & Maintenance team for one of World’s leading Banking Data warehouse application, a critical & strategic project for the current organization gaining client's confidence and appreciation.
First Data - Credit Card Processing & Payment Solutions - Informatica ETL Developer (Feb 2013 – June 2014, Atlanta, Georgia)
Played a lead role in requirements understanding & collection processes and translating them into technical requirements. Includes preparation of Technical Design document, ETL Source to Target Mappings.
Implementation of Data Quality Management (DQM) for Trading Distribution data with upfront quality assurance and built in proactive alerting mechanism.
Prepared Estimation for Development efforts using Microsoft Project Plan.
Responsible for Code movement across environments (Development, Stage, UAT).
Manage Resources technically & operation wise. Responsible for project management activities.
Attend status meetings with Client’s Project Management team.
Manage day to day business operations and work on monitor compliance with Accenture processes.
Administering HR policies regarding Performance Management of consultants reporting to me.
Ideating Six sigma process helping business to reduce operating costs for support and maintenance of application.
Bank of America and WellCare Healthcare - Informatica ETL Developer (June 2008 – Jan 2013, Chennai, India)
Involved in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area.
End to end Implementation of Claim Data for Health Care Clients involving Facts and Dimensions.
Have understood PLSQL Stored Procedures and Packages as part of project deliverable.
Prepare the test cases for the developed logic to the users and to make sure that the gathered requirement is converted as ETL logic.
Perform the comparison of data between the production data and the UAT test data.
Experience in handling XML Sources and XML targets.
Actively pursued and recommended areas of improvement for data profiling, data loading & Data Cleansing techniques.
Experience in Autosys scheduler to schedule Informatica jobs. Experience with UNIX Shell Scripting.
TECHNICAL KNOWLEDGE
Hive, Impala, Python Scripting, Teradata BTEQ
Informatica Power Center 8.x, 9.x, Informatica Cloud (ICS & ICRT)
Oracle, SQL Server, Netezza and DB2.
Salesforce CRM,
AWS EC2, S3.
Quality Center, Rational Quality Manager, Test Rail.
SQL, PLSQL, UNIX Shell Scripting, Windows Batch Scripting.
Experience in scheduling tools like Autosys, Tidal and CA Workstation (ESP Creation).
Exposure to Dev-Ops technologies like Bit bucket, Jenkins, AWS Cloud, New Relic, and Sumo Logic.
Exposure to Hadoop, Cloudera Data Science, No SQL.
Janrain, Smart Button, Retalix, SQL Workbench, Jira, Confluence, Orchard, Tidal, Crush FTP, Test Rail.
OTHER ACHIEVEMENTS
Certified Salesforce Administrator.
Automation of ETL Scripts using Python Wrapper code.
Implementation of DQM Framework increased the business confidence for data being supplied to sales and marketing in analysis and for internal reporting as well as for field usage.
Contact this candidate