OBJECTIVE:

Endeavor to provide timely, workable and effective services at my workplace to enhance the process value and exceed expectations

SUMMARY:

• Extensive experience of 13 years in IT with Projects involving Technical Expertise, Project Management & Delivery, Business Analysis, Application Development, Building Data Warehouse, Data Marts, Data Analytics and Mining, Application Migration Projects, Disaster Recovery, Improving user experience on E - commerce and Mobile applications & Legacy/Database system migration projects.
• More than 15 end to end successful Project Lifecycle Implementation.
• Experience as a Lead with expertise in streamlining project operations, delivering business user requirements, collaborating with teams across departments to ensure to ensure project is delivered timely and of great quality meeting the planned budget and forecasts.
• Hands on experience with Application development, leading and managing team of various sizes, managing project schedules, create status reports and resource forecasting.
• As a Delivery lead, responsible to deliver multiple projects across all phases - Development, QA, Performance, Deployment and Post Go Live. It also involved developing, implementation and maintenance of the best practices of the organization.
• Worked as a Functional Lead gathering requirements by provide effective business & IT solutions, creating technical and functional specifications, oversee the project delivery and perform code reviews
• Informatica Certified Designer with vast knowledge and experience in Data Integration and ETL developments.
• Extracted and analyzed data from Heterogeneous sources including Teradata, DB2, Mainframe, Oracle, Sql server, Netezza, Hadoop, Redshift, Flat files, XML

SKILLS INVENTORY:

• Application Development
• Collaborative Leader
• Agile & Scrum
• Requirement Gathering
• Process Improvements
• Resource Planning & Scheduling
• Project Budgeting & Forecasting
• Documentation and Creating Process Flow Schematics

APPLICATION/DATABASES/METHODS:

• Teradata
• Teradata Viewpoint
• Oracle
• Hadoop
• SAP
• ARIBA Cloud
• Aster Data Systems
• Tableau
• Micro Strategy
• Informatica
• SQL Server
• DB2 UDB
• ERWIN
• Toad
• Mainframe
• Cognos
• MS Project
• MS - Access
• MS Visio
• Retail
• Insurance
• Financial Services
• Health Care
• Telecommunications
• Manufacturing
• Engineering

WORK EXPERIENCE:

Confidential, Woonsocket, RI

Responsibilities:

• Responsible to lead the team and delivery of all phases of SDLC.
• Experience managing multiple projects across all phases of the project.
• Collaborate with project team members to develop and plan project sprints.
• Responsible to execute project in Agile methodology and conduct scrum meetings as needed.
• Hands on experience with Designing & Developing Applications, Perform Data Analytics, Data mining to ensure the data meets the objectives of business requirements and further adds value to the business.
• Develop status reports, cost estimates and part of forecasting resource plans.
• Responsible for delivery of System and Application Architecture documents, Test Plans, Test execution reports and Deployment documents
• Analyze and provide design approaches to integrate various applications to Oracle and Teradata Systems.
• Create Functional specification document which involved capturing the end to end process flow with detailed design plan, design requirements, detailed process steps and mapping documents for data loading
• Create deployment checklist and provide guidance to the operations support team to ensure there is a smooth handshake between teams for application support post go live.
• Make vital decisions and drive decision making across projects.
• Develop, Implement and Maintain best practices as per PMO guidelines.
• Managed resource and capacity planning for projects.
• Supported development and software quality assurance to ensure optimal progress and product stability for end users.
• Coordinate with business users to gather requirements and manage expectations.
• Effectively and efficiently managed project needs, challenges and executed to meet the project milestones.
• Responsible to lead and model a design that meets the standards of the existing expected infrastructure and migrating data from legacy systems.
• Managed teams of various sizes to analyze data, design, build, test and deploy the data networking infrastructure, improve system performance and measure the quality of data.
• Responsible to understand the overall network layout and determine the present and future business user needs in terms of performance and scalability.

Tools: Teradata, Oracle, Hadoop, Informatica, MS Project, MS Visio, Control M Scheduling tool, Putty, Tableau, Micro strategy, MS Access, Windows SFTP server

Confidential, Framingham, MA

