Informatica, Microstrategy, Datawarehousing, SQL, UNIX, Oracle,DB2

Praveena Varadharajan

********.****@*****.***

***-***-***

SUMMARY OF EXPERIENCE

• 5 years of IT experience which includes analysis, design, development, and implementation of client server applications using Data warehousing tools like Informatica, MicroStrategy, Business Objects

• 5 years of Data warehousing & ETL experience using Informatica Power Center/Power mart 5.1/ 7.1/8.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor) in UNIX environment

• Extensive experience in Dimensional Data modeling using Star and Snow Flake schema

• Solid understanding of Data Warehousing life cycle and strong working experience on Data Warehousing applications

• Directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse

• Designed complex mappings using Normalizer, Expression, Aggregator, Lookup, Joiner, Router and Stored Procedure Transformations

• Worked in different business domains like Health Insurance, Telecom and pharmaceuticals, which includes working in Onsite-Offshore model as well.

• Experience in Multi-Terabyte environments, solid experience in coding using SQL, PL/SQL stored procedures/functions and triggers.

• Experience in Databases like Oracle 10g/9i, DB2, SQL Server 2000

• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams, Data Flow diagrams and Normalization concepts.

• Have good experience in data analysis and have suggested many enhancements

• Have the ability to translate business requirements into functional requirements and have worked with the end users/clients directly.

• Proven self-starter with results-oriented work ethic .Positive attitude with readiness to learn continuously in this ever changing IT world

• Good communication and team management skills .Excellent problem solving skill

SKILLS:

• ETL Informatica: Informatica 5.x/7.x/8.x (Power Mart & Power Center)

• Databases: Oracle 10g/9i, DB2, SQL Server 2000, Teradata

• Reporting Tool: Microstrategy, Business Object 5.0, Cognos

• Data Modeling Tools: Erwin, MS – Visio

• Languages: SQL, PL/SQL, Shell Scripting

• Office Applications: MS-Office 97/2000/XP/2007, Open Office Suites

• OS: Windows 9x/NT/2000/XP, Red Hat Linux, UNIX

• Other Tools: TOAD,SQL Plus, AQT(Advanced Query Tool), Control M, Erwin, Hummingbird, Putty

PROFESSIONAL DEVELOPMENT:

Anthem Blue Cross Blue Shield, St Louis, MO

Duration: 10/2007 – 05/2010

Role: System Analyst

Description: WEDW is the West Enterprise Data Warehouse of Anthem/Well point (Insurance).Persistent Data Store (PDS) tables stage the data files from the source (Mainframes) and this in turn will become source to the various EDW (Enterprise Data Warehouse) tables as per the requirements / business logics. Informatica Mappings used to load the data from the Source files to PDS staging tables and from PDS to EDW target tables. UNIX shell scripts are used to run the ETL workflows and run data validation on DB2 database (PDS & EDW tables) and for other automation purposes

This is a Maintenance project and typical activities are Production Support, debugging / fixing Production & data issues. Debugging and fixing production issues involves data analysis. I have taken the role of BA several times while fixing issues raised by clients/end users. Technical work includes developing new, modifying & analyzing the already existing Mappings and Work flows in Informatica and Shell scripts in UNIX and writing DB2 queries. The Project Deals with Insurance transactions which include Claiming of bills, Membership, Capitation, Provider & Revenue.

Accomplishments/ Results:

• Extensively worked on Process Design, Development, Testing and Implementation of the project.

• Responsible for requirements gathering and translated requirements into business rules and made recommendations for Warehouse Development

• Designed the Functional Requirements and Mapping Technical Specifications

• Used Informatica 7.1/8 as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables, Dimension, Work and fact tables.

• Extensively worked on Informatica Power Center – Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations to import source and target definitions into the repository and to build mappings.

• Extracted data from different sources like Mainframe systems (COBOL files) and flat files

• Various kinds of the transformations were used to implement simple and complex business logic

