SUMMARY:

• 16+ years of experience in the field of Information Technology with strong background in ETL(Extraction Transformation Loading).
• Technical, Onsite Lead involving responsibilities such as system requirement analysis, client interaction, business logic analysis.
• Sound understanding of the datawarehousing concepts and standard ETL (Extraction Transformation Loading), reporting processes.
• Experience in Informatica Migration 9x to 10x.
• Strong skills of Informatica Powercenter - Designer, Workflow manager, Workflow monitor, Source analyzer, mapping designer, warehouse designer, various transformations such as source qualifier, expression, joiner, normalizer, router, target, aggregator, sorter, xml source qualifier, xml target, xml generator, xml parser, web service consumer (SOAP), HTTP transformation (GET, POST); tasks transformations - task, email task, workflow, worklet, session; montoring workflows, debugging, workflow task restart, scheduling. Informatica B2B DX/Data Transformation, DQ, PowerExchange.
• Experience in Informatica BDM (Big Data Management) with Hadoop 2.6.2/Hortonworks HDP, HDF
• Informatica Certified Designer/2007
• Experience working on reporting tool Cognos 10x
• Involved in system design & development for projects.
• Experience in working on Mainframes - COBOL, JCL, EASYTRIEVE, CICS, and DB2.
• Good understanding on the various quality standards QMS, SIX SIGMA and the various information security and BCP (business continuity practices).

TECHNICAL SKILLS:

Operating Systems: Windows XP/2K, Windows 95, Windows 98, MVS/ESA, MS-DOS, OS/400, AIX 5.x, Solaris 10/11, RHE Linux 7.5.

Languages: MF COBOL, JCL, RPG II, C, C++, Core Java, VBA, HTML, SQL, XML, PL/SQL, Easytrieve, Unix Shell Script, Perl Script, Syncsort on UNIX, FTP, SFTP, Ansible, Pig Latin, Scala. HiveQL, Python (basic use for triggerring Hadoop DataLake Jobs)

Databases: MS SQLServer 2000/2005, DB2, VSAM, Oracle 8/9i/10g/11g/12c, MS Access, Apache Hive

ETL Tools: Informatica Powercenter 6.X/7.X/8.X/9.X/10.X, PowerExchange, DQ, Informatica Data Transformation (B2B), Informatica BDM (Big Data Management), Apache NiFi

Big Data: Hadoop 2.6.2/Hortonworks HDP, HDF, Sqoop, YARN, Kafka, Spark

Reporting Tools: Understanding of Cognos 10x, Business Objects XIR2, Tableau 2018R1.

Scheduling: Control-M, Autosys, CA Workload Automation 11.x, 12.x, Apache Oozie.

Deployment: Harvest

Tools: and Utilities: Edit Plus, Revolve (for COBOL), Intactix 2006, Toad for Oracle/DB2, SSH Clients - Mobaxterm, Secure Shell.

Enterprise ticketing: Peregrine, Borland Starteam, CA Unicenter

Code Repository: Harvest, Borland Starteam, Bitbucket

Security Authentication: Kerberos krb5, Apache Knox, Apache Ranger.

Task Management: MS Project, Smartsheets.

SKILLS TRAINED IN:

Software Configuration Management (SCM), Informatica Powercenter, Defect Prevention, Six Sigma Green Belt, RPG II, Easytrieve, CICS, QMS (6 Sigma), IMS DB/DC, COBOL/JCL/VSAM, Informatica Powercenter 9/10, Informatica 9x/10x Upgrade Planner. Hadoop/Hortonworks, AWS EC2, AWS S3, Informatica Intelligent Cloud Services (IICS).

PROFESSIONAL EXPERIENCE:

Confidential, FL

Platform & Skills: Windows 7, Informatica POWERCENTRE 8.6.x, 9.1.x,9.5.x,10x SQL, PL/SQL, VBAPerl, UNIX (Solaris/RHE Linux) Shell Scripting, Oracle 11gR2/12c, Toad for Oracle 10/11/12, Informatica Metadata Manager, Informatica PowerExchange, Informatica DataQuality, ER Studio, MS Visio, MS Project,Smartsheets, Hadoop 2.6.2/Hortonworks HDP, HDF & related Apache tools.