Technical Lead

Responsibilities:

• Experience in creating project plan, responsible for leading and managing project activities, scheduled daily stand up meetings and responsible for delivering various phases of the project lifecycle.
• Defined process, standards and implemented application for attributing sales to customers.
• Gathered requirements from Business users to design, build and populate Enterprise Data Warehouse and subsequently staged data to populate data into Marketing Data Mart
• Experience in Agile and Waterfall Project Implementation methodology involving Design, Develop, Build, Test and Deploy processes are planned and implemented concurrently.
• Analyzed Confidential Ecommerce Platform systems to enhance Confidential Infrastructure, Documented Business and IT requirements in preparation for a disaster recovery and published disaster recovery plan.
• Created Functional & Technical specification document which involved capturing the end to end process flow with detailed design plan, design requirements, detailed process steps and mapping documents to load data into EDW, Fact& Dimensional tables in the data mart for the following subject areas - Confidential business delivery(Orders & Shipments), Retail Sales, Promotions, Vendor funded coupons, Sales attribution and the audience of the functional specification document being Business users and Technical team.
• Gathered requirements from Business users to design, build and populate Enterprise Data Warehouse and subsequently staged data to populate data into Marketing Data Mart
• Performed Gap analysis across various systems (AS400, Marketing Systems, Campaign Management systems) to identify the sources to EDW and MDM
• Created Technical design document, Development plan using MS project with end to end tasks defined at the granular level for the planned timeline.
• Expertise in coordination of various tasks and handling them with the following documents - Clarification tracking document, Task List, Development Tracking sheet, Job schedule List, Detailed Implementation plan.
• Proposed & Implemented process and severity level for Error & Reject Handling & Recovery.
• Experience working with Informatica Application, Job scheduler, Code build and deploy, DDL scripts
• Involved in Multiple ETL projects requiring ETL design and development for Application development & migration

Tools: MS Project, Microsoft Visio, Informatica Power Center 8.x, Oracle 9I, DB2 UDB, DB2 Workbench, Tidal, UNIX, AIX, Sql, PL/Sql, Shell Scripting, CRT 4.1

Confidential, Worcester, MA

Senior ETL Lead

Responsibilities:

• Requirements gathering from business users for building and enhancing the Enterprise Data Warehouse, Data Marts, Application and Database migration Projects involving various Insurance Business Sectors like Credit Scores, Claims, Auto, Personal Lines, Commercial Lines
• Performed Customer demo as check point, Acceptance tests and conducted daily stand up meetings
• Created Production Implementation plan, Maestro Job Schedule list, Production Move memo an approach taken prior to moving codes to the Production Box
• Involved in Planning, Designing and development for back end data movement during Application Migration from NIKU(In House developed Application) to PRM( New Vendor Application)
• Planned and assigned assignments for the team on a scheduled basis by dividing the work load to optimize code delivery effort
• Developed the ETL end to end lifecycle Design specs Involving Code development, Testing Guidelines and Implementation
• Created an effective ETL design for building the Proprietary In House consumer report score model
• Involved in Multiple ETL projects requiring ETL design and development for Application migration and extracting data from Financials and HR People soft Product at Confidential which ranges from General Ledger, Accounts Payables, Asset Management Purchase, Payroll, Time and Labor Management, Benefits Administration, HR Management Information system, Recruiting
• Experience in working and building a Proprietary Credit Score Model which involved creating of a Data Mart, a rule based model and executes based on the rules defined in the Java Engine.
• Extracted data from Heterogeneous sources including DB2 UDB 8.X,Mainframe,Oracle 10g,Sql server, Flat files, XML
• Created Functional specifications involving development process flow, Business rules, ETL layout and dependencies
• Developed Source Layout, Target layout, Mappings, Workflows, Sessions, Mapplet, Worklet, Email task, Unix FTP scripts, PL/SQL - Procedures, Functions, and Triggers.
• Coordinated an offshore team in code development and code delivery and provided training in understanding the Business requirement and performed code reviews
• Maintained an end to end co-ordination with the structure of the team involving regular meetings, status updates and discussions with the Business and data vendors, Performing User Acceptance tests
• Worked with Peregrine Application for issues related to the Production environment
• Supported the Application releases and Go-Live

