SUMMARY

• 18 years of experience in IT industry with various fortune 500 companies from different industry sectors. I have worked in various IT roles such as BI Solution Architect, Data Integration Lead, BI Technical Architect and Managing Consultant with emphasis on Data Warehousing, BI and Analytics.
• I have experience with diverse data projects and variety of technology platforms that includes Oracle, Apache Hadoop, SAP BW and Microsoft BI. I have the track record, ability and exceptional strengths in architecting providing BI solutions across multiple platforms.

PROFESSIONAL EXPERIENCE

Confidential

Solution Architect - BI and Analytics

Environment: Native HANA Modeling and SQL Scripts, Oracle, PL-SQL, Business Objects, Data Services, Tableau, Rev R, Cloudera, Hive and Sqoop

Responsibilities:

• Lead development of conceptual and architectural solution blueprint for assigned projects to meet business requirements while ensuring compliance with established architectural principles, standards, and processes.
• Provide deep technical/architecture guidance to project teams in areas of BI and Analytics.
• Responsible for end-to-end solution design review and implementation of architecture standards.
• Lead identification of assets or services that can be re-used by the project teams to drive consistency, cost reduction, and increases speed to market.
• Participate on architectural governance team(s) and processes to guide and sanction critical architectural decisions
• Agile Analytics Solutions to provide rapid development process for data discovery and statistical analytics
• Research and lead development of prototypes to assess and build new capabilities in the enterprise
• Commercial Team POC and Data Archiving platform evaluation - Explore Hadoop environment as an option for Big Data analysis and data archiving.

Confidential

Senior BI Architect

Environment: Oracle, SAP BW, SQL Server, HANA, Business Objects Reporting tool set, Informatica, SSAS, Data Services.

Responsibilities:

• Developing data marts for Oracle and SQL Server applications.
• Migration and rebuilding various BW processes from 7.3 into 7.4 (BW on HANA) and HANA modeling
• Decommissioning data replication server with HANA SLT process and SQL Scripting.
• Data archiving of legacy applications that are set to retire via data extraction to staging SQL Server Databases via SSIS and Informatica
• Self-service BI - Developing and proving design pattern to use logical data warehouse(Using HANA views) for analytical purpose via broad range of reporting tools (BOBJ, SSRS, Power Pivot, Power View)

Confidential

Specialist Senior

Environment: Oracle, SQL server, SAP BW/BI 3.5/7.0, Business Objects, Xcelsius

Responsibilities:

• Maintenance and support of existing modules and OPCOs
• Managing BW testing efforts across all landscapes and keeping systems in sync in the transport path.
• Supporting several upgrades efforts to ECC, CRM and BO systems and handling BI Impact from the upgraded.
• Supporting HANA and Data Services pilot projects to evaluate future HANA options.
• Maintenance and support of BW data model and BO tool set.
• At Checkpoint Systems, a manufacturer that develops security products for merchandise at super markets and electronic stores.
• Implementing standard BI reports in the area of Sales and Marketing using Bex.
• At Confidential ITS developed Consulting Management Reporting System (CMRS) to deliver key management reports and their supporting metrics to enable Consulting Leadership to monitor and evaluate performance.
• Managed BW data model effort to support reporting initiative during the project and handled all QA responsibilities that included front end testing.
• Responsible for developing ETL solution and supporting BW systems. (Data sources, DSOs, Cube, Multiproviders, Queries, Transformations, DTPs, Infopackages, Process Chains, Aggregates and ABAP routines etc).
• Lead POC project to leverage Business Objects Reporting. Created different types of reports likeMaster/Detail, Cross TabandChart and imposed severalJoins,Filters, and Alertsto restrict/highlight the data.
• As a Data Architect at Bell Helicopter for BSM (Business System Modernization)
• Designing ETL architecture and standard of the project.
• Ivolved in developing conceptual modelling and logical data modelling of Enovia (Engineering) and Visiprise (Manufacturing) application data in to federated datawarehouse. Developed naming standard and approach for EIM data dictionary.

Confidential

Senior BI lead

Environment: SAP BW/BI 3.5/7.0, BEx Analyzer, Business Objects, SAP R/3, ABAP, Oracle and SQL Server EDW, SSIS, SSAS, SSRS, DataStage.

Responsibilities:

• Involved in all phases of the SAP BI project cycle from Project preparation, Blueprinting, Design Architecture, Development, Documentation, Integration Testing and Go Live.
• Gathered business requirements and deliverables by functional module analysis together with SAP R/3 and Subject Matter Experts in the business areas.
• Successfully managed the project to integrate SAP BI data into Legacy Oracle Warehouse. This saved nearly six months in getting data to critical users.
• DevelopedComplex Reports(Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Created Transformations, DTPs for SAP 7.0 objects. Used start routine, end routine and other transformation options to modify data as needed.
• Designed and implemented custom solution for ‘grouping systems’ that included a custom DSO to hold grouping system data and can be maintained by each business group. This solution reduced number of requests related to custom grouping and provided a uniform solution across all business units.
• Analyzed SAP early watch report, BW statistics cube and RSRV process to monitor overall system performance and BW objects cleanup.
• Lead effort to create user training materials and conducted training workshops.

Confidential

Senior Programmer / Lead BI Analyst

Environment: SQL server (integration services, Analysis Services), Java, Mainframe, DB2, CICS, VSAM, JCL, UDB, Oracle, Hyperion analyzer.

Responsibilities:

• Data Warehouse infrastructure reporting application.
• Lead the project to provide Near Time Data load to Warehouse systems: By using Dataport, a Java based ETL tool:
• Lead the team of consultants along with in house resources to develop an in-house java based ETL tool. This tactical solution gave our company more time in evaluating outside vendors for ETL products and also saved close 200K in licensing fees for the company.
• I managed the projects to create subject based data marts using star schema design using Kimball design approach and mentored other team members in the new development.