( SR INFORMATICA DEVELOPER)

SUMMARY

Seven Plus (7+) 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 Insurance (XL capitol and All State Insurance) ,Pharmaceutical (Pfizer and Sankyo Pharmaceuticals), Financial and hospitability (Whyndham World Wide, Starwood Hotels, Common Wealth and GE Aviation ) Verticals. Seven Plus (7+) 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 Four Plus (4+) 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. Four plus (4+) 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. Seven Plus (7+) 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, SQL*PLUS, SQL*Loader, DBMS Packages, TOAD & ODBC interfaces to Oracle I have working knowledge of salesforce which gives real time visibility

EDUCATION & CERTIFICATIONS Bachelors in Computer Science

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 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, 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, NYC ,NY SR INFORMATICA DEVELOPER AUG '11 - PRESENT

Confidentialis a Global financial services firm and a market leader in securities , asset management and credit services.Was involved in Summit 4.0 project . Mainly worked on various mortgage projects . Such as sales reporting , FA bonus , FA compensation .Had to analyse , design and do ETL using informatica .

• After getting the requirements , analysed it and created the maps
• Did data validation by writing perl script
• Created ,updated and tested the maps.
• Created and updated the tables
• Had to work on defects whenever a Jira item was assigned to me and resolved it
• Updated various stored procedures as a part of Jira item by changing the logic if the logic is incorrect
• Called stored procedure into the maps
• When the table was changed such as by adding new columns or removing columns , had to change the dependencies such as stored procedures and maps
• Wrote queries in sybase and gave it to Business objects team for generating reports
• Also wrote queries to unit test the maps that I developed
• Had to create views as a part of development work
• Altered the table by removing the primary constraints
• Renamed the tables and indexes
• Had to update or create config files such as domain and interface in order to run the maps from unix
• Ran the jobs using autosys
• Created score cards by running the autosys
• Used perforce to save various versions .

Environment : Informatica 8.6.1,DBArtisan 8.6.4, Sybase, Teradata ,Putty SSH,Unix , Jira Shared 2, Peforce P4V,Autosys

Confidential,CINCINNATI,OH SENIOR INFORMATICA DEVELOPER OCT '10 - JUN '11

Responsibilities

Site,LRU,Product Structure are 3 main tables .We get extract files from all the sites and load them into the stage tables. A part can be nut,screw,resistor,pint etc. Confidential is made up of several parts . Confidential cannot be fitted into another Confidential. A part can be originally made or repaired or spared. Several sites can manufacture same part.Sites can buy parts from another sites or it can manufacture them.

• Created and updated maps.
• Had to create pre map to update duplicate indicator column in the item stage table
• Had to write shell scripts
• Had to place the sessions inside the worklets
• Had to create separate workflow for each session
• Tested the data in database after loading
• Tested shell scripts and maps by running the PDW workflow
• Had to delete unused sessions and maps
• Encripted item, line replaceable unit and product structure files and placed them in dev library
• Had to catch duplicate part numbers and send them back to sites
• Figured out why the rows and files are rejected
• Created score card and error report.
• Created test case documents
• Attended everyday PDW test meeting with offshore team
• I ran the workflow in prod and I should not see errors in the sesson log .
• Zipped the session logs and created load statistics.
• Had to schedule meetings with off shore team

Environment : Microsoft Windows XP professional 2002, Informatica Power Center 8.6.1, Oracle 11g,SQL developer v1.5.5,MS Office Professional Plus 2010,Quality centre

Confidential, CAMPHILL, PA APR '09 - SEP'10 SENIOR INFORMATICA DEVELOPER

Responsibilities

• Attended meetings and got requirements and updates.
• Created and updated maps, sessions and workflows.
• Updated in the Erwin model.
• Did some data modeling in provider qualification subject area.
• Did integration testing and UAT testing.
• Created update maps as a part of integration testing .
• Did documentation and placed it in the common folder
• Created a stored procedure which acts as check box by selecting more than one day in a week and imported into 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.
• Multitasked between 6 PCR's.
• Did testing by comparing -
• Front end application with cognos generated reports,
• 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 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, Oracle 11g, Erwin 7.3.4, Benthic Software Golden 32,Cognos 8

Confidential,NYC,NY JAN'09-Mar'09 SENIOR DW INFORMATICA DEVELOPER

