SUMMARY:

• Expertise in Oracle 10g/11g/12c SQL&PL/SQL with experience ranging from analysis, design & development to support Web based OLTP systems, Business Intelligence, OLAP and ETL/ELT data feeds to EDWH systems.
• Lead efforts to implement Data Warehousing and Data Migration/Integration; includes System analysis, Technical Design, development and deployment end - to-end solution in Enterprise Data Warehousing space.
• Architecture experience on ETL Process/tools such as Netezza AMPP scripting, Customize PL/SQL, Informatica Power center, OWB, ODI and Batch processing. Developing UNIX shell scripting and automation of ETL processes with Schedulers
• Experience in Data Modeling Logical/Physical, Dimensional and Star/Snowflake schema designing for both OLTP/OLAP and DSS systems. Re-factor existing data models & databases for performance and scalability using ERwin, E/R Studio
• Expertise in Oracle SQL, PL/SQL, Packages, Procedures, Functions, triggers, views, Materialized view, Dynamic SQL, bulk collection, Indexes, Analytical function, table partitioning etc. to implement complex business logic/rules
• Expertise in Data migration/conversion of legacy system data from various sources (flat files, XML, heterogeneous databases) to Data warehouse using ETL tools, customize pl/sql and Unix scripts.
• Experience developing and designing technical documentation, source to target data mapping specs includes business transformation logic, join condition etc. comply with define standards and best practices to produce database catalog / data dictionary for organization.
• Extensive experience in Reverse Engineering legacy databases to acquire detailed understanding of existing data structures for both enterprise data model and data warehouse model development using ERwin, E/R Studio
• Responsible for ongoing BI projects and day to day activities pertaining to Data warehouse and Reporting across multiple stakeholders includes liaison with SME/Business users, recruited new team members, trained, coached as mentor. Built teams offshore-onsite from scratch
• Experience on Application Database admin activities including: user security and access control, capacity planning & forecasting, Data growth and trend analysis, backup, DB change management and code migrations from Development to higher environment (QA/UAT etc.) and Production Environment
• Expert in heavy data analysis and resolution for Infrastructure data issues, data incompatibility, Root-Cause Analysis, identifying trends, usage patterns and forecasting systems behavior.
• Experience with Oracle database optimization techniques (SQL Tuning) including re-write queries, re-structure model, table partitioning, indexing strategies, hints etc. using tools such as Explain plan, SQLT, DBMS profiler, dbms stats, Toad Tuner, OEM-Advisor etc.
• Experience developing operational task automation (customize tools) and implement solutions to improve efficiency, remove dependencies, service reliability and productivity of the team. Tools developed in UNIX Shell Scripting and SQL & PL/SQL
• Work closely with engineers, development and functional teams, business product group and peers to understand the business requirements and help design, develop and implement solutions and Integration that meet the business needs.
• Experience in using Version Control, Quality control, remedy and DB change management.
• Experience in documentation that involves functional, technical specification, user manual and technical review.
• Knowledge of full Software Development Lifecycle (SDLC), agile methodology, Extreme Programming.
• Exposure to multiple domains CTI (Contact Center), Manufacturing/Inventory, Health Welfare, Asset, Retail, Finance, Auto Finance, Sales & Logistics, Consulting and Travel management
• Knowledge on Big Data, Hadoop 2.0 Eco System, HDFS, Hive, Map Reduce, Pig, Hbase, Mongo DB 3.0, Talend, OBIEE, Golden Gate. Oracle Apps (EBS-R12)

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/XP, UNIX/LINUX

Languages: SQL, PL/SQL, C, Unix Shell Scripting, JAVA,C#

Databases/RDBMS: Oracle 12c/11g/10g/9i/8.0, SQL Server 2005, IBM Netezza 6.0

Tools: TOAD, PL/SQL Developer, Oracle SQL Developer, SQL*Loader, CA Erwin R9, E/R Studio, SQL Data Modeler, Oracle Apex3.2, Share point, Visio, Win SCP, putty, Mercury Quality center and Change management, Remedy, plan view, VSS, Clear Case, MS TFS, SVN, Salesforce workbench /force

