PROFESSIONAL SUMMARY:

• Highly skilled IT professional with around 10 years of experience in Architecting, Integration Reporting technologies. Currently working as Technical lead/Architect , Good experience in System Analysis, Design, Development, Testing, Implementation and Maintaining Data Warehouse/ Data marts, Database Client/ Server applications.
• Experience in Marketing Sales, Insurance, Banking and Retail domains.
• Good experience in Extraction, Transformation and Loading ETL processes using IBM Websphere DataStage/Qualitystage and Informatica Power Center/ Data Quality.
• Expertise in DataStage/Informatica Performance tuning sources, mappings/jobs or sequences, targets and sessions and Database Performance tuning. Well acquainted with Datastage/ Informatica Designer, Datastage Director/ Workflow Manager and Workflow Monitor Components.
• Good in Data Warehousing concepts like Data Cleansing, Slowly Changing Dimension phenomenon SCD , surrogate key assignment.
• Good Knowledge in Data Quality Solutions with IBM Websphere QualityStage and Informatica Data Quality IDQ , which includes Standardization and Matching of Source data.
• Experience in RDBMS with good programming knowledge in Oracle 10g, SQL Server 2008 R2/ 2005, DB2, Netezza, SQL, PL/SQL, DB Triggers, Views, Stored Procedures, Functions and Packages.
• Experience in Dimensional Data Modeling like Star Schema and Snowflake Schema, Logical and Physical Design.
• Extensively Implemented Error Handling Concepts, Testing, Debugging skills and Performance tuning of targets, sources, transformation logics
• Experienced in UNIX Shell scripting BASH as part of file manipulation, Scheduling and text processing.
• Excellent experience in scheduling monitoring the production jobs using CONTROL-M
• Having working knowledge in BO XI.
• Strong experience in client interaction and understanding business application, business data flow and data relations
• Coordination skills related to management of the offshore resources.
• Team player with good communication skills, written skills, technical documentation skills and also a self-motivated individual with exemplary analytical and problem solving skills.

TECHNICAL SKILLS:

• Databases : Oracle 10g, SQL Server 2005, DB2, MS Access, Netezza
• Big Data Tools : HDFS, Hive
• Informatica 9.0.1 HotFix 2/ 8.6 Power Center
• ETL Tools : IBM InfoSphere DataStage 9.1/8.1/8.0/7.5
• Operating Systems : UNIX Linux, AIX, HP-UX, Solaris , MS DOS and Windows NT/XP
• Scheduling tool : Control-M
• Languages : PL/SQL, T-SQL DDL, DML , JAVA, Excel VBA, XML.
• Database Tools : Oracle SQL Developer, Squirrel, Toad, MS SQL Server Management Studio.
• BI Tools : BO XI
• Modeling Tool : MS Visio, ERwin
• Version Source Control : Borland StarTeam
• Defect/ Task Tracker : Rational Team Connect
• Languages : Java, JSP, JavaScript

Tools Framework:

• Data Stage Error Handling Process - Error handling process built using a pluggable infrastructure model leveraging SOA.
• ETL Framework In house Framework designed for ETL jobs to handle the processing tasks Data Quality, Job maintenance server maintenance tasks

CAREER PROFILE

Confidential

Technical lead/Architect

Confidential , which is ranked 1 in Best places to work in companies, with total assets of 22 billion and employing 23,400 employees it is one of the nation's top Banking, Insurance, Investment Advice organizations. As a lead I was responsible for projects ranging in different domains such as Auto, P C, Banking Investments and Life insurance. My role started from gathering requirements, preparing design docs, data modeling, assigning development tasks to offshore resources, reviewing code, deploying the code to Test Prod through release process.

Responsibilities