Responsibilities:

• Substantially contribute to the system architecture and ETL layer
• Design, develop and unit-test, Informatica mapping as well as session and workflow based on ETL standard and specifications
• Participate in data gathering, defining, and analysis of ETL requirements
• Support cross-functional efforts to in Cognos reporting performance
• Perform impact analysis on required changes in an expeditious manner
• Maintain and support Informatica ETL processes in development, testing and production
• Perform Informatica administrative tasks
• Work with system architects to improve existing OLTP model, increase data quality, and improve ETL performance
• Work with the DBA team and manager to maintain ETL stability, and security
• Write requirements specifications according to standard templates, using clear, unambiguous, and simple language.
• Transfer high-level business and user requirements into functional requirements
• Changes to improve ETL processes and ensure performance
• Successful ETL processing across the data warehouse environment
• Operational performance of ETL processes supported
• Successful recovery from disasters and disaster simulations

Confidential, KS

Platform & Skills: Windows XP, Informatica POWERCENTRE 8.6.x/9.x, SQL, PL/SQL, VBA, Perl, UNIX (Solaris) Shell Scripting, Oracle 10g.

Responsibilities:

• Receiving the requirements from business users in the form of WRD (work request document)
• Preparing FSD (Functional Spec Design). Reviewing with the business to make sure the requirements are met.
• Preparing technical design and technical requirement documents to code using Informatica, Perl / Unix scripts, Oracle, PL/SQL, SQL.
• Prepare UTP (unit test plan), and MTP (master test plan)
• Technical Design reviews with managers.
• Unix Shell Scripting, Perl Scripting, Encryption & Decryption using GPG on Solaris 10.
• Scheduling of jobs using TWS by writing scripts in JCL, UCMD on MVS/TSO so that scripts run automatically on the day and time specified by respective teams.
• Programming in Informatica Powercenter, Unix shell scripts, Perl scripts, Business Objects, Visual Basic Applications
• Unit testing, integration testing, user acceptance testing of new applications in Informatica Powercenter, Unix shell scripts, Perl scripts, Business Objects, Visual Basic Applications
• Deployment of applications in Informatica Powercenter, Unix shell scripts, Perl scripts, Business Objects, Visual Basic Applications to production
• Migration tasks for Informatica Powercenter 8.6.1 to 9.0.1
• 24x7 on-call support
• Bug fixing on failed jobs
• Resolving SNOW tickets
• Making sure data is supplied to teams on time. Notifying respective team when delay in data
• Attending to adhoc requests for data by both internal and external teams, vendors.
• Deployment to next-higher environments.
• Weekly meetings with managers, business users and technical teams.

Confidential, MO

Platform & Skills: Windows XP, Informatica POWERCENTRE 8.6.x, Informatica POWEREXCHANGE, Oracle, SQL, PL/SQL, UNIX (Solaris) Shell Scripting, IBM DB2.

Lead Designer - Code Review - Offshore Coordinator

Responsibilities:

• Impact analysis of adding columns to existing database tables, scripts and various downstream systems.
• Communicating with the business, IRS, downstream systems and peers for the impact and making sure everyone is on the same page.
• Receiving the requirements from business and data analysts in the form of BRD (business requirement document) and FSD (Functional Specific Design)
• .Preparing technical design and technical requirement documents for the Offshore to code using Informatica, Unix scripts, SQL as required.
• Design reviews with managers.
• Code reviews with Offshore.
• Making sure all standards with coding, and proper documentation is prepared by Offshore.
• Deployment to next-higher environments using Harvest Tool.
• Review test results from the testing team, forward any lapses to the Offshore for rectification.
• Daily / Weekly updates to managers and business.

Confidential, OK

Platform & Skills: Windows XP, Informatica POWERCENTRE 8.6.x, Oracle, SQL, UNIX (AIX) Shell Scripting, Informatica Data Transformation, Informatica Web Service Call.

Designer-Developer-Tester

Responsibilities:

• Receiving the requirements from business, coding the mappings in Informatica, scripting in Unix, SQL, using Data Transformation Tool as required.
• Develop mapping with Web Service consumer transformation for accessing external sources.
• Mapping development and testing.
• Unix shell script development and testing.
• Running test, dev and production cycles.
• On call production cycle monitoring, bug fixing.

