SUMMARY:

• Around 14 years of diverse and extensive experience in IT Industry
• Technical Architect with demonstrated success in the design and implementation of end - to-end DW/BI Projects, ETL data processing, master data management, data migration projects
• Delivery Manager - Adept at leading/managing cross-functional programs and team of 40+ resources
• Capable of leading high performing teams under tough deadlines, to meet expectations of multiple customers
• Successfully delivered multiple projects and worked in various roles like Solution Architect, Technical Project Manager, Data Architect, Delivery Manager, Agile Scrum Master, ETL designer/developer
• Experienced with data analysis, data modeling, application architecture, component design (ETL, BI & Operational Reporting, Master Data Management), Project management
• Supported various types of sources including relational databases, Flat files, WSDL/SOAP based web-service calls, Salesforce and XML.
• Actively involved in multiple small and large RFI/RFP responses
• Experience in articulating the functional and technical requirements to the team members
• Experience in coordinating with cross functional team to follow up on project delivery, process oriented, audits, training, deployments, administrators and etc.
• Effective in tracking & reviewing project execution across multiple geographical locations.
• Good analytical, problem solving, communication and interpersonal skills ability to interact with individuals at all levels.
• Experience in Telecom, Information and Insurance industries.
• Expert in Data Architecture and ETL design and development
• Instrumental in setting up Pentaho COE within the organization and trained various teams in Pentaho PDI
• Exposure to Hadoop Ecosystems - Hadoop, HDFS, Hive, Sqoop, Flume, Spark and Kafka

TECHNICAL SKILLS:

Technology: Data Warehousing Architecture, Data Modeling, Data Analysis

ETL & BI Tools: Informatica Power center 7.x and 8.x, Pentaho PDI, Tableau 9.x

Databases: Oracle, Teradata, SQL Server

Scripting: Unix Scripting

Version Control: Tortoise SVN, GitHub

Tools & Utilities: SFDC, Commercial Work Bench, Graphtalk, Visio, SOAP UI 5.0, SQL Developer, Control M, UC4, TD SQL Assistant

PROFESSIONAL EXPERIENCE:

Technical Delivery Manager/ Solution Architect / Data Architect

Confidential, Mt. Laurel, NJ

• Participated in discovery sessions to understand the client’s business, objectives and their needs
• Responsible for designing the end to end architecture solution to integrate data from different systems within Comcast into the specified relational model
• Responsible for the designing of the Logical data model for the BI platform which will then be converted to Physical data model as per the implementation needs.
• Analyze the data source systems in conjunction with the Epics / Business User Stories, and prepare high level solution design to be able to be played back to the business owners
• Interact with client SMEs periodically and breakdown the business requirement in details in order to furnish more details to development and integration team in the form of detailed design documents
• Provide suitable data warehouse and ETL Architectural solutions for the system to project development and implementation team. Participate in system architecture and design related discussions with client, SME, and the development team.
• As a Scrum Master, responsible for management of the Agile methodology within the projects and make sure to have any impediments to the progress of the Sprints to be handled with appropriate attention and priority
• Ensure project team is following Agile ceremonies like Daily stand ups, Story grooming, Sprint planning, Release planning, Capacity planning, estimating the velocity with story points, Sprint review and retrospection
• Responsible for Business Requirements Gathering, High Level Design Approach/Solution and documentation.
• Owner of the HLD, Reviewer and approver of detailed design.
• Onshore-Offshore co-ordination of activities and review of both Onshore and offshore deliverables.
• Liaise with client management team for resource ramp up/down planning to meet the project requirements.

Technical Lead/ ETL Designer/ Sr. Developer

Confidential

• Accountable for the execution of the individual tracks and assigning and tracking tasks in each track, reviewing deliverables and technical leadership.
• Design ETL mapping sheet, develop necessary mappings, Unix Scripts, Database tables wherever required following the Client Coding standards based on the requirements.
• Handling change requests, fixing defects and work on the enhancements of the existing ETL code.
• Updates the Quality Documents and make sure that assignments are delivered on time with high quality. Analyze the Requirement Specifications for all the applications and preparation of the Functional Specification Document and Design Document
• Document the changes / technical modifications that need to be done as per the Change Requests.
• Provide the metrics and monthly status reports to the client manager.
• Involved in Performance Tuning of ETL mappings which were taking longer time
• Co-ordinate with Offshore team and get the work done from them.
• Involved in Performance Tuning of ETL mappings which were taking longer time

Team Lead/ Sr. Developer

Confidential

• Design and development of mappings based on the Business requirements and following the Coding standards.
• Prepare Data flow diagrams and presentations during Knowledge transition phase.
• Provide effective Support of the GHM application and analyze and work on the Business or customer queries.
• Monitoring jobs and timely support activities.
• Analysis Business needs by gathering information, documented and also responsible for creating the mappings, reusable transformation and the corresponding workflows.
• Handling change requests. Involved in data analysis and handling bug fixes.
• Analyze the existing ETL code for the Change Requests coming in and make necessary changes and enhancements.
• Provide suggestions and tuning tips to improve the performance of the existing jobs wherever required in Production

ETL Developer

Confidential

• Preparation of Flow plan and flow procedure.
• Design and development of mappings based on the Business requirements.
• Building Applications from the design options to meet the requirements.
• Involved in preparing Impact Analysis document.
• Program analysis, Functional Specification and design document preparation, Unit Test plan preparation, Review and Testing.
• Produce deliverables according to Client requirements.
• Update Quality documents and make sure that assignments are delivered on time with high quality
• Participate in Team meetings and discussions of detailed assignments to achieve end results.