SIDDHARTH SHANTARAM ANVEKAR

PHONE : 615-***-****

E-MAIL : acz1n7@r.postjobfree.com

OBJECTIVE

Seeking better, new, challenging opportunities in software development, that provide me with a platform to give a complete and impactful expression to my technical competencies, also help to discover and equip new technical and domain skills, thereby expanding and perfecting my sphere of knowledge. PROFESSIONAL SUMMARY

• 15+ years of IT experience in applications on Microsoft Technologies like VB, .Net, SQL Server 2000/2005/2008/2008R2, SSIS, SSRS, C# and Teradata.

• Highly skilled in Analysis, Design and Development of application software and ETL using SSIS, SQL Server, particularly in the use of Microsoft technologies and also using TERADATA and DMExpress.

• Strong background in HealthCare Insurance Domain. Experience working with healthcare data.

• Primary responsibilities have included Application development, ETL, Database modeling, system testing, analysis and design, implementation and project documentation.

• Solid experience working with SSIS development. Excellent understanding of relational and dimensional data models.

• Ability to work independently and as part of a team.

• Worked with Teradata utilities like BTEQ, Fast Load.

• Experience in Version Control System SVN, VSS, TFS.

• Experience reporting software like SSRS, Crystal Reports, SAP BO Web Intelligence 4.1.

• Ability to quickly adapt to new environments and learn new technologies.

• Excellent analytical capabilities and good communication skills. TECHNICAL PROFICIENCIES

• ETL Tools : DTS, SSIS, DTS Xchange,DMExpress

• Reporting Tools : SAP Crystal Reports 2008, SSRS, SAP Business Objects Web Intelligence 4.1

• Relational Databases : TERADATA, SQLServer 7.0/2000/2005/2008/2008R2/2014, Oracle 8i/9i, MS Access

• Languages : C#, VB 6.0, SQL, PL/SQL, Java, C, COBOL

• Framework : COM, DCOM, .Net

• Development Environment : MS Visual Studio.Net, Visual Studio 5.0/6.0

• Operating Systems : Windows 95/NT/2000/XP, Red Hat Linux, Unix and DOS 6.2.

• Scripting Languages : JavaScript, VBScript, HTML, DHTML and XML.

• Web Technologies : Ajax, Web Services

• Internet Tools : ASP.NET, Visual Interdev

• Web Server : IIS 5.0/4.0

• Data Modeling Tools : MS Visio

• Others : Agile, MS VSS, Tortoise SVN, MS Project 2007, Zeke. ACADEMIC QUALIFICATION

• BSc(Statistics) – 1995

• PGDCSA (Post Graduate Diploma in Computer Science and Applications), University of Mumbai. – 1996 PROFESSIONAL EXPERIENCE

EMPLOYER: Cognizant Technology Solutions INC.

Employment Duration : Oct 2014 Till Date

Designation : Manager – Projects

I. Responsibilities: Client : One West Bank. Pasadena, CA. Role Played : Systems Data Analyst.

Duration: Jan 2017 Till Date.

Responsibilities:

• Participate in system analysis and root cause analysis

• Facilitate and participate with the client to create business requirements.

• Create design specifications documents and interaction flow diagrams.

• Provide guidance on strategies that minimize implementation risk and time and/or improve system reliability and performance.

• Develop and review ETL(Extract Transform and Load) process programs and scripts using SQL Server, Oracle, Business Objects Desktop Intelligence, SSIS, C# scripting etc.

• Generate Analytics reports using SSRS, MSExcel and SAP BO Web Intelligence 4.1.

• Conduct business requirements walkthrough sessions with required stakeholders.

• Offshore coordination to discuss the deliverables on a daily basis to exchange project updates. Projects :

CIT BIR Dev and Enhancements .

