Kanika Kalra

*** ******** *****, *** ***, Cumberland, RI.

(Ph.) 401-***-****

Email: nqa251@r.postjobfree.com

EDUCATION

Bachelor of Technology July’02-July’06

Haryana Engineering College, Kurukshetra University, Kurukshetra, Haryana

Scored 72 Percent

H.S.C Apr’02

St. Thomas School, Jagadhri, Haryana

Scored 82%

S.S.C Apr, 2K

St. Thomas School, Jagadhri, Haryana

Scored 85%

OVERALL EXPERIENCE

Overall total IT experience of 5 years comprising of roles varying from ETL developer, Business Technical Analyst,SME and ETL Data Analyst for different projects with Retail CVS Pharmacy in varying Healthcare business areas like Third Party Claims Processing(including new NCPDP D.0 format ), Drugs Data, Patient and Prescriber Data, Financial Data including copay ,tax ,remittance amounts ,write off amounts etc. Worked extensively on Business and Technical side in Retail Pharmacy and Finance area.

IT Analyst worked in different roles for projects at CVS Pharmacy, USA Oct’08-Till Date

Software Engineer at Tata Consultancy Services, Gurgaon, India Mar’07-Oct’08

Technical Support Consultant with Microsoft Client at Convergys, India Aug’06-Feb’07

SKILLS

Technical skills

• Informatica Power Center 8.1.1: Certified Developer

• Databases: Oracle 9i, Oracle 10g, PL-SQL and SQL programming.

• Control M Enterprise: Monitoring, Maintenance and scheduling of batch jobs.

• Operating Systems: Windows, UNIX (Aix/Solaris)

• Programming Languages: Java

Non Technical Skills

• Managerial Skills: Ability to handle teams of fresh and experienced professionals as handled twice the projects as team lead

• Excellent Verbal and Written Communication Skills

• Languages: English, Hindi, Punjabi, German

• Good Team Player skills

• Good & Quick Learner as have learnt different business areas in very less time in different projects.

Projects Undertaken Till Date:

1) TPMS System CVS Pharmacy, Woonsocket,RI, USA Sep’10-Till Date

Team Size: 100

Technology Used: Oracle 10g, PL/SQL (Procedures, functions, packages), Control-M, Informatica Power Center 8.6.1

Description: TPMS is the Third Party Management System being built in CVS. Existing system is on outdated technology and is file based and has very limited transparency for the business user. The new TPMS system is more user friendly and will help them efficiently manage Third Party Payers, maximize cash flow to CVS, minimize bad debt expense, provides ability to process claims daily rather than weekly and replace existing system which is not scalable to current and future volumes .The Data/Transaction volume is very high (~3 million third party claim transactions per day).The system consist of 400 batch jobs comprising of sql batches and ETL batches. This also includes the changes done as a part of upgrade being done from NCPDP 5.1 to NCPDP D.0.

NCPDP Telecommunications Standard Version D.0 is an updated version of the HIPAA standard for pharmacy claims transactions.

Role and Responsibilities as SME for Posting Third Party Claims in TPMS system

• Analyze the Use Cases and Requirement Documents

• Involved with the Design team to make the design decisions and finalizing the

Design documents

• Helped the Development team to understand the design and the Business Flows needed to be implemented

• Helped CVS Business team to fill in the requirement gaps which were found during dev cycle.

• Involved in discussions with Business to discuss different exception scenarios handling and error handling to be done while posting the claim in the system

• Involved in discussions with other teams to discuss about Billing of the claim ,claim matching the remittance received and claim management etc

• Reviewing the Interface Design documents and the design for the ETL batches used to parse and load Tlog files in the staging area for TPMS system

• Understand and review the changes done in the system as a part of upgrade to be delivered to new NCPDP standard D.0

• Involved in the impact analysis done for the overall system as a part of changing the standard to NCPDP D.0

2) Rx90 Data Migration to RxConnect for CVS Pharmacy,USA at Tata Consultancy Services Limited in Lincoln,RI,USA July’09-Sep’10

Team Size: 150

Technology Used: Informatica Power Center 8.6.1(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Transformations), Oracle 10g, PL/SQL (Procedures, functions, packages),Unix Scripts, Control-M

