Manager Data

Aditya Sharma

ac0w4x@r.postjobfree.com, 480-***-****

Informatica, Oracle, PL/SQL Developer

Summary:

8+ years of extensive Informatica and oracle technology experience in analyzing, designing, complex programming and supporting enterprise scale systems.

Experience in Informatica Power Center. Strong Data Warehousing ETL experience of using Informatica 9.1 and 8.6.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.

Worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Knowledge in Full Life Cycle development of Data Warehousing.

Extensive experience in developing complex mappings from varied transformations like Source Qualifier, Connected and Unconnected lookups, Router, Filter, Sorter, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.

Expertise in design and implementation of SCD types 1, 2 and 3 and CDC - Change data capture.

Experience in Dimensional Modeling using Star and Snow Flake Schema, Facts and Dimensions.

Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.

Good knowledge in Data modeling for creating Logical and Physical Design of Database.

Strong technical background with 6+ years of Production Support experience in Informatica, SQL, PL/SQL and ORACLE.

Extensive experience in writing custom PL/SQL and SQL's for client reporting needs and scheduling, using propriety scheduler.

Designed & Developed 100+ custom SQLs to provide business insights using Cognos.

Experience in supporting Public and Private SaaS environment for pharmaceutical clients.

Experience in understanding production issues, identifying root cause and map it back to requirement, base product or customization.

Experience in developing and maintaining complex database objects like Stored Procedures, Functions, Packages and Triggers using PL/SQL.

Experienced in Cursor Variables (Ref Cursors) to pass query results sets between PL/SQL programs and application.

Extensive hands on experience on SQL*Loader, Data Migration, Oracle Import and Export, Data Pump, Index Management, Cursors, Views and Materialized Views.

Experience in loading data using SQL Loader.

Good understanding of Pharmaceutical, Telecom and Finance (Billing) subject areas.

Supported clients having large database size of 3TB with 3 servers including Production, Testing and Development.

Experienced in SQL Query performance tuning for optimized results using tools like Golden Benthic.

Experienced in creating and maintaining database objects such as tables, constraints, indexes, views, synonyms, sequences, db links etc.

Good knowledge of Dynamic SQL, Autonomous Transaction and Analytical Functions.

Good exposure to DBA routine tasks like managing users, roles, privileges, schema and objects, developing PL/SQL triggers for user access audit.

Strong customer interfacing/consulting skills and experience.

Oracle 9i Database Administration Training.

Proficient in creating and applying Cron jobs and backup scripts.

3 time winner of State Tennis Championship.

Represented/Won Inter college Tennis Championship.

Technical Skills:

Operating Systems Windows Family, RHEL 5.0

Programming Languages SQL, PL/SQL, Unix Shell Scripting

Databases Oracle 11g/10g/9i, SQL Server 2008 R2

Development Tools TOAD, Golden Benthic, SQL Developer.

Reporting Tools Cognos 10

ETL Tools Informatica 8.6, SQL*Loader, KomodoTM

Productivity Tools Microsoft Office (Word, Excel, Power Point), UltraEdit, Notepad++

Others Data Migration, Schema Backups, Oracle Database Import and Export, Data Pump, Index Management, Packages, Procedures, Functions, Triggers, Cursors, Views and Materialized Views.

Detailed Work Experience

Client: Sanofi, USA (May, 2014 - Present)

Project: NexxusTM Mobile Intelligence,

Role: Production Support Engineer, Oracle/ETL Developer

Tools/Technology: Oracle 11g, Informatica 8.6, KomodoTM, Toad, Golden Benthic

NexxusTM Mobile Intelligence (MI) application provides capability that enables the mobile workforce to gain business insights through information analysis using applications optimized for mobile devices. NexxusTM Mobile Intelligence is a single platform for Pharmaceutical Industry (Medical Representatives) to empower teams to create better customer (Medical Professionals, Physicians, Doctors) engagements and to record future and past interactions (Meetings & Calls). NexxusTM Mobile Intelligence delivers timely information to the field for more effective interactions.

• Responsible for analyzing production issues (Data and Application related), replicate them in lower environment, fix code as required, test and deploy.

