SUMMARY:

• MBA with over 20 years’ experience in technical product introductions utilizing technology, marketing, finance, and strategic management expertise. Strengths include: Full life - cycle experience with software applications, strategic thinking and understanding of the big picture, excellent leadership, coordination, and communication skills, and in-depth understanding of project management methodologies, requirements definition techniques, business process re-engineering, data warehousing and business intelligence, data modeling, object modeling, software design and database technologies. Expertise in multiple project management methodologies such as agile with scrum and RUP utilizing onshore and offshore teams.
• Proficient in working with various functional groups such as marketing, sales, manufacturing, development, test, quality, regulatory and external vendors. Adept utilizing business intelligence tools such as Cognos, Business Objects, and OBIEE.

TECHNICAL SKILLS:

General: MS Word, Excel, PowerPoint

Operating Systems: Windows, UNIX, Solaris.

Databases: ORACLE, SQL Server

Analytics: Cognos, SAS, Business Objects (BI4), OBIEE

ETL: Informatica

Software Engineering Methodologies: RUP, UML, Agile with Scrum

Programming Languages: Java, C++, C, SQL, PL/SQL, ASP .NET with C#

Modeling Tools: Visio, Rational Rose, Enterprise Architect

Requirements Management: Rational RequisitePro, DOORS, HP Quality Center

Configuration Management: Clear Case, PVCS, TFS, Share Point

Project Management: PlanView, Daptiv, Smartsheet, Atlassian Jira, MS Project

Others: Sales Force, Hyperion

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior Business Intelligence Business Analyst

Responsibilities:

• As consultant through High Tech Solutions Consulting, analyzed requirements and business processes for incorporating Price f(x) data and Pricing Analytics into Salesforce to be leveraged by Sales Reps and Area Sales Managers in the quote creation and quote approval processes.
• Proposed business process reengineering options for simplifying the quote approval workflow and price escalators on long term quotes.
• Led Salesforce developer in solution design and screen layout design for Pricing Analytics project.
• As a trusted advisor, led the business process reengineering of Operations Finance department in the USA and Canada to standardize definitions, data sources, and formulae for calculations for the manufacturing cost reporting.
• Developed report functional specifications, conceptual data model, and data mapping requirements including formulae for all calculations including complex allocations for Manufacturing Cost Analytics project.
• Led the data architecture, dimensional data modeling, ETL solution design and report design for Manufacturing Cost Analytics.
• Analyzed and documented requirements for integrating with Hyperion as a source of the plan data and for sending actual manufacturing cost data to Hyperion for financial reporting and forecasting.
• Skills used: OBIEE, Salesforce, Financial Reporting, Hyperion, Atlassian Jira, Visio, Oracle EBS

Confidential, Cincinnati, OH

Business Intelligence Business Analyst

Responsibilities:

• As consultant through Data Intensity and Halcyon Solutions, analyzed requirements for integrating the reporting to facilitate the merger of xpedex Inc. and Unisource Inc. to form Confidential, a fortune 500 full service distribution company.
• Led the business process analysis and reengineering to identify the similarities and differences in the operations of legacy xpedx and Unisource companies so that common systems can be used by users from both sides of the company.
• Identified and coordinated the resolution of data gaps in reporting due to the differences in the systems used by the two companies prior to the merger.
• Developed report requirement specifications, data models, and data mapping for Confidential ’s over 40 high priority reports for revenue management, sales customer service, accounting, and finance.
• Led the data architecture, data modeling, and ETL solution design for inventory and back order reporting
• Managed off-shore and on-shore developers in developing the reports.
• Led the collaboration with multiple application teams to resolve data issues.
• Managed the User Acceptance Testing of reports by various stakeholders.
• Skills used: SAP Business Objects (BI4), Data Vault, SmartSheet, Atlassian Jira, Oracle, SQL Developer

Confidential, Confidential, IN

Business Intelligence Specialist

Responsibilities:

