SUMMARY

• 8 years of IT experience and extensive experience working with the clients Bank of America, Confidential, Confidential, Wal Mart Stores, Well Care Health Plans and in the business domains BFSI (Banking, Financial Services and Insurance), Mortgage, Retail and Healthcare.
• Expertise in handling various aspects of Business Intelligence viz. Data Warehouse Design, Development, Administration and Architecture, ETL Administration, Development and Production Support, Informatica PowerCenter / Data Quality / B2B / Master Data Management , Talend Data Integration / Data Quality / MDM, Abinitio, Oracle PL/SQL, Teradata PL/ SQL, Netezza PL /SQL and UNIX Shell Scripting.
• Good understanding end to end architecture on server and how ETL / Big data tools (Informatica / Talend / Abinitio / Apache Big data products) interact with it.
• Extensive experience in writing UNIX automation scripts using Informatica Command Line Interface (CLI) commands viz. pmcmd, pmrep, infacmd.sh, infasetup.sh and server monitoring commands viz. iostat, vmstat, mpstat, top.
• Extensive Experience working with Solaris, Suse Linux and AIX servers and Clustered File systems viz. VxCFS and GPFS and good understanding of their architecture.
• Good understanding of Data storage and Networking.
• Extensive experience in capacity planning and bench marking of server memory, C.P.U, Storage and Network.
• Expertise in handling multiple projects simultaneously and design / development of client - server and multi-tier applications and Decision Support systems and solutions.
• Expertise in working on administration of 11 different application servers at the same time.
• Expertise in working on server migration projects and doing end to end set up of Informatica / Talend application servers.
• Troubleshooting and Performance tuning of Informatica Server and ETL applications
• Experience in version upgrade projects of Informatica viz. version 8.6.1 to 9.1.0, version 9.1.0 to 9.5.1 HF2 and version 9.5.1 HF2 to 9.6.1 HF2 and setting up of Informatica MDM Multi-domain & Informatica Data Director (IDD)
• Expert in all phases of Software development life cycle - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
•  Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation. 
• Expertise in data warehousing, ETL architecture, Data Profiling. 
• Experience in working with various versions of Informatica Powercenter 10.x, 9.x, 8.x, 7.x-Client and Server tools.
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2 Mainframes. 
• Strong experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, T-SQL, DTS.
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping. 
• Involved in writing Unit test cases for complex scenarios.
• Experience in creating UNIX shell scripts and Perl scripts. 
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and knowledge in microstrategy. 
• Knowledge in Installation and configuration of Informatica server with sql server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.

TECHNICAL SKILLS

Business Area: BFSI Domain(Banking, Financial Services and Insurance), Mortgage, Retail, Pharmacy Domain

Project Development Methodologies: Agile, Agile Scrum, Kanban, Waterfall

ETL / MDM Tools: Informatica on Grid, Informatica Power Center 10.1.0/ 9.6.1 / 9.5.1 / 9.1.0/8.6.1/7.1.3 ,, Informatica BDM 10.1 / 9.6.1,Informatica developer(Data Quality), Informatica B2B, Informatica Master Data Management (MDM) Multi-Domain, Informatica Metadata Manager, Informatica Test data Management (TDM), Informatica PMPC, Informatica Data Replication (IDR), Informatica Data Validation Option (DVO), Informatica Data Director(IDD), Teradata Decision Expert 12.1.2, TERADATA BTEQ, FLOAD, MLOAD,NZSQL, Talend, Abinitio,

Application Server: Jboss, Apache Tomcat

Modeling Tools: ERWIN 7.3.1, ERStudio 8.0

Databases: Oracle 11g/10g/9i/8i, Teradata 12.0/13.0/14.0 , Netezza, PL/SQL Developer, Toad, SQL Plus, SQL Assistant,Teradata SQL Assistant, Aginity, DB2, CA- IDMS

Programming languages: Python, Java, Scala, R Programming, UNIX shell scripting, Windows Batch Scripting, VB Scripting, Oracle PL/SQL, Teradata SQL, Netezza SQL, NoSQL, COBOL, EZTREIVE, JCL

Scheduling/Automation Tools: AppWorx 6.1.4, UC4 Applications Manager 8.0, Control-M 7.0, Autosys, CA7 Job Scheduler

Operating Systems: UNIX(Solaris), Suse Linux, AIX, Windows XP, MVS for IBM 3090 Mainframe

Cloud Computing Tools: AWS (Amazon Web Services), IBM Soft layer

Reporting Tools: BOXI (Business Objects), PC / SAS, SAS Enterprise Guide, Teradata Decision Cast

Mainframe Tools: OLQ, DMLO, IDDM, ADSC, MAPC, ADSA, ADSL, DME, ADSALIVE, APC, XPEDITER for IBM 3090 Mainframe, Darstran.

Apache Frame work Tools: Hadoop Eco System Viz. Hadoop Common, Hadoop Distributed File System (HDFS), Hadoop YARN, Hadoop Map Reduce, Spark, SQOOP, Flume, HBASE, HIVE, PIG, HCATALOG

PROFESSIONAL EXPERIENCE

Confidential, Charlotte.NC

Role: Informatica Developer/Administrator

Responsibilities:

• Install and Configured Informatica 9.5.1,9.6.1 and 10.1.
• Upgraded Informatica 9.5.1 to 9.6.1,9.6.1 to 10.1. 
• Create folders, grant user access to Informatica Repository
• Applied Informatica Patches to the Informatica servers 
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL server and Flat files. 
• Expertise in developing and integrating end to end customer master implementation for Insurance and healthcare domains using different versions of Informatica MDM
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions. 
• Experience with MDM SIF APIs and SOAP based web services
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Union, Expressions and Aggregator transformations. 
• Provided product demonstrations and technical guidance to business users on the capabilities of Informatica MDM
• Developed Slowly Changing Dimension for Type 2 SCD 
• Worked on Oracle SQL developer to develop queries and create tables and views in Oracle.
• Used mapplets for use in mappings thereby saving valuable design time and effort 
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Written procedures, Queries to retrieve data from EIDW and implemented in NIDW. 
• Worked with Session Logs and Workflow Logs for Error handling and Troubleshooting in all environment.
• Worked on TOAD and Oracle SQL developer to develop queries and create procedures and packages in Oracle.
• Responsible for Unit testing and Integration testing of mappings and workflows. 
• Created Jobs and Job streams in Control-M scheduling tool to schedule Informatica, SQL script and shell script jobs.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.

Confidential, New Tazewell, TN

Role: Informatica Administrator

Responsibilities:

• Worked as Confidential Team Administrator
• We are testing the informatica code according to the new releases
• We are handling 3 test environments for testing the code in parallel.
• Transformed data from source system to target. 
• Configured outbound JMS queues in MDM hub console. 
• Writing the queries on metadata level to figure it out the standards
• Implementing the standards in the release basis. 
• Migration of objects from Dev-SIT, SIT - PPE and PPE - PROD 
• Handling the issues in the informatica level 
• Creation of folders/user permissions. 
• Handling other informatica administration activities 
• Upgrading the Informatica Repositories from 6.x to 7.x.
• Giving L2/L3 Support for all applications. 
• Giving 24/7 Production Support for all application. 
• Involved and resolving the issues (Tickets) in Informatica Power center.

Confidential,  Morristown, NJ

Role: ETL Consultant

Responsibilities:

• Coordinate PowerCenter technical review/approval before on-boarding new projects to shared platform 
• Prepared design documents, Technical Object documents, Business Scenario documents.
• Created Informatica mappings for initial load, daily updates and monthly loads. 
• Involved in Code review, Functional and Integration testing for all the mappings and workflows.
• Developed standard document and reusable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter. 
• Extracted source data from different sources like SAP, Oracle, flat files from Legacy systems and load the same into business data warehouse after applying business rules. 
• Performed objects deployment on versioned repositories from QA to Production
• Experienced with Installation, Configuration, and Administration of Informatica and patch installation in Unix environment. 
• Involved in Migration process from development, Test and Production Environments 

Confidential, Bentonville, Ark.

Role: ETL Developer / Data Analyst.

Responsibilities:

• Used Informatica Designer to Create Mappings, Mapplets, Transformations, and Target tables. Extensively used Server Manager for creating and scheduling various sessions.
• Extensively worked on all phases of Software Test Life Cycle - requirement analysis, Estimation, Estimation approval from client, Design, Walkthroughs and approval of test artifacts from client team. 
• Created data model after analysis of entities and relations among them, using Erwin.
• Highly analytical and process-oriented data analyst with in-depth knowledge of database types; research
• Responsible for monitoring all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings that failed using debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Selected as team lead to manage four analysts for major project to validate Confidential brand new datawarehouse
• Provided technical support to programmers and data analyst teams  
• Created Functions, Packages, Stored procedures, triggers using PL/SQL.
• Migrated code from QA to Prod Environment and provided Production Support. 
• Helped QA team in creation of test cases for regression testing. 
• Created universe in Business Objects for annual reports. 
• Modified mappings and stored procedures in Powercenter for maintenance and enhancement activity. 
• Interacted with Data Architect and Business Analysts to meet the deadlines.
• Develop reports and data to assist in evaluation in business performance and operation
• Performed Data analysis and Data profiling using complex SQL on various sources systems including Oracle and Teradata. 

Confidential Tampa, FL

Role: Informatica Developer

Responsibilities:

•  Initial analysis of Raw Data received from business Users. Data use to differs from County to county and State to state. 
• Worked on SQL Loader to load the data from flat files obtained from various vendors. 
• Wrote SQL and PL/SQL programs to retrieve required information from the database.
• Created Indexes on the table for faster retrieval of the data to improve database performance. 
• Created database objects like tables, views, materialized views, procedures and packages using oracle tools like TOAD, SQL Developer and SQL*Plus. 
• Handled errors using exception handing extensively for the ease of debugging and displaying the error message in the application. 
• Involved in ETL in order to meet the requirements for extraction, transformation, cleansing, and loading from source to target. 
• Involved in ETL process from development to testing and production environments.
• Extracted data from various sources and loaded it into target database using Informatica Power Center 7.1.
• Tuned mapping and SQL queries for better performance and efficiency. 
• Performed unit testing and validated the Data. 
• Provided Weekly status report to manager on the process and timeliness. 
• Performed performance tuning of the process at the mapping level, session level, source level and the target level.