SUMMARY:

• 6 years of strong Data Warehousing experience in analysis, design, development, implementing, testing and maintenance of the software solutions in various business applications with ETL/Informatica PowerCenter 7.x/8.x/9.x
• Extensively worked with various components of the Informatica PowerCenter PowerCenter Designer Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation developer , Repository Manager, Workflow Manager, and Workflow Monitor to create mappings for the extraction of data from various source systems.
• Good knowledge of business/process dataflow in organizations and proficient in data modeling using ERWIN.
• Experience in implementing complex business rules by creating re-usable transformations, and robust mappings/mapplets using different transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure, Normalizer etc.
• Proficient in full life cycle development of Data Warehousing, ETL strategies, reporting and hands on experience in Performance Tuning of sources, targets, transformations, mappings and sessions using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Extensive experience in integrating data from various Heterogeneous sources like Relational database Oracle, SQL Server, Teradata, DB2 , Flat Files Fixed Width and Delimited , COBOL files, XML Files and Excel files into Data Warehouse and Data Mart.
• Experience in Database Design, Entity-Relationship modeling, Dimensional modeling like Star schema and Snowflake schema, Fact and Dimension tables.
• Worked with Slowly Changing Dimensions type 1 and type 2.
• Experience in PL/SQL Programming Stored procedures, Triggers, Functions, Packages and UNIX shell scripting to perform job scheduling.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Demonstrated ability to take initiatives, grasp and expand on ideas, tackle and follow through difficult assignments in the fast-pace and changing environment.
• Independent yet team oriented with excellent analytical, problem solving, multi-tasking, oral and written communication skills.

TECHNICAL SKILLS

• ETL Tools: Informatica PowerCenter9.1/8.6/7.1/6.2, Informatica Designer, Workflow Manager, Workflow Monitor, Repository Manager
• Databases: Oracle 11g/10g/9i, MS-SQL Server 2000/7.0
• Languages: SQL, PL/SQL, UNIX Shell Scripting, FTP/SFTP, LotusScript, HTML
• Environment: Windows, UNIX
• Tools: TOAD, SQL Developer, Autosys, Remedy,MS-Office Word, Excel, PowerPoint , Lotus Notes 7.x, 6.x and 5.x, Notrix

PROFESSIONAL EXPERIENCE:

Condidential

Informatica Developer

Veristat provides life sciences companies with comprehensive clinical research services, both for individual clinical studies and for entire clinical programs.in this project data management utilizes technologies combined with proven processes that allows us to provide efficient, customized and high quality data management solutions, and the work encompassed on whole SDLC- requirements gathering, analysis extraction of unstructured data from Verizon data formats, designing and developing strategies for successful implementation of ETL mappings, testing and implementation.

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets in corresponds to project coordination. Worked directly with Senior Architect and other team members to create ETL design specifications and support the implementation.
• Involved in translating the functional requirements into technical mapping specifications and leveraged Informatica Power Center 8.6.1 to extract the data from AS/400 DB2 files, Oracle tables and flat files to populate billing, service order and plant interface files, which are then loaded into the Citizens DPI billing system.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure and update strategy to meet business logic in the mappings.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Developed, executed Test Plans and Test Cases to validate and check Referential integrity of data extracts before loading it to Data Warehouse.
• FTP scripts and Extraction of Unstructured Data from various Verizon Data formats using Shell Scripts. XML/flat file formats also extracted successfully. Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with explain plan, creating new indexes, partitions and Materialized views.
• Designed and developed error handling and rekey mechanism in Informatica
• Created repository assigned grants to users to access the repository.

Environment: Informatica Power Center 9.1/8.6.1, Informatica Power Exchange 9.1/8.6, Oracle 11g, PL/SQL, XML, Flat files, UNIX AIX 5.3 , Toad, Teradata, SQL Developer, SQL Loader, DB2, Shell Scripting, HP Quality Center

Condidential

Role: Informatica Consultant

Condidential is a leading pharmaceutical company with strong presence in fields of neurology, gastrointestinal disorders and oncology/critical care. The project with Eisai is to create a data warehouse that houses the customer review data across different subject areas related to neurology, gastrointestinal disorders, oncology etc. coming from multiple source systems. Various Business Rules and Business Processes were applied to Extract, Transform and Load the data into the Data Warehouse.

Responsibilities:

• Gathered requirements from users and translated into technical specifications.
• Involved in the design of Data-warehouse using Star-Schema for the detailed data marts.
• Participated in Conceptual model on requirements analysis with Data Analyst and Business Analysts.
• Developed complex mappings and Slowly Changing Dimensions type-I and Type-II mappings in Informatica to load the data from various sources using different transformations and created complex mapplets for reusable purposes.
• Used various Transformations like Expression, Filter, Joiner and Lookups for better data messaging, migrate clean and consistent data.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Extensively used Workflow Manager for creating workflows, worklets and tasks like Email, Timer Event Raise, Event Wait, Decision and Command.
• Scheduled and ran Extraction-Load process and monitored tasks/workflows using the Workflow Manager and Workflow Monitor.
• Implemented post-session and pre-session UNIX shell scripts to run and control workflows using the pmcmd.
• Worked on scalability and performance tuning batch processing to handle large volumes.
• Involved in fixing the invalid mappings, and testing the stored procedures and functions as part of Unit and Integration Testing.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it is rolled in to production.
• Troubleshoot problems by checking sessions/error logs in the Workflow Monitor and also used debugger in Mapping Designer to debug complex mappings.
• Resolved memory related issues like DTM buffer size, cache size to optimize session runs.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

