SUMMARY

• Eight Plus (8+) years of total IT experience in the Business Requirements Analysis, Application Design, Dimensional Data Modeling, Data Modeling, Designing, Coding, Development, Testing and Implementation of Business applications with RDBMS, Data Warehouse/Datamarts, ETL, OLAP, Client/Server environment applications for Financial and hospitability (Whyndham World Wide, Confidential, Confidential, Confidential ),Investment banking ( Confidential
• Eight Plus (8+) years of strong experience in Data Warehousing and ETL using Informatica PowerCenter 8.6/8.0/7.1.1/7.1.3/7.0/6.2/5.1 , Informatica PowerMart 6.2/5.1/4.7, (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server), PowerConnect, PowerPlug, Power Analyzer, PowerExchange, SuperGlue, ETL, ETI, Datamart, OLAP, OLTP
• Five Plus (5+) years of Data modeling experience using Normalization, Business Process Analysis,
• Reengineering, Dimensional Data modeling, FACT & Dimensions tables, Physical & logical data modeling, ERwin 4.5/4.x/3.0.
• Five Plus (5+) years of experience working on Business Intelligence tools like Business Objects 6.5/6.0/5.1/5.0
• Web - Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), Cognos Series 7.0/6.0/8.0.
• Five plus (5+) of unix shell scripting experience, worked on korn, bourn and c shell .
• Good programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures, Triggers.
• Three Plus (3+) years of Hands on Experience working with scheduling tools like Autosys, Control M, Maestro, UC4 Cleansing tools like Trillium 7.0, Firstlogic.
• Eight Plus (8+) years of Database experience using Oracle 10g/9i/8i/8.x/7.x, DB2 8.0/7.0, Teradata V2R5/V2R4/V2R3, MS SQL Server 2005/2000/7.0/6.5 , Sybase 12.x/11.x, MS Access 7.0/2000, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.
• Strong Experience to databases SQL, PL/SQL,T SQL SQL*PLUS, SQL*Loader, DBMS Packages, TOAD & ODBC interfaces to Oracle

TECHNICAL SUMMARY

Dimensional Data Modeling: Dimensional Data Modelling using Star & Snow Flake schema. Extensive Experience with Ralph Kimball and Bill Inman Methodologies. Designed Data models using Erwin 4.5/4.0/3.5, Oracle Designer 2000 and Visio

Data Warehousing: Informatica Power Center 9.1/8.6/8.0/7.1/6.2/6.0/5.1 (Workflow Manager, Workflow Monitor, Worklets, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations,), Informatica Power Mart 6.2/6.0/5.1, Informatica Power Analyzer, Power Exchange, Metadata Managaer, ETL, PowerConnect,Launch Informatica Developer, ETL, OLTP, OLAP, Autosys, Control M, Maestro

Data Profiling: Trillium, Firstlogic Business Intelligence, Cognos Series 7.0/6.0 (Impromptu & PowerPlay), Business Objects 6.5/6.0/5.0

Programming: SQL, PL/SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, HTML, DHTML, C, C++, Unix Shell Scripting.

Data Bases: Oracle 10g/9i/8i/8.0/7.0, Oracle Report Writer, SQL, PL/SQL, SQL*Plus, SQL*Loader, Teradata V2R5/V2R4/V2R3, IBM DB2 8.0/7.0, MS SQL Server 2005/2000/7.0/6.5 , MS Access 7.0/2000

Environment: MS DOS 6.22, Win 3.x/95/98, Win NT 4.0, 2003/2000/XP, SCO Unix, Linux

PROFESSIONAL SUMMARY

Confidential, Jersey City,New Jersey

INFORMATION QUALITY MANAGEMENT

Responsibilities:

• Created the profiles on tables and files Validated the profiles using the SQL query and excel functions
• Created status report and sent it to the business users Monitored the profiles in the evening after 7PM Fixed the failed profiles and re-ran Had to create the profile list containing the profile name and folder name Had to do documentation work such as data quality tracker and work intake etc Had to create draft sheet on the rule request document sent by business user Created CDO and then profiles and attached rules to the columns in the profile
• Validated the rules with cognos and created the status report Wrote excel functions to calculate metrics for DQ tracker, to create CDO queries,to create rule draft sheet and to validate the profiles Raised RSAM and EURC requests to get various access such as oracle,teradata,unix etc