• Managed multiple business intelligence projects through inception, requirements, data modeling, design, development, test, implementation, and support for Confidential, the leading casket manufacturer in the US.
• Developed Cognos Reports, Active Reports, Dashboards and Cubes to meet needs for different functional areas including Marketing, Logistics, Sales, Revenue Management, Manufacturing, and Finance.
• Developed dimensional data models for reporting and data vault models for data integration.
• Developed several Informatica jobs to integrate data from various data sources.
• Prepared the evaluation criteria for RFP for a new reporting platform.
• Prepared the strategy and roadmap for the data warehouse transformation project. received on Cognos Report Development, Active Reports, Framework Manager, Transformer, Data Vault 2.0 (based on Scrum).
• Trained analysts from different functional groups within Confidential on Cognos report development.
• Skills used: Cognos Report Studio, Framework Manager, Transformer, Power Play Studio, Workspace, Workspace Advanced, Active Reports, Data Vault 2.0, Informatica, Daptiv, Oracle, Toad, JD Edwards

Confidential, Erlanger, KY

Business Intelligence Project Manager

Responsibilities:

• Managed multiple business intelligence projects through inception, requirements, design, development, test, implementation, and support.
• Regularly presented project status to management team.
• Performed cost benefit analysis during inception of the project.
• Performed project reflection at the end of the project to identify opportunities for future improvement as well as validation of the benefit realization.
• Performed business process analysis to ensure that new applications achieve desired business process improvement.
• Managed project budget.
• Performed resource allocation across multiple projects and managed a team of 8 developers.
• Established project status reporting process by working with other project managers.
• Trained other project managers on preparing projects for governance approvals.
• Skills used: Planview, MS Power Point, MS Visio, OBIEE, Informatica, MS Word, MS Excel, TFS.

Confidential, Cincinnati, OH

Project Manager

Responsibilities:

• Managed multiple projects for client GE Aviation.
• Managed multiple IT projects in parallel and successfully completed them within the target budget, timeline and exceeding customer expectations for features and quality.
• Regularly presented project status to client CIO and the management team.
• Managed the project for the implementing SAS for use by analytics team.
• Managed the project for developing web application that allowed airline customers to report engine wash dates and obtain engine performance improvement report.
• Managed various projects involving data model and ETL changes.
• Represented department in the companywide upgrade of hardware and software upgrade for Teradata and Informatica platforms.
• Documented business processes that were relevant to the department.
• Skills used: MS Project, MS Power Point, MS Visio, SAS, MS Word, MS Excel, HP Quality Center

Confidential, Fishers, IN

Business Analyst - Contract through Adecco

Responsibilities:

• Led the business process analysis for the introduction of a new diabetes management website that integrates data from medical devices such as blood glucose meters and insulin pumps, EMRs, Lab Systems, etc. and serves care givers, Confidential ts, payers and Roche market analysis personal.
• Developed use cases, system requirements document and system specifications for data synchronization from various data sources with the web-based diabetes management system.
• Performed documentation of requirements that met the FDA guidelines for medical devices.
• Participated in core teams that included representation from multiple functional areas.
• Supported prototype development and proof of concept using the Agile with Scrum methodology.
• Skills used: MS Project, MS Visio, Enterprise Architect, MS Word, MS Excel, Rational RequisitePro

Confidential, Cincinnati, OH

Principal Consultant - Enterprise Solutions Consulting

Responsibilities:

• Consulted at clients such as Procter & Gamble Company (P&G), GE Aviation, Indiana Interactive, Toyota Motor Company, Givaudan and Valassis on various software development, business intelligence, as well as business process automation projects.
• Successfully managed IT projects through initiation, analysis, design, development, testing, and deployment. Communicated project status to stakeholders. Completed projects on time within budget and with high quality and customer satisfaction. Managed project risks and changes proactively.
• Managed off-shore and on-shore project teams.
• Developed business cases and project charter for IT projects.
• Managed the end to end project execution for developing plant applications that track supplier quality issues at Toyota’s manufacturing plants using an onshore development team.
• Managed the project through requirements, development and testing for the Office of Teacher Quality teacher assessment application for the State of Arkansas using an offshore development team.
• Managed the project that developed advanced reliability reporting solution for GE Aviation using an onshore development team. Developed BI reporting requirements and data models for advanced reliability analytics.
• Managed a combination of offshore and onshore team members for developing P&G’s Enterprise Data Warehousing solution. Developed the business requirements and logical data model for P&G’s Enterprise Data Warehouse that integrates all of P&G’s 115 global manufacturing locations. Developed data dictionary (meta data), data mapping documents and report specifications.
• Led facilitated sessions to document business processes at P&G, Toyota, Valassis and Indiana Interactive and enabled various business process automation projects.
• Analyzed business requirements and developed specifications for software development.
• Developed test cases, conducted system testing and coordinated user acceptance testing.
• Analyzed business and functional requirements for the complete business process automation of Promotion Execution Partners, a subsidiary of Valassis.
• Developed a working prototype for a Data Warehouse and developed the queries for calculating Givaudan’s corporate and strategic key performance indicators.
• Developed business requirements and logical data model for P&G’s Market Optimization Data Mart.
• Skills used: MS Project, MS Visio, MS Word, MS Excel, Oracle, SQL Server, Rational RequisitePro

