Candidates About

 

Ranjani Pai

 

 

 

Education Qualifications:

 

Masters in Electrical Engineering (2008), New Jersey Institute of Technology- (GPA -3.5/4.0)

 

Immigration Status:  H1B- I140 approved

----------------------------------------------------------------------------------------------------------------------           Summary

·         Over more than 10+ years of Industry experience in IT and Telecom.

·         Information technology professional with 8+ years of Data Integration experience in Healthcare, Banking, and Financial and Insurance domain.

·         Electrical Engineering professional with 5 years of  experience in realizing communication signal processing algorithms using C, Matlab, Lab view, DSP processors, Fixed point arithmetic.

·         Proven track record in project life cycle including solution design& development, system integration, testing, implementation and delivery. 

·         Experience in Agile and Waterfall development methodologies

·         Detail oriented with excellent organizational and demonstrated problem solving skills.

·         Excellent at Business Data, ETL data and work flow analysis.

·         Highly motivated and adaptive with ability to analyze and grasp requirements quickly.

·         Self-motivated, determined, honest and like to work with people who share my passion for doing their best.

·         Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical, verbal and written communication skills.

·         Commitment to excellence- Ability to meet/beat deadlines and deliver quality results on time. 

 

 

Skill Sets:

IBM Information Server v7.5/8.0/8.1/8.5/8.7/9.1, Oracle 10g, MS SQL Server 2005, MS Access, Sybase, Netezza,SQL, DB2 v10, TOAD 9.6, AQT, Erwin, PL/SQL Oracle Developer 2000, Microsoft Visio/Power point/Excel/Access, IBM AIX UNIX, UNIX Shell Scripting ,Windows NT,/XP, Macintosh, C,C++, HP Mercury  Quality center/Quick Test Professional, Matlab, Labview, DSP

 

Project Summary:

 

Fifth Third Bank, Cincinnati-OH                                                                  Jan 2016 - till date                     

DataStage Tech Lead- consultant

Working on multiple projects, leading a team of 3 offshore developers in the Investment Advisory and Wealth& Asset Management group.

 

Projects: Held away Data conversion, IA data Purge, Information Server upgrade from version 9.1 to 11.5

 

Hardware /Software:

 

IBM DataStage Information server 9.1, Quality Stage, DB2/ AQT, Unix/AIX, SQL, MS Visio, Erwin, WinScp, Tivoli scheduler, MS Visual Studio C++, IBM Data Studio

 

Responsibilities:

•      Involved in Analyzing Business Requirement in terms of ETL data rules.

•      Work closely with Business Analysts in creating ETL mapping documents.

•      Perform Data profiling and analyze data Quality

•      Create table relations and data model

•      Identify data quality issues and applies analytical skills to design and develop resolution Strategies.

•      Analyze all the tables in IA/WAM group and defining a strategy for Data purging process/policy.

•      Analyze existing Server /Parallel jobs for migrating Jobs from version 9.1 to 11.5 migration

•      Write Technical Designs to develop ETL Job Streams and promote code to test and production Environments.

•      Develop technical solutions using approved methodologies and review it with clients.

•      Write  complex SQL queries, Procedures, Routines and UNIX scripts

•      Perform performance tuning of ETL jobs and SQL queries.

•      Conduct Code review with the client team.

•      Unit testing and integration testing of ETL jobs developed to verify the functionalities.

•      Lead a team of 3 offshore developers, identify issues and propose solutions, manage deliverables/milestones, and deliver weekly statuses.

•      Provide production support

 

 

American Modern Insurance Group -OH                                                   June 2015- Dec 2015

DataStage Developer- Lead/ Data Analyst- consultant

 

Worked on Business Transformation (BT) Initiative Project for Guide Wire Policy Center (PC) and Billing Center (BC) in Property & Causality domain.

 

Hardware /Software:

IBM DataStage Information server 8.7, Quality Stage, Oracle 11.1.0g, Unix/AIX, SQL Developer 4.0.3, WinScp, Control-M

 

·         Involved in understanding of the requirements for Migrating Policy Center data from Legacy systems IC/HUON to Guidewire PC

·         Data Analysis to understand the requirements and derive data mapping for downstream vendor extracts.