Environment: Launch Informatica Developer Version: 9.1.0 HotFix4,Informatica Analyst Version: 9.1.0 HotFix4,SQL Developer 2.1.1,Microsoft Office Excel 2007,Abnitio Metadata Portal Version mh-3.1.2.4,IBM Cognos Connection Version 10.2.1,Control M Workload Automation Version 8.0.00,Teradata Version 13.11.0.04

Confidential, NY

SR INFORMATICA DEVELOPER

Responsibilities:

• Created and updated mappings
• Created mapplets to generate surrogate keys and to load reference tables
• Core tables are split into current and history table
• Created triggers which loads history table before update on fact table
• Stage and core tables had surrogate keys as rowwids
• The sources were csv,xml,relational tables etc
• Had to use regular replace function to transform xml data
• Did dimensional modelling and created star schema and snowflake schema
• Created primary keys at informatica level as there was no primary keys in the database
• Repeated records changed or unchanged in the same session or another session will be updated
• Had to dynamic lookup on target table as the number of records target table were in the range of 80k
• Configured all the columns in CSVfile as string datatype
• Did error handling by giving error condition in the router and sent invalid records to error table
• Duplicates in the same session or another session changed or unchanged will be updated as type 2
• Used dynamic lookupfor scd 2
• Created tables,stored procedures,triggers,indexes and granted privileges to tables
• Used file list concept (indirect method) to load many files at a time
• Updated unix shell scripts and called them as pre and post shell command which creates indirect list
• MQ series was one of the sources and did sorted join between mq series and xml parser to get message id, xml message, message date and columns
• Updated shell scripts which downloads file from ftp and archives it
• Updated stored procedure which is called from map to add new column

Environment: Informatica Powercenter 9.1.,Oracle 10g,SunSolaris 5.1, microsoft visio 2010,Notepad++,IBM websphere MQ, PVCS,sharepoint, Putty suite release 0.62,Filezilla,sql developer toolmicrosoft communicator2005, rfhutil, winscp etc

Confidential, NY

SR INFORMATICA DEVELOPER

Responsibilities:

• Attended the meetings and interacted with business analyst to understand the business requirements
• Paticipated in the detailed requirement analysis for the design of data mart and star schemas
• Extensively worked with source analyzer,warehouse designer,transformation designer,mapping designer and mapplet designer
• Created or Updated SCD type 1, type 2 maps and tables Designed various mappings using transformations like lookup, router, update strategy,filter,sequence generator,joiner,aggregator,Java and expression transformation
• Used mapplets,parameters and variables to implement object orientation techniques and facilitate the reusability of code Did unit testing of maps in DEV for which I had to load data from higher environment into Dev tables whenever required
• Used regular extract in place of instr and substr functions Updated the mappings and moved to production on the same day as a part of emergency ticket Updated the xml definition to add a column Used sequence generator to generate surrogate keys Configured and ran debugger from within the mapping designer to troubleshoot mappings Wrote and debugged Java code for Java transformation
• Extensively involved with fine tuning the informatica code ( mapping and sessions), sql to obtain optimal performance and throughput
• Wrote SQL queries Created range partitions at the source qualifier to improve the session performance Came across many issues and resolved them Created technical specification document Wrote JIL scripts to create or update autosys jobs in 3 environments QA,UAT and PROD Created deployment objects to deploy informatica power center objects to QA,UAT and PROD Involved in the Migration of informatica 8.7 to informatica 9.1 Installed informatica power center 9.1 client Saved DDL scripts in Confidential and moved to QA,UAT and PROD Created change request tickets to deploy objects to QA,UAT and PROD
• Refreshed data by running autotsys jobs in UAT every week Did prod rollout during fridays to move informatica and database objects from UAT to PROD Had to send emails to
• Release and Change Management group for the prod deployment Wrote sql loader scripts to load data from files into oracle tables
• Wrote unix shell scripts to connect to oracle and run queries Wrote merge script to load final tables Had to use pivot to convert rows into columns
• Used filezilla software to upload files from desktop to unix home directory
• Worked on Confidential projects and updated oracle stored procedures Saved the stored procedures in
• Confidential and created QA,PROD tickets Used common table expressions in backfill queries to load new columns

Environment: - informatica 9.1, SQL Server 2008, Oracle 11g, Linux 2.6.32.220. e16.x86 64, Autosys 4.5, Putty Version 0.6, filezilla 3.3.3,SmartSVN Enterprise 5.0.1,Excel 2010, MS outlook 2010,CA Service Desk Manager,SqlDbx Version 3.41

