SUMMARY:

• Over 15 years of experience in the IT industry, involved in analysis, design, development, testing, implementation & maintenance of databases in Client/Server and Internet/Intranet environments.
• 14+ years of experience in Oracle, SQL and PL/SQL Database Cursors, Triggers, Exceptions, Views, Materialized View, Packages, Stored Procedures and Functions.
• 14+ years of experience in UNIX, UNIX shell Scripting (Korn, C, BASH) and SQL*Loader.
• 14+ years of experience of Oracle Utilities, such as Import/Export, SQL*Loader and SQL*Plus.
• 13+ years of experience in Unit Testing, Integration testing and GUI testing.
• 12+ years of experience in Informatica PowerCenter with Designer Components such as Source Analyzer, Target Designer, Transformation Developer, Mapplets and Mapping Designer.
• 12+ years of experience in developing Strategies for Extraction, Transformation and Loading mechanisms using Informatica.
• 12+ years of experience in ETL design and development using Informatica 7.1.1, 8.1.1, 8.6, 9.4, 9.5.1, 9.6.1 & 10.4.1
• 12+ years of experience in Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• 11+ years of experience in performance and query tuning ( Generating Plan Table, Optimizer ) using SQL Trace, Explain Plan, indexing strategy, TKProf, Analyze and Hints.
• 11+ years of experience ETL Methodology for supporting Data Extraction, Transformations & Loading Processing, in a corporate - wide-ETL solution using Informatica.
• 10+ years of experience in Toad, PL/SQL Developer, Erwin (Conceptual/logical & physical Database Design and Model), SQL Server, TSQL.
• 10+ years of experience in Dimensional Data Modeling using Star Schema, Snow-Flake Schema, Fact and Dimensional Tables.
• 10+ years of experience with version control software like TortoiseSVN, CVS, and PVCS.
• 8+ years in AWS Cloud & Big data Solutioning.
• 7+ years in Python, Hadoop ecosystem components like Map Reduce, HDFS, Hbase, Oozie, Hive, Pig, Flume.
• 7+ years of experience in developing reports using Oracle BI Publisher, OBIEE and QlickView.
• 7+ years of web development experience in HTML, XML, CSS, VBScript and JavaScript.
• 7+ years of experience in integrated BI Publisher reports on OBIEE dashboards and designed complex BI Publisher templates using MS word and excel properties.
• 6+ years of experience in developing reports using Oracle Form, Business Objects.
• 5+ years of working knowledge of Informatica CDC, ESB/Cloud integrations and Power Exchange for AS/400.
• 14+ years of experience in gathering business requirements by interacting with users, preparing functional documents from business requirement and creating technical document.
• 13+ years of experience in working on Data Modeling, Repository Architecture, Data profiling, Business Modeling and Analytics.
• 12+ years of experience in understanding the business issues and data challenges of Healthcare, Pharmaceutical, Telecommunication, Retail and Auction industries and business.
• Self-motivated, strong analytical and problem-solving skills, flexible, excellent team player with proven leadership skills & excellent communication and interpersonal skills.
• Excellent in customer relationship, requirement analysis, offshore- onsite and shared service model.
• Strong knowledge of key business processes and the ability to research the numerous tables to provide data relationships and support the business requirements.

TECHNICAL SKILLS:

Databases: Oracle 11G/10g/9i/8i/7x, Netezza, SQL Server, Teradata, Hadoop, DB2

Operating Systems: UNIX (Solaris, HP-UX, AIX and Red Hat Linux), Windows 98/NT/2000/XP, MS DOS

Database tools: TOAD, PL/SQL Developer, SQL*Plus, SQL Developer, Aginity Netezza Workbench

ETL tools: Informatica PowerCenter, DM Express

Reporting Tool: Oracle BI Publisher 10.1.3.4.1 , OBIEE 10g, Crystal Reports, Business Objects

Data Modeling Tools: Erwin, Microsoft Visio 2003, Toad for Data Analysts 2.1, Power Designer 16.5.3.0

Languages: SQL, PL/SQL, Python, C/C++, HTML, XML, Java Script, Shell Script, and Visual Basic

Domain Knowledge: Healthcare, Pharmaceutical, Telecommunication/Communication, Retail, Auction

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

ETL (Informatica) & PL/SQL Developer

Environment: Oracle 11g, Informatica Power Center 10.1.1, AWS, Big Data, SQL Developer, GitHub, UNIX, Migle-Agile, PL/SQL, SQL Server 2008, Putty/WinSCP, DB Visualizer, DB2, Business Objects, HipChat, Slack, VersionOne, Web Services, SoapUI, Microsoft SQL Server Management Studio, Toad, Rally, Salesforce

Responsibilities:

• Working with business partners to support critical issues/requirements and make sure that identified issues are tracked, reported on and resolved in a timely manner.
• Working with Oracle DBA and Informatica Admin for migrating developed components to higher environments (QA, UAT, and Prod).
• Designing and implementing cloud-based solutions for hybrid, private & public cloud deployment models.
• Designed and setup AWS backend serverless architecture using AWS Cognito, API Gateway, Lambda, IAM and DynamoDB for Inventory Solutions Sales Evolution (ISSE).
• Identifying strengths and weaknesses in existing processes to enhance existing ETL processes to meet evolving requirements.
• Created stored procedure for complex Nine different aggregations for ISF process.
• Planning, Design, Architecting Cloud and Big data related Solutions for ISSE.
• Designing highly available, cost effective, Secured and fault tolerant systems using multiple EC2 instances, Auto Scaling, Elastic Load Balancer, Route53, RDS and AMIs.
• Excellent knowledge on various transformations to convert business requirement into informatica PowerCenter code. EX. concatenate different rows into one row using expression and aggregation transformation.
• Created Shell Script to manage job scheduling of the OPENLANE process. Extract zip files, run workflow for XML extracted from the zip, calling API to send .JPG file and to receive URL etc.
• Creating and verifying Informatica Power Center data mappings/sessions/workflows for OVT.
• Created ETL mapping to upload data to Salesforce from oracle database.
• Created informatica mappings to put data in AWS S3 Bucket.
• Created informatica mappings to take data from AWS S3 Bucket and upload to salesforce.
• Creating/Modifying complex PL/SQL procedure/function for OVT enhancements.
• Working on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, Web Services Consumer and Source Qualifier.
• Successfully resolved OVT prod issue and made permanent fix.
• Used XML as source and populate SQL Server table from XML data. Also, Generated XML from SQL server tables and FTP to sterling server.
• Extensively used workflow variable and mapping variable using 'Pre-session variable assignment' and 'Post-session on success variable assignment'.
• Created .xsd files for XML Source and Target definition.
• Created Web Services Consumer transformation using TECR.wsdl (Web Service Description Language) file.
• Called Web services using Web Services Consumer transformation and stored retrieved result in SQL server table.
• Participating in test-driven, peer reviewed, agile development methodology and scrum Meeting.
• Preforming unit testing on modified OVT components.
• Involving in requirement analysis, understanding of business requirements, identifying the flow of information and analyzing the existing systems.
• Created new FACT and Dimension tables in OVT data model. Added new attributes to the existing tables. Defined grain of new tables. Developed source to target mappings (S2T- for ETL).
• Defining load strategy and created schedules for existing and new processes to meet business SLA.
• Experienced in analyzing query logs and explain paths. Identify performance bottlenecks and optimize respective databases and processes for performance improvement.
• Designed Type 1, 2 and 6 - slowly changing dimensions as a base for accurate historical reporting.

Confidential, Atlanta, GA

Informatica PL/SQL Developer

Environment: Oracle 11g, PL/SQL, Informatica Power Center 9.6.1, SQL Developer, TOAD, TortoiseSVN, UNIX, Web methods 8.2, SAP Sybase Power Designer 16.5.3.0

Responsibilities:

• Working as a solution architect in Confidential EBI team and leading and mentoring TNC/NSA team members.
• Providing estimates for design, development, unit and integration testing to client.
• Created high level and low-level design for new requirements and driving design review meeting with client.
• Worked and implement of Informatica CDC (Change Data Capture) and SCD (Slowly Changing Dimensions).
• Involved in reviewing technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems (MySQL).
• Reviewed the TNC (Transaction Data Warehouse) data model with architect, data modeler, leadership and Application Development team.
• Developing PL/SQL Stored Procedures, Functions, Triggers and Packages.
• Created Informatica Power Center mappings/sessions/workflows for TNC and NSA Projects.
• Creating/Modifying complex PL/SQL procedure/function for TNC/NSA enhancements.
• Analyzed the source data coming from Oracle, Flat Files, and MySQL coordinated with data warehouse team in developing Dimensional Model.
• Working with highly available, transactional database and a large volume data set.
• Creating/Modifying Informatica workflows/sessions/mappings for TNC/NSA enhancements.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into TNC Dimension and Fact tables.
• Created detailed Component Design Document and user guide for TNC and NSA.
• Created Indexes, sequences and wrapper stored procedure.
• Improved Informatica TNC process by creating index, used cache files and session level partitions in Informatica.
• Creating POI excel reports and delivering to business upon requests.
• Created complex Informatica mappings using Filter, Joiner, Expression, Aggregator, Update Strategy, Lookup transformations.

Confidential, Atlanta, GA

ETL Lead/ Onsite Coordinator

Environment: Hadoop, Cassandra, PL/SQL, Informatica PowerCenter 9.1, Teradata, SQL Assistant, Quality Center 10.0, TortoiseSVN, DB2, Business Objects.