Data Warehousing/ ETL: ODI, IBM Netezza Data Warehouse Appliance 6.0.4, Oracle Warehouse Builder (OWB), Informatica 9.6, Informatica 9.6 metadata manager

Data Analytics / Reporting: Cognos 8.4 and 10.2, IBM SPSS, Oracle Reports, Discoverer/ Discoverer plus

Application: Oracle Forms 9i/6i, CRM E-Business Suite 11.5/12(AP, AR, CS, INV), Reports

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, TX

Sr. Consultant (Data Architect/ Modeler)

Responsibilities:

• Consulting as Data Warehouse Architect / Modeler, working on GMF Auto Finance System (Loan Origination /Servicing) using ERWIN, SQL and Oracle Database.
• Perform a variety of in-depth data analysis, data modeling, data discovery & data mapping tasks on complicated data sets with potentially complex data integration scenarios with limited supervision.
• Performed analysis on both source and target system to locate required data set, whether data conversion or data cleansing needed before the data loaded into the target system
• Participate enhancement of Data Vault 2.0 design to create data presentation/ visualization layer for the enterprise multilayer data warehouse solution environment
• Perform key contributor (data solution) role in analyzing, designing / developing several new data feed for salesforce interface (API’s) from enterprise data warehouse and Oracle ERP system.
• Work closely and conducts walk-through meetings with business stakeholders, system analyst, architects, ETL developers, DBAs and quality analysts to ensure data model / mapping meet the business metrics and cover all aspect of technical requirements.
• Support Cognos report and package development for data analysis, ad hoc data analytics feed to IBM SPSS.
• Support and provide senior level guidance to ETL development/ Data Quality/ functional team member to solve data issues for the enterprise warehouse with root cause analysis.

Environment: Oracle DB 11.2, 12c, RAC, SQL, PL/SQL, TOAD, TOAD data modeler, SQL Developer, CA Erwin R9, Cognos 10.2, Salesforce workbench /force, Informatica 9.6, Informatica 9.6 metadata manager.

Sr. Consultant (Lead / Data Architect/Developer)

Responsibilities:

• Design, Develop and implement Comprehensive Data Warehouse Solution to extract, clean, transfer, load and manage quality/accuracy of data from various sources to EDW Enterprise Data Warehouse.
• Architect framework for data warehouse solutions to bring data from source system to EDW and provide data mart solutions for Order/Sales operation, Salesforce activity, Inventory tracking, in depth data mining and analysis for market projection etc.
• Standardized data management procedures, processes and protocols that will enable data transparency around data usage, quality, timeliness and integrity
• Design, Develop Star/Snowflake schema data modeling for business process and creating Logical/Physical design of Database using SQL Data Modeler tool.
• Define, Design customize, flexible, scalable and efficient home grown (ETL/ELT) data load process using PL/SQL, scripting, automation of ETL job processing and scheduling, Source to target data mapping, performance tuning and query optimization.
• Improvise the data load process for transactional data set to EDW near real time from 3 times a day to every 30 min cycle as well as increasing stability and availability by implementing industry standard practices, proactive job monitoring alerts and error controls.
• Analyze performance bottleneck/offensive queries and optimize database / reporting application.
• Involve Analyzing various streams of large data sources, upwards of millions of records, to identify correlations and trends using IBM Cognos & SPSS analytics tools.
• Support and hands on Cognos report development, build packages, report studio, query studio, ad-hoc report, active reports and cleaned/prepared data in SPSS.
• Providing technical leadership for new proposals and existing projects inclusive of analysis, requirements definition, architecture, design, validation, implementation, problem identification and resolution.

Environment: Oracle DB 11.2, 12c, SQL, PL/SQL, SQL Server 2000, SQL Developer, SQL Data Modeler, ERWIN,DataStage, Cognos 8.4 and 10.2.2, IBM SPSS, EBS 11.5 / R12