Servicing Profitability Analysis (SPA) : Jan 2017 Till Date The aim of this project is to migrate 600+ SAP Business Objects (Desktop Intelligence Reports) reports from version 3.1 to SAP BO Web Intelligence version 4.1 . Apart from this there is also a need to develop some reports in SSRS 2012. During this conversion all the new functionalities of the new version will be implemented. These Business Intelligence reports helps the customer to use profitability analysis to evaluate customers. These Analysis helps the management to identify the most and least profitable clients, identify the most and least profitable products or services, discover which sources of information offer the most reliable facts,evolving the product mix to maximize profits in the medium and long term, isolate and remedy the causes of decreasing profit margins. Apart from this, data integration ETL jobs are being developed in SSIS 2012, SQL server 2012 and Oracle. Jobs involve loading the data from customers OLTP applications as well as 3rd Party financial institutions into the Service Data Mart Application.

Environment : SQL Server 2012, SSIS 2012, SSRS, C# Scripting, SAP BO Web Intelligence 4.1, MS Excel, Oracle. II. Client : Pepsico Inc. White Plains, NY

Role Played : Data Analyst/SSIS Tech Lead.

Duration : April 2016 Till Oct 2016.

Responsibilities :

• Migrating of Pepsico One Touch Middleware Migration From Dialog Directs Environment (SSIS 2008R2) to Pepsico Inhouse Env(SSIS 2014.)

• Schedu 875+ling of SSIS jobs in Dev, QA and Prod Environment using SQL Server Agent.

• SSIS performance Tuning. Version Control using TFS.

• Software testing using Platinum Software.

• Providing guidance on strategies that minimized implementation risks and time and/or improved system reliability and performance.

• Setting up the Hardware and Software Infrastructure needed to execute this ETL project and getting in touch with the necessary stakeholders for the successful execution for the project.

• Interacting and assigning project related work to the offshore resources. Projects :

Pepsico One Touch Middleware Migration . April 2016 Till Oct 2016 The aim of this project is to migrate and execute this middleware ETL from pepsicos third party vendor to pepsico in house.This ETL process is part of the Pepsico initiative to support and provide services to all Frito-Lay retail accounts through transforming several source files provided by PepsiCo( Bottlers list and Customers List)and Frito Lay( Customers list, Routing list and geography list) . These files contain the Chain and Banner information as well. PepsiCo OneTouch is a “program” (or offering to retail customers) for supporting DSD retail operations. OneTouch sits on a PepsiCo implementation of Microsoft Dynamics CRM. OneTouch program of PepsiCo operates by loading Frito-Lay and Pepsi customer master records to CRM, and entering inbound customer service requests from retail account into the One- Touch CRM program.

Environment : SQL Server 2014, SSIS 2014, C# Scripting, Powershell, TIBCO, FMS. III. Client : Humana Inc., Louisville, KY

Role Played: Data Analyst / SSIS Tech Lead.

Duration : Jan 2015 To March 2016

Responsibilities :

• Migrating and Reengineering of DTS/SSIS 2008 to SSIS 2008 R2.

• Understand the CART Tool Business requirements and implement the same in Transactional SQL blocks for campaign processing.

• Creating Analysis reports related to CART application data using SSRS and MS Excel.

• Scheduling of SSIS jobs in Dev, QA and Prod Environment using SQL Server Agent.

• SQL Query Performance Tuning.

• SSIS performance Tuning. Version Control using TFS.

• Migrating required data from multiple databases to a central repository for Qlikview reporting team using SSIS, SQL Server 2008 R2,C# Scripting

• Participate in Analysis, Root Cause Analysis.

• Creating Design documents as required.

• Conduct Business Requirements walkthrough sessions with Required Stake Holders.

• Support Adhoc Report Requests for Guidance Center Team for their Data Analysis using SQL, SSRS and MS Excel.

• Providing guidance on strategies that minimized implementation risks and time and/or improved system reliability and performance.

Projects :

CART (Career Agent Retention Tool) Reengineering Jan 2015 till March 2016 Reengineering of CART Tool that will help the Marketing and Sales team to create various types of Campaigns to help Member and Agent Retention and thereby help Humana in increasing their Star Rating in the Insurance industry for their services .

Environment : SQL Server 2008R2, SSIS, TFS, SSRS, MSExcel, C# Scripting. IV. Client : Credit-Suisse, NY