Description: RxConnect is an Enterprise Pharmacy Management System developed for CVS/Pharmacy, one of the largest pharmacy chains in the United States. The current CVS Pharmacy legacy system used was Rx90 system which was built in mainframe .The data had to be migrated into the new database so that the new application can be deployed in the stores. The new application is centralized application thus once data is loaded into centralized data base we need to migrate data from centralized Oracle database to MYSQL local database as that is being utilized during offline i.e when system goes offline, it uses local store MySql DB.

Role and Responsibilities as Pharmacy Business Data and ETL Analyst:

• Actively participated in the design phase for data conversion architecture.

• Involved in Meetings/Discussions with the site teams on regular basis as part of the requirement gathering.

• Create mapping for all the fields to be migrated from one system to other with business rule of transformation mentioned with the same.

• Involved in the preparation of High level Design (HLD) and Low Level Design (LLD) specifications.

• Involved in designing and developing the Informatica mappings and work flows for Data Conversion mechanism.

• Involved in complete software development life cycle (SDLC) of the project.

• Review the mappings for code issues/functional correctness

• Review migrated data functionally for critical areas like Third Party Claims, Patient Information, Pricing data and Drug data

• Migrated Mappings, Sessions, and Workflows from Development to Test

• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.

• Created and monitored sessions and batches to run the mappings.

• Verified the application behavior and reports on converted data and identified and resolved data issues or informed the Business if any other major issues found with the application and reports.

3) Longs Conversion Acquisition for CVS Pharmacy, USA at Tata Consultancy Services Limited in Woonsocket,RI USA Oct’08-July’09

Team Size: 60

Technology Used: Informatica Power Center 7.1(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Transformations), Oracle 10g, PL/SQL (Procedures, functions, packages),Unix Scripts, Control-M

Description: CVS Caremark Corporation acquired Longs Drug Stores Corp for $2.9 billion. The deal brought Longs drug stores which were almost 521 stores in California, Hawaii, Nevada and Arizona into the CVS fold. This acquisition was very critical for the CVS Corp as with this acquisition ,CVS acquired the business in West coast region .In the initial phase of this acquisition, I was involved in the requirement analysis and effort estimation of the project which consisted of converting all the Longs stores to CVS new RxConnect Dispensing system. Then I worked throughout the acquisition SDLC cycle .The first Longs Store was live on the new system by my team on 3 March’

Role and Responsibilities as Longs Acquisition Techno Functional Business Lead:

• Actively participated in the design phase for data conversion architecture.

• Involved in Meetings/Discussions with the site teams on regular basis as part of the requirement gathering.

• Understanding the usage of Database tables by different Module leads in Longs Development team. There were around 400 database tables out of which 280 are transactional tables.

• Involved in mapping rules/business logics in the mapping sheet for thousand of fields in Longs Database to map to the CVS RxConnect system’s Database with CVS team.

• Setting up meetings with different groups associated to the business model like Legal, Operations, IS etc to understand their needs.

• Involved in the preparation of High level Design (HLD) and Low Level Design (LLD) specifications.

• Involved in designing and developing the Informatica mappings and work flows for Data Conversion mechanism.

• Accountable for developing the mappings/scripts using Designer to build the business rules for each data element and load the longs data into CVS Database tables from the respective source systems.

• Worked on Unix scripts to process the extracted feed files sent from Longs system before loading process

• Most of the transformations viz., joiner, expression, aggregator, XML transformations, lookup, filter, router, sequence generator, pre/post SQL etc. are used in development.

• Extensively worked with the Informatica components such as Designer, repository manager, work flow manager and work flow monitor as part of the development and code deployment processes.

• Highly responsible for performance tuning, deliver the qualitative code and to meet the business requirements.

• Responsible for creating/updating the solution design documents for all the data elements which are in the conversion process.

• Analyzing data/code issues and providing the solution to the reported site teams.

• Designed dynamic Control-M jobs for conversion process and completed the scheduling of the jobs in Control-M setup for the testing of batch jobs.

• Supported the Production run of the conversion jobs throughout the rollout of all 500 stores.