Confidential, TX

Platform & Skills: Windows XP, Informatica POWERCENTRE 8.x, Informatica POWEREXCHANGE, DB2, Oracle, SQL, UNIX (AIX) Shell Scripting, Business Objects XIR2.

Designer-Developer-Tester

Responsibilities:

• Receiving the requirements from business, then creating technical specs for coding the mappings in Informatica, scripting in Unix and SQL as required.
• Mapping development and testing.
• Unix shell script development and testing.
• Running test, QA and production cycles.
• On call production cycle monitoring, bug fixing.
• Resolving tickets from business for enhancement of reports.

Confidential, TX

Platform & Skills: Windows XP, Informatica POWERCENTRE 8.x, DB2, Oracle, SQL, PL/SQL, UNIX (AIX) Shell Scripting, Intactix 2006, Cognos

Designer-Developer-Tester

Responsibilities:

• Receiving the inputs from business for coding the mappings in Informatica, scripting in Unix and SQL/PL SQL as required.
• Mapping development and testing.
• Running production cycles.
• On call production monitoring, bug fixing.
• Updating business of the results of each run of the cycle and providing planograms details.

Confidential, TX

Platform & Skills: Windows XP, Informatica POWERCENTRE 8.x, Informatica POWEREXCHANGE, Informatica DQ, Mainframes (TSO), Perl Scripting, UNIX (AIX) Shell Scripting, Control-M scheduling.

Designer-Developer-Tester

Responsibilities:

• Analysis of the COBOL/JCL codes on the Mainframe and preparation of understanding documents.
• Preparation of design documents and technical specification documents.
• Coding in Perl or Aix shell script or Informatica Powercentre as per the technical specification document.
• Testing of the codes - Unit, Integration etc.
• Creating Control-M schedules for running test as well as production cycles.
• On call after hours production cycle monitoring.

Confidential

Platform & Skills: Windows XP, Informatica POWERCENTRE 7.x, Microsoft SQL Server 2000/2005, SQL, PL/SQL, UNIX Shell Scripting.

Designer-Developer-Tester

Responsibilities:

• Receiving the technical specifications from onsite for coding the mappings in Informatica.
• Mapping development and testing.
• Loading full data in test and QA environment.
• Comparison of legacy and QA data.
• Updating onsite of the results.

Confidential, NJ

Platform & Skills: Windows XP, Informatica POWERCENTRE 7.x, Microsoft SQL Server 2000/2005, SQL.

Designer-Developer-Tester-Technical Lead-Production Support

Responsibilities:

• Construction of mappings in Informatica for loading ‘raw data’ and ‘variables’ into data base tables.
• Review, testing, performance tuning of mappings, sessions completed by team.
• Unit and integrated testing of mappings.
• Point of contact both at offshore and onsite.
• Monitoring production workflows.

Confidential, NJ

Platform & Skills: Windows XP, Informatica POWERCENTRE 7.x, Microsoft SQL Server 2000, SQL.

Designer-Developer-Tester

Responsibilities:

• Construction of mappings in Informatica for loading ‘raw data’ and ‘variables’ into data base tables.
• Review, testing of mappings; creating sessions for mappings.
• Unit testing of mappings.
• Monitoring production workflows.

Confidential, NJ

Platform & Skills: Windows XP, Informatica POWERCENTRE 7.x, Microsoft SQL Server 2000, SQL.

Designer-Developer-Tester-Production Support

Responsibilities:

• Construction of mappings in Informatica for loading ‘raw data’ and ‘variables’ into data base tables.
• Review, testing of mappings; creating sessions for mappings.
• Unit testing of mappings.
• Monitoring production workflows.

Confidential, NJ

Platform & Skills: Windows 2000/XP, Informatica POWERCENTRE 6.x, 7.x, Microsoft SQL Server 2000, SQL.

Developer-Tester-Production Support

Responsibilities:

• Construction of mapping in Informatica for loading data from data warehouse tables to data mart tables as per specifications given by onsite.
• Review, testing of mappings; creating sessions for mappings.
• Unit testing of mappings.
• Monitoring production workflows.