As one of the world’s leading banks, Credit Suisse is committed to delivering financial experience and expertise to corporate, institutional and government clients and to ultrahigh-net-worth and high-net-worth individuals worldwide, in addition to affluent and retail clients in Switzerland. The integrated business model combines the resources of its two divisions, allowing to provide comprehensive solutions to the clients. Founded in 1856, it has operations in over 50 countries and employs 45,100 individuals from approximately 150 different nations. Role Played: SSIS Tech Lead

Duration : Oct 2014 To Dec 2014

• Migrating 2008 SSIS packages to SSDT-BI SSIS

• Performance Tuning SQL and SSIS Packages

• Resolving tickets related to Production issues.

• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008/2012 using SSIS

• Scheduling of SSIS jobs in Dev, QA and Prod Environment using SQL Server Agent. Project : Data Integration Oct 2014 to Dec 2014

Migrating existing SSIS 2008R2 ETL packages to SSDT-BI SSIS and thereby implementing the new features of SSDT_BI SSIS.

Environment : SQL Server 2008R2, SSIS, SSDT-BI, SPEAR Tool, TFS

EMPLOYER : SYNTEL Consulting Inc.

Emploment Duration : July 2003 – Oct 2014

Designation : Senior Project Lead.

I. Client : Hospital Corporation of America (HCA), Nashville, TN, USA Hospital Corporation of America (HCA) is an American for-profit operator of health care facilities, the largest in the world. It is based in Nashville, Tennessee and currently manages 162 hospitals and 113 freestanding surgery centers in the United States and United Kingdom.

Role Played : Senior ETL Developer

Duration : Jun 2013 – Oct 2014

Responsibilities:

• Develop and Review Extract, Transform and Load (ETL) processes programs and scripts, using Teradata, DMExpress, SSIS, SQL Server, Unix.

• Perform the role of Database Developer/ETL Architect using TERADATA and DM Express.

• Provide guidance on strategies that minimize implementation risk and time and/or improve system reliability and performance.

• Using BTEQ (Basic Teardata Query utility )scripts to Create Database Objects.

• SQL Performance tuning.

• SSIS Performance Tuning.

• Creating Views, Stored Procedures, Triggers, User Defined Functions as and when required.

• Scheduling of SSIS jobs in Dev, QA and Prod Environment using SQL Server Agent.

• Configuration and Release management using ZEKE. Projects :

Clinical Data Management. Jun 2013 – Oct 2014

CDM is a joint initiative between the Clinical Services Group and IT&S of HCA to provide a venue to standardize and normalize the silos of data across the Enterprise into a single Clinical Data Warehouse with reporting, analytic and soon data exchange capabilities for the operator and leadership of HCA facilities. The analytic capability will allow for support of physician leader to identify opportunities to improve efficiencies and effectiveness of care as well as understand the clinical drivers of technology utilization and patient thoroughput. Additionally, it will begin HCA ability to manage and filter individual patient populations by a variety of criteria and increase HCA awareness of operations and services to better serve these populations.

Environment : Teradata, SyncSort DMExpress, SQL Server 2008 R2, SSIS, UNIX shell Scripting, DocLib II. Client: Humana Inc, Louisville, KY, USA

Humana Inc. is an American managed health care company that markets and administers health insurance. Humana offers a range of products and services in addition to group health insurance. Their lines of business serve the military, individuals, seniors, and many others. They also offer specialty products, and other innovative consumer initiative products, services, and partnerships that are focused on consumers. Role Played : Project Lead/ Reporting Manager.

Duration : July 2003 – Jun 2013

Responsibilities:

• Develop and Review Extract, Transform and Load (ETL) processes programs and scripts, using DTS/SSIS (SQLServer 2005 /2008/2008R2 Integration Services)

• Creating Reports in SSRS.

• Perform the role of Database Developer/Architect using SQL Server 2000/2005/2008/2008R2

• Creating web applications using Technologies like ASP.Net, ADO.Net, WebServices, Ajax, C#, ASP, ADO, COM, IIS, VB6.0, JavaScript, VBScript.

• Monitored Unit testing,system testing and creating test cases using SQUIDS

