Summary

• 750K revenue recovery related to OE pricing reconciliation raw material tracking
• Saving of approximately 4 Mil per year on IT cost from 2007 spend on pricing support
• 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:
• I look forward to meet with you soon. Please do not hesitate to contact me if you have any questions or clarifications.
• Thanking you very much for the consideration.
• Yours truly,
• Rama Ganapathy

Experience

• 24 years of overall IT experience, recent 15 years in architecting data warehouse, business intelligence analytical data marts for industries like Retail, manufacturing and functions like sales marketing, finance and pricing.
• Strong exposure to data warehouse, business intelligence and analytical model design and delivery.

Skill Set Summary:

• 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

Application Development Architect

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

Technical features encompass:

• 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

Application Development Consultant 2002-2006

• Hired as Application Development Consultant, quickly earned reputation for speed and accuracy and became a de facto go to guy. Soon found myself involved in data schema design and complex ETL work related to Sales Order Management subject areas.

Tools used:

• Use of TERADATA, Oracle, shell script, Perl, HP UNIX, Windows
• Strong use of BTEQ, a TERADATA tool to create and run SQL procedures
• Use of INFORMATICA, a GUI ETL tool for data loading and transformation
• Use of AUTOSYS, for job automation
• Use of ERWIN

Confidential

• Hired as a contract developer through Computer Enterprises Inc CEI , Pittsburg, PA for developing data warehouse programs using Pro C and Oracle on Unix environment supporting sales marketing, inventory and finance subject areas.
• 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.

Technical features:

• 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

Air Touch Cellular now Verizon wireless , Dublin, OH August 1997 October 1999

• Hired as a contract software developer/tester through Computer Enterprises Inc CEI , Pittsburg, PA for Y2K test developed and executed test cases etc. for billing system.
• 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 .

Technical features:

• Use of Oracle 7.3, ACMS, Pro C, Dec C, DCL, Datatrive, Cyrano
• Use of PRO C, ORACLE, DEC C, COBOL and DCL.

Confidential

• Implementation and customization of an ERP system called EMIS involves finance, sales and distribution, order management, inventory management, BOM and routing, production, shop floor control etc.

Technical features:

• 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

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