Sr. Consultant (Enterprise Database Architect/Developer)

Responsibilities:

• Define Database Modeling Policy, Strategies, Standards, Guidelines and Best Practices for large and strategic application systems in retail domain.
• Define Data Architecture and Data Conversion/ migration strategies
• Lead Data Migration efforts from SQL Server 2000 to Oracle 11g, providing guidance and mentored team of data modeler and developer.
• Design Relational and Dimensional Data modeling for creating Logical and Physical Design of Database(OLTP/OLAP) and ER Diagrams using data modeling tools like Erwin/SQL data Modeler
• Design standards to use normalized data structures (3NF), de-normalized structures, and dimensional structures. defines common design patterns for modeling various types of relationships; provide additional insight and analysis to improve the processes
• Re-engineering existing data and data usage patterns to build new retail data model and refining existing data structure; Converting business logic from application layer to database layer using stored program units. Ensured business continuity by coaching all other members of the team.
• Design, Develop and build several PL/SQL stored program unit to implement complex business logic keep in mind scalability and performance of code.
• Developed interfaces/Utilities using PL/SQL (Packages, Procedure & Functions) to support business common functionality /complex business rules.
• Involve into POC for the selection and recommendation of appropriate tools, software, applications, and environments to support business data management to achieve short and long term business goals.
• Involve into availability of various (dev/qa/uat/perf) environments to allow applications development, database change management, code promotion, maintaining 140 user schema, automation of tools, archival of data and design the new database objects as per application function enhancements
• Produced catalogues of logical and physical schemas. Database design and implementation for numerous applications used by several devices in retail space such as scanner, POS, GOT etc.
• Part of platform team (Architecture group) and single point of contact for all database related work across the retail solution project (RISE).
• Closely working with business stream, SME groups and co-coordinating off-shore development teams.

Environment: Oracle DB 11.2, SQL, PL/SQL, SQL Server 2000, SQL Developer, SQL Data Modeler, ERWIN, Visual Studio 2010, TFS 2010, Share Point 2010, Windows scripting, Windows Server 2003, Multilayer architecture.

Sr. Consultant (BI-EDHW Integration specialist)

Responsibilities:

• Lead team of ETL developers for OTC data integration to HUB EDWH.
• Work with Data Modular and Business/Data Architects to re-factor existing data model, define end to end data flow by subject area and convert them in technical data mapping spec.
• Work on Oracle Data Integrator (ODI) as part of POC for Netezza interface.
• Development for ELT Process, Mapping specs for legacy system, data feeds from 17 different source systems to Landing Zone, Data Integration HUB and Business area / Reporting Data Marts.
• Development of Dimensions, Hierarchies, aggregate/summary and Fact tables.
• UNIX shell and SQL scripting (Data load framework) to standardize Meta data /rule based data load mechanism to pull /push data into EDWH.
• Hands on Netezza tools and Utilities: NzLoad, NzSql, NzPL/SQL, Sqltoolkits, Analytical functions etc.s
• Lead initiative to implement industry standards, Best Practices to improve performance and scalability of ELT process.
• Production troubleshooting, Support data validation, data quality analysis, code deployment to higher environment.
• Job scheduling, Performance & Monitoring of Data Loads.

Environment: IBM Netezza Data warehouse Appliance 6.0 (TwinFin 3/6), Aginity, nzsql, nzplsql nzload, ER/Studio, Toad, UNIX Scripting, Control - M, Oracle DB 10gR2, SQL, PL/SQL and Informatica

Sr. Database Consultant / Administrator

Responsibilities:

