Upendra Panwar

Cell # 201-***-****

Email adci5u@r.postjobfree.com

Energetic and Accomplished technical leader with over 12+ years of IT, Data Warehousing, BI, Data/Business/System Analysis, OLAP & OLTP Reporting Applications Management in complex and data driven organizations:

Expertise in ETL Informatica development, programming with Oracle 12c/11g, working on Very Large Scale Databases including OLTP, DWH and ETL environments.

Interact with management team at a high-level concerning the alignment of the data warehouse and BI capabilities with long-term business goals.

Working closely with BA, Offshore and Onsite developers and DBA teams on functional and technical requirements, development, QA, and releasing code to production.

Experience in full SDLC Dev. using Agile/Rapid Software Development Methodologies, from HLD, DD, Test Plans, coding then Unit & String Testing and providing support in Integration & System Testing and Defect Fixing to Production Support.

Expertise in various Database and query languages such as Oracle, PL/SQL, SQL, SQL Server, MySQL, AWS RDS.

Experience of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables.

Assist in implementation and execution of the data quality program to ensure data quality standards are being met. Adheres to the structure, best practices, storage needs of the data lineage.

Demonstrated analytical ability to understand the business requirement/process, convert the business specification to technical document, data management, develop and integrate solutions to meet the Clients custom requirements.

Extensively involved in System Analysis, Client-Server Software Architecture, Application Design, Development and Implementation of database systems (SDLC).

Technical Skills/Specialties:

Power Center, Informatica Power Exchange, Informatica Data Services, SSIS, Business Objects, Oracle, SQL Server, DB2, Unix, Predictive Analytics, Python, R, Dimensional Modelling & ETL Architecture, Oracle 12c/11g, PL/SQL, OEM.

Professional Experience

Grand Circle Corporation 31 Mar 14 – till date

GCC is the largest U.S. provider of international vacations for Americans aged 50 and older. We’re a family of three brands: Grand Circle Cruise Line, Overseas Adventure Travel, and Grand Circle Travel.

Senior DW-ETL/SQL Developer

Worked with both technical staff and business constituents to translate business requirements into technical solutions.

Responsible for analyzing Requirement Documents and converting Functional Requirements into Technical Specifications.

Responsible for Unit Testing and Integration testing of mappings and workflows and migrations to all the environments/

Extensively worked with SCDs slowly changing dimensions Type 1, Type 2, and Type 3.

Overseeing requirements definition, architecture, data integration development of multiple feeds data to ODS (Operational Data Store) and DM and report writing.

Lead and mentored onsite and offshore Developers and review code of Mappings and other ETL objects developed by other developers.

Work closely with other IT staff to meet expectations for design reviews and coding standards.

Extensively worked with BI Reporting to help them on designing data visualizations reports and dashboards using Business Objects, and Tableau.

Responsible for the scoping, planning, and execution of a portfolio of IT BI & Data Warehouse projects.

Responsible for leading offshore Developers and Conduct code reviews and validations for onshore developer’s deliverables, and ensure that proper level (as required by SDLC) of design documentation, traceability and test coverage are in place for functional and non-functional requirements.

Resolutions using Session Logs, and Workflow Logs and also Responsible for determining the bottlenecks in existing code and fixing the bottlenecks with performance tuning.

Delivering Business Intelligence (BI) and Reporting solutions for Business Performance Management (BPM), Online Analytical Processing (OLAP), Predictive Modeling and Forecasting applications.

Information Architecture, Enterprise Information Management, Business Intelligence / Data Warehousing, Master Data Management.

Accomplishments:

Successfully Implemented CVENT (NCA) Data to associated with existing behavioral marketing campaigns to send emails to customers.

Successfully implemented FULLFILLMENT process by which GCC sends printed mail items to our customers through different channels. Ex: Brochures (Requested by phone), Print on Demand(WEB) etc.

Improved call center issue log service efficiency by overhauling previously haphazard correspondence management systems. We were missing support help desk using manual track of all the tickets.

Worked on migration legacy reservation from different source to build consistent system for all the customers travelled with GCC to improve company overall reports and PAX.

IkaSystems Corporation 30 Mar 10 – 30 Mar 14

IkaSystems delivers business automation and process solutions that transform how health plans conduct Commercial, Medicare, Medicaid and Accountable Care Organization (ACO) business. IKa’s solutions automate key processes for sales, marketing, regulatory compliance, claims administration, customer service, quality management, and revenue optimization – all on an integrated, Web-based platform that’s fast and scalable

D4C (Diagnosis for Care):

The purpose of ikaD4C is to assist medical record reviewers and providers in coding diagnoses correctly, and achieving a precisely correct diagnosis is a critical provider function and contributes importantly to appropriate management and treatment decisions.

RAPS (Risk Adjustment Payment System):

Risk Adjustment Payment System (RAPS) is a system used to provide information for a risk adjusted payment under the Centers for Medicare & Medicaid Services – Hierarchical Condition Category (CMS-HCC) payment model.

Sr Software Engineer

Work closely with Clients and Business analysts to fully understand business requirements and come up with the design.

Transforming Clients Legacy System data and Loading years of data into the OLTP DB’s using complex SQL Loader routines.

Worked extensively with the business intelligence team to incorporate any changes that they need in the extracts.

Responsible for Optimizing the Code, performance Improvements and Code standardizations.