• Created and configured workflows, worklets & Sessions to transport the data to target systems using Informatica Workflow Manager.

• Used Control M tool to schedule workflows

• Developed UNIX shell scripts to create parameter files, rename files and compress files

• Participated in the Informatica Upgrade from 7.1 to 8.1

• Have written lots of SQL scripts in Pre-sql and post sql sessions tasks

• Debugging and Troubleshooting Informatica Mappings and unix scripts to identify the root cause of the problems that occurred during the production runs

• Involved in Unit, System testing and regression testing

Environment: Informatica Power Center 8.1/7.1, DB2, UNIX Shell Script, SQL, AQT

Merck Pharmaceuticals, Lansdale,PA

Duration: 10/2006 – 09/2007

Role: Software Engineer

Description: The primary focus of Insight is on call planning, call reporting, sampling and customer profiling. This project was aimed to develop a central data warehouse to stage the product (all pharmaceutical products) data, customer data etc. This was basically a migration project as well as integrating the three different data marts into one warehouse.

Accomplishments/ Results:

• Enhancements were suggested and eventually applied to have a smooth run on production

• New mappings were created based on the requirement. Design of ETL mappings using Informatica transformations like Lookup,Filter, Aggregator, Router and Expression etc.

• Have used PL/SQL procedures in the transformations

• Change request processing

• Involved in unit testing

• Solving production Issues

• Bug fixing

Environment: Informatica Power Center 7.1, Oracle10g, Unix, SQL, PL SQL

Verizon Data Services Ltd, Arlington,VA

Duration: 06/2004 – 10/2006

Role: Software Engineer

Description: Telecom is a regulated business in USA and the genesis of the project lies in the Central telecommunication Regulation act of 1996. This act opened the local telephone market for competition giving rise to the competitive local exchange carriers (CLEC). The bandwidth providers were mandated to provide service to these smaller telecom service providers who would collect their customers by offering discounts and use the bandwidth and services provided by carriers. The FCC therefore asked the incumbent local exchange carriers (ILECs) to produce metrics validating that the CLECs were being provided same level of service as any other customers of ILECs. The Network Metrics Platform (NMP) is an initiative to bring this data on a central platform. This entails extracting data from several existing systems feeding this data to the data warehouse, building data marts to support the reporting requirements, doing the number crunching and producing the required reports

Accomplishments/ Results:

• PHASE 1: First level of transition of the ongoing projects from our primary vendor Sapient to Verizon, India from Dec 2004 – Feb 2005 for network performance, Operator Services and General Standards domains.

• PHASE 2: Second level of transition of Ordering and Billing domain from our primary vendor Sapient to Verizon, India from Apr 2005 – May 2005.

• Involved in development, testing and operations for different domains like Ordering, Billing, Network performance and Operator Services.

• Developed new and maintained existing Informatica mappings and workflows based on specifications.

• Analyzed the business source data and reporting requirements and have designed source-to-target data maps and business-driven transformation rules

• Participated in the design of new or changing mappings and workflows and produce requisite specifications. Implemented the change control requests (CCR) on need basis from client side

• Participated in functional test planning and testing the application. Involved in Developing, implementing and maintaining unit tests for applications.

• Participated in problem solving and troubleshooting for the applications implemented with Informatica using session and workflow logs. Responding quickly and effectively to production issues.

• Documented all new and modified mappings according to standards as part of the Data Warehouse documentation.

• Used indexes and partitioning on the fact tables to enhance performance

• Participated in the Informatica upgrade from Informatica 5.1 to Informatica 7.1 and oracle upgrade from 9i to 10g.

• Done the operations of daily, weekly and monthly reporting to FCC for Billing, Network Performance, Operator Services, General Standard domains in parallel, monitoring the informatica system to ensure that they run properly.

Environment: Informatica 7.1/5.1, Unix, Oracle 9i, MicroStrategy, Unix & Perl Scripts.

EDUCATION & CERTIFICATIONS:

• Bachelors in Electronics and Communications Engineering in 2004

Contact this candidate