4) Store Reports Functional Analysis and Performance Tuning in RxConnect System for CVS Pharmacy, USA at Tata Consultancy Services Limited Oct’07-Dec’07

Technology Used: PL/SQL, java

Description: The Store Reports are the critical part of the RxConnect System. There are majorly daily and weekly reports. The daily reports at the store are used either as a practice of legal reports and other help the store manager at the store to see the out of stock drugs, monitor the work performed by each pharmacist in each shift. The weekly reports normally are weekly sales report, Dispensing time report which Operations/Business look at to determine if the prescriptions are dispensed on time and what are the average sales per store /per drug etc .The accuracy and performance of these reports is very important.

Role and Responsibilities as Technical and Functional Analyst

• Worked with business leaders to translate business needs and requirements into technical specifications.

• Lead the development of conceptual, logical and physical architectures with technical teams (Application Development, Business Intelligence, Data Reporting, Quality Assurance).

• Worked with other area managers/store managers and assigned Project Manager.

• Visited CVS Pharmacy stores frequently to understand the pain areas to resolve the issues.

• Participated in the entire project lifecycle, from due diligence to implementation.

• Review and confirm requirements, plans, designs and other deliverables.

• Provided expertise and lead architecture solution on a broader range of business systems, either across Regions or technology Domains.

• Performed complex analysis, consulting and providing solution recommendations to clients.

• Proficient with the current software development technology, tools and pharmacy practices to determine the technology to be used.

• Review code for the performance tuning for the time consuming report queries which was affecting business at the store specially Customer Reports.

• Represent the business issues and needs to other IT areas.

• Proved good leadership skills and was able to motivate and develop other team members

5) Tlog Module Development in RxConnect System for CVS Pharmacy,USA at Tata Consultancy Services Limited in Gurgaon,India Mar’07-Oct’07

Technology Used: Informatica Power Center 7.1(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), Oracle 9i, PL/SQL (Procedures, functions, packages),Unix Scripts, Java Swings

DESCRIPTION: RxConnect System CVS/pharmacy is the nation's largest retail pharmacy chain, with approximately 7000 stores across 38 states. With more than 40 years of dynamic growth in the retail pharmacy industry, CVS/pharmacy generates over 68% of its revenue from the pharmacy business and is committed to providing superior customer service - to being the easiest pharmacy retailer for customers to use. CVS/pharmacy fills more than one of every seven retail prescriptions in America, and one of every five in our own markets. What's more, our Extra Care program boasts over 50 million cardholders, making it the largest and most successful retail loyalty program in the country. Tlog was an important part of the system dealing with the financial feeds for all the transactions. These financial feeds were an output feed from the system for all the stores. These feeds were the input to various other downstream systems like Mainframe System for financial analysis, sales etc.This was also a feed for the TPMS (Third Party Management System) which is a system at CVS that manages finances/billing with various Third Parties.

Role and Responsibilities as Development Module Lead

• Managing the team and answering the queries raised by the team independently or consulting the Business users.

• Actively participated in the design phase for Tlog architecture.

• Involved in Meetings/Discussions with the onsite teams on regular basis as part of the requirement gathering.

• Involved in the preparation of High level Design (HLD) and Low Level Design (LLD) i.e. mapping document with field level specifications.

• Involved in designing and developing the Informatica mappings and work flows for Tlog generation

• Accountable for developing the scripts using PL/SQL to build the business rules for each data element and fetch from the Database fields.

• Extensively worked with the Informatica components such as Designer, repository manager, work flow manager and work flow monitor as part of the development and code deployment processes.

• Highly responsible for performance tuning, deliver the qualitative code and to meet the business requirements.

• Responsible for creating/updating the solution design documents for all the data elements which are in the conversion process.

6) Performance Tuning of RxConnect batches and RxConnect Application to be deployed in 7000 stores

Technology Used: Informatica Power Center 7.1(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Mapping Designer, Transformations), Oracle 9i, PL/SQL (Procedures, functions, packages), Java Swings

