Candidates About

 

Hazarath Shaik

I am a certified ETL consultant having 10+ years of Lead developer/Architect experience in designing and developing ETL solutions using Informatica suite like Power Center, MDM, IDQ and power exchange, Microsoft SSIS 2014, Talend 5.5 in various environments including UNIX Shell scripting, DB2, Microsoft SQL, Oracle and different file formats. I have extensive technical knowledge using and supporting enterprise wide data warehouse and data marts in HealthCare Industry and pharmacy. I have profound knowledge and experience in the areas of capturing requirements, working experience on star schema and snowflake schema methodologies and performing Extract Transformation and Load process.

Experience Summary

• 10+ Years of experience in IT industry which includes Analysis, Design, Development, Testing and Implementation of applications on Informatica and Microsoft SSIS, Talend 5.5.1.
• Analytical and solutions-oriented Senior IT Consultant and Technical lead with experience guiding teams through the SDLC and agile methodologies to improve efficiency of state-of-art-systems on time and under budget.
• Proposed and implemented enterprise encryption strategy for sensitive data conversion at Assurant HR and Finanace datamart's.
• Certified Power Center Data Integration 9.x:Developer Specialist.
• Experienced in the installation of informatica software in various environments.
• Proposed and built data marts/data warehouse as per business needs for end user extracts and reporting purposes.
• Extensive experience in Healthcare domain and certified by AHIP with PAHM (Professional academy of HealthCare Management).
• Completed HealthRules training in 2013 and certified by HealthEdge.
• Have hands on experience on creating logical and physical data models using ERWIN/ER Studio.
• Experience in working on slowly changing dimension SCD type I and type II to fast ETL Mappings.
• Excellent experience in designing the Star and snowflake models for Data Warehouse, have good knowledge of data warehouse concepts like Inmon and Kimball methodologies.
• Experience in designing complex mappings using transformations like Expressions, Aggregators, Routers, Joiners, Rank, Sorter, Stored Procedure, Lookups, Sequence Generator and Update Strategy, webservice and HTTP transformations.
• Experience in designing of Dimension modeling using star schema and snowflake schema
• Experience on performing Testing and tuning database
• Good in preparing documentation and test plans, unit testing experiences.
• Experience in integration of various data sources like Oracle, SQL Server, MS-Access, Flat Files and XML Files into data warehouse.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements. Excellent communication skills, management and leadership qualities.

Technical Expertise

Elements	Particulars
Primary Skills	Informatica power center V9.6.1,Microsoft SSIS 2014, Talend 5.5, Informatica MDM, IDQ 8.6, power exchange.
Operating Systems	UNIX, MVS, Windows NT/XP/2000/2003/ 2007
Data Warehouse	Star Schema, Snowflake Schema, EDW, Data Marts.
Data modeling tools	Erwin, ER Studio
Languages	Fourth Gen – DB2 SQL, Oracle SQL, Microsoft SQL, PL/SQL, UNIX Shell scripting, HDFS, C, JAVA.
Development Tools	Informatica power center 9.X, Microsoft SSIS, Informatica cloud Version Control–SVN, Endeavor,TFS, Panvalet Jobs Scheduling – CA-7, Tivoli, Control-M, UC4(Automic) Test: HP ALM
Databases	Oracle DB2, Mainframe DB2 5.6 and Microsoft SQL.
Configuration Tools	SCM configuration tool, Informatica version control, Dimensions, Team track, TODD, Putty, Ultra edit, Reflection FTP client
Domain Knowledge	Health Insurance, Pharmaceutical, P&C.

 

Project Details:

ETL Informatica Sr developer/Architect                                                                         06/16 to Till date

Client: Assurant

Location: MN

Team Size: 03

About the company:

 

Assurant, Inc. helps people protect what matters most to them. Assurant provide specialty protection products and related services to safeguard against risks. With a strong commitment to service, sophisticated technology and an array of flexible tools, Assurant build solutions to meet customers’ needs.

Assurant Solutions

Specializing in providing extended service contracts and other risk management solutions, Assurant Solutions offers a wide range of products that protect appliances, electronic devices, mobile phones and family finances through preneed insurance.

Assurant Specialty Property

Working with mortgage lenders, property managers, manufactured housing firms, auto finance companies and insurance agencies, Assurant Specialty Property provides client-centered solutions to protect homes and personal property.

 

Project: ESPP and EquityComp Upgrade POC

 

