Around 7 years of extensive professional experience in Information Technology with strong background in the areas of ETL Design and Development in Data Warehousing using IBM Datastage Tool including administrator set-up activities. Experience in building operational data store (ODS) and Enterprise Data Warehouse with the knowledge of logical and physical Dimensional modeling concept Star/Snowflakes Schema, fact and dimension table and proficient in identification of Facts, measures and dimensions. Knowledge of managing full project life cycle, including planning development, requirement definition, application development, QA testing support and implementation. Expertise in handling errors and performance in Datastage Tool and Unix Shell Scripting for data manipulation and scheduling task along with third party scheduling tools like Zeke. Hands-on experience on all mostly used stages of Datastage with variety of source file formats including .csv, mainframe and xml files as well as diverse databases like DB2,Oracle and SQL Server. Proven ability to lead and motivate teams inorder to maximize productivity. Results-oriented, dedicated professional with record of accomplishment for consistently delivering effective solutions within critical time and budget constraints. Have excellent analytical abilities and ability to solve problems and technical flaws with excellent communication, interpersonal and presentation skills. Skilled in onsite co-ordination of traditional waterfall model and agile projects with exposure to Vendor Management related activities and RFP documentation. A broad understanding of Health Insurance domain with specific experience in Claims and Medicare Compliance within HIPAA regulation and requirement with code format including ICD 10 and ICD 9.
ETL Tool - IBM Datastage
*Database - IBM DB2, SQL Server
in the ICD-10 redemption project to develop the ability within the MARS System to receive, store, process, transit and report ICD-10 codes.
Accustomed with CMS Call Letter Changes from 2010 onwards to understand the impact of layout changes in monthly and daily files and how the record type changes can happen for Record Type 'A' and record Type 'B' and the impact on RAPS Submission Process and the MMR Restatement one including logic change based on Adjustment Reason Code (ARC) etc.
Responsibilities: Worked closely with large project team consisting Business analysts, Data Architects, data modelers, ETL developers, WEBI developers and Mainframe Developers and implemented successful projects.
Defined best strategy for ETL architecture and worked with ETL architect to design optimum and efficient data extraction, load processes.
Performed analytical business requirement analysis for strategic and tactical decision to support applications for enterprise business intelligence.
Active involvement in developing and maintaining Parallel, Server and Sequencer jobs including generic job concepts through RCP Techniques and multi-instance sequencer concepts.
Worked heavily on performance tuning activities using advanced concepts of Datastage Functionalities.
Worked as Offshore Developer lead from 2010 to 2015,April.
Currently playing the role of Application SME Lead Developer in Application Code Migration from v7.5 to v8.5.
July,2010-Till Data Application - EDW Claim System Adhoc Reporting Role: Developer in preparing adhoc DB2 queries to extract claim related information based on the business requirements by joining tables across Claims, Members and Providers related tables.
Limited exposure to the SAS environment for the generation of aggregated as well as formatted reports Analysis of claim related tables to gather PHI information.
Application- Enterprise Integrator Engine (EIE) Methodology- Agile Role: Involve in requirement analysis, design, coding, testing and production implementation.
Onsite Co-ordination activities like attending Sprint Planning and Stand-up calls Worked on .xsd preparation for xml file generation in IBM Datastage v11.3 environment Amex Project: Mystic Data-warehouse Project, AMEX Details: This project is a migration project of DB2 Databases to Netezza.
The project involves migrating 17Tb of data from DB2 to Netezza.
The entire application contains around 1000 Datastage jobs and around 500 Wrapper/Unix scripts.
Role: Primarily involved in Job redesign including inclusion of NZ connector stages and unit testing 2013 Infosys *Was Member of Infosys Thought Leadership Program, BBSR Worked on POC - Data Virtualization, Data Federation, In-Memory Database and Graph Database Prepared IBM Data Stage Code Review Tool against extensively used Datastage stages Worked on Contract Preparation for Data Science Domain, Aetna Conducted Interviews on Infosys IBM Data Stage Recruitment Datastage COE Member - Set-up Datastage v8.5 Server within domain 2010-Till Date.
Technology Analyst / Onsite CoordinatorAetna Health Insurance
Connecticut Application - Medicare Analysis and Reporting System (MARS) Currently engaged in application wide impact analysis for the replacement of SSN-based HICN from Medicare Cards with Medicare Beneficiary Identifier (MBI) because of The Medicare Access and CHIP Reauthorization Act (MACRA) of 2015.
Onsite coordinator of the team which rewrite the Medicare revenue risk assessment model for risk adjustment activities along with data integration of Coventry Data, to be housed in the Aetna Environment.
The improved system provides the end users with the benefits as: Allows for accurate forecasting of Medicare revenue and analysis of the data in support of business objectives of growing and enhancing this line of business.
CMS RAPS Process, MMR, MAO4, MPRW and Daily TRR Compliance and Analysis Financial Reporting and Performance Management Medical Management (Care Management & Disease Management) Reporting and Analysis.
Revenue and Revenue Yield Reconciliation.
Extensively worked on building the Cohort Module to provide up-to date Cohort Data which encompasses different sets of Aetna-defined criteria in which member data can be grouped and reported on.
Built the system to generated reports as an input to SAS Modules to support Medicare Risk Adjustment Activities and to provide functionality to join data extracted from vendor with internal data sources e.g.
B.Tech: Applied Electronics and Instrumentation KalyaniJIS College of Engineering-
Applied Electronics and Instrumentation Kalyani
Extracurricular activities Photography Angling Certificates and Awards IBM Infosphere Information Server v8.5 2013 IBM Infosphere Information Server v8.0 2012 IBM DB2 10.1 2013 IBM Cognos 10 BI Authors : 2005
2003West Bengal University of Technology-
8.05/10 Passed Higher Secondary Examination Kanailal Vidya Mandir, Chandernagore West Bengal Council of Higher Secondary Education. Marks Obtained: 780/1000.
*Passed MADHYAMIK Examination Sri Aurobindo Vidya Mandir, Chandernagore West Bengal Board of Secondary Education.
Marks Obtained: 680/800.
Technology Domain\Consulting Champion: 2014-
MVP Award Winner - Infosys Limited: 2014-
Infosys SI, INSTA AWARD -Q2: 2014-
Successfully completed Campus-Connect Program conducted by Infosys Technologies Limited: 2010JIS College of Engineering-
B.Tech : Applied Electronics and Instrumentation Kalyani Extracurricular activities Photography Angling Certificates and Awards IBM Infosphere Information Server v8.5 2013 IBM Infosphere Information Server v8.0 2012 IBM DB2 10.1 2013 IBM Cognos 10 BI Authors : 2005
2003 Technology Domain\Consulting Champion : 2014 MVP Award Winner - Infosys Limited : 2014 Infosys SI, INSTA AWARD -Q2 : 2014 Successfully completed Campus-Connect Program conducted by Infosys Technologies Limited : 2010
Create a job alert for [job role title] at [location].