·         Coordinating with architects in determining the solutions for ETL.

·         Wrote SQL queries for extracting data from Oracle database.

·         Designed and developed ETL processes using DataStage Versions 8.7 for extracting data from Enterprise Data Center (EDC)

·         Creating downstream vendor extracts from EDC data ware house generating fixed width flat files.

·         Wrote Complex SQL queries to extract data from different Policy Center tables in EDC layer.

·         Performed performance turning of the query and ETL jobs.

·         Designed and developed one time update of DB tables for agent’s profile.

·         Wrote stored procedure to tie the premiums for AL3 policy, truncate tables.

·         Wrote Stored procedures and used stored procedure stage to call procedures.

·         Unit testing of the ETL jobs and identifying the dataissue for any discrepancy in the extract.

·         Documented Run books for scheduling through Control-M. Production support documents.

·         Provided Post implementation support.

 

 

EmblemHealth – New York                                                                        Oct 2013- May 2015

Sr.ETL Developer - consultant

 

Working on multiple projects- Membership Rewrite, Logical Deletes and Medicare Sequestration, E837 and Reporting requirements.

 

Hardware /Software:

IBM DataStage Information server 8.1.0/9.1, Oracle 11.1.0, Unix/AIX, Toad 9.7.2, WinScp, Autosys

 

Responsibilities:

•      Involved in understanding of the requirements for enhancing existing ETL processes from staging to ODS.

•      Involved in understanding of the requirements to read and load data from MF files into Staging and then from Staging into ODS tables.

•      Analyzed the existing ODS tables to identify the gap in the design for missing data from the source.

•      Designed and developed a Reverse Lookup method for capturing missing data from the Lookup tables.

•      Identified the issue and redesigned the ETL job to fix the incorrect population of Member address in the ODS by rewriting the sql query for extracting latest email address from the Staging table.

•      Designed and developed post update processes for updating existing claims with Sequestration Indicator and Sequestration amount in the ODS tables.

•      Conducted Code review with the client team.

•      Unit tested the jobs developed to verify Reverse lookup scenario and regular daily batch scenario.

•      Unit tested the jobs developed for post update process 

•      Moved the code from DEV to QA and performed testing in QA.

Co-ordinated with Data Analysts for validating data in DEV, QA and PROD.

•      Created Autosys JILS for scheduling jobs through Autosys.

 

 

Department of Transportation-New Jersey (NJ-DOT)                          July 2013- Oct 2013

DataStage Developer - consultant

 

Worked on the TransInfo project to load Datwarehouse and datamarts for the State of New Jersey 

 

Hardware /Software:

IBM DataStage Information server 8.5, Oracle, Unix/AIX,SQL tool,WinScp

 

Responsibilities:

•      Involved in understanding the requirements enhance existing datawarehouse to load data from source systems 

•      Created jobs to stage data from PONTIS source systems.

•      Created all Data Stage jobs required to load data to the existing TransINFO normalized Data Warehouse from the Staging Area.

•      Created all Data Stage jobs required to load data to the existing TransINFO de-normalized (Star Schema) Data Marts from the Data Warehouse.

•      Created Exception Log entries in conformance with the TransINFO project standard methodology.

•      Used Change Capture stage to implement Slowly Changing Dimension (Type 2) data in the Star Schema Data Marts to maintain history.

•      Created DataStage loop sequence to load historical data to the Datawarehouse 

•      Conducted Code review with client team.

•      Unit tested the jobs developed to verify scenarios like Initial, incremental and No activity Load.

 

 

Huntington Bank-OH                                                                             Dec 2012- July 2013

DataStage Developer-Lead consultant

 

Working on migration Project for Enterprise Sales& Services (ESS) to migrate Weblogic ETL batch process to DataStage ETL process.

 

Hardware /Software:

IBM DataStage Information server 8.7, Oracle, DB2, Web logic, web services, xml, IBM Data Studio,Agile, Unix/AIX

 

Responsibilities:

•      Analyzing existing batch processes in Weblogic and deriving high level requirements, mapping and design document for DataStage processes.

•      Communicating with cross-functional teams to understand the existing system.

•      Designing and developing complex webservices jobs in DataStage Version 8.7.0 webservices package, xml package.

