JAMES

314-***-****

aczgc7@r.postjobfree.com

PROFESSIONAL SUMMARY:

● Total 6 years of experience in IT Industry.

● 4 Years of experience in Informatica development and maintenance assignmentsfor large data warehouse projects using Informatica versions (Power Centre 9).

● 1Year of experience in ODI maintenance assignments.

● 1 year of experience in SSIS and Reporting tool SSRS (2005).

● Proficiency in developing SQL with various relational databases like Teradata, Oracle and SQL Server.

● Knowledge in Full Life Cycle development of Data Warehousing.

● Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

● Experience with dimensional modeling using star schema and snowflake models.

● Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.

● Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.

● Strong with relational database design concepts.

● Developed OLAP applications using SSIS 2005.

● Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.

● Strong business understanding of verticals like Retail, Healthcare and Insurance.

● Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

● Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.

● Comprehensive technical, oral, written and communicational skills.

● Proficient in importing the Informatica objects.

● Identify, troubleshoot, and resolve complex production environments (Informatica Application, Databases, etc.) reported through monitoring systems, support teams, and trouble tickets as per established SLAs.

● Good experience in Outages Handling and communicating with different teams at the outage.

SOFTWARE KNOWLEDGE:

Operating Systems: W indows, Linux

Software / Applications: M S Word, MS Excel, MS Access, Outlook, PowerPoint Database: S QL Server 2008/2005/, Oracle 11g/10g, Teradata SQL Assistant and Studio 15. ETL: I nformatica PowerCenter 9.6.1, Informatica Power Exchange 8.6.1 OLAP/BI Tools: SSAS/SSRS

Languages: H TML, XML, SQL.

WORK EXPERIENCE:

Client: Monsanto, St. Louis, MO October 2016 to till date Role: Informatica & Teradata Support

Description: M onsanto Company is a publicly traded American m ultinationala grochemical and a gricultural biotechnology corporation. It is headquartered in C reve Coeur, G reater St. Louis, M issouri. Monsanto is a leading producer of g enetically engineered (GE) s eed and Roundup, a g lyphosate- based h erbicide. The main objective of this project shared data Repository is to capture new vitality program customers data, grower information, Agreement, group policies, plans. Data is coming from various sources like SQL Server, SAP, Salesforce, Oracle, Flatfile etc. Which will be loaded in to EDW based on different frequencies as per the requirement. The entire ETL process consists of source systems, staging area, Data warehouse and Datamart.

Responsibilities:

● Support and Enhancements ETL programs using Informatica and Teradata to implement the business requirements.

● Communicated with business customers to discuss the issues and requirements.

● Created shell scripts to fine tune the ETL flow of the Informatica workflows.

● Used Informatica file watch events to pole the FTP sites for the external Steel veg vendors.

● Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

● Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.

● Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

● Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

● Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

● Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.

● on Onsite and Offshore work model.

● Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.

● Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

● Performed unit testing at various levels of the ETL and actively involved in team code reviews.

● Identified problems in existing production data and developed one time scripts to correct them.

● Fixed the invalid mappings and troubleshoot the technical problems of the database. Environment: Informatica 9.6.1, Teradata SQL Assistance and Studio 15, UNIX Client: Clorox, O akland, California January 2016 to October 2016 Role: ETL ODI Support Analyst

Description: T he Clorox Company based in O akland, California, is an American worldwide manufacturer and marketer of consumer and professional product with approximately 7,700 employees worldwide as of June 30, 2015. Clorox Oracle BI Support has collection of application which includes DOS, WALLMART, TA-SHIPPMENT, HOME DEPOT, and WMINTL. The Project deals with end to end business flow from order creation to order shipment. We used to get the POS and INV files from Retail link to file store, from there the data will be loaded into IDR data warehouse by using PL\SQL and ODI Jobs.ODI job runs from Control M and PL\SQL job runs from Windows task scheduler job. Responsibilities:

● Involved in working on tickets related to Job failure and enhancements and new developments.

● Involved in Business Users Meetings to understand their requirements.

● Created reverse engineering models as per the requirements.

● Migrating code to different environment using ODI import /export options.

● Strong Knowledge in debugging the ODI mapping.

● Created and monitored packages using designer and operator in different environment.

● Assist team to preparing project related document for audit purpose.

● Ensure the team to maintain 100% SLA for all the tickets.

● Worked on different type of CR to do the new enhancements.

● Wrote UNIX scripts.

Environment: ODI 12 C, Oracle 11g, Windows.

Client: Lincoln, PA, USA January 2015 to December 2015 Role: ETL Informatica Support Analyst

Description: L incoln Financials has a datawarehouse consisting of the outbound and inbound processes. It consists of inbound process (Receiving data) from external system/ application like SFDC, Relist, CWD, and PMACS. It is also having outbound process (sending data) for external system/application like SFDC, SPM. This project involves supporting the currently going process that are developed using informatica power center and power exchange for salesforce and sql server objects, salesforce application and autosys. Responsibilities:

