PROFESSIONAL SUMMARY:

• Having 19 years of experience in the Information technology industry including Project Management and Solution Architecture with complete SLDC (Software Requirements, Design, Construction, Testing, Implementation and Support Maintenance) knowledge
• Played Solution Architect, Technical Manager, Project Manager, Data Architect, Data modeler roles
• Developed and Implemented End - to-end customized Manufacturing solution for engineering companies
• Designed and Implemented complete Data Warehouse and Data Marts using Microsoft Technologies
• Having hands on experience on Online Transaction Processing (OLTP) and Data Warehouse Physical and Logical Data Modeling
• Having exposure to ISO 9001 and CMM Level 5 Quality procedures and processes
• Having exposure to various domains including Manufacturing, ERP, MRP, Supply Chain Management (SCM), Banking & Finance, Retail, Automobile and Media & Advertising and Oil and Gas
• Have excellent communication skills, self-motivated and having aptitude towards learning new technologies and domains

SKILLS:

Master Data Management (MDM)

Microsoft Project Plan and Office 365 (Project Online)

Agile and SCRUM

Oracle 12c, Oracle 11g and Oracle 10g

SQL Server 2012 and SQL Server 2000

Data Science Tools ( R, Python, Tableau and Power BI

BIG Data (Hadoop, Hive, Sqoop)

Talend Data Integration

Microsoft BI (SSIS & SSRS)

Teradata Database 12.0 ( BTEQ, FASTEXPORT and MLOAD)

IBM DB2 8.1 ( SQL and Move for DB2)

All Fusion Erwin Data Modeler 7.2 (Logical and Physical Data modeling)

PLSQL Developer, Toad 9.0, Oracle SQL Developer 1.0 and Teradata SQL Assistant 7.1

BMC Remedy

Oracle SQL Loader (Bulk Data Load) & Shell Scripts (Korn Shell)

Cognos Report Net, Cognos Framework Manager, DataStage and Informatica

Linux, UNIX, Windows 2000 server, Window 9x and Windows XP, Mac X OS

Visual FoxPro 8.0, Visual Basic 6.0, Symantec pcAnywhere, Visual source safe

C, C++, C# and JAVA UiPath

PROFESSIONAL EXPERIENCE:

Confidential

Project Manager

TECHNOLOGY: SQL SERVER, .NET, TERADATA, DATA STAGE, COGNOS AND MORE

Responsibilities:

• Contributed heavily to win multi-year, multi-million Agile Managed Services contract
• Executed last three Qtrs. services with Tier 1 bonus
• Show cased cross functional supervision, Team Building and mentoring capabilities
• Setup excellent client Relationship
• Contributed to Uipath Automation
• Changed execution model of two application tracks from waterfall to Agile methodology
• Overseen DataStage upgrade and other Integration projects
• Worked with different customers and acquired project budget for 2018
• Excellent feedback received from customer for BCP support during Harvey
• Excellent customer feedback received in Quarterly Governance
• Initiated Azure/Cloud application migration track/project
• Executed Jenkins/DevOps POC

Confidential

Project Manager

TECHNOLOGY: ORACLE 11G, ORACLE 12C, UNIX, CLOUDERA 5.7, SQOOP, TALEND AND COGNOS

Responsibilities:

• Reached FY15 and FY16 customer goals (On time Tickets resolution, On time Projects Delivery, Overdue tickets control, TED One Number Improvement, Tickets rating improvement and Projects rating improvements) by taking various measures
• Improved TED one number (System Health Number) from 74% to 92% (Historical High)
• By systematic approach, reduced overdue tickets from two digits to single digit to improve system stability
• Setup BIG DATA COE
• Involved in Designing Data Lake
• CPD Divestiture, Data Separation project
• 53 Weeks Project (Data validation/correction project for year on year data comparison)
• SAP Upgrade (SAP Production system, which sends 70% of data into TED was updated to latest version) O Re-platform/Oracle 12c upgrade (18 TB DB50 plus web applications and 5000 plus Jobs testing and migration)
• Worldwide SAP rollout projects (New plants in China, Japan, South Africa, Brazil, and USA)
• Worked with Data Providers/SAP team to avoid recurring data quality issues
• Multiple Technical discussion conducted with DBA team to avoid tablespace error and other recurring
• Database errors which were affecting the SLA and TED One Number
• Mentored the team by providing technical guidance on Oracle related technical issues
• Participated in various performance improvement activities related to database performance Improvements
• Created a case study on Data Science using Time Series Analysis and Twitter data Analysis
• Provided multiple technical suggestions to avoid/minimize production downtime

Confidential

Project Manager/Solution Architect

TECHNOLOGY: SQLSERVER 2012, MSBI (SSIS & SSIS), SAP BW AND COGNOS CUBES

Responsibilities:

• Created comprehensive Project Schedule for GDW
• Developed or updated project plans, objectives, technologies and milestones
• Monitored the project and Highlighted risk factors through careful analysis
• Proposed mitigation plans for all the risks identified time to time
• Executed the project End-to-End delivery
• Setup Good relationship with the Customer and other support teams at Onsite
• Led cross skilled technical and non-technical teams at Onsite and Offshore
• Defined processes and tools best suited for GDW project
• Resolved the conflicts between team members
• Setup good platform for Onsite-Offshore communication through daily meetings
• Identified different project dependencies and projected in status meeting for closure
• Technically contributed on the following:
• Design of Overall Solution Architecture of GDW
• Data Modeling - Dimensions
• Data Modeling - Facts
• High Level ETL strategy design
• Low Level ETL Job design
• Reports Technical Design and guidance
• Brand Marts/Data Marts Design
• Data Load strategy design for 3 Brand Marts having GDW as source system
• Contributed to Route Cause Analysis (RCA) of the defects to control quality issues

Solution Architect

Confidential, Cupertino

TECHNOLOGY: ORACLE (SQL, PLSQL), MYSQL 5.5 AND JAVA

Responsibilities:

• Successfully completed five major development releases with Zero UAT
• Successfully completed fourteen month end close activities, NPI support and Expansion projects
• Responsible for End-to-End delivery of the development releases
• Designed, Created and Maintained HTML report from PL/SQL for FY-11 Q1 Sonar Mail-in flow monitoring
• Facilitated Oracle 11g migration by coordinating with DBA team and executed post upgrade testing in development environment by comparing pre & post AWR reports, Parameters and executing Autosys jobs etc.,
• Generated Volume Trend Reports on monthly basis from Sonar production database
• Analyzed the existing performance hurdles and suggested solutions by analyzing the AWR reports
• Created a new optimized Data model for Miniteam and related tables in SONAR
• Analyzed MySQL database performance
• Provided solution to the production issue related to receipt printing by using Oracle 11g Skip Locked clause
• Designed MySQL Data model for store database using MySQL Workbench
• Designed and Implemented DDL Auditing triggers in all DEV and QA databases to capture the changes done by various teams
• Partitioned of high volume transaction tables for performance and maintenance

Confidential, Dearborn, Michigan

Technical Lead/Data Migration Analyst

TECHNOLOGY: ORACLE (SQL, PLSQL), SQLSERVER 2000, TERADATA AND IBM DB2

Responsibilities:

• Played Lead Data Separation Analyst/Project Lead role and separated Business Data for 16 DB2 8.1 (CMMS suite of applications) and 2 Oracle 10g applications by analyzing the existing data models, data bases, tables etc., and gathering Business Rules from Subject Matter Experts. Created Move of DB2 scripts and designed the Data Separation job schedule for all CMMS suite of DB2 applications and Oracle applications
• Played Lead Data Separation Analyst role and supported database installations and Data Separation activities (Data Extract and Data Load) of 24 Oracle 9i/10g applications (All distributed Oracle Applications based on US and UK). Managed and technically supported all the Data Separation Offshore team for distributed applications
• Played technical role and supported the Data Separation activities for 3 Teradata 12.0 applications. Created FASTEXPORT and MLOAD scripts for FPC and DOLVOL applications
• Coordinated and technically supported offshore and onsite team for Dry Runs and Accelerated plan
• Created Design Documents and Written Data Separation Queries, Scripts using SQL, PL/SQL and Move for DB2 for DB2 and Oracle applications including a complex DB2 application with more than 3 Terabyte of data using complex partitions methods and a complex Oracle 10g application with more than 400 tables
• Extensively scheduled and conducted sessions for more than 200 hours with Business and IT Subject Matter Experts (SME) from different parts of the world (USA, UK and India) and captured all the information required for Data Separation
• Appreciably coordinated with Client Manager, Subject Matter Experts, Group Managers, Onsite and Offshore team members to attain the production effectiveness and timely completion of target deliverables

Confidential, Washington, DC

Senior Database Analyst

TECHNOLOGY: ORACLE (SQL, PLSQL), INFORMATICA AND COGNOS

Responsibilities:

• Supports management reporting needs for MIS. Supports reporting needs that relate data across multiple systems.
• Supports trend reporting for analysis of business activity over long periods of time
• Designed and Implemented Data Extract and Load Architecture for Operational Data Store (ODS)
• Created Oracle Stored Procedure to Extract Data from various legacy Production Systems and Load (REFRESH) them into Enterprise Data Warehouse (EDW)/Operational Data Store (ODS)
• Created and implemented Oracle Stored Procedures to Reconcile the data between Source Production Systems and ODS
• Monitored Data Quality of daily/weekly/monthly feeds
• Created and implemented system for adjustment transactions within the existing system
• Designed and Implemented Oracle to XML and XML to Oracle Data Conversion Interface for Metadata Management

Confidential

Senior Systems Analyst

TECHNOLOGY: SQLSERVER 2000 AND VISUAL FOXPRO 6.0

Responsibilities:

• Designed Logical and Physical Data Models
• Created SQL Server Stored procedures, Triggers
• Analyzed the requirements specified in the Technical Request
• Developed solutions for the cosmetic, Logical, Fatal and Design Issues mentioned in the Technical Request
• Created Q-Patches and Service Packs based on customer various requirements