Sr Developer & Analyst

Vajeed

Email: ******.*****@*****.***

Summary

• Over 8 years of IT experience with extensive Data Warehousing implementations across Retail, Insurance, Financial and Communication Industries.

• Over Six (6) years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.x/ 8.x/7.x/6.x and PowerMart 8.x/7.x.

• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.

• Extensive experience of extracting data from various sources including Teradata, Oracle, SQL Server and Flat file.

• Extensive experience with MLoad , Fast Load in Teradata multiple loading and quickly load data into empty tables

• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.

• Experience in creating High Level Design and Detailed Design in the Design phase.

• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.

• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.

• Well versed in OLTP Data Modeling, Data warehousing concepts.

• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).

• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.

• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).

• Experienced in UNIX work environment, file transfers, job scheduling and error handling.

• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.

• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.

• Involved in Unit testing, System testing to check whether the data loads into target are accurate.

• Experience in support and knowledge transfer to the production team.

• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.

• Extensive functional and technical exposure. Experience working on high-visibility projects

• Assign work and provide technical oversight to onshore and offshore developers

• Excellent analytical/ communication skills and good team player.

Technical Skills

• Databases • Teradata, Oracle 7.x/8.x/9x/10g/11g, SQL Server 2008/2005/2003/2000, DB2 UDB 7.2, My SQL 5.0/4.1, MS-Access. Editors ( SQL Navigator, Toad)

• Oracle Tools • Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g

• ETL Tools • Informatica 9.x 8.x/7.x/6.x, Informatica PowerExchange 8.x/7.x

• Data Modeling • ERWIN , Visio

• Reporting Tools • MS SQL Server Reporting services 2005, Business Objects XI, Crystal Reports 10, Crystal Reports 2008, Oracle Reports 2.5.

• Programming Skills • C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, FORTRAN, JAVA (Eclipse IDE and Net Beans IDE), HTML, JAVA Script, J2EE, CSS.

• Operating Systems • UNIX, HP, Sun Solaris 2.x/7/8, Windows ME/2000/2003/NT/XP, IBM AIX, Exceed (Editor)

Professional Experience:

L’OREAL USA, Berkeley Heights, NJ Mar 2010 to Till Date

Designation: Sr. ETL Developer

Description: For the past century, L’Oreal has pursed its adventure in the beauty industry to cement its position as the world’s leading Cosmetics Company. In LPD CRM Project, implemented a comprehensive database marketing solution that will provide consumer management and reporting across all channels and all brands. The selected solution is the Harte-Hanks Allink 360 Campaign Solution for storing data, selecting customers for marketing communications, and reporting on results.

Responsibilities:

• Implemented CDC by tracking the changes in critical fields required by the user.

• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.

• Extensive use of Persistent cache to reduce session processing time.

• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.

• Modified the shell/Perl scripts as per the business requirements.

• Maintained warehouse metadata, naming standards and warehouse standards for future application development.

• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.

• Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.

• Developed shell scripts for file transferring

• Extensively used Stored Procedures, Functions and Packages using PL/SQL.

• Implemented screen door process for cleaning flat files as per the business requirements.

• Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

• Involved in Unit testing, User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

• Preparing and using test data/cases to verify accuracy and completeness of ETL process.

• Actively involved in the production support and also transferred knowledge to the other team members.

• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica PowerCenter 9.1, Informix, Teradata, SQL Server 2008, Erwin 4.1, Windows XP, UNIX, UNIX Shell Script.

KOHLS CORPORATION, Menomonee Falls, WI Dec 2008 to Feb 2010

Designation: Sr. ETL Developer

Description: Kohl’s is one of the nation’s largest retailers. The project is aimed to build a data mart which will provide merchants ability to report on Order Planning, Weeks of supply data and merge it with enterprise data warehouse. The project’s name is ‘Service Level, Quantum and Projection Analysis Reporting’. This data mart is the biggest data mart that Kohls has.

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.

• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.

• Extensively involved in Data Extraction from Mainframe source (VSAM), Oracle using PowerExchange when there was change in the source data sets.

• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.

• Read\Wrote XML Messages from\to MQ Series Queues and worked extensively with XML Parser (XSD) and XML Generator 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.

• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.

• Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.

• Validation of Informatica mappings for source compatibility due to version changes at the source.

• Trouble shooting of long running sessions and fixing the issues.

• Implemented daily and weekly audit process for the Claims subject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.

• Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.

• Involved in writing SQL scripts, stored procedures and functions and debugging them.

• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

• Worked with reporting team to help understand them the user requirements on the reports and the measures on them. Helped them in creating canned reports.

• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.

• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica PowerCenter 8.6.1,PowerExchange 8.1, Teradata, Oracle 10g/11g, SQL Server 2005, DB2, Mainframe, XML, XSD, IBM MQ Series, Solaris, Unix, Unix Shell Script, Erwin, Business objects XI Release 2.

Chubb Group of Insurance Companies, Warren NJ Jul 2007 – Nov 2008

Designation: Sr. Informatica Developer

Description: Chubb Group Of Insurance Companies is a General Insurance company and is focusing on auto, homeowners and small-business policies. The CSD (Claims System Department) in Property and Casualty at Chubb Group of Insurance Companies wanted to build a warehouse to consolidate their P&C Legal data existing in multiple databases across the country. In this we developed a warehouse for Claims System Department by using Informatica PowerCenter 8.1.1 Version.

