Career Summary

Over **+ years of IT experience. During this period primarily worked in the area of Data Warehousing and Business Intelligence with notable success as ETL Designer/Lead, Data Analyst, Data Modeler and DevOps Engineer.

Involved in all phases of data warehouse projects including Requirement Gathering, Design, Development, Implementation, Acceptance Testing and Production support for end-to-end IT solution offerings.

Expertise in DW & BI area with special focus to ETL (Informatica, SSIS), Oracle, Teradata and DB2.

Experience in strong DW & BI fundamentals and has expertise on ETL tools, Databases and Unix.

Worked in diverse domains like Retail, Banking, Travel & Hospitality, Health Care, and Pharmaceuticals S&M space.

Experience in Dimensional Data Modeling using Star and Snow Flake Schema and FACT Tables, Dimension Tables, OLTP and OLAP.

Excellent knowledge in identifying performance bottlenecks and also in tuning the ETL jobs by implementing various techniques like partitioning, push-down optimization.

Excellent analytical, problem solving and troubleshooting skills.

Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De Normalization Concepts.

Excellent working knowledge in UNIX shell scripting and Job Scheduling on multiple platforms like Windows NT/2000, Unix/Linux.

Experience in leading and managing teams. Handled multiple roles – ETL Team Lead, Senior Application Developer, and Onsite Coordinator. Have also worked as Business Analyst.

Good communication skill, interpersonal skill, self-motivated and quick learner.

Excellent team player with good inter-personal and Client Interfacing skills and also has the ability to quickly understand technical scenarios and formulate efficient solution to meet complex technology needs.

Skill Set

Informatica Power Center 9.1, Informatica Data Quality (IDQ 9X)

SSIS, SSRS

Database like Oracle, Teradata, DB2, MS SQL Server 2008, Sybase

Teradata, BTEQ Scripts, Mload, Fast load, TPump

Erwin r7.1/7.2, ER Studio V8.0.1

Unix Scripting

Strong SQL writing skill, TSQL, PL SQL (Stored Procedure, Functions, Triggers, cursor)

DAC, Siebel Analytics (OBIEE)

Scheduling tool Tivoli, ESP Scheduler, Autosys

R Programming

Business Objects

Hadoop Concepts, Map Reduce, Hive, Pig

Education

Degree: Master of Science – Data Analytics

Institution: Western Governors University

Location: North Carolina, United Sates

Date: 2017-2019

Degree: Bachelor in technology - Electronics and Communication

Institution: West Bengal University of Technology

Location: Kolkata, India.

Date: 2001-2005

Professional Experience

CVS Pharmacy Inc

Position – Software Developer

Sep 2018 till date

Project

Accordant Health Care, Greensboro, NC

Design and Develop applications in support of the EPIC and Accordant application including Construction, Code Review and Unit Testing

Analysis of existing application to identify problems, develop ideas and propose solutions

Create SSIS Packages to export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2008 and scheduled the job as SQL Server Agent

Create databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures

Work on T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Maintain code in TFS and VSS for version control

Create Audit log framework for each job and task

Used recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.

Create technical documentation of design logic and ETL processes based on technology best practices, guidelines and repeatable processes

Support during QA and UAT testing

Create ticket for Production code migration and participate in release management call

Prepare production turnover kits for support team before deployment

Involve in migration of SSIS objects into Informatica

Bank of America

Position – Application Architect / DevOps Engineer

June 2017 till Sep 2018

Projects

One Team Connection, Charlotte, NC

Responsible for developing banking software solutions for projects and developing Agile User Stories software to support business priorities

Develop SSIS Package for uploads and schedule them as SQL Server Agent. Use SSIS to create ETL packages to validate, extract, transform and load data to SQL Server database.

Responsible for creating database objects (table, views, store procedure, triggers etc) to provide structure to store data and to maintain database efficiently.

Involved in performance tuning of TSQL queries and Stored Procedures.

Involved in development, enhancement and improvement of existing processes and methods to meet both internal and external analysis requirements.

Maintained SVN repositories for DevOps environment: automation code and configuration

Troubleshoot and diagnose customer issues, document recreation steps.

Troubleshoot issues related to SQL, SSIS and SSRS.

Raise Change Request using remedy and handled overall deployment.

Provide technical direction and system architecture for individual initiatives

Monitor production jobs and take necessary action during failure.

Managed production tickets through Jira and set up weekly meeting with business to provide update. Prepare weekly status report for stakeholders

Manage and supervise offshore team

Create validation rules/scripts to check data quality

Johnson Controls Inc

Position – Business Intelligence ETL Analyst/Developer

June 2015 till May,2017

Projects

NxGen Analytics. Milwaukee, WI (June 2015 till May 2017)

Analyze, design, develop and maintain Informatica ETL and Oracle DAC scripts in support of an implementation of Oracle Business Intelligence Enterprise Edition (OBIEE, formerly Siebel Analytics) for a large Siebel 8.0 CRM Field Service application environment

Build ETL Design including data extraction from heterogeneous sources, Auditing, Error and rejection handling and re-start ability design

Extensive Experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations and Mapplets.

Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.

Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.

Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.

Worked on the Snow-flaking the Dimensions to remove redundancy.

Analyze, debug and tune queries; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, troubleshoot and recommend improvements and alternate methodologies

Monitor nightly ETL processes to ensure timely completion and availability of data in data warehouse for reporting use;

Utilize experience with Informatica ETL (Extract, Transform, Load) from multiple data sources; Oracle Data Warehouse Administration Console (DAC); SQL; Oracle Database Environment; Data Warehouse Design, including Slowly Changing Dimensions; Oracle Business Intelligence Enterprise Edition (OBIEE) including Oracle Answers, Reports & Dashboard, and Repository, and Siebel CRM for Service

