Post Job Free

Resume

Sign in

Informatica ETL Developer

Location:
Phoenix, AZ
Posted:
February 24, 2020

Contact this candidate

Resume:

Misbhauddin Mohammed

adbx8z@r.postjobfree.com

504-***-****

SUMMARY:

Over 15+ years of professional experience. Over 8+ years of IT experience in analysis, design, development and implementation of Business Intelligence solution using Data Mart/Data Warehousing Design, ETL, Client/Server and web application on Unix and windows platform in various domains such as Finance, Banking.

Over 8 years of experience in Customer Service industry, Peoples management, Insurance Management and Operations Management.

Expertise in managing people and the team for business-driven objectives.

Expertise in managing customers relationship, life cycle of insurance management system,

Experience in handling Day-to-Day basis issues related to Garnishment Services global issues, as it’s large in number. Every month audit a percentage of each client and resolve issues, if any with Business Units.

Experience in Creation, Modification and Testing of Informatica Mappings, Mapplets, Workflows, Worklets and debugging and performance tuning of Informatica Mappings and Sessions

Experience in Write High Quality SQL, Stored Procedures, Functions and SQL * Loader scripts based on Business requirements.

Strong analytical, presentation, problem solving and excellent inter-personal communication skills and flexible to learn new technologies in the IT industry towards company’s success

ACADEMIC QULAIFICATION:

Completed Master of Science in Management Information System from Southern University of New Orleans, LA – USA in May 2012

Completed B.com from Wesley Degree College through Osmania University, India in 2002.

Completed Intermediate from Wesley Boys Junior College through Board of Intermediate, India in 1999.

Completed S.S.C from St. Mary’s High School through Boar of Secondary Education, India in 1997.

PROFESSIONAL EXPERIENCE:

Currently employed with Comtec Information System as a Consultant and working for their clients as a contractor for their projects.

Client: Bank of the West, Tempe, AZ Apr’19 – Current

Role: Sr. Informatica Developer

Responsibilities:

Perform business and data analysis based on the functional specifications provided by the business users and managers

Implement and maintain multiple ETL process to synchronize data between different source system and database.

Document, test, implement and provide ongoing support for Oracle and ETL applications.

Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development

Interface with users, project managers to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.

Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification

Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions

Created Deployment groups and worked closely with DBAs to migrated Informatica code database tables from Dev to QA and QA to Production.

Environment: InformaticaV9.6.1/10.2, Oracle11g, UNIX, Flat Files, CSV Files, Tidal, JIRA, Toad

Took break for few months from November 2018 to March 2019, went to home country (India).

Client: Wells Fargo Bank, Charlotte, NC Oct’16 – Oct’18

Role: Informatica Lead Developer

Responsibilities:

Worked as onshore Informatica lead developer.

Lead a team of 6 ESG members who are working offshore developer.

Perform business and data analysis based on the functional specifications provided by the business users and managers

Creating and presenting SAS (System Architecture Specifications) & FSD (Functional Specification Document) to business users for approvals.

Design new data mart and data model for new projects using Erwin data model tool.

Implement and maintain multiple ETL process to synchronize data between different source system and database.

Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification

Interface with users, project managers to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.

Document, test, implement and provide ongoing support for Oracle and ETL applications.

Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development

Created Informatica mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations

Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions

Created Deployment groups and worked closely with DBAs to migrated Informatica code database tables from Dev to QA and QA to Production.

Environment: InformaticaV9.5.1/9.6.1,10.2.0 Oracle11g, UNIX, OBIEE, Flat Files, CSV Files, Teradata, BMC Remedy, PAC 2000, JIRA

Client: Bank of the West, San Ramon, CA Apr’16 – Oct’16

Role: Informatica Developer

Responsibilities:

Perform business and data analysis based on the functional specifications provided by the business users and managers

Implement and maintain multiple ETL process to synchronize data between different source system and database.

Document, test, implement and provide ongoing support for Oracle and ETL applications.

Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development

Created Informatica mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations

Interface with users, project managers to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.

Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification

Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions

Created Deployment groups and worked closely with DBAs to migrated Informatica code /database tables from Dev to QA and QA to Production.

Environment: InformaticaV9.5.1/9.6.1, Oracle11g, UNIX, OBIEE, Flat Files, CSV Files, Toad

Client: Wells Fargo Bank, Charlotte, NC Aug’12 – Mar’16

Role: Infomatica Developer

Responsibilities:

Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification

Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development

Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development

Used Informatica to load data from Flat Files/CSV files/ to DB2 database and extract data from different databases (Teradata, oracle, SQL Server).

Created Informatica mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations

Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions

Created Deployment groups and worked closely with DBAs to migrated Informatica code /database tables from Dev to QA and QA to Production.

Environment: InformaticaV8.1/8.6, DB2, Oracle10g, Teradata data SQL Assistant, SQL Server, UNIX, CRON, OBIEE, Flat Files, CSV Files, Toad

Worked with Southern University of New Orleans as a Graduate Assistant from Sep 2010 to April 2012.

Worked with ADP India Pvt Ltd as a Sr. Customer Service Representative from Dec 2007 to Dec 2009.

Worked in Garnishment Services, Finance & Compliance services (FACS) part of global delivery team.

Answering inbound calls from Employees, Agency, Court, Custodial Parents and Plaintiff’s to give out information about garnishment related queries based on Unites states of America’s court order and their state statutes like on Spousal alimony, Federal and State levy Bankruptcy etc.

Handling Escalations on day to day basis for every project.

Take huddles, giving presentations for team, updating process queries, resolving any issues for the team, coordinating with Business Units, driving project in a timely & efficient way, helping & coaching the new joiners and handling team in the Team Lead’s absence

Worked in Nipuna Services Pvt Ltd (A Satyam company) as Sr. Customer Service Associate & Acting Team Leader from December 15th, 2004 till September 15th, 2007 in a Dental Insurance Process

Handling Dental Benefits queries from provider’s office.

Handling tier II & supervisory calls regarding claims enquiry.

Prepare and maintains the Team matrices like AHT, Productivity, Attendance, Quality reports & process related MIS, APR, Weekly Status reports. Agent Skill Improvement Plan for the up skilled agent. (Tier II)

Acted as a Team Leader in the absence and presence of the Team Leader.

Rewards & appreciation:

Have been a consistent performer throughout my tenure.

Was rated twice as exceptional performer in the Annual appraisals.

In my tenure have won 12 POB’s & an appreciation from the client for the best attendance, quality & giving excellent customer service on calls.

Worked in Concentek Pvt Ltd as a Sales Executive from May 2004 till November 2004

Worked for a renowned U.S cellular service as a telesales executive.

Was a Group Leader & Verification officer.

Was a consistent performer and my responsibility being to make call backs on behalf of my team and do credit check of the sales.

Have monitored calls for new joiners on the floor and assisted them in improving their Process skills.

Job related strength:

Positive Attitude

Always ready to take initiatives.

Good Analytical re-presentation regarding data.

Good Communication skills.



Contact this candidate