Responsibilities:

• Created complex Hive Scripts for Dedup/Merge/Decouple customer data.
• Created Informatica workflows to populate Hadoop files from DB 2 tables.
• Developed standards and processes for Hadoop based Golden Records’ design and implementation to process large sets of structured, semi-structured and unstructured data.
• Involved in data validation in Teradata database using Teradata SQL Assistant.
• Created and scheduled loader & audit scripts to refresh GR lookup tables in Production.
• Prepared Technical Design Document for Golden Record.
• Created Hadoop/Hive queries for the data validation using DB Visualizer.
• Created SQL queries and Stored Procedures for data analysis in Business Objects.
• Worked on data extraction, transformation and loading (ETL process) from source to target systems.
• Worked on PL/SQL Procedures, Functions, Packages, Triggers, and Views.
• Gathering technical requirements from client business analysts.
• Created data flow diagram for Golden Record and Bazar Voice application.
• Participating in test-driven, peer reviewed, agile development methodology and scrum meeting.
• Performing extensive data analysis using SQL and, Salesforce and legacy source data. Expertise in writing ad-hoc complex SQL queries for data profiling.
• Completed multiple projects using Salesforce, CDC (Change Data Capture/Power Exchange), IDQ.
• Constructed many mappings using Oracle Exadata/SQL Server, DB2, Salesforce, Informatica and Oracle stored procedures/scripts.
• Created reporting layer views using FACT and dimension tables from star schema. Developed several layer of roll-ups using complex queries and filter criteria.
• Developed complex mappings using several distinct types of transformations like Power Exchange, Java, Web Service Consumer, Active MQ, Tibco queues for real time data load.

Confidential, Louisville, KY

ETL PL/SQL Developer/ Onsite Coordinator

Environment: Oracle 10g, TOAD, PL/SQL Developer, Informatica PowerCenter 8.6.1, OBIEE 10g, Oracle BI Publisher 10.1.3.4.1 , VersionOne, Java Script, XML, Toad for Data Analysts 2.1, IBM AIX 5.3, Netezza, TortoiseSVN, Agility Netezza Workbench 2.1.186.7045

Responsibilities:

• Developing PL/SQL Stored Procedures, Functions, Triggers and Packages.
• Created all Informatica PowerCenter workflows for Pharmacy Analytics, Cstar & TQP Projects.
• Populating oracle tables from different flat files using SQL*Loader.
• Involved in data validation in Netezza database using Toad for Data Analysts.
• Created and scheduled loader & audit scripts to refresh TQP & Cstar lookup tables in Production.
• Prepared Technical Design Document for C-Star, TQP & Pharmacy Analytics.
• Proving Production support (24 x 7) for Medical Metrics, Cstar, TQP and Pharmacy Analytics application.
• Created Oracle BI answers for Cstar Commercial (40) & Individual (24) Reports.
• Performed system testing on OBIEE dashboard pages by validating data with excel sheet.
• Used Java Script in OBIEE for dynamic header for Cstar reports.
• Written all formulas in OBIEE & Validated them with excel reports.
• Worked in Data Extraction, Transformation and Loading (ETL process) from source to target systems.
• Created complex BI publisher reports using rtf, excel template & VBA.
• Created data flow diagram for TQP, Cstar & Pharmacy Analytics application.
• Participating in test-driven, peer reviewed, agile development methodology and scrum Meeting.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Created, modified and customized BI publisher .rtf files for commercial key metrics.
• Analyzed and tuned critical sql queries to improve performance for BI publisher reports.
• Involved in system testing for all BI publisher reports (64) and make them UAT approved.
• Created the data model for Corporate-Strategic Trend Analytics Report using Toad for Data Analysts.
• Developed OBIEE reports with analyzing data source, designing, testing and implemented analytics reports and OBIEE dashboards.

Confidential, Miami, FL

ETL Developer/ PL/SQL Developer

Environment: Oracle 10g, TOAD, SQL Developer, Java, Informatica Power Center 8.6.0, Solaris, ClarifyCRM, CVS, Beyond Compare, BI Publisher, Microsoft Visio 2003, Informatica Data Explorer(IDE).

Responsibilities:

• Interacting with business teams to understand the requirement.
• Worked with Architects for high level estimates and project plan during the bidding of the project.
• Developed Procedures, Functions, Packages, Triggers, and Views using PL/SQL.
• Involved in data loading into the staging tables using SQL*Loader and UNIX shell scripts.
• Extracting source data from Flat Files and moving into Staging area and then transforming to Oracle target database using Informatica.
• Written SQL*loader control files for data loading into oracle tables from flat files.
• Created public synonym and granted roles and privileges to users.
• Performed database code optimization using Explain plan.
• Identified the required modification to the ETL jobs for extracting the new required data.
• Involved in data profiling using Informatica Data Explorer (IDE).
• Created complex excel template for BI publisher reports using VBA.
• Coordinated with the testing team members to perform integration testing.
• Participated in meeting and walkthroughs with business team and development team.
• Provided technical support and coordination among team members.
• Worked on Informatica Power Center 8.6.0 - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Involved in Unit testing of the developed/modified components, research and Impact Analysis.
• Documented the Data Flow Diagram and system design Documents.
• Involved in creating script for double minutes and performed unit testing on it.
• Used CVS for SQL version control management.
• Developed ETL process in Informatica power center.
• Optimized and fine-tuned the Crystal Reports for efficiency.
• Modified existing packages and added new functions & procedure according to new requirements.
• Preformed unit testing on modified packages.
• Involved in table/field mapping for Low Balance Revenue.
• Changed existing logic within the packages for optimum performance.

Confidential, Louisville, KY

Oracle PL/SQL Developer/ Onsite Coordinator

Environment: Oracle 10g, TOAD, ASP.Net, PL/SQL Developer, DM Express, Informatica Power Center 8.6.0, AIX, Microsoft Visio 2003, Shell Script, OBIEE, VersionOne, Java Script, XML, Netezza, TortoiseSVN.

Responsibilities:

• Participated in meetings with the clients (users) and gathered business requirements.
• Developed PL/SQL automated testing framework for Medical Metrics (honored for being first in Confidential ).
• Generated procedures which return REF cursors as result sets.
• Wrote UNIX shell script to automate OLAP cube build process.
• Involved in monthly OLAP cube built using DM Express.
• Developed PL/SQL Procedures, Functions and Packages.
• Participated in agile software development environment using the Scrum methodology
• Involved in code review with team members and smoothly migrated code to production environment.
• Worked on SQL tuning, table indexing, data migration and scripts debugging.
• Documented Test Plans that contains test scripts, test cases, test data and expected results for the User Acceptance testing (UAT).
• Sophisticated transformation rules are implemented using Informatica features like Aggregator, Filter, Expression, Sequence Generator, Lookup, Update Strategy and Source Qualifier.
• Developed packages, stored procedures, functions for performing various calculations and converting COBOL based program into Oracle-based sql scripts.
• Worked extensively in developing Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into data warehouse.
• Modified existing package for medical metrics pharmacy source data from OLAP cube to Netezza server.
• Involved in creating OBIEE presentation layer to synch data between OLAP cube and Netezza server.

Confidential

Oracle PL/SQL Developer

Environment: Oracle 10g (SQL, PL/SQL), Informatica Power Center 7.1.3, HTML, XML, TOAD, SQL*Loader, Microsoft Visio 2003, OBIEE, Oracle BI Publisher, PVCS.

Responsibilities:

• Participated in the full software development life cycle.
• Participated in weekly design reviews and walkthroughs with project manager and development team.
• Worked on database design with the development team.
• Involved in tuning of sessions for better performance.
• Wrote Unix Shell Scripts to automate Job scheduling process.
• Wrote PL/SQL code using the technical and functional specifications.
• Documented business rules, functional and technical designs, test cases and user guides for the Confidential application.
• Worked on Analytical functions, Partitioned and sub-partitioned tables, Local and Global Indexes and Dynamic SQL queries.
• Implemented basic replication using snapshots.
• Involved in the debugging and error handling.
• Used SQL*Loader to minimize data load time into Oracle database.
• Involved in documenting functional specs and helped establishing deliverables.
• Developed packages, stored procedures, functions and Triggers.
• Created SQL*Loader control programs and PL/SQL validation procedures to map data from different data sources to the oracle server.
• Worked on Informatica Power Center 7.1.3 - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.

Confidential

Oracle Programmer

Environment: Oracle 8i, SQL, PL/SQL, SQL*PLUS, C, UNIX HP-UX 11.22, UNIX Shell Script, Crystal Reports, Erwin.

Responsibilities:

• Changed already existing Procedures, Functions, Views, and Packages to improve performance of the application.
• Created SQL scripts for static data of Database.
• Involved in data modeling for the additional tables/databases needed using Erwin.
• Optimized and fine-tuned the Crystal Reports for efficiency.
• Participated in code reviews with the development team.
• ETL using PL/SQL and Unix Shell scripts from the production database to the Data warehouse database.
• Worked with developers to tune the SQL statements to increase the performance.
• Involved in the Database design and maintaining database security.
• Developed data using Erwin as a data modeling tool.
• Responsible for users, roles and privilege management.
• Responsible for definition and management of schemas and objects.
• Responsible for schema comparison.
• Responsible for enhancements depends on the client’s functionality.
• Supported and advised developers during databases related issue.
• Wrote SQL queries to improve the performance of the application.