Developed Code Inquiry Service, Batch Hotlist Process, Create Blank Doc using webservice transformer, xml schema library, xml input, oracle Connector,Db2 Connector, sequential file,lookup,transformer, row generator,FTP

•      Designed and developed an Incremental loading pattern for loading Data from ESS database to the mainframe database.

•      Used stored procedure stage to call store procedure for very large objects.

•      Used complex XSDs for transformation.

•      Applying coding standard, Identifying parameter sets.

•      Unit testing of the job modules developed and parallel testing of the Web logic and DataStage processes for data accuracy and performance gain.

•      Creating relevant documents required for design and testing.

•      Creating Runbooks for Zena scheduler.

 

 

Blue Cross-Blue Shield-RI (BCBS-RI)                                                  Jan 2012- Nov 2012

DataStage Developer -Lead consultant

 

BCBS is the second largest health care Insurance provider in the USA. 

 

I worked on multiple projects GHI, Callidus, PCMH. 

 

Hardware /Software:

IBM DataStage Information server 8.1.0, Netezza 3.0, Aginity LLC, AIX, Sybase,Oracle,Toad

 

Responsibilities:

•      To act an interface between offshore and the customer.

•      Analyzing existing reporting system in DataStage, Identifying the discrepancy in the report for compliance and applying necessary corrective actions to make it compliant.

•      Communicating with cross functional teams to analyze the discrepancy in the existing Data Stage code.

•      Understanding new business requirements and deriving low level DataStage design specifications for the requirement.

•      Migrating code from DS version 7.5.2 to DS version 8.1.0 and applying coding standard

•      Understanding source system, Enterprise Data Repository (EDR) structure for analyzing the requirements

•      Creating Data mapping from Sources LRSP and Facets to the target databases Netezza and Oracle

•      Designing and developing in both server and parallel jobs on 8.1.0

•      Developing and unit testing of the parallel job modules developed and modified for new BRs and documentation.

•      Used DataStage stages Transformer, look up, join, odbc, oracle Enterprise, Copy, Sequential file, Remove duplicates, Aggregator, Datasets, Modify,Funnel, Shared container, filter, CDC in developing parallel jobs.

•      Creating new tables in oracle and modifying the tables for additional columns required per business requirement.

•      Querying Netezza database for verifying and validating DataStage extract output per requirements.

Used shell scripting to move files from one directory to the, renaming files and ftping the files from one server to the other, processing files one by one and moving them to the archive directory once get processed.

•      Used DataStage routines and shell script for cleaning up previous run files from the directory as a start of job activity and End of job Activity to collect load statistics

•      Loading fee fact table for claims.

•      Parallel testing of the previous production code with new DS extract.

•      Preparing runbooks for job scheduling team for quarterly run.

 

Union Central Life Insurance Company, OH                                                  July 2010-Dec 2010 

 

DataStage Developer – consultant

 

Union Central Life Insurance Company is an Insurance and Investment company that provides financial and product services to its customers across USA.

The main objective of the project, MAPS Annuity, is to enhance existing Client Service System for improving customer services by adding Fedwire source information to the existing system.

 

Hardware /Software:

 

IBM Ascential DataStage 7.5.2, Oracle 10g, Windows NT, Flat File, Zeke

 

Responsibilities:

 

•      Interacted with Business Analysts in understanding business requirements.

•      Involved in mapping existing system to the ACORD Industry Standard model.

•      Designed and developed ETL pattern for Incremental loading using DataStage designer to load data from Oracle OCI, Flat File to staging database and from staging to the target Data Warehouse database.

•      Developed Server jobs to implement Slowly Changing Dimension (SCD) Type I for loading data from source to ODS and SCD II logic to load data from ODS to Datawarehouse.

•      Used Transformer, Oracle, Aggregator, Sort, Hashed File, Sequential File stages,Local containers to develop Server jobs.

•      Developed work stream control to log ETL statistics of the Incremental loading pattern.

•      Developed a Sequence job to integrate server jobs that had dependencies.

•      Performed performance tuning of the job using Link Partitioner and Link Collector.

•      Used Local containers to simplify job design for performance tuning.