• Established data migration process by Gathering business requirement, perform impact/Gap analysis, Design ETL process and develop mapping of data from source to target system.
• Lead the data integration and database implementation imparted training and mentored to team members about HHSC system.
• Database reverses engineering using ErWin to identify the dependency, Constraint, and unused DB objects to re-design application database. Data modeling, Schema design for state portal database which will be part of data mart in future of Enterprise data warehouse.
• Worked as logical DBA to prepare the various (dev/sit/uat/prodfix) environments to allow parallel applications development, execution of scripts, database change management, automation of tools, archival of data and design the new database objects as per application function enhancements.
• Developed UNIX Shell Scripts for database code change deployment to various environments and Job Scheduling
• Improve the application performance includes; re-structure the queries, implemented the indexes, materialized view, hints and reduce the triggers and dependency on base tables.
• Overall Application performance troubleshooting include database, app server, analyzing monitoring tools data, co-ordination between functional and development teams.
• Installation, setup, Configuration of Oracle Apex 3.2 & Apex 4.0
• Develop Tools of for operational activity using Oracle Apex 3.2
• Production Troubleshooting and support, Perform end to end root cause analysis of problems, solution, development, and implementation to meet the business needs
• Handling unforeseen Production complications as single point contact and recommending solutions or alternative plans for the successful implementation of projects
• On Call level-III production database support on rotation basis, involved in validating the log files for failure sessions, identifying bottlenecks and project enhancements to the system to automate the data loads process.

Environment: Oracle DB 10gR2, SQL, PL/SQL, CA ErWin, SQL* Loader, Toad, OWB 10g, IBM RAID, Content Manager, J2EE, Portal, Hibernate, Web service, Share Point, Solaris 9 UNIX Scripting, Windows 2003 and Linux

Sr. ETL/ DWH Consultant

Responsibilities:

• Involved in designing the entire ETL workflow using OWB, it includes development, technical design, Schema design and mapping document.
• Created/updated ETL mappings, process flows to transfer data from legacy sources to staging area and from staging area to data warehouse and to data marts using Oracle Warehouse Builder. Source includes flat files, MS-SQL Server, FoxPro, MS-Access database
• Used OWB client tools - Warehouse designer, Mapping Designer and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Defined Target Load Order Plan for loading data into Target Tables using Maximo Enterprise Adapter (MEA),
• Developed PL/SQL packages, procedure, triggers and functions to implement backend business logic.
• Developed and Created Oracle views, indexes and materialized views to improve the performance of the reports.
• Developed SQL*loader scripts to load bulk data in the custom/EBS iface tables.
• Exported/Imported OWB metadata, mappings, process flows etc. between Test, QA and Production environments
• Used FTP/SFTP to transfer files from UNIX

Environment: Oracle DB 10gR2, OWB 10gR2, PL/SQL, SQL* Loader, Toad, IBM MAXIMO, Share Point UNIX Scripting, Windows 2003 and Linux

Sr. Database /ETL Consultant

Responsibilities:

• Preparation of technical design specifications, development, testing & implementation of ongoing custom Oracle CRM standard forms (Contact center) and enhancing of existing API's using SQL/PLSQL packages with focus of optimize the application performance. As part of team successfully deployed endorsement, troubleshoot, BOM-Override functionality in define time lines
• Involve in customization of Customer support module of Oracle CRM & Finance Application which includes enhancement of Forms, Custom.pll, Install Base API, Contract creation, service request, task etc.
• Involved in Data Conversion/Data cleansing with the use of Sql * Loader, External tables, customize PL/SQL Packages & procedures to load/extract the data coming from/to different clients used Dynamic SQL, Analytical function, Bulk Collect.
• Worked on stored procedures by performing data loads using Collection, bulk techniques.
• Involve into Datawarehose designing and set up of ETL process to capture CCR activity during the call. These data use to generate the business required reports.
• Created Materialized views, Summary table using Analytical function to improve the performance of EDWH
• Analysis of existing system to streamline the application flow, improvement areas, reusability and easy maintainability of code. Performed impact analysis of existing application to implement process flow based development instead off client specific customization using coding best practice.
• Design and developed the Rules based mechanism for two new processes introduced in contact center application, product endorsement and troubleshooting.

