Data Developer

VIKAS KUMAR

GUPTA

(*****.*****.**@*****.***)

+91-701*******, +91-953*******

PAGE 1 OF 5

EXPERIENCE SUMMARY

Over a decade of rich experience in Requirement Gathering, Software Design & Architecture, Application Development, Testing, Product Deployment, Configuration && Customization the Product functionalities as per the client requirement needs, Identify the root cause of recurring issue of End user query in existing ongoing application and to address with a concrete fix for long term with surprising degree of accuracy as well as Technical Production Support of Client Request. Responsible for delivering solutions to clients according to requirements. That includes client solution design, configuration, testing, implementation etc.

Excellent track record of success in delivering solutions that drive business value with domain expertise that includes the integration of OLTP [CRM, SFA, AGS && Third-Party Source], Master Data Management (MDM) and ODS, Data Warehousing, Onekey, Hub by using ETL Methodology. Hands on experiences in integrating the application across the enterprise to simplify and automate business processes of Pharmaceutical Company.

Big picture leader with proven track record of working intelligently/individually to reach goals on time and significant Team Member/Leader for any Team.

Ability to adhere to with these competencies (i.e. Client Focus, Collaboration, Communication and Ownership) while implementing the end user requirement till deployment and encourage/motivate myself to do something innovate in existing functionality to the end user system.

Empowered the team to develop the high-quality technological solution to meet the needs of internal and external users with strict adherence to compliance protocols.

Expert in Agile software development methodologies and project execution techniques including Scrum and Kanban. Follows internal MAP (Methodology and Aligned Processes) Protocol [include best practices of ITIL, PMP, PMI and so on] while delivering products and services to end user.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. Good exposure in data warehouse development lifecycle, from gathering requirements to testing, implementation, and support for the data-warehouse as well as business-intelligence reports [basic knowledge] to be used by the management. Exceptional background in analysis, design, development, customization, implementation and testing of software applications.

Hands on experience in data migration, data migration testing. Expertise in PL/SQL development, Complex SQL Query Tuning Technique and Basic Oracle Database Administrator (Version 11g,12c), Oracle APEX.

Skilled at learning new concepts rapidly, can work well under pressure and able to communicate ideas clearly and effectively.

Hands-on wide experience of developing the ETL Job and generating the workflow by using Nucleus / Informatica Power Center tool (i.e. Mapping Designer, Workflow Manager and Repository Manager) and monitoring the running task (i.e. Workflow Monitor and Nucleus One-Point Dashboard).

Hands on experience in Unit Testing [TDD],Integration Testing, System Testing, Sanity Check as well as ETL Testing and also defect management tool as JIRA and Source Management Tool as “TFS”, Surround SCM 5.0.4 and utilize content Management Tool as SharePoint, ARCH, MS Office for storing/managing the project-related documents.

Hands on experience in Process Improvement, Re-engineering the existing functionality, Automation and Scheduling the Task by using Window Scheduler utility and Oracle Scheduler Packages.