As part of corporate initiative Assurant decided to switch to Talend ETL tool for current and future call center projects as Talend has etl and reporting capabilities in built and also future call center big data projects.

As part of this initiation Assurant decided to migrate existing employee stock purchase plan (ESPP) and Equity comp extracts to Talend environment to test functionality.

 

Roles/Responsibilities:

 

·         Understand existing ESPP and EquityComp ETL code

·         Create technical specification documents and review with business team for any enhancements.

·         Create Talend jobs to read data from Oracle tables and create ESPP, EquityComp extracts.

·         Work with EFT team to setup internal/external FTP mailboxes and incorporate in UC4 jobs.

·         Unit test the results and support business team in system test phase.

·         Create deployment plan and review with team.

·         Create RFC’s to migrate code to production and schedule UC4 jobs as per business provided schedule.

 

 

 

Project Name: ADP Outsource payroll

 

Assurant Inc. is engaged with ADP to outsource payroll process, as part of this initiation Assurant should send/receive required information in the form of extracts to/from ADP daily. Those extracts include Equity comp inbound files, recurring deduction and department files, Lawson data.

 

Roles/Responsibilities:

 

·         Work with business team to get better understanding of requirements.

·         Involved in project design meetings with ADP to design payroll Datamart.

·         Design Payroll Datamart from HRDW and Lawson data warehouse.

·         Work with DBA’s to build table structures in payroll Datamart.

·         Create ETL mappings/workflows based on ETL specifications to send payroll extracts to ADP.

·         Design/build staging tables for the inbound/outbound operations.

·         Work with connect enterprise team to setup ftp process to send/receive files from ADP.

·         Unit test the results in Dev environment and migrate the code to Model environment.

·         Support user acceptance testing and generate extracts as per business needs.

·         Create deployment documents and setup jobs in UC4 Model environment.

 

Project Name: PwC upgrade

 

Assurant Inc. is engaged with PwC (Price water coopers) to audit financial transactions, as part of this process Assurant sends current and catchup financial files to PwC on a quarterly basis for auditing. Due to increasing financial transactions Assurant upgraded from Oracle to SQL server database along with SSIS tool to handle data more effectively.

 

·         Involve in project initiation/technical discussion meetings to understand requirements.

·         Implemented automated process to extract quarterly date ranges based on job schedule date.

·         Implemented process to truncate if PwC process is schedule to run repetitively in the same quarter else insert data.

·         Created new SSIS packages as per existing Informatica logic in mappings/workflows.

·         Unit test PwC files and work with business in system testing area.

·         Work with EFT team to setup mailbox to FTP PwC files.

·         Create deployment documents and setup jobs in UC4 environment.

 

Project Name: Limeade Eligibility Extract

 

Assurant Inc. engaged with Limeade to maintain wellness activities of employees and eligible populations from year of 2017. Assurant Inc. is responsible to share required information of eligible employees, spouse/domestic partners and COBRA eligible employee’s information with Limeade on a weekly basis.

Assurant sends weekly limeade extract to limeade using secured FTP transmission.

Roles / Responsibilities

·         Work with business team to get better understanding of requirements.

·         Create ETL technical specifications document and review with team.

·         Extract eligible employee, spouse/domestic partners and COBRA eligible employee’s details from HRDW and LAWSON tables.

·         Generate limeade extract with required columns from HRDW as per Limeade accepted format.

·         Created reusable mapplet to decrypt employee social security information while generating Limeade extract.

·         Unit test the results in Dev environment and migrate the code to Model environment.

·         Support user acceptance testing and generate extracts as per business needs.

·         Create deployment documents and setup jobs in UC4 Model environment.

 

Project Name: Enterprise encryption project

 

Enterprise encryption project is initiated by Assurant corporate to encrypt employee sensitive data across the organization. As part of this initiation social security numbers are identified and encrypted both in FinDW and HRDW data ware houses to keep confidential information invisible. Assurant contracted with Liason to build a custom interface to encrypt the data as per Assurant standards.

Roles / Responsibilities

·         Work with architect to understand requirements.

·         Created a POC workflow to encrypt sample data using Liason web services and ETL transformations (used SOAP request) and validated results.

·         Get performance statistics with encryption and without encryption logic, share the results with management to make decisions about project.

·         Install informatica 9.5.1 hot fix4 and EBF patch to fix certificate errors while calling web services from informatica 9.5.1.