• Involved in all phases of building operational systems like analyzing the business requirements, ETL process design , data modeling and code development testing
• Led the team in architecting, developing and implementing frameworks for Integration reporting process across the enterprise.
• Guide the team in designing and implementing the End to-End process for IMSM Data Refreshment, E3 framework Upgrade, EIA retirement ADR predictive analytics.
• Developing DataStage Sequences/Jobs, reusable Sequences/jobs, Activities for Daily process to loading heterogeneous data into the data warehouse. Source files include tables, delimited flat files, XML files and Sales force data.
• Extensively used stages like Aggregator, Joiner, Transformation, Lookup, SK generator, Merge, Change Capture, Column Export/Import, Sequential files, File sets, lookup sets, Datasets, DB Connectors, XML Pivot.
• Executed sequences, both sequential and concurrent for efficient execution of jobs and used other activities like Job Activity, Set Variables, Exec Command, Email Notification, Sequencer, Nested Conditions, Start Loop End Loop.
• Developing Informatica Mappings, Mapplets, reusable Transformations, tasks, sessions and Workflows for Daily process to loading heterogeneous data into the data warehouse. Source files include delimited flat files, and DB2 tables.
• Extensively used stages like Aggregator, Joiner, Transformation, Lookup, SK generator, Merge, Change Capture, Column Export/Import, Sequential files, File sets, lookup sets, Datasets, DB Connectors, XML Pivot.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Union, SQL and Sequence generator.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email and command.
• Improved and enhanced various jobs inside different cycles by creating Reusable Common jobs technique. Extensively used parameters at run time to push in job related parameters.
• Integrating with the data sources like Member data and products from various systems . Comprehensively used DataStage for loading the historical data from various tables for different Line of Business
• Managed the authenticity of UNIX components by Checking-in Checking-out code from StarTeam/RTC, a code versioning tool.
• Prepared Unix Shell Scripts for scheduling the jobs using Control-M.
• Created UTP, Wisdom solution, ETL overview Code walk through documents.
• Code migration of DataStage/Informatica jobs from Dev, Test Prod through release process. Ensuring the Unit testing, Integration Testing, Job Environment parameters testing along the way.
• Actively participated in discussions and implementation Error Handling process
• Coordinating with the Offshore team

Confidential

• Marketing the right offers to the right member at right time is the major task for the marketing business. This project provides the predictive analytics capability for the marketing business to identify the eligible members at right time for a specific offer. Separate models are designed for identifying the eligible members for each offer. Models are designed and members are scored for each major offer through analytical modeling tools and store the model scores data on the Hadoop servers. Model Score Data will be extracted through Hive, processed and loads through ETL batch process into marketing Sales environment for campaign executions.

Confidential

• Informatica to Data stage Migration project. Enterprise Integration Area Application is getting retired as part of modernization and to improve the Member experience. Enterprise Integration Area is the main data source for the major applications like marketing, Bank pre approvals, Mortgage and P C member data. Marketing applications moved off from EIA as part of modernization of marketing sales process and influenced other applications to move out of EIA to cut down the huge infrastructure costs. This phase of the project is to redesigne and to redevelop the Bank pre approval Process Mortgage process using data stage.

Confidential

• Marketing/ Sales batch jobs are running on DataStage 8.1. Current env became unstable as there was an increase in the applications developed deployed. To resolve the env issues Infrastructure team proposed to upgrade the Datastage version from 8.1 to 9.1 and the infrastructure to grid. Marketing/Sales batch process is one of the major and critical batch process in the enterprise with around 2500 ETL jobs. These jobs need to migrate to 9.1 with through testing to minimize the business impact. Infrastructure components need to be upgraded to E3 framework, which has key enhancements in the data quality space. This project is executed in phases covering daily jobs, weekly jobs, monthly jobs, semi annual jobs and adhoc jobs. The major challenge in this project is the coordination with other modules which are depending on Marketing cycles and vice-versa.

Confidential

• Currently campaigns are executing only during the CST business hours, customer is planning to execute the campaigns 24X5. Current infrastructure didn't have the capability of executing the campaigns 24X5 because the feeds from various source systems loads at various intervals. To resolve this issues, ne process was designed and developed to load the data into marketing marts without disturbing the campaign execution

Confidential

• IMSM system started receiving large volume of data after the changes in member Eligibility criteria. Due to high volume of data infrastructure issues, the IMSM systems start experiencing data latency issues. To overcome the data latency issue we redesign the long running jobs in the product batch process and reduced the total execution time by 25 .

Confidential

• Bank business teams are unable to measure the product effectiveness of the bank offers like credit cards deposits. This project was executed to support the business teams to measure the campaign effectiveness and the ROI. OMS operational Data was loaded into Enterprise Data Warehouse EDW to provide as trusted source for other systems. Once the data was loaded into EDW, the data related to bank offers are processed base on the reporting needs and loaded into Bank Reporting Data mart for Reporting purposes. As part of this project, we implemented the Purge process for Credit Cards Deposits.