•      Interacted with DS administrator in scheduling Jobs using Zeke.

•      Wrote DS routines to pass job status in the sequence job and to capture insert, update and reject link counts.

•      Performed unit testing of the Incremental loading pattern for Initial load for Inserts and Updates, Repeat updates, No activity,Reject load scenarios and documented the results.

•      Used SQL script to pull data from the database to verify the results logged in the workstream control.

•      Exported .dsx of the jobs developed in the Development environment for Test, Model and production Server.

•      Wrote DS command file to automate the DataStage project Execution through Zeke on a daily basis.

•      Closely worked with DS administrator in DS code moves of the jobs developed from Development->Test->Model->Production.

•      Created Naming standards for Project and Jobs developed.

•      Documented the ETL application document and used Visio to draw flow chart of the ETL Pattern flow.

 

Blue Line software Services Inc. NJ                                                           October 2009- March 2010              SQA Tester

Worked as a SQA Engineer, for Testing of Client server application for sensor based battery monitoring system CellTrac. CellTrac acquires battery performance on which it is installed and sends it to the server through a 900 MHz radio. The Cell Trac application,a GUI,is used to download data to the server and generate reports in the excel format.

I was actively involved in Implementation of ISO 9001:2000 compliant quality systems Responsibilities:

•       Involved in Requirement gathering, analysis and manual testing. Wrote test cases based on Business requirement specifications.

•       Contributed in Test Planning, and all testing activities across Technology for the three distinctive phases. Developed and documented testing strategy, test plan.

•       Created test cases, test conditions and test data required for testing.

•       Involved in Daily Stand up meeting with Development Manager and development team to identify and resolve the issues.

•       Tested communication between the CellTrac unit and the application and functioning of the unit using ‘AT’ commands.

•       Maintained the Traceability Matrix and also conducted the Gap Analysis to check if the testing efforts are in sync with the requirements.       

•       Performed functional testing, System Testing, Back end testing, Validation Testing and        User Acceptance Testing. 

•       Reporting bugs, verifying bug fixes, daily status and creating test metrics.

•       Executed SQL Queries in SQL 2005 and SQL Management studio environment to retrieve data from database to verify the report generated.

•       Involved in implementing ISO 9001:2000 compliant quality systems.

•       Used Visio to plot flow chart for procedures defined in the system.

 

Blue Line Software Services, NJ                                                       June 2009-Sept 2009 SQA SQA Tester

Worked as a QA tester at inXpay Inc on web based E-billing application.

The application had two modules account payable (AP) and account receivable (AR) to keep track of transactions.

Responsibilities:

•       Active participation in decision making and QA meetings and regularly interacted with the

Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design.

•       Analyzed business requirements with perspective to Black Box Testing,

•       System architecture/design and converted them into functional requirements/test cases.

•       Used Quality center to document the requirements and created traceability matrices for the requirements.

•       Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy.                   

•       Created detailed Test Cases and Test sets and executed them manually.

•       Performed Cross-Browsing testing to verify if the application provides accurate information in different (IE, Netscape, Firefox, Safari) browsers

•       Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries. 

•       Provided management with metrics, reports, and schedules and was responsible for entering, tracking bugs.

•       Ensured that the Defect was always written with great level of detail.

•       Logs, tracks and verified resolution of software and specification defects.

 

      New Jersey Institute of Technology, NJ                                                             April 09-June

      Project Assistant  

 

•       Responsible for evaluating the performance of Luby Transform (LT) code in AWGN.

 

      Berkeley Varitronics Systems Inc. NJ                                                   August 2008– March 2009 WiMaX Software Engineer

     Tools: Visual DSP++ 5.0, BF-532 assembly & C, Microchip Programmer

     Development of a Blackfin-532 DSP based firmware for Mobile WiMAX modulator     

Responsibilities:

•       Loading code into flash via flash programmer (.ldr file, .bin file).

•       Boot processor-load interrupt vector table and toggling external watchdog timer.

•       UART/serial port communication.

•       Download XILINK’S configuration via serial port (.bin file)

•       Test code for XILINK-DSP communication.

•       External clock generation through programmable PLL.

•       Flash read/write using DSP.

•       Loading DAC samples to external SRAM through XILINK.