SUMMARY

• 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.
• Led discovery sessions to understand the existing and desired business processes, serving as a liaison between multiple departments to facilitate project scoping, requirements gathering for new business processed by conducting deep data analysis and data profiling that helped architect a new solution for business. Built a roadmap, cost estimates and implementation plan to deploy the end-to-end solution in BI space.
• Experience in Data Modeling Logical/Physical, Dimensional and Star/Snowflake schema designing for both OLTP/OLAP and DSS systems. Refactor existing data models & databases for performance and scalability using Erwin, E/R Studio
• Architecture experience on ETL Process/tools such as Netezza AMPP scripting, Customize PL/SQL, Informatica Power exchange, OWB, ODI and Batch processing. Developing UNIX shell scripting and automation of ETL processes with Schedulers
• 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, metadata repository, master data management for the organization.
• Extensive experience in Reverse Engineering legacy databases to acquire detailed understanding of existing data structures for both OLTP data model and OLAP data 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 a mentor. Established teams offshore-onsite from scratch
• Expertise in Oracle 10g/11g/12c SQL&PL/SQL, SQL Server, Netezza with experience ranging from analysis, design & development to support Web-based OLTP systems, Business Intelligence, OLAP and ETL/ELT data feeds to EDWH systems.
• 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
• Experience with 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.
• Work closely with business stakeholder, cross-functional teams, engineers and peers to understand the business requirements and help design, develop and implement solutions and integration that meet the business needs.
• Performed entrepreneurial management skills including leadership, problem analysis and decision-making, planning and organizing, interpersonal, adaptability/flexibility, stress tolerance and time management. Skills included staff and work planning, personnel appraisal, motivation and team-building, and delegation.
• Experience in using Version Control, Quality control, remedy and DB change management.
• Knowledge of full SDLC, agile methodology, Extreme Programming.
• Proficiency working within the Hadoop platform including Kafka, Spark, Impala, Hive, Pig, Hbase, Flume, and HDFS in multi-tenant environments
• Knowledge on 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, PostgreSQL, SQL Server 2005IBM Netezza 6.0

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

Data Warehousing/ ETL: Snowflake (Cloud based data warehouse MPP), IBM Netezza Data Warehouse Appliance 6.0.4,Oracle Warehouse Builder(OWB), Informatica Power exchange 9.6, Informatica 9.6 metadata manager

OLAP/ Reporting: Cognos 8.4 /10.2, SPSS, Oracle Reports, Discoverer/ Discoverer plus

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

Big Data: Hadoop Ecosystem, HBase, Pig, Hive, Spark, Python, AWS, RedShiftMongoDB

PROFESSIONAL EXPERIENCE

Confidential, Plano TX

Sr. Consultant (Data Architect/Modeler)

Responsibilities:

• Leading efforts to re-model legacy systems 3NF data models to de-normalize flattening data strategy for data migration to cloud base data warehouse (Snowflake MPP) system in AWS cloud environment.
• Designing data architecture standards, best practices, and data governance procedures, end-to-end data workflow, blueprint of overall data model structure pre & post migration.
• Building logical/physical data model schema designing for operation reporting and analytics platform.
• Refactor existing data models using Erwin, maintaining metadata, design ETL/ELT mapping technical spec
• POC for data movement patterns, writing SQL scripts to cleansing data, business logic transformation and establishing data pipeline using kafka, AWS S3, spark, sparkSql, SnowSql and python.

Confidential, Arlington, TX

Sr. Consultant (Data Architect)

Responsibilities:

• Consulting as Data Warehouse Architect / Modeler, working on GMF Auto Finance System (Loan Origination /Servicing) using Erwin, SQL and Oracle Database. Research and evaluate new data managements techniques such as Data Vault2.0, Hadoop, NoSQL, Data Virtualization, Data Services and make recommendations on how they can complement the existing GM Financial Data Architecture.
• Participate establishing Data Architecture standards, best practices, and Data Governance procedures. Oversee adherence to these standards.
• 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.
• Develop end to end solution /architect and model several new data feeds for salesforce interface (API’s) from enterprise data warehouse and Oracle ERP system.
• Create and document logical data integration (ETL) strategies for data flows between disparate source/target systems and the Enterprise Data Warehouse.
• Participate enhancement of Data Vault 2.0 design to create data presentation/ visualization layer for the enterprise multilayer data warehouse solution environment.
• 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 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, Salesforce workbench /force, Informatica Power exchange 9.6, Informatica 9.6 metadata managerCognos10.

Confidential, Lewisville, TX

