SUMMARY

• Over 17 years of IT experience including over 10 years in Data Warehousing and Business Intelligence consisting of Dimensional Modeling, ETL, Reporting and RDBMS.
• Full life cycle Implementations of Enterprise Data Warehouse solutions wif emphasis on Dimensional Modeling (Kimball/Inmon), Data Modeling and Data Analysis.
• Integrated roll - out of teh Business Intelligence solutions in parallel wif ETL and Data warehousing implementations
• Successfully managed multiple projects in a challenging environment in Logistics, Customer Service, Operations, HR, AR, and AP functional areas.
• Communications wif cross-functional teams and Business Partners to ensure projects are implemented on time
• Successfully managed medium scale IT groups, both offshore and onsite
• Recognized for leadership in project management and implementation of IT projects

PROFESSIONAL EXPERIENCE

Data Architect

Confidential

Responsibilities:

• Involved in teh existing systems study, gather requirements, identify customer’s needs and proposed Data Warehouse solutions.
• Analyzed OLTP sources, Metadata repository for data discovery.
• Designed and Developed Logical and Physical DB’s on Oracle
• Involved in documentation of ETL process, creating Data Dictionary and followed data standards nomenclature.

Confidential, Memphis, TN

Technology Architect

Responsibilities:

• Data profiling of huge volumes of data for quality, accuracy and consistency.
• Involved in creating dimensional modeling strategy, Knowledge transfer to customer, implemented change requests and conducted end user training.
• Created technical specifications docs from functional requirements, analysis of business processes.
• Helped in creating a process for development of Reports, Dashboards and KPI’s for Field Operators, Engineers, Managers and Senior Management covering over 3000 locations.
• Implementation of Data Mart for teh Domestic Ground Operations for Postal data
• Data Modeling, Data profiling for postal data and extraction from OLTP sources.
• Understanding and refine functional requirements, mapping data and providing solutions
• Created documents for end users, best practices guide, templates and also conducted end user training.Integrated disparate data sources into Data Mart for Global Linehaul
• Implemented Data Mart solution to consolidate teh worldwide fleet movements by providing a centralized view of all teh flights and trucks.
• Profiled teh OLTP sources for accuracy, statistics and quality.
• Implemented reports and dashboard for trucks and flights as part of data warehouse implementation.
• Provided test cases, test scenarios for Unit, System, Integration and UAT Testing for all reports.
• Implementation of BI strategy for Sales - Lead Program and implemented throughout teh enterprise
• Created an ETL process for extracting data from disparate OLTP sources and loading into Sales data mart.
• Worked as mentor to Junior Developers, Business Analysts on BI strategy.
• Created mappings, workflows and transformations for ETL.Implemented SAP BO Dashboard and Reporting for a fleet of over 45,000 vehicles
• Lead business interviews and information discovery sessions to collect existing processes and procedures.
• Designed and developed mock-up dashboards.
• All teh metrics for dashboard implemented based on department’s hierarchy wif security.
• Developed SAP BO XI 3.1 Xcelsius Dashboard for agents to track Cost per mileage, Stops per hour, Accidents, Repairs per vehicle, Scheduled Servicing.Implemented Accounts Payable EDI department’s BI strategy
• Performed thorough Data Profiling and Data Analysis to ensure dat reports meet their business objectives.
• Designed BI solution to meet teh internal customer objectives.
• Developed SAP BO XI R2 Deski reports for all Vendors in teh department.
• Delivered training on ad-hoc reports for power users.

Project Manager/Lead Consultant

Confidential

Responsibilities:

• Managed a team of 10 in teh project which involved end to end testing of enterprise level systems in Accounts Receivables systems. This project was executed at FedEx Institute of Technology utilizing teh resources from teh University Of Memphis.
• Created training plans, trained teh staff, scheduling of resources, developed testing approach, provided direction on testing approach, created testing procedures, documentation and completion of multiple iterated testing cycles.

Confidential, Memphis, TN

Lead Technical Consultant

Responsibilities:

• Provided team leadership in teh design, development and implementation of logic for new surcharges for all US Shipments in mainframe/distributed environment. Spearheaded expansion projects to create more meter numbers for automation devices, involved in ARISE project for integration of data for Express and Ground invoices. Ensured teh team of 6 developers conformed to standards, specifications and quality expectations. Interfaced wif DBA for teh design, creation, and maintenance of data in IMS/DB2/SQL Server.
• Worked on Corporate Initiative requests and involved in doing Impact Analysis for teh system, writing systems requirements and delegating on to teh programmers to make changes to teh impacted programs
• Played key role in a variety of projects in design, development and enhancement projects for billing systems in IBM mainframe and distributed environment. Played a key role in enhancing teh group’s impact by successfully implementing teh projects on a timely basis.

TECHNICAL SKILLS

Software: Java, SAS Base,ASP.net, VB Script, Java Script, C#, VB.net, UNIX,COBOL, JCL, C, REXX, Microsoft - Office, Project, Visio, HTML, Shell Scripting

Database: SAP HANA, SQL Server, Oracle, Teradata, MS Access, DB2, IMS, CICS

BI/ETL Tools: Informatica, SAP BW, SAP BO Data Services, SSIS, SSAS

Reporting Tools: SAP BOBJ, Web Intelligence, Desktop Intelligence, Crystal Reports

Operating Systems: Windows, UNIX, Linux, z/OS

Tools: TOAD, ERWIN, Power Designer, Xpeditor, File-Aid, Team Foundation

BIG DATA: Hadoop, Map Reduce, PIG, Hive, HBase, Sqoop and Zookeeper (working noledge)