• Onsite/Offshore Collaboration

• Provide guidance on strategies that minimize implementation risk and time and/or improve system reliability and performance.

• Performance tuning using SQL Query Analyser/Management Studio.

• Configuration and Release management.

• LOB Staffing Management.

Projects:

APEX [ Accelerated Provider Exchange] Jan 2013 – Jun 2013 Provider Single Point Plus (PSP+) is a workflow and contract loading application built by Humana IT.It is being migrated into Accxelerated Provider Exchange (APEX) which is being developed in PEGA BPM tool. Environment : SSIS, SSRS, SQL Server 2008 R2, Pega BPM, Web Services,WCF,.Net Framework 3.5,ADO.net. PIMS (Provider Information Mngmt System) SQL 2008 SSIS conversion (Phase II) Aug 2012 – Dec 2013 Under this project, 2nd Phase of conversion of PIMS SQL Server 2000 DTS packages/Batch jobs is being converted to SQL server 2008 SSIS packages.

Environment : SSIS, SSRS, DTS, SQL Server 2008 R2, C# Scripting. ReCredentialing Automation Nov 2011 – Jun 2012

Contracted providers must be re-credentialed every three years. This Project brought Re-credentialing Automation Tool up to date and automated the process of tracking provider during the re-credentialing process. Environment : SSIS, SSRS, SQL Server 2008 R2, C# Scripting Directory Validation and Comparison Automation Aug 2011 – Oct 2011 The purpose of this project is to automate the process of identifying contracted providers in CAS (Claims Adjudication System) & MTV (Metavance) that are NOT printing in directories. These reports would strengthen Humanas ability to provide more complete and accurate, provider directories to their members. Environment : SSIS, SSRS, SQL Server 2008, C# Scripting Provider Directory Audit Automation April 2011 – Jul 2011 Business users need the ability to ensure all providers from an Excel spreadsheet are included in the final Provider Directory PDF. There are multiple PDFs, so an automated solution will prevent business users from having to perform a manual one to one search from the spreadsheet into the PDFs. Environment : SSIS, SSRS, SQL Server 2008, Webservices, .Net Framework 3.0, PDF Documents. PIMS SQL 2008 SSIS conversion(Phase I) Dec 2010 – April 2011 Under this project, conversion of PIMS SQL Server 2000 DTS packages/Batch jobs is being converted to SQL server 2008 SSIS packages. Use of third party tool DTSXchange is also being used for conversion. Environment : SSIS, SSRS, SQL Server 2000, DTS, SQL Server 2008, DTSXchange. Provider Communication Preferences: Oct 2010 - Feb 2011 The goal of this project is to develop end to end process to store, manage and deliver provider communication preferences via Self-service (modified Manage My Demographics application (MMD)), and store the preferences in provider database (PIMS).

Environment : ASP.Net, SQL Server, VS.Net, ADO.net, webservices, C#,SSIS, VSS, HTML, DHTML, javaScript. Physician Performance Indicator (PPI) Mar 2010 – Sept 2010 This Application will create a one-stop shop for provider to review both efficiency and effectiveness data. This project seeks to enhance the current communication process between Humana and their contracted providers, and also to streamline efforts with and for the Quality department. Environment : ASP.net, ADO.net, Webservices, Silverlight, SQL Server 2008, SSIS, VSS, HTML, DHTML, JavaScript. ERA/EFT (Electronic Remittance Account\Electronic Fund Transfer) Dec 2009 – Mar 2010 Provide the ability for all providers, vendors, and associates (secured and unsecured), vendor or Humana associate to fill out an ERA or ERA/EFT setup/maintenance request online. Environment : ASP.net, Webservices, Ajax, SQL Server 2005, SSIS, VS.Net, C#, VSS, HTML, DHTML, JavaScript, XML.

DCAV (Data Collection and Verification) - Provider Self Service via Provider Portal June 2008 to Oct 2009

This tool adds a new feature to the Provider Portal enabling a provider, or his agent, to update non sensitive information directly to PIMS, and sensitive information directly to a Provider Single Point queue. It presents the provider with their current known demographics information, allowing updates to both sensitive and non-sensitive information through appropriate channels.