Confidential

• The project objective is to improve Marketing's ability to respond to member activities by acquiring and storing detail transaction level data and automating the execution of campaigns and tracking the product transactions research across the enterprise.
• Confidential
• o Extend Vehicle Protection EVP .
• o Credit Cards
• o Life Offers
• o Deposits
• Objective of this project is to load the offer details and related member details into the OMS operational data using batch cycles. Business will define the offers and related business rules to select the people for a particular offer. The Offer details will be loaded into Marketing tool Epiphany/ UNICA and the audience file will be created by the tool. The created audience files will be loaded into OMS system, which will be displayed on the .com based on the member profile. The following offers are loaded into OMS operational DB.
• Provide high level reconciliation process to confirm accuracy of the data Common Validations / Error Handling .

Transactional Data into Epiphany Mart Phase 2 From Jun' 10 to Oct' 10

• Member Contact data Workforce, MAAC Contact, MAAC BPH
• Bank data CFS, Demand Deposits, Debit Card Authorization, Credit Assessment
• Web activity
• Enhance the Epiphany Data Mart to include transaction data for use in campaign execution:
• Transactional Data into Epiphany Mart Phase 1 From Nov' 09 to May' 10
• P C data PML Indicators
• Offer Management System Offer Promotion, Offer Tracking
• Bank data Credit Card - Regz
• Email Campaigns Invalid, Bounce, Response
• Model Scores
• Enhance the Epiphany Data Mart to include transaction data for use in campaign execution:
• P C data Claims, Auto Flow Thru, Liability Limits, GA Boat

Confidential

• This objective of this project is to automate the Marketing campaign Channel Analysis, which reduces the manual intervention and using of multiple data stores. Marketing Campaign Chanel analysis application helps the business users to understand the differences between the Projections and the actual of the campaigns. Ex: Expected customers to be reach through email channel is 100,000. But the actual is 75,000. Then Business will analysis the reasons behind the difference between projections and actual .
• Confidential
• Bank data Credit Card Account, Demand Deposits, Web Bill Pay, Debit Card - Account
• This project loads the product data for the following products:
• The project objective is to enhance the Epiphany Data Mart by acquiring additional Credit card Deposit and mortgage data to improve product acquisition and retention, and member acquisition and retention across all channels. Eliminate manual processing outside Epiphany to support the execution and analysis of campaigns by acquiring and loading data from additional sources.

Confidential

• Enterprise Employee Performance Measurement is to remodel the existing legacy system and to build a data infrastructure solution. The data infrastructure will support dashboards for performance measures, performance scoring calculators and ad-hoc reporting to effectively drive desired MSR Member Service Representative behaviors, with accountability aligned across all levels of the organization

Confidential

It is the second-largest discount retailer in the United States, The company is ranked 36th on the Fortune 500 as of 2013 and is a component of the Standard Poor's 500 index. Target grew and eventually became the largest division of Dayton Hudson Corporation, culminating in the company being renamed as Target Corporation in August 2000. In 2013, Target expanded into Canada and ConfidentialObjective of the Confidential is a web intelligence application, which allows business groups to leverage historical lead time information in order to improve replenishment accuracy and responsiveness to changes that occur within the supply chain. The data from dispatch of goods International/Domestic Vendor to receiving the goods at stores are stored in 9 source systems each segment data is stored in separate source system . Data from these source systems has to be extracted, transformed according to the requirements and loaded to the replenishment mart. ATG front end application will extract the data from the mart and generates reports.

Confidential

• The Issue tracker provides Bug Tracking, Help Desk Ticketing, Issue Rising Issue Resolution, Search Facility Help info. Issues related to software projects can be raised, tracked and resolved by Employees of different departments. Resolved issues can be allowed to access from Knowledge Base as Knowledge elements as help desk. The issue tracking system does all the jobs that are done in conventional system but, here, everything is done in more formal and efficient manner. All the users of organization can interact with each other through the Issue Tracking System. This system acts as an interface between the employees thereby enabling them to forward their issues to the centralized Issue tracking system. Worked as an UI developer.