• Interacting with the clients to understand the requirements for customization.

• Trained and certified on NexxusTM Mobile Intelligence.

• Provided support to ensure stabilization of new clients using NexxusTM Mobile Intelligence.

• Defined customized interface for new clients to ingest data into NexxusTM Mobile Intelligence system.

• Created SQL Loader scripts to load data from interface files into NexxusTM Mobile Intelligence database.

• Customized NexxusTM MI base product data interface (ETL) jobs (KomodoTM, Informatica) to import/export interface files based on client customization requirements.

• Responsible for developing mapping, workflows and Re-usable components using Informatica Designer & Workflow manager tools to load the data from various sources.

• Extensively used Transformations like Stored Procedure, Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator.

• Responsible to tune Informatica mappings to optimize load and query Performance

• Written documentation to describe program development, logic, coding, testing, changes and corrections.

• Followed Informatica recommendations, methodologies and best practices.

• Responsible for fixing production issues (using PL/SQL, SQL) related to underlying data used by NexxusTM Mobile Intelligence application for different pharmaceutical customer in Public and Private SaaS environment.

• Supported data ingestion using tools like KOMODOTM, Informatica.

• Monitor data load reject logs on daily basis and analyze rejects for technical/business error.

• Responsible for reprocessing rejected records manually on daily basis for technical error and work with business to identify solution for business errors

• Responsible for creating predefined/adhoc reports as per client request.

• Responsible for writing complex SQL queries using joins, sub queries and inline views to retrieve data from the database.

• Responsible for troubleshooting performance issues and bugs within packages, forms, and reports using dbms_output & Explain plan.

• Developed 100+ custom reports to provide business insights using Cognos and scheduled them using TigerTM scheduler. Ensure that reports are delivered to the customer as per the defined SLA.

• Create daily data load status reports and deliver to customer to provide insight into data load status.

• Ensure daily health checkups are performed as expected to identify any issues with iPAD sync, anomalies with assignments, app sync with latest active replica, anomalies with representative iPAD sync duration.

• Monitor and guided 4 member team, provided task assignment and review team deliverables

Client: Pfizer, USA (Jan 2013 - May 2014)

Project: (II) NexxusTM Organization Manager

Role : Senior Software Engineer

Tools/Technology : Oracle 11g, Informatica 8.6, Toad, Oracle Forms/Reports.

NexxusTM Organization Manager (OM) is a Life Sciences-specific, cloud-based, CRM-agnostic solution that enables sales operations and field sales team to collaborate on territory alignment and employee and product roster management. OM is the master of Employee, Product and Sales Force data which will flow to MI as per business requirements.

• Involved in gathering business requirements, analysis and defining technical requirements.

• Created technical design documentation as per the functional requirements.

• Responsible to tune ETL mappings to optimize load and query Performance.

• Supported huge data loads using Informatica.

• Used Informatica Power Center 8.6 for loading data in the database.

• Developed interfaces to transmit data on a daily basis from the mainstream application to downstream applications.

• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

• Documented Informatica mappings in Excel spread sheet.

• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

• Used Debugger to test the mappings and fixed the bugs.

• Responsible for analyzing reject data files, analyze and reprocess them after fixing technical issues

• Worked with client to identify solution for business errors occurred during data loads.

• Responsible for creating predefined/ad-hoc reports as per client request.

• Extensively worked on triggers responsible for moving data between systems.

• Participated in code walk through and review sessions with development team.

• Responsible for writing complex SQL queries using joins, sub queries and inline views to retrieve data from the database.

• Used Oracle Analytical functions to create report requirement.

• Created SQL*Loader scripts, external tables to load the date from source files into database tables.

• Responsible for developing database objects like Stored Procedures, Functions, Packages and Triggers using SQL and Oracle PL/SQL.

• Responsible for performing database related activities, e.g. scripts to create new tables, constraints, synonyms, views and materialized views for new enhancement.

Client: Verizon (Sep 2011 - Dec 2012)

Role : PL/SQL Developer.

Environment : Oracle 11g, Toad, Cognos, Unix