Environment: Informatica Power Center 8.6.1, Power Exchange 8.x, Oracle 10g, XML files, SQL Server 2008, Oracle Express, SQL Developer, Flat Files, Autosys, UNIX, Cognos, Business Objects XI reports.

Condidential

Role: Developer

CitiCards Customer communications system - Letters DCF Document Composition Facility is developed and supported through IBM VS script and HP Exstream Dialogue applications with core process of data being handled in Mainframes. IBS International Bankcards System and FDR First Data Resource interfaces to the DCF that provides the capability to accept and process communication requests. Communication requests include paragraphs, letters, and e-mails. I have been a part of the Letter transformation phase I project which handled the basic infrastructure and the initial part of the letters being transformed in to Dialogue format. I have also been an integral part of many projects, which needed skills in developing and maintaining letters in the Dialogue format.

Responsibilities:

• Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target.
• Extracted data from various source systems like Oracle, XML and flat files and loaded into relational data warehouse and flat files.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Maintained good interaction with analysts, Project Managers, architects and testers to have efficient and better results.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse.
• Designed and developed various kinds of reports based on user requirement. Provide weekly status report on support tasks, monthly reports and metrics on monitoring and support initiatives and quarterly reviews on existing processes.
• Provided production support for business users and documented problems and solutions for running the workflows.

Environment: Informatica Power Center 9.1/8.6 , Oracle 11g, TOAD, PL/SQL, OBIEE, Flat Files, COBOL, MS SQL Server, SQL Loader, UNIX Shell Scripting, Autosys, Tidal, Windows XP.

Condidential

Software Developer

• Condidential is the Third Party organization marketing the two balancing tools used to support Finance's balancing needs. The products are ACR/Summary and ACR/Detail. Both products work in a similar fashion. They: Read files containing reports, Extract data from the input report, Subject the extracted data to balancing logic Report the results of the balancing logic.
• Amex has incorporated this tool in Production Environment according to its need to Automate Balancing process. This is used to maintain data integrity between the Sending and Receiving Systems. The Controls assure Summary Balancing Control Module automatically verifies that information from two different sources, across multiple applications and business processes, meets user-defined business rules.
• From balancing information to performing historical comparisons and reporting errors, this solution assures information accuracy, consistency, and reliability. As part of the Controls assures solution, the Summary Balancing Control Module reduces operating costs and eliminates manual processes.

Responsibilities:

• Worked closely with Business Analysis team, discussed and gathered the Analytics requirements and created the Business Model using Star schemas.
• Worked on designing and coding the complete ETL process using Informatica for various transactions and loading data from different sources like Flat Files and Relational Database.
• Created numerous Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, Sequence generator, Sorter, Joiner and Update Strategy.
• Used Parameter files to define values for parameters and variables used in the mappings and sessions.
• Dropping and re-creating Indexes on the database Target table using pre-sql and post-sql techniques while loading huge tables.
• Created Sessions and Worklets in Workflow manager having event tasks like e-mails.
• Worked on performance tuning by finding out the bottlenecks in various mappings.
• Unit testing self and other mappings before deploying the code for QA testing by creating scenarios based on the business requirement
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Designed new Informatica mappings which extract data from PDM system and load into DSS systems.
• Involved in creating Autosys Jobs which call Informatica Workflows, which run in the supply chain environment.
• Played a key role in day to day production support of the Informatica batch.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 8.6/8.1,Oracle 10g, PL/SQL, Autosys Scheduler and UNIX Script.

Condidential

Software Developer

Description: This project deals with two areas, Dental claim processing and Agent/ Agency Management. Through Daily Claim Processing, the claims received by HUMANA on dental medical ground are scrutinized and corrected. Duly verified claims are reimbursed. Agent/Agency Management take care of the commissions and incentives to be awarded to HUMANA agent or agencies.

Responsibilities:

• The prime responsibility of the team is to develop a Patient Care Data Warehouse PCDW .This data warehouse is used to access detailed clinical data on a platform and also to facilitate the enterprise-wide data analysis within the health care environment.
• Designed and deployed overall ETL strategy including CDC, SCD's, Partition Management, Materialized Views and other complex mapping logics.
• Migrated from Informatica PowerCenter Repository version 7.1 to 8.1 and applied patches over 8.1.
• Implemented appropriate Error handling logic, data load methods and capturing invalid data from the source system for further data cleanup.
• Involved in designing logical and physical database designing using ERWIN tool.
• Developing shared objects in Informatica for source/target/lookup transformations, developed complex mappings, sessions/workflows/worklets, database connections
• Entered metadata descriptions at both the transformation and port level in complex mappings
• Design the ETL process and schedule the stage and mart loads for the data mart.
• Debugging and Troubleshooting Informatica Mappings.
• SQL Query tuning including Explain Plan, using Optimizer Hints, Indexes and Histograms.
• Involved in Postproduction support and enhancements.
• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse
• Involved in Project scheduling and Project Estimations.
• Worked closely with the Requirements Manager and business Analysts on the requirements collection process.
• Provide technical support to the IT staff in identifying and resolving problems. Act as a liaison with internal teams to research, analyze and propose solutions to technical, operational and test scenarios.
• Assisted the tester in developing the test cases and reviewed them.
• Have thorough experience on Defect Management.
• Supervised the Environment migration process from Development to Test.

Environment: Informatica 8.5.1, Oracle 10g, Informatica Power Center 8.1.1, Erwin 4.5, Oracle Applications, Flat files, PL/SQL, TOAD 9.0, SQL, UNIX, Quality Center 9.0

Condidential

Software Developer

• Fujitsu is a leading provider of IT-based business solutions for the global marketplace. Fujitsu combines a worldwide corps of systems and services experts with highly reliable computing and communications products and advanced microelectronics to deliver added value to customers.
• The project main is for migration form Natural Adabase to Java. So it is the process of reverse Engineering i.e from the available Natural adabse code we need to analyze the businees requirement and prepare a requirements document which is an input to the Java team which helps them in developing the code in JAVA.

Responsibilities:

• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Business Analysis and Requirements Gathering. Worked as a liaison between the end users and DW development team.
• Identified Data relationships.
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Involved in System Analysis, Design and Development of the OLAP application
• Involved in creation of unit test cases and preparing documents for QA.
• Involved in Performing the Unit testing
• Created and executed detail function Test Scripts and Test cases based on the business requirements.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Extensively used stored procedures and also worked with parallel processing.
• Created snapshot for the transactional tables in distributed databases and also created Triggers, Procedures and Functions for the backend Development.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects.
• Created complex joins, transformations of all types to pass data through ETL maps.
• Improved development time by leveraging metadata, and reduced IT coordination costs by providing a common working business model across the Banks enterprise architecture.
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Partitioned the sessions to reduce the load time.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
• Re-designed ETL mappings to improve data quality.
• Optimized/Tuned mappings for better performance and efficiency
• Database Query Manager for data loading and management.
• Database Creation, Security Management, and User permissions Management.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Recommended tuning options to source/target database DBA team to gain optimum performance.
• Provided production support by monitoring the processes running daily
• Experience in SDLC life cycle

Environment: Informatica Power Center , Flat files, Erwin , MS SQL Server 2005, Oracle 9i, SQL, PL/SQL, IBM DB2 8.0, Business Objects , Toad, Unix shell scripting, Windows.

Condidential

Software Developer

The Condidential is all about analyzing the code which is already developed and finding the faults from the existing code which leads to problems in the business. The Project contains different phases in cards like embossing, Authentication etc . We had training in cards to go deep into the programming modules to find all the bugs in the

Responsibilities:

• Working on different tasks in Workflows like sessions, events raise, event wait, e-mail, command, worklets and scheduling of the workflow.
• Creating sessions, configuring workflows to extract data from various sources, transforming data, and loading into enterprise data warehouse.
• Running and Monitoring daily scheduled jobs by using Work Load manager for supporting EDW Enterprise Data Warehouse loads for History as well as incremental data.
• Design, Development and Documentation of the ETL Extract, Transformation Load strategy to populate the Data Warehouse from the various source systems.
• Prepared data marts on policy data, policy coverage, claims data, client data and risk codes.
• Extensively used Informatica PowerCenter 8.6 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner. Used Power exchange for mainframe sources.
• Involved in loading the data from Source Tables to ODS Operational Data Source and XML files using Transformation and Cleansing Logic using Informatica.
• Based on the logic, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, XML, Stored procedure transformations in the mapping.
• Involved in performance tuning of mappings, transformations and workflow sessions to optimize session performance.
• Developed Informatica SCD type-I, Type-II and Type III mappings and tuned them for better performance. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Snowflake Schema was mainly used with Geography, Customer, Product, and Time as basic dimensions.
• Creating Test cases for Unit Test, System, Integration Test and UAT to check the data quality.
• Investigating failed jobs and writing SQL to debug data load issues in Production.
• Writing SQL Scripts to extract the data from Database and for Testing Purposes.
• Interacting with the Source Team and Business to get the Validation of the data.
• Supported the code after postproduction deployment.

Environment: Informatica Power Center 8.6.1/8.1.1, Oracle 10g/9i, MS SQL Server 2005, TOAD for SQL Server, Flat Files, PL/SQL, Windows 2000, XML.