·         Identify SSN’s in both Finance and HRDW data warehouses.

·         Create reusable process (mapplet) to identify social format and encrypt using Liaison tool.

·         Create a process which compares both input and encrypted social last four digits to perform sanity check.

·         Load data into intermediate files to be used by interfaces to encrypt/decrypt SSN.

 

Project Name: Bicycle

 

Bicycle project changes Assurant employees pay cycle from bi monthly to bi-weekly. MAIN, MINI and SPECIAL are three different kinds of existing payroll processes for BI reporting needs. Bicycle project retires MINI process and enhances existing MAIN and SPECIAL process in addition to build new Accrual process for the HR reporting purpose.

Roles / Responsibilities

·         Work with business team to get better understanding of requirements.

·         Migrate existing code from INFA8 to INFA9 and develop informatica mappings to replace existing shell scripts.

·         Enhance MAIN and SPECIAL payroll process to get data from Lawson, build Accrual process for the budget forecasting purpose.

·         Unit test the results in Dev environment and migrate the code to Model environment from Dev.

·         Involve in code and unit test results review meetings.

·         Create deployment documents and setup jobs in UC4 Model environment.

·         Execute jobs to generate files and FTP to smart stream to upload into GL.

 

Environment

OS: WINDOWS, UNIX

Files: Text files

Utilities: Informatica 8, Microsoft SSIS DT, Talend 5.5, Informatica 9.5.1

Database: Oracle 11g, SQL server 2014

Languages: UNIX Shell scripting, HDFS

Scheduling: UC4 (Automic)

 

ETL Informatica Lead                                                                                                   02/16 to 06/16

Client: CVS Caremark

Project name: Cash Recon

Location: IL

Team Size: 04

Project Description

 

Cash Recon is CVS Caremark's rebates processing system to bill manufacturers based on trade relations agreements and distribute to clients based on claims received for each quarter. This system processes approximately 5.1 million rebates every quarter and it is growing.

 

Cash Recon system creates reports based on trade relations agreements between CVS and manufactures and consolidates reports into single invoice based on manufacturer. Each invoice contains admin, base, formulary, contract, performance and price protection revenue buckets based on negotiated contracts. SAP system confirms after reception of invoice amount and it will be distributed across clients by RPS system with holding the admin fee amount.

Roles / Responsibilities

·         Worked on enhancements to existing ETL code as per business identified BSR's.

·         Create scenario's and work with team to execute and capture the results.

·         Work with business team with identified issues and explain complexity of the BSR or PSR.

·         Create reports and invoices based on claims inclusion and exclusion rules and communicate with SAP and RPS as part of unit testing.

·         Create design documents for the proposed code fixes and review with business to get approvals.

·         Work with business team to gather scenarios and execute in the unit testing phase.

·         Setup unit test results review meeting and get approvals for SIT and UAT migration.

·         Provide support to QA and business teams while performing testing in SIT and UAT regions.

·         Trigger batch process from JAVA screens based on scenario's and capture results.

 

Environment

OS: WINDOWS, UNIX

Files: Text files

Utilities: Informatica 9.5.1, SVN

Database: DB2 5.6

Languages: UNIX Shell scripting

UI: JAVA

 

ETL Informatica Developer                                                                                          06/15 to 02/16

Client: Medica

Location: MN

Team Size: 01

Project Description

 

Medica refers to a group of companies held by a non-profit, tax exempt holding company called Medica Holding Company. Its family of businesses includes Medica Health Plans, Medica Health Plans of Wisconsin, Medica Insurance Company, Medica Self-Insured and Medica Health Management, LLC, as well as the Medica Foundation and the Medica Research Institute.

Medica is accredited by the National Committee for Quality Assurance (NCQA®) for its Minnesota Medicaid HMO plans and commercial health plans in Minnesota and North Dakota.

 

Project Name: AArete/Verisk waste and error

In 2013 Medica enhanced its Fraud Waste and Error (FWE) activities to strengthen and better coordinate FWE activities across the organization. Those enhanced capabilities were implemented only for claims processed on Medica’s UHG legacy systems.

 

When Medica’s Phoenix Program implemented the IFB line of business on a new claims platform (Health Rules) on 1/1/2014, a business priority decision was made not to attempt to extend the enhanced capability for claims processed on the new platform.

 