• Provided extensive production support for applications and resolved the bug fixes by coordinating with the business users

• Created and deployed the SQL Scripts in production as per the adhoc business requirements.

• Created an automated process to export the database objects from one schema to the other to in building a production like test environment.

• Provided on-call support and created Trouble Tickets (AOTS TT’s) for Production issues of the application and coordinated with teams which were being impacted by the issue to resolve it.

• Triaged calls to find out the root cause of the issue and generated the reports of impact to the applications to the higher management.

• Involved in code walk through of the existing applications and review sessions with development team.

• Responsible for coordinating on-site/offshore for Release Deployments and Knowledge Transfer

• Participated in the design calls to understand the new business requirements.

• Created E-R diagram by reverse engineering the existing table structures, enhanced it with new tables to support the business requirements of the application.

• Developed ETL process using stored procedures, functions and packages to migrate the data from SQL Server to Oracle Database.

• Performance tuned sql queries and pl/sql code for the better performance using explain plans and by creating the indexes.

• Used export, import and oracle data pump to replicate the schemas for creating test environment.

• Involved in testing the custom applications, created test plan, documented the test cases and coordinated with the business and the development teams in resolving the issues.

Client:-- JVVNL (2010 Feb - 2011 Aug)

Project(3) :-- SPOT and BASE Electricity Billing System.

Client :-- JVVNL.

Role :-- PL/SQL Developer.

Tools/Technology : Oracle 11g, Toad.

JVVNL is one of a discom involved in electricity distribution along with energy billing and revenue collection. The vision of the JVVNL is to do the change management by adopting a most modern billing system to improve the consumer satisfaction revenue flow and to reduce the overall time between readings to issuance of the bills.

• Scheduling and generating Electricity Bills for consumers by creating/running anonymous blocks for desired consumer subdivisions.

• Troubleshooting in case of billing/ledger issues reported by Client.

• Managing and creating pre/post electricity bill checking standards.

• Creating and generating MIS every month and provide it to client as per SLA.

• Wrote a code to implement the Cleaning tax and integrate it to the billing business logic for the state government.

• Modified backend code for implementing billing slab changes based on consumer type as directed by the state government.

• Created outstanding reports for clients to ensure that there is no pending amount for Consumers.

• Developed database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL which in-turn used in billing calculation and front end applications.

• Modified database objects like Stored Procedures, Functions and Packages to increase processing performance, referred to as performance tuning.

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

• Created the test scripts and complex queries to test the application and to quality assurance of the data.

• Ensuring database objects (views, stored procedures, triggers, constraints, etc.) and SQL statements meet performance and security objectives.

• Responsible for database storage space management. Adding a datafile to a tablespace in case of low storage space.

• Responsible to ensure daily backups are done successfully.

• Experience in a production Oracle 9i/10g environment including PL/SQL, database tuning and troubleshooting.

• Improved the performance of the application by rewriting SQL queries.

• Taking daily/weekly backups.

• Created standby (Testing) database.

• Installed and configured Oracle 9i and 10g on Linux and Windows.

Client: PSEB.(2009 Feb - 2010 Feb)

Role : Jr. Developer

Tools/Technology : Oracle PL/SQL, Toad

PSEB is involved in electricity generation, distribution and revenue collection with a vast consumer base. The vision of the department is to covert the manual work related customer services to the fully computerized paper free environment is to increase the customer satisfaction level and enhance the image of the Utility, for which they want to implement CRM (Customer Relationship Management) Software to address the customer front-end activities. I worked as database developer /DBA responsible for:

• Creating stored procedure/functions which in-turn is used by front end applications

• Managed the on-site backup and recovery process

• Provided front-line database support supporting client facing applications

• Worked as part of a project team to coordinate database development and determine project scope and limitations.

• Assisted with application upgrades, migrating objects from development to test and test to production representing changes as necessary in Change Management

• Developed and implemented standards for data object naming and database design.

• Participated in Disaster Recovery planning and testing.

• Creating staging database.

Education:

• MS (Masters of Computer Applications)

Contact this candidate