SUMMARY

• 8+ years of overall experience working in the Information Technology Industry.
• Experience inBI / Data warehouseprojects involving Informatica andCognos suiteof products.
• Worked on various projects through all phases of Data Warehouse Development Life Cycle, including, requirement gathering and analysis, design, development, testing, performance tuning, and production support.
• Good Experience on Managing, Scheduling, and Monitoring of Informatica workflows.
• Experience in data warehousing using variousETL tools (Informatica 6.1/7.1/ 8/9).
• Vast experience in Designing and developing complex mappings from varied transformation logic likeUnconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Data Transformation Servicesetc.
• Experience in working withdata warehousesanddata martsusingInformaticaPower center(Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
• Design and Maintain Informatica PowerCenter mappings for extraction, transformation and loading between Oracle, Teradata and Sybase databases.
• Extensively followed Ralph Kimball and Bill Inman Methodologies. Design the Data Mart model with Erwin using Star Schema methodology. Develop Logical and Physical data models dat capture current state/future state data elements and data flows using Erwin. Designed and Customized data models for Data warehouse supporting data from multiple sources on real time.
• Understanding & Working knowledge of InformaticaCDC (Change Data Capture).
• Developed Strategies for Extraction Transformation Loading(ETL)mechanism.
• Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables.
• Extensive work withPL/SQL, performance tuning ofOracle.
• Experienced with InformaticaPowerExchange(5.x/8.x/9.x) for Loading/Retrieving data from mainframe systems.
• Extensive experience on Data validation tools (Data Flux, Informatica DVO, Spoon)ILM Data Archiving tool 6.1
• ExtensiveUnix Shell Scriptingknowledge.
• Control - M- 5 Years up toControl-M 7.0.300. Control-D2 Years’experience with Migrations, Upgrades
• Very Good Knowledge onControl - Mworkload Automation
• Monitoring all Informatica batch jobs incontrol - M(Enterprise Manager)and fixing abends, check for long running jobs and investigate for any loop back issues with batch jobs.
• Ensure timely completion of the batch cycles, HOLD, Force complete, Rerun and schedule to run next workday.
• Provide Production support 24X7 which involves escalation of abends.
• Provide immediate fixes to the production abends. Solving production abends as per the prose of the document.
• Monitor batch cycles for daily, weekly, monthly, quarterly, yearly jobs and report statistics to client.
• • Ensure dat all transaction processing regions are up on time.
• Extensive experience with relational databases(Oracle 8i/9i/10g, Teradata v2 R6, SSIS, Sql Server 2000/2005).
• Generating and deployingPowerplaycubes and reportsinUnix and windowsenvironments
• Proficient in network installations andtroubleshooting.
• Reliable, responsible, hard working and good team player.

TECHNICAL SKILLS

Data Modeling: ERWIN 7.1/4.2/4.0/3.5/3.x, Visio, Oracle Designer 2000, Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Data warehousing & ETL: Informatica PowerCenter9.1/8.6/8.1.1/7.1/7.0/6.2/6.1/5.1.2/5.1.1/4.7 (Workflow Manager, workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart 6.2/6.1/5.1.2/5.1.1/4.7, Power Connect, PowerPlug, PowerAnalyzer, SuperGlue, Power Exchange,Oracle Warehouse Builder 11g Release1 (Warehouse Builder Client and Server, Design and Runtime Repositories, Design Browser and Runtime Audit Browser, Client Version, Integration with Oracle Application Server), Datamart,DataStage, ETL, OLAP, ROLAP, MOLAP, OLTP, Star Schema, Snowflake Schema, Autosys, Control M, Maestro

BI & Reporting: OBIEE, Oracle Discoverer, Answers & Publisher,Business Objects Developer Suite 5.1/6.0, Cognos, SQL Developer and others.

Validation Tools: Informatica DVO, Data flux, Spoon

Databases: Oracle 10g/9i/8i/8.x/7.x, DB2 8.0/7.0/6.0, Teradata V2R5/V2R4/V2R3, Sybase SQL Server 12.0/11.x, MS SQL Server 2005/2000/7.0/6.5, MS Access 7.0/’97/2000, PL/SQL, SQL*Loader, Developer 2000

Job Scheduling & Other tools: CA Autosys, BMC Control M, Cron, IBM Maestro, Quest TOAD 7.6, Quest Central for DB2

Environment: UNIX (Sun Solaris, HP-UX, AIX), Windows 2003/2000/XP/98, Sun-Ultra, Sun-Spark, Sun Classic, RS/6000, HP 9000, Compaq Tru64, SCO Unix, Mainframes

Others: Cobol, Java, XML, JavaScript, XHTML, HTML, DHTML, C++, Visual C++, VBScript, CSS, SQL

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Sr.Informatic Developer

Responsibilities:

• Manage scope jointly with other DCs
• Design, Develop and implement the initial population and ongoing sync
• Evaluate when to employ Mock Data Movements
• Develop data Validation
• Understand and prepare High and Low Level Design based on Functional and Business requirements of Horizontal Data Movement(HDM).
• Interact with the requirements team and designers to get a brief knowledge of business logics. Review of Master Data Workbooks for better understanding of business logic.
• Perform study and select industry standard tool for Data validation.
• Involve in Data validating, Data integrity, performances related to DB, Field size validation, check Constraints and Data Manipulation and updates by using SQL.
• Extract data from flat files,DB2 and to load the data into the Oracle and Sales Force database. Extensively used various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Improved performance using Oracle Partitions, Indexes and other Performance Tuning techniques. Developed re-usable components in Informatica, Oracle and UNIX
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation
• Used web services, cvs files and tables as sources and loaded the data into relational tables.
• Used xsd.exe tool to generate the xsd’sfrom the xml generated from the SharePoint.
• Also used xml parser to parse the xsd generated and load the data accordingly.
• Worked on web services lists,xsd.exe tool, web services consumer transformation and xml parser transformation as well.
• Validate the ongoing data synchronization process using validation tools to ensure the data in source and target system are synchronized.
• connecting to HP Service Manager (via API exposed) through DVO Review the results and open a HP Service Manager ticket for any deviations automatically (throughDVO)
• Used Data flux Data Management Studio for identifying and resolving problematic data, Standardize, Normalize and transform data, validate data and improve overall accuracy.
• Used Data Flux MDM to integrate data from data sources into a single, reliable and accurate Master record and extending data management routines throughout information infrastructure.
• Extensive experience using in CONTROL - M(7.0.0.3), Control- M workload Automation
• Scheduling jobs in Control M(Windows and UNIX jobs).
• Making Scheduling changes as per Client's Requirement such as defining a new job, modifying an existing job, calendar updates, adding predecessors and successors to the existing job and adding file dependencies.
• Explanation of Job definitions, Job streams, Calendars, Workstations, Scripts, Checking the timings of job running, checking the variants in control M (EM)
• Ad hoc request to Schedule Particular Jobs.
• Review daily abend reports to determine jobs dat may require further action for a permanent resolution.
• Setting up calendars in all tools as part of Year End Process. Direct Client support by communicating with them.
• Handling ERTs, Outages and RCAs (Root Cause Analysis).
• Giving permanent solutions for the scheduling issues to the jobs in all the tools, System health check-up,
• Extensive experience in Identify and Create automated scripts to reduce manual efforts.
• Automate Job and Batch process of data validation in UNIX system using Shell scripts with cURL.

Environment: Informatica Power Center 8.6.1/8.1.1/9.0.0 Data flux 7.0/8.0 Control - M 7/8, Talend Open Studio for data integration 5.1, SQL, PL/SQL, SQL Server 2008, UNIX Shell Scripting, Autosys Workload Scheduler, TOAD 9.7.2, Sql Server tool, Oracle 10g/11g, Windows NT server, SQL, PL/SQL, HP-UX 10.2, TKPROF, RMAN, STATSPACK, Server Manager, SQL*Loader,SalesForce, SOQ,L UNIX, Web services, xsd.exe,ILM Tool

Confidential

Sr. Informatica Developer

Responsibilities:

• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Implemented slowly changing dimension Type 1 and Type 2 forChange data capture.
• Responsible for Error Handling in Workflows and sessions usingInformaticaworkflow manager and monitor the workflow run and statistic properties onInformaticaWorkflow Monitor.
• Responsible for DefiningMapping parametersandvariablesandSession parametersaccording to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Alsoprovided production support by monitoring the processes running daily
• Doing Change Requirement for complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
• Designed Sources to Targets mappings from Mainframe, Flat files, to Oracle using Informatica Power Center.
• Responsible for working with DBA and Data Modellers for project coordination.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, workflows for the mapping to run daily based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Involved in unit testing and fixing the bugs identified,provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Involved in team weekly and by monthly status meetings.

Environment:Informatica Power Center 9.1/8.6, UNIX scripting, Oracle 11g, Mainframe.

Confidential, Bridgewater, NJ

Sr. Informatica Production Support

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
• Designed Sources to Targets mappings from SQL Server, Excel/Flat files, Xml Files to Oracle using Informatica Power Center.
• Responsible for working with DBA and Data Modellers for project coordination.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Implemented slowly changing dimension Type 1 and Type 2 forChange data capture.
• Responsible for Error Handling in Workflows and sessions usingInformaticaworkflow manager and monitor the workflow run and statistic properties onInformaticaWorkflow Monitor.
• Responsible for DefiningMapping parametersandvariablesandSession parametersaccording to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Alsoprovided production support by monitoring the processes running daily
• Doing Change Requirement for complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Involved in unit testing and fixing the bugs identified,provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Involved in team weekly and by monthly status meetings.

Environment:Informatica Power Center 9.1/8.6, Unix scripting, MS SQL server 2005, Oracle 10g, Quality Toad, PL/SQL (Stored Procedures, Triggers, Packages)

Confidential, Philadelphia, PA

ETL Informatica Developer

Responsibilities:

• Analyzing business processes, functions, existing transactional database schemasanddesigning star schemamodels to support the users reporting needs and requirements
• Converting the Business rules into Technical Specifications for ETL process
• CreatedConceptual data modelby gathering the business requirements from various sources like discussion with functional teams, business analysts and from business documents
• Designedlogicalandphysicaldatabase designing usingERWINTool.
• Created High Level and Low level design documentation for National, Sub National, Comm. Dashboard and RSA Systems
• Conducted code review sessions with BSA, Project Managers and with Technical Team.
• Used SQL * Loader to load the data from Flat files to Oracle for Comm. Dashboard system.
• Worked extensively onFlat Files, as the data from various Legacy Systems is flat files.
• Created Mappings usingMapping Designerto load data from various sources, using different transformations likeSource Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations.
• Designed and optimized moderate to complex Initial load to populateSCD Type-2 using date format.
• CreatedmappletsusingMapplet Designerand used thoseMappletsfor reusable business process in development.
• Implemented Error HandlingStrategy
• Created re-usable transformations andWorklets
• Improved thesession performancebypipeline partitioning.
• Generated Unittestandcase text documents.
• Created Workflows in theWorkflow designerand executed tasks such as Sessions and Commands and monitored transformation processes using Workflow monitor
• Involved inperformance tuningof the Informatica mapping and identifying the bottlenecks.
• Extensively worked with the Informatica server dat runs onUNIX platformand usedworkflow monitorto monitor the Informatica server and reviewed session logs dat it generates for failed sessions.
• Worked withUNIXshell scriptsto performpre-sessionandpost-sessionoperations.
• Used Shell script and Perl script to audit check on the flat files before loading the data into National data mart.
• Designedthedata warehousetables based on the functional requirements.
• CreatedSQL Loaderscripts and batch processes to load data from the source files (flat files) to the data warehouse tables.

Environment:Informatica Power Center8.1.1/7.1.3,WorkFlow Designer, Powercenter Designer, Repository Manager, Oracle 10g/9i, SQL,PL/SQL, SQL Loader, UNIX Shell Scripting, Windows XP

Confidential, Atlanta, GA

ETL Informatica Developer/Admin.

Responsibilities:

• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Extensively worked on Informatica client tools like Designer, Workflow Manager and workflow monitor.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Involved in migration of ETL environment, Database objects and EDW.
• Tested data integrity among various sources, targets and various performance related issues.

Environment:Informatica Power Center 6.2.1, Windows 2000, Sun Solaris, SQL Server 2000, Oracle 8i, PL/SQL, UNIX Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Analyzed specifications and identified source data needs to be moved to Data Mart, participated in the design team and user requirement gathering meetings.
• Performed major role in understanding the business requirements and designing and loading data into data warehouse. Designed star schema using Dimension modeling using the ER-win design tool.
• Extensively used ETL (Informatica) to load data from source (Flat files) to target Oracle database.
• Lookup, Aggregator, sequence, joiner and other transformations are used in populating data process.
• Created Informatica Mappings with PL/SQL procedures/functions to build business rules to load data.
• Involved in scheduling the Informatica Workflows using Autosys.
• Conducted Performance tuning of application by modifying the SQL statements and using Explain Plan andTOADSoftware.
• Used the Oracle stored functions/procedure/Packages.
• Created PERL scripts for some of the target system load
• Involved in developing the requisite reports (list, grouped list, cross-tabs etc.) using Business Objects.

Environment: Informatica Power Center 7.1,Oracle 8i, PL/SQL, SQL, Autosys, Toad for Oracle, Windows NT, PERL Scripting, MS Access.