SUMMARY:

• I have strong exposure to data warehousing, business analytics, data mining. I have strong technical skills, combined with business exposure.
• I have solid data warehouse design expertise (star, snowflake), warehouse concepts (Bill Inmon, Ralph Kimball) and worked on large scale data warehouse projects. I have worked closely with business management and translated business needs into conceptual, logical, and physical data models. I have strong exposure in conceptualizing and designing data mart and analytical marts.
• I enjoy analytics and have designed several analytical marts and data marts to support business analytics. I have a good understanding and application of business statistical methods.
• I have hands on experience using data modeling tool ERWIN, Microsoft BI tools (SSIS, SSAS & SSRS) & ETL tools like INFORMATICA. I also possess a strong expertise on databases like Oracle, TERADATA and SQL Server.
• Various initiatives I have implemented on my current employment resulted in huge cost savings. Few of them are listed below:
• Saving of approximately 4+ Mil per year on IT cost (from 2007) spend on pricing support
• 750K revenue recovery related to OE pricing reconciliation (raw material tracking)
• Able to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.
• Driving technology projects, serving as link between business stakeholders and developers to ensure delivery of new solutions according to client requirements.
• Strong exposure to design concepts: conceptual, logical and physical models for data warehouse, data mart and analytical mart.
• Design standards for using normalized data structures, de - normalized structures, and dimensional structures.
• Strong analytical skills, fact finder, data mining and business statistical skills.
• Vast experience on Extraction, Transformation and Load (ETL) strategy, design and implementation.
• Understanding of “Big Data” and unstructured data concepts;
• Designed conceptual & physical data models for an analytical data mart to review $2 billion trade spend; which enabled discussion with channel, brand, sales & marketing managers.
• Authored and designed analytical data marts to measure ROI for several national promotions and independent marketing drives and events
• Authored business metrics like “Retail Refined Average” - Estimation of regional and/or national market price average (noise reduced), “Target Segment Market Price Index” - An index which measures overall price in different target segments; designed conceptual and physical models to support the analytics.
• Played a vital role in establishing an IT team to support pricing functions which resulted in a cost savings of approximately 4+ Mil per year.

TECHNICAL SKILLS:

Data Design Concepts: Data warehouse concepts of Bill Inmon, Ralph Kimball, dimensional models, 3rd normal form designs, star, snowflake schema designs etc. Data mart, analytical mart designs using normalized and/or un-normalized or partially normalized designs and their transformations.

Project Management: Waterfall, Agile methodologies and strong technical and people skills.

SQL and Databases: SQL Server, Oracle 7-11g,TOAD,SQLldr, TERADATA, BTEQ, MLOAD, TSQL, PL/SQL, ANSI-SQL

ETL/BI Tools: INFORMATICA, SSIS, SSRS, SSAS.

Document Database: Knowledge of Python and Mongo database

Office Programming: Develop applications using Excel, VBA, Word, Access and Power Point

Design/Case Tools: ERWIN

Programming: C++, C#, VB, VBA, VB.NET, C#.NET, ASP.NET

Operating Systems: Windows Servers, Solaris, HP Unix, Shell, Unix utilities, VAX-VMS

Conventional: COBOL, C, Clipper, dbase, FoxPro

PROFESSIONAL EXPERIENCE:

Confidential, Akron, OH

Application Development Architect

Responsibilities:

• Designed and implemented sales data mart for North American consumer business segment with a focus to analyze rebate, trade spends and profitability trends.
• Designed and implemented a market pricing database aka competitor database; established web scraping procedures, parsing routines, data quality control procedures etc. Developed and managed an offshore team to support tactical activities and maintenance. Currently this database captures about 2 million price points per month from almost 154 data sources and became widely used database by sales and marketing teams.
• On recognizing my analytical skills, I was promoted to Trade Fund Planner where I got a chance to closely work with business management, became an end-to-end analytical solution provider. Managed a solution portfolio with SLA.
• Leveraging my analytical skills, authored, designed and developed analytical marts for analyzing trade spends, opportunity SKUs, price elasticity, raw material price tracking for “OE customer pricing” etc.
• Designed, implemented and developed a “Run-rate” data mart to support run rate models.
• Authored business metrics like “Retail Refined Average” - Estimation of regional or national market price average (noise reduced), “Target Segment Market Price Index” - An index to measure overall price in different target segments; designed conceptual and physical models to support the analytics for dash boards, competitor pricing comparisons, pricing trends, new product pricing and positioning etc.
• In 2014, as Business Process Principal, I was given additional responsibility of rebuilding offshore team again due to unexpected resource attritions.
• Designing of data marts & analytical marts
• Use of SQL Server 2000, 2005 & 2008 on Windows
• Use of T-SQL for database procedures
• Use of VBA and Office programming, VB.NET, C#.NET, Visual Studio 2008,2012,2013
• Use of SSIS, SSAS & SSRS
• Use of AUTOSYS, ERWIN

Confidential, Eden Prairie, MN

Application Development Consultant

Responsibilities:

• Soon started working on many critical projects like financial dash board, market basket analysis, owned inventory report etc. Successfully tuned many Pro*C code, SQL; notable one is calculation of Owned Inventory (under 2 hours) which eluded many programmers earlier (all previous runs never completed or force terminated after weeks.)
• Quickly become only contract resource sitting in design/implementation meetings; involved in data warehouse/data mart design, ETL development and implementation.
• Also, I have provided on-call support on production issues.
• Use of Pro*C/C++, PL/SQL, shell script, Perl, HP UNIX, Windows
• Oracle Application Tuning and recommendations for database tuning
• Use of Maestro, a commercial networked scheduling package on UNIX, for job automation
• Use of INFORMATICA, a GUI tool for data loading
• Use of ERWIN

Confidential, Dublin, OH

Responsibilities:

• Eventually become the only person in the team who could able to pull data from production and setup test data for test case scenarios. Liaised with software developers and billing SMEs to document functionality of billing system in order to write effective test cases and plans.
• Created test scripts using Cyrano; setup test environment (includes database setup, data collection, develop support tools, data aging etc).
• Use of Oracle 7.3, ACMS, Pro*C, Dec C, DCL, Datatrive, Cyrano
• Use of PRO*C, ORACLE, DEC C, COBOL and DCL.
• Use of Oracle 7.3, Oracle Forms
• Use of Lotus 123,clipper,DBase, FoxPro
• Use of SCO Unix and Windows 3.1

Confidential

System Analyst/Programmer

Responsibilities:

• Joined as a programmer supporting payroll, sales & accounting.
• Promoted as System Analyst/Programmer, tasked with payroll system upgrade, development of supply point billing and invoicing systems which integrates with sales accounting.

Environment: VAX-COBOL, VAX-VMS, Ingres 6.2, C, Clipper 5.2, DBase, NOVELL NETWARE 4.1, FOXPRO