Analyze and resolve problems and provide technical assistance as necessary and implement corrective actions

Cognizant Technology Solutions

Position – Senior Associate - Projects

March 2006 till June 2015

Projects

Kohl’s Corporation. Menomonee Falls, WI (April 2011 till June 2015)

As ETL Team Lead and Onsite Coordinator responsible for analysis, design, development and testing all develop components in support of implementation of Oracle Business Intelligence Enterprise Edition (OBIEE, formerly Siebel Analytics)

Responsible for Shouldering overall responsibilities to understand Client Processes and to work efficiently to meet targets and deliver solutions in accordance with Cognizant quality control standards and business practices and procedures

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Loaded and Tuned Teradata loads using TPump and Multiload external loaders.

Working on data profiling and defining the data quality rules

Imparting domain and technical knowledge to the new entrants and also fellow team members

As part of deployment activities, the responsibilities include gathering the requirements from the business, performing analysis on the business requirements and development of high level and detailed system/functional design, unit testing and implementation of the approaches.

Dealing with various teams from the Customer end to drive the objective of the approaches followed to have effective deliverables.

Further responsibilities also comprise of ensuring top quality deliverables from Cognizant to client and collection of project metrics.

Managing offshore resources and involved in technical coordination.

Direct less experienced team members in investigation, data gathering and analysis. Make work assignments, check output, and provide instruction and end-user training. Review results and prepare recommendations

Perform tradeoff between implementation, schedule and cost and resource constraints, and recommend alternatives. Provide technical feedback, inputs and consultation to other organizations involved in system design or implementation activities

Setup guidelines and prioritized work requests to handle contingencies and meet set goals.

Ace Hardware Oak Brook, IL (September 2009 to March 2011)

Played the role of senior developer and Onsite Co-ordinate for all developments with offshore team for ACE Business Transformation Project

Responsible for communicating extensively and effectively with client, to design and build a Complex design for BT program. Through Workshops and meetings gathered client requirements and proposed the design to be built in Informatica to fulfill the requirement and developed High Level Design Document.

Data integrated different source and target databases like Oracle, MS SQL Server, Teradata, DB2 using the ETL tool.

Created complex mappings using Unconnected Lookup, Sorter, Aggregator, and dynamic Lookup and Router transformations for populating target table in efficient manner.

Performed Unit Testing and worked with the end user at various stages of the test cycles.

Managed Cut-over during BT Phase 1, Phase 2 and Phase 3 Go-Live.

Prepared the High Level Design with the technical inputs to meet the desired functionality.

Took part in quality reviews of code bundles and TS before delivery to the client.

Developed complex mappings

Co-ordinate with offshore team and ensure on-time and defect free delivery

Setup guidelines and prioritize work requests to handle contingencies and meet set goals

Health Net Inc. - ClaimSphere HealthCare Solution, Kolkata, India (Jan 2009 to Aug 2009)

Installation and Configuration of different software’s like Informatica, Business Object etc.

Analyzing and Gathering Requirements

Preparing the Business System Design document.

Design Aggregate Table based on Reporting requirements.

Designing data-mapping and ETL Strategy documents.

Developing ETL routines in Informatica

Creating Perl Script used for System Integration.

Involved in creating unit test cases.

Monitor nightly ETL processes to ensure timely completion and availability of data in data warehouse for reporting use;

Realogy Corporation, Kolkata, India (June 2007 to Dec 2008)

Shouldering overall responsibilities to understand Client Processes and to work efficiently to meet targets and deliver solutions in accordance with Cognizant quality control standards and business practices and procedures.

Have developed a level of competency, which helps to anticipate issues and solve them in advance.

Maintained/Monitored end to end data transformation and delivery workflows.

Performed Coding, Testing and deployment activities.

Perform Unit, Functional, Integration and Performance testing there by ensuring data quality

Acquired Email and Telephonic etiquettes, analytical skills, problem solving and trouble shooting skills by identifying the elements and relationships of a problem in a systematic way.

Performed various root cause analysis and elimination to improve system stability. Followed corrective /preventive maintenance methods and transition processes to ensure adherence to SLA.

Performed peer review of the code written by team member.

Novo Nordisk Corporation, Kolkata, India (Jan 2007 to May 2007)

Involved in designing and developing complex mappings in Informatica to extract, transform, cleanse and load data.

Prepared design documents.

Responsible for development, Unit and integration testing of the application.

Excellent experience of Trouble shooting problems during the course of work.

Updating the Process and Functional Specification in accordance with the changes made

Interaction with customer/onsite coordinator on daily basis in resolving queries and ensure delivery on-time.

Analyze, design, develop and maintain Informatica ETL and Oracle DAC scripts in support of an implementation of Oracle Business Intelligence Enterprise Edition (OBIEE, formerly Siebel Analytics) for a large Siebel 8.0 CRM Field Service application environment

Affiliated Computer Services, Kolkata, India (June 2006 to Dec 2006)

Designing data-mapping documents during design phase.

Developing mappings in Informatica during development phase.

Involved in creating unit test cases, development and testing the routines developed.

Writing shell scripts.

Preparing mapping documents.

Achievements:

Received Above and Beyond award for consecutive two years at Cognizant.

For consecutive three years evaluated as one of the top contributors at Cognizant.

Training:

DW Basic Training at Cognizant

Advanced Informatica training at Cognizant

Communicating Effectively in Global Environment

Time Management

Communicating for Operational Excellence

Working with Cultural Diversity

Microsoft Azure Machine Learning

Certifications:

Completed Datastax Cassandra certification.

Hadoop Certification from Edureka

Oracle Database SQL Certified Associate

SAS Certified Base Programmer for SAS 9

SAS Certified Statistical Business Analyst Using SAS 9: Regression and Modelling

Contact this candidate