DESCRIPTION RxConnect is an Enterprise Pharmacy Management System for CVS/Pharmacy, one of the largest pharmacy chains in the United States. CVS/pharmacy® fills one of every eight retail prescriptions in America. The RxConnect application is being built to meet the CVS Store operations needs. It is an online transactional software system enabling pharmacies to address the needs of prescription filling, drug dispensing and verification activities. The system captures all interactions with the CVS customer and provides functionality to fill the prescription in an easy and efficient manner. The system will support the CVS enterprise organization consisting of multiple pharmacies dispersed across a large geographic area.

System is based on JAVA/J2EE technology stack. Application has a thick-client designed using JAVA Swings and uses HTTP for Client/Server communication. Application is deployed on Web Logic environment with 20 Web Logic instances on AIX environment. The two major technologies used in the project were Java for the front end application and Oracle as the Database and Informatica to load the data from the older system to new system. Other technologies used in the system are JMS, JAXB, JTA and JDBC, Oracle 10g as Central Database, MySql as Store database and Informatica for ETL.

Role and Responsibilities as Performance ETL Analyst

Performance Tuning of the Pl/Sql queries, ETL code and RxConnect Application Java Code in the PT team

• Improved performance of the pl/sql queries used throughout the Java code in the application.

• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.

• Worked as part of Performance SWAT team, responsible for analysis of performance related issues and providing solutions.

• Analyze functional intermodule impact of all performance changes done in the system.

Responsibilities as Technical Analyst/Designer:

• Interacting with Business Users and providing solutions for implementation of the business processes.

• Technical and functional Assessment of changes driven by new business requirements.

• Providing functional and technical inputs to the design team.

• Reviewing the Design Deliverables.

• Induction trainings for new joiners and explaining the functionality to Testing team.

Other Responsibilities:

• Playing an active and parallel role in the Build Maintenance Cycle of the project. This involves root cause analysis of production issues, defect fixing, impact analysis of Change Requests, effort estimation for Change Requests, development of Change Request and coordinating with the offshore for the timely delivery of the build in production.

• Presenting the Build Contents on each delivery to the stakeholders representing the Business and Operations of retail CVS Pharmacy.

7) Communication Subway ,AZZARO WEB SITE and software for THE NATIONAL LEVEL TECHNICAL AND CULTURAL FEST held at HARYANA ENGG COLLEGE (Btech Projects) Jun’04& Jun’05

Technology Used: Jsp, java Servlets and java scripting. (Running on tomcat apache web server), MySql, HTML, JDBC Connector ---Btech Project

DESCRIPTION: This project works as a communication subway .The aim of the project is to provide two services i.e. mail service, matrimonial service within an organization. Clients can write, send and receive mails as well as can maintain their address book. Clients can add their profile and can search their suitable match using matrimonial service. The attracting feature of the project is that this project can work even if the server is down members within the organization can communicate with each other. This project provides you services that are implemented at server side using Servlets and can be accessed through the clients all over the network and the clients can have any platform-linux/unix/Microsoft O.S or any operating system and any web browser (Mozilla, Netscape, Internet explorer)

Credits

_________________________________________________________________________________________________

• Informatica Certified Designer

• Hippa Certified while working with CVS Pharmacy

• Performance Engineering - Level 1.0 Certification [TCS Internal]

• Appreciated amongst top 10 IT analysts out of team of 270 TCS team members by CVS Client Managers.

• Participated in various school level Debates and Quizzes

• Participated in Technical Quiz in Technical Fest at DAV GIRLS COLLEGE, Jagadhri in 2003

• Won First Prize in Paper Presentation on Ad-hoc networking at Azzaro, the National Level Technical Symposium in 2005.

• Participated in a Quiz, Paper Presentation and Group Discussion at Vedanta, The Technical Fest at JMIT, Radaur in 2005.

• Won Second Prize in Paper Presentation on NAT SERVER at Azzaro, the National Level Technical Symposium in 2006

• Won Second Prize in Paper Presentation on IPTV at Azzaro, the National Level Technical Symposium in 2006.

REFERENCES

CVS Project –

Lidia Ramos–Business Lead

Email Id: nqa251@r.postjobfree.com

Contact No. : 508-***-****

TCS Project –

Gaurav Talwar– Team Lead

Email:nqa251@r.postjobfree.com

Contact No: 401-***-****

Contact this candidate