Sr. Consultant (Lead / Data Architect)

Responsibilities:

• Provide technical leadership for new proposals and building road map from scratch to improve data delivery to business users, keep in mind the big picture of the business process to accommodate future changes, which includes in-depth analysis, requirements definition, architecture, design, validation, implementation, problem identification and resolution.
• 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
• Closely work with management to prepare data architecture plan to meet business needs and design robust data models to ensure data consistency and traceability across enterprise systems, proper resolutions for data integration, roadmap for enterprise data initiatives and maintain documentations of all architecture processes
• Design, Develop Star/Snowflake schemadata modeling for business process and creating the Logical/Physical design of Database using SQL Data Modeler tool.
• Define, Design customize, flexible, scalable and efficient homegrown (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.
• Exploring a business process to find out how data is or will be, used and implicated on people, process, products and technology. Analyze performance bottleneck/offensive queries and optimize database/reporting application.

Environment: Oracle DB 11.2, 12c, SQL, PL/SQL, SQL Server 2008, SQL Developer, SQL Data ModelerErwin, Data Stage, Cognos 8.4 and 10.2.2, EBS 11.5 / R12.

Confidential, Irving, TX

Sr. Consultant (Lead / Database Architect/Developer)

Responsibilities:

• As part of platform team (Architecture group), key contributor to Define Data Architecture and Data Conversion/ migration strategies and point of contact for all database related work across the retail solution project (RISE). Closely work with the business stream, SME groups and co-coordinating off-shore development teams.
• Define Data integration/conversion road-map, database modeling policy, strategies, standards, guidelines and best practices for large and strategic application systems in the retail domain.
• Lead Data Migration efforts from SQL Server 2000 to Oracle 11g, providing guidance and mentored a team of data modeler and developer.
• Design relational and dimensionaldata model for creating the logical and physical design of database (OLTP/OLAP). Deliver ER diagrams using data modeling tools like SQL data Modeler
• Re-engineering existing data and data usage patterns to build new retail data model and refining existing data structure; Converting business logic from the application layer to database layer using stored program units. Ensure 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 the code.
• 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.
• Produced catalogs of logical and physical schemas. Database design and implementation for numerous applications used by several devices in retail space such as a scanner, POS, GOT etc.

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

Confidential, Houston TX

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 the end to end data flow by subject area and convert them in technical data mapping spec.
• Work on OracleDataIntegrator(ODI) as part of POC for Netezza interface.
• Development for ELT Process, Mapping specs for a 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.
• Hands on Netezza tools and Utilities: NzLoad, NzSql, NzPL/SQL, SQL toolkit, Analytical functions etc.s
• Production troubleshooting, Support data validation, data quality analysis, code deployment to the higher environment.

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 Power exchange

Confidential, Austin TX

Sr. Database Consultant / Administrator

Responsibilities:

• Lead the data integration and database implementation imparted training and mentored to team members about Confidential system.
• Established data migration process by gathering business requirement, perform impact/gap analysis, design ETL process and develop a mapping of data from source to the target 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 database admin (TIERS) 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.
• Production Troubleshooting and support, perform end to end root cause analysis of problems, solution, development, and implementation to meet the business needs

Environment: Oracle DB 10gR2, SQL, PL/SQL, CA Erwin, SQL* Loader, Toad, OWB 10g, IBM RAIDContent Manager, J2EE, Portal, Hibernate, Informatica Power exchange, Web-service, Share Point, Solaris 9 UNIX Scripting, Windows 2003 and Linux

Confidential, Baltimore

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
• 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 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

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

Confidential, VA

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 the focus on optimizing the application performance. As part of team successfully deployed endorsement, troubleshoot, BOM-Override functionality in defined timelines
• 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.
• Involve into Data warehouse 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
• 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

Confidential

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.
• 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, compresses and sends mail as attachments to recipients (Use UTL MAIL).
• 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 the application. Reduced the time by 60%.
• Lead the Implementation of error logging mechanism for pl/sql program units that runs in Autonomous Transaction space.
• Customer Journey tool: Designed, developed and implemented (point of contact), which providing transfer statistics of customer calls in Confidential contact center, it played an important role in Confidential Business to improve customer satisfaction.
• BPI project: Prepared Survey question set and conduct the online survey across the Confidential India site agents. Capture data, perform data analysis, preparation presentations of captured data to the team. As a result, based on survey data statistics we initiated “train the trainer” program to use specific function/feature of softphone tool more effectively and efficiently. This reduces the call duration to the agent and increases # of calls answered by an agent.

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