● Involved in working on tickets related to modification and enhancements and new developments.

● Identifying the bottlenecks in ETLs and database and tuning the code.

● Guiding and supporting the developers in the project.

● Reviewing of the ETL codes and test cases.

● Interacting with the project stake holders and discuss ongoing problems and providing the project status.

● Conducting reviews with all the stake holders and ensure a smooth implementation. Environment: I nformatica, SQL Server 2008, SFDC, Windows. Client: Philips, NL January 2014 to December 2014

Role: ETL Informatica Support

Description: P hilips Healthcare uses a global CRM application for tracking calls made by customers. This application (called Clarify) is being hosted and maintained in Atlanta (USA). Clarify uses a database stored in MS SQL Server 2000. Early 2007 an initiative was started to see if the Clarify database could be used to generate reports to gain insight into call resolution rates, call duration, and so forth. These reports became part of a data warehouse prototype whichwas built by Randy Thomas. This prototype was developed using Microsoft Business Intelligence tooling: SQL Server Integration Services

(SSIS and INFORMATICA) for data extractions and transformations; SQL Server Analysis Services (SSAS) for generating multidimensional OLAP cubes; SQL Server Reporting Services

(SSRS) for the actual reports.

Responsibilities:

● Understand the overall DWH architecture and the existing CCC Reporting and RADAR application.

● Interfaced with Business users for gathering the business requirements and designed User-friendly templates to communicate any further enhancements needed.

● Worked with Power Center – Designer tool in developing mapping and mapplets to extract and load the data from flat files, Oracle to Oracle, DB2 to Oracle.

● Will be responsible for analyzing the business requirements, design, develop and implement highly efficient, highly scalable ETL processes.

● Can write programs with scripts, packages and mappings.

● Used Various Transformations like Source Qualifier, Lookup, Update Strategy,

● Developed several Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into data warehouse.

● Scheduled Sessions and Batches on the Informatica Server using Informatica server Manager.

● Responsible for ETL process under development, test and production environment.

● Identifying and fixing the known and unknown issue that are reported.

● Develop informatica mappings and workflows for new change requests.

● Support activities using Informatica Power Center client tools. Environment: I nformatica, SSIS, SQLServer 2005, Windows 7. Client: McKinsey March 2013 to December 2013

Role: MSBI Support Analyst

Description: Consumer Market Solution (CMS) is an Advanced Healthcare Analytics service offering fromMcKinsey to Healthcare plans of US. By using this service, McKinsey diagnosis the performance of U.S. Healthcare plans and gives recommendation to improve their book of performance. Cognizant has partnered with McKinsey in automating the existing solution. During this engagement, Cognizant developed Metadata Driven ETL System that can import data into the Dimensional model and generate McKinsey predefined reports - Decision Tree, Heat Maps, Bar charts and Area graphs.

Responsibilities:

● Responsible for getting, understanding the business specification, preparing technical specification documents.

● Designing Data model and creating tables and relationships.

● Creating cleansing, transformation stored procedure for each file.

● Support unit testing to ensure zero defect and quality deliverables Environment: SSIS, SSRS, SQL Server, Windows

Client: Philips, NL January 2011 to February 2013

Role: SSIS, SSRS Support Analyst

Description: C atalogue has collection of application which includes SIEBEL, PMGCAT, SELCAT, UPDATE7, and SOFON. The project deals with end to end business flow from quote creation to order acceptance after which order is service by application in downstream. Responsibilities:

● Actively involved in different phases of project life cycles.

● Gathered business scope and technical requirement.

● Responsible for cleansing the source data.

● Developed several Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into data warehouse.

● Used SQL queries and PL/SQL for database programming.

● Used Various Transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Aggregate, Sequence Generator and Joiner on the extracted source data per the business rules and technical specifications.

● Optimized the mapping using various optimization techniques and debugged some existing mappings using the Debugger to test and fix the mapping.

● Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager.

● Responsible for ETL process under development, test and production environments.

● Documented the mapping process and methodology used to facilitate further development.

● Extracted data from Flat-Files into staging area then cleaned the data using appropriate business rules and load the information into Target tables.

● Implemented Variables and Parameters in Mappings.

● Created Transformations and Mappings using Data Flow Tasks.

● Used Control Flow Tasks like For Loop Container, For Each Loop Container, Execute SQL Task, Execute Package Task and Data Flow Task.

● Extensively used Derived Column, Data Conversion, Conditional Split, Aggregate, Lookup and Sort.

● Created Event Handlers for the Packages Using Event Handler Tab. Environment: Informatica, SQLServer, Windows

Contact this candidate