Confidential is the largest pharmaceutical company in the world , which has remained dedicated to discovering and developing new and better ways to prevent and treat disease and improve health and well being for all the people in the world.

Responsibilities

• Migrated from oracle database to teradata database.
• Created folders, groups and giving permissions.
• Verified the workflow in development according to CIF standards
• Deployed the workflow from development to testing and production.
• Validated the workflow in testing and production.
• Started the integration service for a folder.
• Created, updated and deleted the autosys jobs in development ,testing and production using jil files.
• Moved the parameter files,shell scripts,environment files and dat files from development to testing and from testing to production.
• Created the inbound and outbound directories in the testing and production for that informatica folder.
• Ran the autosys jobs in production.
• Marked the autosys jobs as hold or success or fail or inactive or active in production.
• Created relational connections in the workflow manager for the teradata database.
• Created TNS names in tnsnames.ora.
• Inserted the records into ctl_infa_param and ctl_interface tables in QA and production.
• Executed SQL scripts in teradata database and oracle database.
• Took the DMR and CCB ticket requests from the off-shore team and worked with them to complete the tickets
• Worked with off-shore team and communicated with sametime chat software
• Did data migration to Salesforce.com

Environment: Informatica Power Center 8.6.1,oracle 11g,linux - Red Hat 53,Autosys - R11 SP2,Toad 9,Edit Plus,Teradata V2R6,Lotus Sametime

Confidential,WHITE PLAINS,NY JUNE '07 - DEC'08 SENIOR DW INFORMATICA DEVELOPER Confidential is one of the world's largest hotel and leisure companies. It conducts hotel and leisure business both directly and through its subsidiaries. Its brand names include the following: St.Regis,The luxury Collection, W,Westin, Le Meridien, Sheraton, Four Points and Aloft .Through its brands, we are well represent in most major markets in the world. Our operations are grouped into two business segments, hotels and vacation ownership and residential operations. 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 order into informatica as pre sql session and loaded source tables.
• Created reusable failure and success email tasks.
• Created dependencies between workflows using event wait task and OK files.
• Called a unica stored procedure which in turn calls many stored procedures into the map for error handling.
• 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, oracle 10g , PL/SQL, unix commands,Excel and shell scripting, HP-UX 5.8, MS Windows XP professional 2002

Confidential,PARSIPANNY,NJ JAN '06 - MAY'07 SENIOR DW INFORMATICA DEVELOPER Confidential is one of the world's largest hospitality companies across six continents. Confidential world wide is the world's largest lodging franchisor,encompassing nearly 6500 hotels under 10 brands on six continents. 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.
• Due to memory space issues, replaced look up transformations with stored procedures and bridge tables.
• When source table was altered, modified maps in the downstream applications containing that table.
• 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
• Cleansed the data present in site reporting level table with a query.
• Created 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,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

Confidential,STAMFORD,CT SEP '04 - DEC'05 SENIOR DW INFORMATICA DEVELOPER

Confidential is a global insurance and reinsurance company providing property, casualty and specialty products to industrial, commercial and professional firms, insurance companies and other enterprises on a worldwide basis. It has its branches in Canada, Bermuda, Switzerland, London etc.

Responsibilities:

• Attended meetings and gathered business requirements.
• Wrote PL/SQL procedures in MS sql server to get current and previous batch dates.
• Fixed the bugs using the debugger.
• Tuned informatica Map and Sessions for optimum performance.
• Created autosys jobs and scheduled the workflows.
• Did unit testing and signed off unit test document.
• Wrote a technical specification document.
• Loaded the data from WINS stage into WINS ODS.
• Views were created on WINS ODS with semantic column names and semantic table names.
• Used changed data capture to get only updated and new records from policy and claims tables.
• Supported the WINS ODS jobs.
• Before extracting procede data from ceded claim transaction detail, deleted procede data from ceded claim accounting month summary table by calling as pre sql session.
• Loaded different types of financial data (WINS and PROCEDE data) from ceded claim transaction detail table into ceded claim accounting month summary table.

Environment: Informatica PowerCenter 7.1,Informatica PowerConnect, (Repository Manger, Designer, Server Manager, Workflow Monitor, Workflow Manager), PowerExchange,ETL, Erwin 4.5, Flat files, MS SQL Server 2005/2000, PL/SQL, Reporting Services 2005, Autosys , DOS commands, Excel and batch scripting, Perl scripting, DOS, MS Windows 2000