Confidential

SENIOR INFORMATICA DEVELOPER

Responsibilities:

• Attended meetings and got requirements and updates.
• Created and updated maps, sessions and workflows.
• Updated in the Erwin model.
• Did data modeling in provider qualification subject area.
• Did integration testing and UAT testing.
• Created update maps as a part of integration testing
• Used informatica features to implement type II changes in slowly changing dimension tables
• Did documentation and placed it in the common folder
• Created stored procedures and called from informatica
• Created and altered stage tables and temporary tables.
• Copied maps from TFP into DEV and updated them.
• Created new sessions and made it reusable
• Created T - SQL and developed databases
• Multitasked between 6 PCR s.
• Did testing by comparing -
• Front end application with cognos generated reportsCompared Datawarehouse tables with application database tables
• During testing loaded the stage, temporary, dimension,helper and fact tables.
• Had to communicate with application team since there was no documentation.
• In the front end application there was no data so created query with case statements, joins on application database.
• Resolved the issues during development along with our team members.

Environment: Windows XP professional 2002, Informatica Power Center 8.6.1, SQL Server 2008, Erwin 7.3.4, Benthic Software Golden 32,Cognos 8

Confidential, NY

SENIOR DW INFORMATICA DEVELOPER

Responsibilities:

• Attended meetings and got the business requirements.
• Created and updated maps, sessions and workflows.
• Tested the maps moved them to production.
• Did performance tuning of maps.
• Wrote unix Korn Shell scripts for various purposes.
• Installed filezilla software and sent the files manually to WPS.
• Created FTP scripts which automates file to and from WPS.
• Replaced FTP scripts with SSL scripts.
• Scheduled the workflows in the workflow manager
• Used informatica features to implement type II changes in slowly changing dimension tables
• Called stored procedures in oracle as pre sql sesssion.
• Created reusable failure and success email tasks
• Created dependencies between workflows using event wait task and OK files
• Ran the sessions in parallel and connected it to decision task
• After we send the file will be receiving confirmation and rejection files in 1 hour gap used timer task
• Sent files to WPS using filezilla software
• Supported all starcom and aeroplan jobs in production.
• Wrote sql queries to patch the records which were missing for jan 22nd and march 09th into the base and fact table
• Catched ups of all informatica jobs along with my team.
• Created job status report in excel sheet during weekends.
• Downloaded informatica power center 7.1 client.
• Downloaded oracle 10g client and toad 9.0.
• Upgraded from informatica power center 7.1 to informatica power center 8.1.1.

Environment: Informatica PowerCenter 8.1.1,Informatica PowerConnect 8.6 (Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager), Power Exchange CDC,PowerAnalyzer, ETL, Erwin 4.5, Flat files, Toad 9.0, SQL Server 2008, PL/SQL, unix commands,Excel and shell scripting, HP-UX 5.8, MS Windows XP professional 2002

Confidential, NJ

SENIOR DW INFORMATICA DEVELOPER

Responsibilities:

• Attended meeting and got business requirements from team lead.
• Created parameter files for daily loads or monthly loads.
• Wrote unix shell scripts to send success email as post session command.
• Replaced look up transformations with stored procedures and bridge tables due to memory space issues
• Modified maps in the downstream applications containing the tables which were modified
• Loaded the data from source flat file into oracle table using oracle external loader in staged mode.
• Fixed the bugs using debugger in informatica.
• Created maps of SCD type 2
• Upgraded to teradata and BTEQ queries in teradata
• Cleansed the data present in site reporting level table with a query.
• Wrote stored procedures with cursors on smaller tables to improve the performance.
• Copied the workflow from production to development using import and export.
• Did unit testing by writing sql queries.
• Maps were tested by the off - shore team.
• Created reconciliation reports using cognos.
• Improved the performance by performing calculations on chunks of data as it dealth with 1 billion records present in DB2 tables.
• Tuned the maps by placing sorter before aggregator and checked sorted inputs.
• Dropped the indexes before loading the table and recreated the indexes after loading.

Environment: Informatica PowerCenter 7.1.1,Informatica PowerConnect, (Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager), oracle 10g,Teradata V2R4 PowerExchange,PowerAnalyzer, ETL, Erwin 4.5, Flat files, Toad 7.4,Quest Central for db2 version 3.1.0, PL/SQL, unix commands, Excel and shell scripting, Unix SunOS 5.8, MS Windows XP professional 2002,Cognos 7