Data Validation and data quality checks at database level using SQL scripts.

Responsible for the development and implementation of hundreds of Interfaces and Data Extracts.

Accomplishments:

Implemented Ika Health Exchange Platform (HIX) using Oracle and .NET. Leading the implementation and development for the IKA Health Exchange Platform Reports like Call Center, Correspondence, Member Plan change, new member added, EFT Letters from a HIX perspective.

Successful migrated and delivered Call center reporting project on 11g.

Kendle International Inc, 9th May 08 – 15th Mar 10

Kendle provides full service CRO conducting clinical research and providing pharma consulting to help develop the medicines people need, work on studies from early to late phase.

.

Trial Watch (Clinical Research Organization)

Trial Watch (TW) is Kendle’s Proprietary management information system that standardizes the collection, management, and distribution of project data.

Sr Software Engineer

Analyze business processes and application requirements to produce formal analysis and Technical design documents.

Understand the customer requirement, project planning and timeline management.

Created SQL Packages, stored procedures, functions, triggers and views using PL/SQL/T-SQL

DBMS Jobs to automate jobs and loading data into the Database using SQL* Loader.

Accomplishments:

Successfully implemented Bi –directional Replication setup between US and UK to access the patient’s information at the same time to work on studies.

Successfully implemented automate bridge between TW and Trial Line to help company to access studies data for both the system.

Lionbridge Technologies Mumbai 4th Dec 06 – 15th Dec 07

Lionbridge provide translation, online marketing, global content management and application testing solutions that ensure global brand consistency, local relevancy and technical usability across all touch points of the global customer lifecycle

Pearson Success Maker Enterprise

This project is based on E-Learning Application developed by Pearson Education system Project development and testing environment deployment on internet via Web logic clustering, using web service like apache, has physical load balancer, has an oracle database, which is on Solaris environment.

Sr. Oracle Developer

Extensive use of performance tools like AWR, TKPROF and Explain plan for performance monitoring and troubleshooting.

Wrote Unix Shell scripts for hot backups, SQL Loads, export and import of database

Developed PL/SQL Packages, Functions, Procedures, and Triggers to implement the Business Logic.

Planning, capacity and timeline management for SMe modules.

Involved in Production Readiness checklist for Pre and post-production support.

Employer: Focus Management Mumbai 6th Jun 06 – 3rd Dec 06

Client: Pearson Education Technologies Chandler USA

Pearson Success Net

This project is based on E-Learning Application developed by Pearson Education system

Project development and testing environment deployment on internet via Web logic clustering,

Using web service like apache, has physical load balancer, has an oracle database, which is on solaris

environment.

Sr Programmer Analyst

Production DBA 7*24 Support in highly paced and dynamic environment.

Schema Management and control, Synchronization of Production and Test environments.

Leading member of Performance Tuning Task Force for Proactive Tuning and monitoring of Very large databases (Multi-Terabyte Databases).

Lead Performance and Tuning Task Force for proactive performance monitoring.

Accomplishments:

Successfully completed Sybase replication to help all SMe’s modules in the company to use multiple systems to help business.

Developed installed shield application to create Sybase database and SMe application.

3i-InfoTech 7th Nov 05 – 5th June 06

3i InfoTech is a public global Information Technology company committed to Empowering Business Transformation. The Company is also focused on value added services such as business intelligence & analytics services, infrastructure management services, testing & compliance, application development & maintenance, consulting and its BPO offerings.

Web Bounce Management System (WBMS)

Web bounce system is designed for tracking bounce cheques details against the bank statement. Various MIS are getting generated through this application as an input to other applications like Finnone and RECON.

PDC Factories (POST DATED CHEQUE)

PDC Factory is a centralized application for storing, managing and banking the PDC instruments Administration and Security of users.

Software Consultant

Creation of Batch Provision Utility for PL/SQL packages/procedure calling.

Developed, implemented and unit tested Invoice Order Interface. This involved importing data from the legacy system into staging tables using SQL Loader, validating the data using PL/SQL procedure.

Created Stored Procedures, Packages, Functions, database Triggers for the Retirement info module.

Remote monitoring and tuning of Database Processes in the Client environment.

Writing Shell scripting for File transfers to SFTP location.

Accomplishments:

Learnt how to interact with client and get the requirements.

BKP-Consultants Mumbai 6th Jan 05 – 14th Sep 05

BKP Consultants Pvt., Ltd. operates as a telecom and information technology consulting company.

The company specializes in wireless networks and health care management systems.

NAT (Network Analysis Tool).

NAT is product of BKP-Consultants that is based on GSM and CDMA technologies. NAT is Network Analysis Tool that works on the OMCs of the MSC for the telecom vendors. Like Tata, Tele Services and Hutch, NAT is used by the telecom vendors for generating various reports that helps for the network analysis and managerial decisions.

Software Engineer

Creation of database schema, Roles, Table spaces, Rollback Segments.

Written the Unix Script to the run the multiples control files written in SQL Loader.

Automated routine DBA tasks of database monitoring thru shell / SQL scripts Responsible for proactive management.

Experience in developing web application using ORACLE.

Monitoring database using Oracle Enterprise Manager or TOAD (Tables paces, Data files, Jobs, Users, sessions, Processes).

Accomplishments:

Designed data model and migrated from SQL SERVER to ORACLE.

Reference: Available upon request

Contact this candidate