Confidential, Cincinnati, OH

Business Analyst

Responsibilities:

• Analyzed requirements and defined business rules for converting legacy systems supporting the insurance operations into newer, more flexible and user friendly systems.
• Developed templates and standard proposals for the various intermediate deliverables in the software development lifecycles.
• Developed DXL scripts to do proper formatting of data to be transferred from DOORS to Test Director.
• Skills used: DOORS, DXL, SDLC.

Confidential, Bolingbrook, IL

Senior Systems Engineer/Business Analyst

Responsibilities:

• Managed multiple projects, analyzed requirements, feasibility, network scenarios, and competitive product offerings for a new broadband digital cross-connect system that is generating over 90 million dollars yearly revenue since 2001.
• Clarified product goals with marketing team to ensure customer focus.
• Led 5 engineers in object oriented modeling and writing requirement specifications for CMIP/CMISE interface of digital cross-connect system.
• Increased market opportunity by making it possible for customers to use a single computer to manage different types of equipment. As primary technical contact, assisted external vendors such as Telcordia in developing user interfaces for the product.
• Reviewed the design documents, test plans and test results to obtain high quality deliverables from Telcordia.
• Saved Tellabs over a million dollars in contract negotiations with Telcordia.
• Communicated and coordinated changes to product requirements with various development and test teams and achieved successful product releases.
• Reduced development cycle time by 50% for 50 developers by developing an object model and translation engine that converted model into C++ code.

Confidential, Rosemont, IL

Technical Specialist

Responsibilities:

• Managed new IT Infrastructure team after department restructuring and oversaw application design, Oracle database administration, Lotus Notes development, and desktop/server software evaluation and .
• As technical project manager of the application design team, led team of 5 engineers in business process engineering that resulted in 15% reduction in development effort. This effort improved quality by standardizing common functionality across 22 applications including order processing, provisioning, billing, financial analysis, fraud detection and customer targeting.
• Coordinated effort to install applications from other departments in our call centers that allowed sharing of customer service personnel between departments.
• Skills used: Oracle, SQL, PL/SQL, Solaris, C++, MS Project, Tuxedo, Object Oriented Modeling and Programming, Business Objects, Clearcase.
• Led object modeling and development of the software for provisioning toll free (800) service.
• Skills used: Oracle, SQL, PL/SQL, Solaris, C++, Tuxedo, Object Oriented Modeling, Clearcase, System Architect.

Confidential, Roundlake, IL

Senior Software Engineer

Responsibilities:

• Managed multiple projects, analyzed requirements, performed object oriented modeling, design, development and test of software for medication dispensing equipment that is currently used in hundreds of hospitals for inventory control.
• Evaluated off-the-shelf software, prepared RFPs, evaluated proposals from consulting firms and made recommendations to management.
• Skills used: MS SQL Server, SQL, Windows NT, Visual C++, Orbix, Rational Rose, MS Project, Object Oriented Modeling, PVCS, Select OMT, Crystal Reports.
• Designed, developed and tested the software for tablet packaging equipment used in several hospitals.
• Developed integration test plans and coordinated alpha and beta testing at customer sites.
• Trained customer support team.
• Skills used: Unix, Oracle, SQL, PL/SQL, C, MS Project, PVCS.

Confidential

Software Engineer

Responsibilities:

• Designed, developed, tested, and maintained, BANCS 2000—India’s leading banking automation software.
• Communicated directly with clients to determine system behavior.
• Unix, Oracle, SQL, PL/SQL, C.