Environment: Oracle 10gR2 RAC, PL/SQL, SQL* Loader, Erwin, Toad, Scripting Languages, E-Business Suite11.5.10, Forms 6i/9i, Reports 9i, Windows 2003 and Linux

Sr. Software Engineer II

Responsibilities:

• Requirement gathering, Analyze various business requirements, preparing scope document, high-level design and use-cases that contributed towards technical design and database design of each business requirements using full system development life cycle(SDLC)
• Development of custom packages, procedures, functions, triggers in PL/SQL and SQL Queries to meet the strict performance requirements, specifications and standards.
• Writing new PL/SQL packages modified existing code to perform Certain Specialized functions / enhancement on Application.
• Lead the ETL data load efforts and train/mentor to team members.
• Implemented Full cycle of ETL Load Monitoring Mechanism to track, monitor and report status of daily data loads from various sources into CTI database. This involves Full and Incremental data loads using both External Table and SQL*Loader approach to scheduling the load job etc.
• Developed common program unit that reads oracle data, compress and send mail as attachments to recipients (Use UTL MAIL).
• Worked on performance tuning of the existing SQL queries & stored procedures by performing data loads using Collection, bulking techniques. Performance tuning technologies used are Explain Plan, TKPROF, TOAD tuner etc.
• Write specifications and perform extraction of data from transaction processing systems to the data warehouse through the ETL process utilizing Oracle Warehouse Builder, SQL, and/or PL/SQL
• Redesigned the SQL queries, optimize, and performance tuning to produces the desired output of transfer phone list as tree hierarchy used in application. Reduced the time by 60%.
• Lead the Implementation of error logging mechanism for pl/sql program units that runs in Autonomous Transaction space.
• Optimized database throughput and cost of operations via performance tuning, storage settings, use of sequence #s and allowing for easy administration. Solution for auto generated sequence number missing while data load process in RAC environment.
• Designed, Developed and implemented Customer Journey tool, which providing transfer statistics of customer calls in Dell contact center, it played an important role in Dell Business to improve customer satisfaction. I am the single point of contact for this application.
• Participated to deployment of web services & DB scripts in DIT/SIT environment to perform testing.
• Support the implementation of the project, Validation, Testing efforts and address any post implementation defects.
• Analyzed various report statistics to identify the areas of improvement for tool. As well as Floor Visit, troubleshoot & on site / on call support.
• Prepared Survey question set and conduct the online survey across the Indian site users, Data capture, Data Analysis, Preparation of Graphical Representations of captured Data to team Based on data statistics we trained the agent to use specific tool more effectively and efficiently.

Environment: Oracle 10gR2 RAC, Oracle 9i, SQL, PL/SQL, SQL* Loader, Erwin, Toad, ASP.NET, C#, JAVA, web service, UNIX scripting.

Sr. Software Engineer (Data warehouse /ETL)

Responsibilities:

• Responsible for Data Modeling, data warehouse and Data Mart Technical Specification in support of source data and its modeling and transformation to support new sets of business intelligence solutions
• Developed interfaces/Utilities using PL/SQL (Packages, Procedure & Functions) to support data loads from legacy system to Oracle database.
• Optimize ETL processes whenever necessary using customize pl/sql code.
• Used OWB client tools - Warehouse designer, Mapping Designer and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse
• Created mappings from source systems to target systems. Implemented Join, Expression, Aggregate, Lookup, splitter, duplicator, Filter, Sorter etc. Transformations in Mappings.
• Developed the general solution to handle slowly changing dimension to accommodated business requirements
• Scheduling job using oracle Job scheduler.
• Design and development of customize reports as per the requirement using oracle reports and Discoverer
• Design and developed the Client GUI using forms 9i as per the change request.

Environment: Oracle 8i/9i Database, Oracle warehouse builder, PL/SQL, HTML DB, Sql*Loader, Erwin, Forms 9i, Discoverer/Reports 9i, Informatica Power Center, TOAD, UNIX/Windows 2000.