Responsibilities:

• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.

• Perform analysis on quality and source of data to determine accuracy of information being reported and analyze data relationships between systems.

• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.

• Involved in data modeling and database design of the new P&C Legal management database by applying Ralph Kimball methodology of dimensional modeling and using Erwin for data modeling.

• Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.

• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from Oracle, SQL Server, Sybase, DB2, flat file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).

• Developed custom data transformation (structured/unstructured data) process using Itemfield content master data transformation tool.

• Worked on Informatica PowerCenter tool – Source Analyzer, Mapping Designer, Mapplet Designer and Transformation Developer.

• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, SourceQualifier, Sorter, Update strategy and Sequence generator.

• Developed PL/SQL stored procedures for Informatica mappings.

• Created Sessions and Workflows to load data from the SQL server, flat file and XML file sources that exist on servers located at various locations all over the country.

• Scheduled the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data for P&C Legal management reporting.

• Involved in unit testing, Integration testing and User acceptance testing of the mappings.

• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.

• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.

• Responsible for creating business solutions for Incremental and full loads.

• Installation and configuring the PowerCenter tool including database connections.

• Providing technical support and troubleshooting issues for business users.

• Actively Participated in problem solving and troubleshooting for the applications implemented with Informatica.

• Used Workflows Manager to create the Sessions to transport the data to target warehouse.

• Used UNIX shell scripting to generate User-Id’s.

• Designed and developed reports using Microsoft Reporting Services tool.

Environment: Informatica PowerC enter 8.1.1, Power Exchange, Erwin 4.1, Teradata, oracle 11g/10g/9i/8i, PL/SQL, SQL Server 2005, Sybase, DB2, XML, Unix, Unix Shell Script.

M&T Bank, Buffalo, NY Mar 2006 –Jun 2007

Designation: Sr. Informatica Developer

Description: M&T Bank is considered one of the country's most highly regarded regional banks. founded more than 145 years ago in Western New York, It's parent company, M&T Bank Corporation, had over $55billion in assets and is one of the 20 largest commercial bank holding companies in the U.S. M&T Bank operates at over 650 branches throughout New York, Maryland, Pennsylvania, Washington, D.C., Virginia, West Virginia and Delaware. Responsible for the development of Data Warehouse and supported Data mart for reporting services in large financial organizations credit card division supported high availability ad-hoc reporting.

Responsibilities:

• Analyzed business process and gathered core business requirements. Interacted with business analysts and end users.

• Prepared a handbook of standards for Informatica code development.

• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all application and systems.

• Developed Custom metadata repository.

• Used Informatica designer for designing mappings and mapplets to extract data from SQL Server, Sybase and Oracle sources.

• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.

• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.

• Used Debugger to test the data flow and fix the mappings.

• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.

• Partitioned Sessions for concurrent loading of data into the target tables.

• Tuned the workflows and mappings.

• Involved in identifying the bottle necks and tuning to improve the Performance.

• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.

• Executed Workflows and Sessions using Workflow Monitor.

• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.

• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.

• Executed the workflow using pmcmd command in UNIX.

Environment: Informatica PowerCenter 8.1.1/7.1.3, Oracle 10g/9i/8i, SQL Server 2000, PL/SQL, Erwin, TOAD, SQL*Plus, SQL*Loader, UDB, Sybase, XML, Windows, Linux and HP-UNIX.

Intermedia Communications, Huntsville, AL Jan 2005–Feb 2006

Designation: Informatica Developer

Description: Intermedia serves the voice, data and high-speed Internet communication needs of organizations such as telecommunications providers, Internet service providers, retailers, financial service institutions, multi-tenant office buildings, business services, and government entities. This project involved development of a data warehouse in order to deliver timely, accurate and integrated information that can be used by internal and external customers. The single information source provided with a data warehouse will employ easy-to-use reporting tools that allow business analysts to report and analyze success metrics and trends.

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.

• Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.

• Extensively worked on Informatica to extract data from Flat files, Excel files, and MS Access database to load the data into the target database.

• Implemented the Incremental loading of Dimension and Fact tables.

• Created Stored Procedures for data transformation purpose.

• Created Tasks, Workflows, and Sessions to move the data at specific intervals on demand using Workflow Manager.

• Developed the control files to load various sales data into the system via SQL*Loader.

• Developed Unix Shell scripts for maintaining Files.

• Designed and created an Autosys job plan to schedule our processes.

• Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation.

• Develop, test and implement break/fix change tickets for maintenance.

• Involved in writing test cases, assisting Testing team in testing.

• Developed the document of the complete ETL process.

Environment: Informatica 7.1.1, UNIX, TOAD, IBM DB2 8.1, Oracle 8i (SQL/PLSQL), MS Access 2006, Win 2000, Autosys, MS Excel 2006, UNIX, UNIX Shell Script.

OSI Technologies, India Oct 2003 – Dec 2004

Designation: Informatica Developer

Description: OSI implemented a warehouse for claims management and reconciliation (CMR). Involved in extracting data from various sources like flat files and Oracle, transform and load in to CMR data warehouse.

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.

• Extensively involved in migration of ETL environment, Database objects and EDW.

• Tested data integrity among various sources, targets and various performance related issues.

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

Contact this candidate