That decision was based in significant part on the small number of lives initially migrated to the Phoenix Ecosystem. But That decision is changed as the potential implementation of over 100,000 Iowa Medicaid lives on the Phoenix Ecosystem on 1/1/2016, and planned continued expansion in following years has made it a business priority to implement FWE capabilities on HealthRules for a Q1/16 implementation.

Roles / Responsibilities

·         Worked with Data Architect to understand the business requirements and Convert business requirements in technical requirements.

·         Worked on end to end ETL design of the project.

·         Created ETL process to source data from IDM and create output file as per Aarete standards.

·         Worked with automic scheduling to automate job schedule.

·         Worked with cleo team to setup MFT process to FTP the files to Aarete on a daily basis.

·         Version the code and deploy the code in QA and PROD.

 

Project Name: Emdeon Member Eligibility

Emdeon is Medica’s third party vendor to reprice claims processed by Medica based on member’s eligibility criteria. HealthRules members eligibility information is extracted from Integrated Data Mart(IDM), Salesforce on a daily basis and Ftp’d to Emdeon. The eligibility file contains members who are effective from past 18 months.

Roles / Responsibilities

·         Worked with Data Architect to understand the business requirements and Convert business requirements in technical requirements.

·         Worked on end to end ETL design of the project.

·         Created ETL process to source data from IDM and cleanse data using Informatica DQ standards to create output file as per Emdeon standards.

·         Worked with automic scheduling to automate job schedule.

·         Worked with cleo team to setup MFT process to FTP the files to Emdeon on a daily basis.

·         Version the code and deploy the code in QA and PROD.

Project Name: Midlands to COPIS

COPIS is Medica’s find a doc website where members can access provider directory and access to care.

 

As part of Midlands to COPIS project Medica receives facilities and practitioner XML full files from Midlands. Medica processes these files as per business rules and loads facility and practitioner files into stage table which will further feed into COPIS(Consolidated provider information system).

Roles / Responsibilities

·         Responsible for working with Data Architect to understand the business requirements and Convert business requirements in technical requirements.

·         Responsible for creation of landing zone tables for facility and practitioner once XML files are received from Midlands.

·         Worked on ETL build for loading data from LZ to practitioner and facility stage tables as per business requirements.

·         Worked on unit testing of LZ and STG tables after data load.

·         Provide support to QA while performing paired testing and QA validation.

·         Version the code and deploy the code in QA and PROD.

 

Project Name: Subrogation

Subrogation is defined as a legal right that allows one party (e.g., your insurance company) to make a payment that is actually owed by another party (e.g., the other driver's insurance company) and then collect the money from the party that owes the debt after the fact.

 

As part of subrogation project Medica sends all IFB (Individual Family business) paid Medical/Rx claims to OPTUM (United Health Group) on a weekly basis for validation and processing of payments.

Roles / Responsibilities

·         Responsible for working with Data Architect to understand the business requirements and Convert business requirements in technical requirements.

·         Responsible for end to end ETL design of the project.

·         Responsible for creating ETL build to source data from IDM and create output files as per OPTUM standards.

·         Developed MEDICAL and Pharmacy claims files as per requirements specified in s2t’s and created UNIX scripts to move files from UNIX server to Cleo.

·         Version the code and deploy the code in QA and PROD.

 

Environment

OS: WINDOWS, UNIX

Utilities: Informatica 9.6.1, Informatica MDM, SVN, Service Now.

Cloud Utilities: Informatica cloud, Salesforce

Files: XML’s, flat files

Database: Oracle 11g, Microsoft SQL

Languages: UNIX shell scripts

Files transfer: FTP

 

 

ETL Informatica Lead/Architect                                                               02/11 to 05/15

Client: CareFirst BCBS

Location: MD

Project Name: Medical Loss Ratio

Team Size: 07

Project Description

 

CareFirst is the major health insurance carrier in the state of Maryland, the District of Columbia and Virginia providing coverage for over 3 million policy holders.

 

Medical Loss Ratio (MLR): The Medical Loss Ratio (MLR) Regulation as mandated by Section 2718 (b) of the Public Health Services Act (PHSA) and the Patient Protection and Affordable Care Act (PPACA) requires health plans offering group and individual health insurance to publicly report on their medical loss ratio in order to create transparency around a plan’s efficiency in allocating premiums to actual healthcare costs.  Plans will be required to issue a rebate to groups and subscribers if the amount of premium spent on claims expenses is less than 85% for large group or 80% for small group and the individual market.

 

<p class="MsoNor