Hands on experience to develop/API-testing/implementing web and window based application by using Visual Studio 2005 to 2017 Tool, include Technologies [ASP.NET Core 2.1 – 3.* && Standard Framework, WPF, WCS], Languages (C# 2.0 - 8.0, VB.NET) and Services [includes Window Service, REST Based API, Web Service and so on], Framework [2.* to 4 MVC with Entity Framework using IoC [Inversion of Control]

&& DI.

Hands-on experience to integrate the various native and 3rd Party data source [i.e. Onekey,(Stateboard Data)State License Number, IMS HCOS, PDRP, WxDM,National Provider Identification (NPI), Drug Enforcement Administration (DEA), AMA, Vermont License Source Data, SAP ECC, Mobile Intelligence

[SFA], Veeva, Symphony, Aggregate Spend, Compliance ID DB and many more] data while providing the Customer MDM Solution to Life Science Company.

PROFESSIONAL WORK SUMMARY

1. Prolific Software craftsman seeks a good opportunity to work in challenging Environment in only Delhi NCR location.

Responsibilities and Roles:

AWS Foundational Services [i.e. EC2, VPC, S3,EBS], AWS Database Services[i.e. RDS, Amazon Aurora [Cloud DB]], In-Built Migration Services [i.e. DMS, SCT], AWS Management Services [i.e. AWS Auto Scaling, Elastic Load Balancing, Scaling, Application Health Monitoring]

Exploring New Technologies (i.e. Oracle Cloud Infrastructure, Oracle Machine Learning, Autonomous Data warehouse cloud) and learn it by using many tools (i.e. Tablet, Data Virtualization desktop – used for data analysis, Online oracle machine learning tool, SQL VIKAS KUMAR

GUPTA

(*****.*****.**@*****.***)

+91-701*******, +91-953*******

PAGE 2 OF 5

Developer), utilities (SQL Loader, Data Pump and External Table) and OCI object Storage [i.e. Bucket] and also doing some practically hands-on in Oracle Cloud portal and prepare POC for this activity.

Learning Path: Utilizing my skills to build a web-based application as a POC in Online Oracle APEX portal by using Oracle APEX tool [Version 19 Here, I am performing/learning both developer and administrator activities.

Passed PL/SQL Training Practice Exam in Oracle Learning Portal, sql oracle problem solving in Synergisticit Portal.

Learnt DBA Activities [i.e. Basic/Advanced Installation of Oracle Database 18c and Database Creation (using OUI and DBCA), User/Schema/Tablespace Management, Monitoring && Tune the database through EM application, Backup and Restore the database through RMAN, Oracle dump utility, Multiplexing, Data Guard [High Availability and Disaster Recovery], Replication Through Golden Gate and so on]

Learnt the test management activities by using Zephyr plug-in in JIRA Tool.

Learning Python and developing a simple project as a POC. 2. I had been associated with IQVIA [Formerly known as QuintlesIMS – IMS Health - Cegedim] as a post of Application Developer Spec2 position in Information Management (MDM) Team since March-10 to September-19.

Responsibilities and Roles:

Responsible for delivering solutions/products to clients according to requirements. That includes client solution design, configuration, testing, implementation etc.

Participated from inception to retirement of the product/Project [includes Kick-off meeting to Go Live, Signed-off Document and maintenance of the project [1 Month Hypercare Support] and till Launch Phase].

Participated in set up the environment [i.e. TEST, DEV as well as PROD] during implementing the defined project scope for internal/external client. Apply the Product Release [which is published by Product Team i.e. Service Update, Patch and Hotfix] in Client System based on its availability.

Participated in analyze the defined project scope with respect to provided functionalities and behavior of this tool and noted down the assumption && Constraints if we get in our analyzing.

Participated to assist PM with respect to prepare execution plan (i.e. involve in decompose the defined project scope into smaller task and forming the activities [Used for placing into phase] as well as defining the ETC of each task and its execution dependency and try to place activities into project phase). Review and refine the project plan in every week status meeting with team and update the status of working task accordingly.

Participated in data analysis and design and develop the requirement based on product behavior. Customize and configure the product functionality and behavior based on scope and implement it to appropriate sandbox with respect to client by using complete product deployment process. Prepared the documentation of assigned task in project and jot down risk, assumption and constraints of assigned task in document if occurs.

Develop the interface based on their definition defined in DID and prepare the unit test case and execute it.

Customize the existing code based on client requirement and write the new code from scratch and plug-in it into product if the product don't support any feature of client requirement.

Participated to sanity check during Project deliverable as well as daily process cycle.

Participated in release management process of the project and prepare the documents such as IQ/OQ in details to deploy the product in different sandbox.

Participated to integrate many downstream systems by using data stewardship and data governance process and prepare the ITP document and execute it.

Participated in Risk Assessment Matrix and Impact Analysis in my project execution technique.

Prepared UTP document during developing the requirement in requirement specification as well as Test Plans, Test Cases and Test Scripts during QA && QC of developing the requirement and Prepared SIT document [Test Case of User Story] during UAT.

Implemented the Web Portal and Framework into the Web Server and apply the patch, Hotfix, service pack during ongoing support in application.

Provided ongoing production support such as provide resolution of any process’s failure and performance related issue while loading the huge amount of data/ extracting the data into the file and so on.

Identified the root cause for the recurring issue of End user query and provide a concrete fix for long time.

VIKAS KUMAR

GUPTA

(*****.*****.**@*****.***)

+91-701*******, +91-953*******

PAGE 3 OF 5

Collaborated to other/our team members during the implementing the product to end user system.

Successfully completed all certification exams which were aligned to me by organization. Here is the list of Stakeholders for which I have participated to provide MDM Solution by using disparate sources data and integrate internal /external system by using ETL methodology. Duration

Onekey Integration [includes IMS HCRS (ODS

&& Data Warehousing) – Onekey - ComplianceID

- AGS and so on].

Jan-2018 to Aug-2019

AMA (American Medical Association) Sep 2015 to Jan 2018 Westward Nov-2014 to Sep-2015

Otsuka,Smith && Nephew, Mylan, Dexcom,

Westward, AMA, BMS, Pfizer [APAC] and many

more

Provided Technical Support to Client

Query in Ongoing running Project

during my tenure with IQVIA

AZ POC Jun-2015 to Aug-2015

Redbird(UCB) Feb-2015 to May-2015

EMD Sereno Nov-2014 to Dec-2014

Abbvie July-2014 to Nov-2014

DSI (Daiichi Sankyo) Apr-2011 to Jun-2014

Siemens Dec-2010 to Apr-2011

Shire, HealthPoint Oct-2010 to Dec-2010, Apr-2010 to Sep- 2010

3. I

was

associated with Future Focus InfoTech Pvt Ltd as the post of Sr. System engineer from Nov-2009 to till Feb-2010. Here I had been deputed to Tata Consultancy Services Phase II Noida, and worked as a post of IT Analyst for client Humana.

Responsibilities and Roles:

Directly communication with the On-Site team for understanding the requirement of the application

Prepared a Low/High level Technical Documentation for the Project

Participated in Analysis, Designing, and Coding Prototype as well as Unit Testing 4. I was associated with Saitec International Computer Consultants (SICC), NOIDA as a post of SR. Software Developer from Feb-2005 to Nov-2009.

Responsibilities and Roles:

Direct Interaction /communication with the client to handle query of project as well as gathering the requirements to develop. Prepared a report and documentation for application.

Participated in the area of Analysis, Designing, and Coding Prototype as well as Unit Testing

Participated to integrate unrelated modules of mini ERP.

Implemented the product in client system.

Developed the business specific report based on client needs and implement it to client system.

PROGRAMMING SKILLS

Languages:

PL/SQL, VB6.0, VB.NET, C#. NET 2.0/3.0/3.5/6.0/7.0

Technology, Services & 3rd Party Library Known: REST based API,ASP.NET (Technologies && Core),Window Communication Foundation (WCF), Web Services, Composite Application Library, Microsoft Enterprise Library 4.01,FirstLogic USPS Postal Soft, Newton Soft

Script Languages: VB Script, Unix (Basic), Batch, Shell Script (Basic), Java Script (Basic),JQuery

(JavaScript Library -3.3.1), BootStrap v3.*,4.*

VIKAS KUMAR

GUPTA

(*****.*****.**@*****.***)

+91-701*******, +91-953*******

PAGE 4 OF 5

Database: Oracle 10i/11g, MS Access 2000, and SQL Server (2000/2005/2008)

Operating Systems: Windows NT/95/98/2000/XP/2003/2005/2007/2008, Linux 7 [Basic]

Tool Known: Orbix 3.3 (Basic), Tibco 5.6.0 (Basic), Microsoft Visio 2007, Visual Source Safe (VSS), TFS, Surround SCM 5.0.4 (Build 37), JIRA 4.2/5.0,PL/SQL Developer, Benthic, Toad 12.6, Infomatica PowerCentre 9.*-10.* (i.e. Mapping Designer, Workflow Manager and Workflow Monitor), Oracle APEX

Web Server: Apache Tomcat 5.5.9 Server, IIS -6.0, 7.0, 7.5

SharePoint: Defect Notification Portal & Project Related document. ACHIEVEMENTS & COACHING

Certifications:

Successfully completed the certification examination for Internal Product Mobile Intelligence 9

[CRM - SFA].

Essentials, Primary & Specialty Care, MI Touch, Administration, Architecture and Implementation, HO Features, Configuration, Komodo Loading, MI Technical, Advanced Configuration, Komodo Advanced Interface.

Successfully completed the certification examination of MAP (Methodology && Aligned Processes). Commendation:

Received Significant Above and Beyond Award by external higher Management Team in the year of 2019 of my significant contribution to Onekey Integration.

Received GDC Standing Ovation Award by Internal Management Team in the Year of 2019 of my contribution of my efforts in Project Support in 2018-19.

Received “Technology Solution Special Recognition Award” of MDM/Nucleus – AMA Nucleus Implementation team in the year of 2017 of my efforts in the year of 2016 by external higher management team.

Received “MVP” of MDM/Nucleus – Siemens Nucleus Implementation team by Internal Management Team in the year of 2012 of my efforts in the year of 2011. Coaching:

Trained and mentored to new and junior developers about this tool to achieve the milestones of assigned project.

EDUCATION AND TRAINING SUMMARY

Master of Computer Application from AMC Engineering College, Bangalore in the year 2004.

Bachelor of Science (Mathematics) from Kanpur University in the year 2000. ASSIGNMENTS UNDERTAKEN DURING MY TENURE

Project #1 Nucleus Pharma 3.1/3.2.4/4.0/4.2/5.0/5.2/5.3/5.4 Company IQVIA (Formerly known as Cegedim - GSC Bangalore – IMS Health – QuintilesIMS) Duration

Front End

Back End

Technology &

Framework

Middleware

Tool

Other Tools

Script

Mar-2010 to Sep -2019

C#.Net, JSP, ASP.NET, C++, VC++, XSLT,XML

Oracle 10-11g

Web Services, Window Services, COM+, CORBA, REPLICATION, MSMQ, OMQ, MVC, Orbix 3.3, Tibco 5.6.0

JIRA 4.2/5.0, Surround SCM 5.0.4 (Build 37), TFS, Sharepoint Shell, Java Script, Unix, DOS, VB Script

Common Project

Details for all

Client

Nucleus Pharma is a middleware product of all Cegedim/IMS Product and also third party system. Nucleus provides 360-degree view of customers of golden records as well as Source records to end user. It uses spoke and Hub architecture to integrate all application. It’s a centric system between OLAP and OLTP system for maintaining the current customer data. Nucleus Pharma is a comprehensive Windows and Web- based customer information management system that enables users to capture, centralize, and manage customer-related information. Nucleus Pharma provides sales organizations with a corporate view of each customer based on all available data from disparate sources. It enables pharmaceutical companies to define and store unique customer views that support enterprise-wide business activities. This provides sales forces, management, operations, and home office personnel with accurate, timely, and comprehensive customer information for making critical business decisions.

Nucleus Pharma Package is used a set of application/tool/Processes for generating a best-of-breed profile of the customer, listed below. This package is implemented in multitier (N-Tier) architecture and some application is divided into SOA with VIKAS KUMAR

GUPTA

(*****.*****.**@*****.***)

+91-701*******, +91-953*******

PAGE 5 OF 5

multi-layer. This package provides a MDMaaS and also it can be installed in on- premise.

Configuration Assistant: [Metadata Driven application]

Code Management Tool [Used to insert LOV related to various source and map with underlying codes]

NP Onepoint [Running the Jobs, Workflow as well as monitoring the job, Workflow]

Customer Portal [Creating the Customer information, managing the DCR, Decaying any customer entity information temporarily for certain period, can resolute the conflict profile and many more]

User Management Application [Can maintain the administration for user

[i.e. creation, providing access to application to user,Team Creation, password management and so on]]

Customer Maintenance [Old version [prior to 5.*] of Nucleus use this app.]

Set of Automatic Processes: Parsing && Standardization, transforming, translating, Candidate Selection, Hash, Matching, Grouping, Merging, Manual Resolution and so on.

A Set of utilities in NP Tool provide profiling, cleansing, parsing, standardized, Fuzzy Matching, Merging and quality of the data prior to generate best-of-breed information of the Customers [Master Records] and also maintain the customer information [i.e. Personal details, Specialty of the Customer, Location as well as affiliation between them and so on] accurately based on real world demographic change in any characteristics of Customer information. This package is made of many tools and supports ETL processing for client data comprehensively and is used to provide Master Data Management (MDM) Solution to Life Science Company for simplify and automate business processes of Pharmaceutical Company. This system can configure the physical MDM stewardship application so that it meets Pharmaceutical organization's needs for maintaining/managing the demographics information accurately. Nucleus Pharma package is specially designed for providing the MDM solution to Life Science company. It provide in-built base interface template which are fully tested and it fulfills the base common requirement. Hence, it cutoff the implementation time during shipping MDM Solution to Life science company. This package contains many tools and application and each contains one or more component. Each can be enhance by plug-in functionality.

Previous

Company

Assignment

ANCD (Automated New Case Document for Plan, Payer and PBM), Mini ERP of Pepsi

&& Creambell [includes Salary Package, inventory, Order Management and majorly work in Finance, Inventory Reporting so on], Cremation Management System, Leave Management System, Clinical Support System. Data Migration between SQL Server 2005 and Oracle 10g and so on.

PERSONAL DETAILS

Address : Plot# R-108 (UGF Side) R-Block Vani Vihar Uttam Nagar New Delhi - 110059

Date of Birth: 20-11-1979

Languages: English, Hindi

Date : VIKAS KUMAR GUPTA

Place :

Contact this candidate