Environment : ASP.net, Webservices, Ajax, SQL Server 2005, SSIS, VS.Net, C#, XML, VSS. Dentist Homepage (Dentist Finder and Dentist Portal) Mar 2008 to May 2008 This tool provides the ability for registered, in-network dentists to enter and maintain their own office hours, spoken language, and the provider’s web address by logging into provider portal. Environment : ASP.net, SQL Server 2000, C#, DTS, VSS, HTML, DHTML, javaScript, XML. Humana Provider (Humana’s My Choice Tools) Mar 2007 to Oct 2007 Humana's MyChoice tools helps user choose providers wisely while utilizing benefits with confidence. The tools use easy-to-understand numbers and graphics to show estimated costs for common procedures and conditions, along with other useful information for patients to discuss with their doctor. Environment : ASP.net, Webservices, SQL Server 2005, SSIS, VS.Net, C#, XML, VSS, HTML, DHTML, javaScript. Humana Provider (e2 Spirit: Physician Effectiveness) Oct 2006 to Mar 2007 This PET web application provides information on an individual physician’s performance in treating a specific condition based on Humana claims data.

Environment : SQL Server 2000, DTS.

E2 Spirit (Physician Transparency and Hospital Cost Data) Mar 2006 to Sept 2006 The transparency project created the web tools and data to allow Humana Health Plan members to view cost performance and process of care performance measures for both physicians and hospitals on the Internet. The tools allow members to have information to make informed decisions regarding their health care. Environment : ASP.Net, SQL Server 2000, VS.Net, Webservices, C#, HTML, DHTML, javaScript,XML. Provider Architecture Reengineering (Humana MCD Provider Impact) Dec 2004 to Feb 2006 Re-Engineering Architecture project specifically relates to the capture and/or maintenance of Provider Information data, the creation of Provider Directories, or supporting Directory processes and interfaces in or out of the data repository. Environment : ASP, SQL Server 2000, Visual Studio, COM, DCOM, IIS, MTS, Javascript, VbScript,HTML, DHTML, VB6.0, DTS, VSS.

Dynamic Plan Load (Rel 4.4, 4.3, 4.1). Sept 2003 to Dec 2004 The Dynamic Plan Load Project (DPL) is intended to reduce Humana's administrative cost by streamlining the process to design, build and modify benefit plans in Metavance (EDS developed Platform handling Enrollment, Claims etc) which are taken from the Product Database.

Environment : ASP, SQL Server 2000, Visual Studio, COM, DCOM, IIS, MTS, Javascript, VbScript,HTML, DHTML, VB6.0, VSS.

EMPLOYER : ION EXCHANGE [INDIA] LIMITED

Ion Exchange India is premier company in water, waste water treatment, and environment management products and services, with a strong international presence.

Employment Duration : May 2000 – April 2001

Designation: Senior Programmer

Responsibilities:

• Creating windows applications using Technologies like VB, COM, SQL Server 7, MTS

• Architect applications using SQL Server and VB, MTS

• Creating Database Design specification

• Performance Tuning

EMPLOYER : DESS TECHNOLOGIES

Dess Technologies provides software solutions in the areas of Imaging and workflow management. Employment Duration : Feb 2000 – May 2000

Designation: Senior Programmer

Responsibilities:

• Creating web applications using Technologies such as VBScript, JavaScript, HTML, ASP,IIS, Access 97.

• Documentation.

EMPLOYER : SOFTSCRIPT SYSTEMS AND SERVICES PVT LIMITED SOFSCRIPT is into Healthcare Info solutions .Their other expertise includes Engineering Applications, Commercial Applications and Training & Education.

Employment Duration : July 1998 – Feb 2000

Designation: Senior Programmer

Responsibilities:

• Creating windows applications using Technologies like VB, COM, SQL Server 7, MTS

• Architect applications using SQL Server and VB, MTS

• Creating Database Design specification

• Performance Tuning

HOBBIES

Travelling, Reading, Stamps collecting, and Photography.

Contact this candidate