Tools: MS Project, MS Visio, Informatica Power Center 7.x, Power Mart, Oracle 10g, Sql ServerDB2,UNIX, AIX, Sql, PL/Sql, Shell Scripting, SecureCRT 4.1, Sql Server Enterprise ManagerETL Architect, Progress Database, Toad, QMF Windows for DB2

Confidential, Denver, CO

ETL Application Architect

Responsibilities:

• Created Functional specifications involving development process flow, Business rules, ETL layout and technical dependencies
• Performed Analysis of Existing Source systems and Proposed an effective design for the Development of Data Mart
• Maintained coordination with the structure of the team by daily feedbacks, Status updates, Conversion clarification if any.
• Worked with Power center Designer- Source Analyzer, Warehouse Designer, Mapping, Workflow Manager - Session, Task Scheduling, Email, Decision, Command, Timer, Control
• Performed code reviews prior to sign off, Unit test case reviews, User demo for User acceptance testing and performance check.
• Proposed Development status sheet, Defect tracking sheet and Business Clarification sheet, had designed a template for all the above and had it circulated for an effective code life cycle process
• Extracted Data from Homogenous Sources, Heterogeneous Sources that Includes RDBMS, Fixed Width, De-Limited Files
• Performed Data Cleansing, Merging, Aggregation on the Source Data as per the specification and Loaded to the Target.
• Knowledge with Teradata utilities Fast Export, Tpump, Multi-Load, Fast Load
• Developed Pre-session and Post session SQL Stored procedures
• Created Mappings for Specifications to load data into complex dimension and fact tables using Transformations, Aggregator Functions, Stored Procedures and Lookup Tables
• Development and Performance Tuning of Complex Sql Queries to Extract data from source
• Worked with Mapplets, Worklets and Transformation Developer to make the Code being Developed reusable
• Created Stored Procedures to Perform Session Pre-load, Session Post-Load, Target-Preload, Target Post Load

Tools: Informatica Power Center 7.x, Oracle 9i, Unix, Sql, PL/Sql, SAP, Shell Scripting, Cognos 8.x

Confidential, Phoenix, AZ

Data Warehouse Consultant

Responsibilities:

• Prepared System Requirement Specification (SRS) Documents
• Analyzed the Different Source Systems and Involved in Optimizing the Star Schema Comprising the Facts and Dimensions for Better Quality Reports
• Involved in regular meeting sessions with Reporting team to satisfy their level of data for Data Drilling
• Involved in Data Modeling for Subject areas including Accounting, Billing, Sales, Geography
• Developed Shell Scripts for Cron Jobs for Scheduling Workflows Externally
• Involved in development of Star Schema data Cubes with Dimension Region, Currency, Customer, Order Type, Time and Product Categories
• Created Stored Procedures, Functions, Cursors, Triggers Including User defined Exception Handling
• Involved in working with Business Objects Universe, Classes, Objects
• Involved in Migration of Informatica from 7.1.1 to 7.1.2
• Experience working with Power Exchange to extract data from People soft environment
• Documented all the Mappings and Transformations Involved in the ETL Process
• Improved the Performance of Job Run by Re-assembling the Transformation Such as Filter, Aggregator, Sorter
• Involved in Integration Testing and Supported the Code in Production
• Created Parameter Files, Mapping Variables, Mapping Parameters for different Job Runs with Different Values
• Extracted Data from Oracle, DB2, Fixed Width Files, De-Limited Files
• Worked with Sync Sort to Perform Sorting on Tables with Millions of Records
• Proposed Partitioning of disk for Better Query Performance
• Created Shell Scripts for running Daily scheduled Task
• Involved in Identifying the Bottlenecks at the Target, Source, Mapping, Session by Doing Test run sessions
• Created Test plans and performed Test runs on the developed codes
• Involved in Transporting Data from the Legacy System to the SAP R/3 Server for SAP Team

Tools: Informatica Power Center 7.x, Oracle 8.x, SQL, PL/SQL, Business Objects SQR, Sync Sort