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