SUMMARY:

• 19+ years of Confidential Services experience with 9+ years in leadership / Program Management in Managing, delivering and supporting EDW\BI projects across a wide range of industries
• Hands - on Big Data Architect
• Expert in UNIX, Linux embedded OS, storage systems, high performance file systems, high performance embedded databases, real time applications, online analytical processing, web services, and cloud storage services.
• Experienced working in BI 4.0 and BW 7.3.
• Involved in Upgrading various BW systems 3.0/3.5/7.3.
• Architected BI/BW data models to satisfy reporting requirements.
• Lead Blueprint and Business requirement gathering sessions with Business and Functional Teams. Identified various BI Strategies and Approaches based on requirement sessions.
• Provided project estimates and scoping based on project timelines.
• Design solution architecture for IT Infrastructure Management based on industry best practices.
• Experience in Store Persistent Data, Polyglot Persistence (using multiple data storage technologies)
• Experience in Public and Private Cloud, Configuration Management, Automation & Orchestration.
• Experience in Service Oriented Architecture (SOA) -Web Service Orchestration - framework to orchestrate web services using the BPEL4WS specification.
• Technologies - J2EE, .NET, Oracle, XML, WSDL, UDDI, SOAP. Built a range of tools, products, components and accelerated application development toolkits to help reduce the complexity of the “Application integration spaghetti" paradigm.

TECHNICAL SKILLS:

Data Warehouse/BI: OBIEE(mobile), Tableau, Hadoop, NoSQL, SAP BW, Qlikview(Mobile), HP Autonomy, HP Vertica, Oracle Reporting Suit, Business Objects Data Integrator, Erwin, Embarcadero ERStudio, DataStage, Business Objects, Business Objects FirstLogic, Informatica, WebMethods, Ab Initio, Hyperion, Essbase, Pivotal HD, Oracle Big Data Appliance, Exadata, Exalytics, Microstrategy, AlphaBlox, Rational Rose, Dataflux, Veeva, Exalytics, Exadata, Hadoop

Data Modeling: Infocubes, Multi-Providers, Infosets, ODS/DSO, Info Objects (Characteristics and Key Figures), Master Data.

Reporting: Business Objects WEBI, Info View, Web Application Designer, BEx-Analyzer and Query Designer.

ETL: Info-Source, Transformations, Transfer Rules, Update Rules, Start Routines, End Routines, User Exits, DTP, and Data sources, Generic Data Sources, Process chains.

Performance: BIA / BWA, Aggregates, Partitioning, OLAP Cache, Indexes, Statistics, Compression, ABAP/4, Number Range Buffering, Information Broadcasting and Precal Server.

Security: BW/BO Security, User Groups, Roles, Profiles, Analysis Auth.

Upgrades: Technical / Functional Upgrade of SAP BW 3.x to 7x. Migrated Queries, Web Templates, workbooks, BI Security 3.x to 7.0, Migrated 3.x data flow to 7.x.

Environment: s: BI7.01/BW3.5/3.0B/2.1C/2.0B/1.2B, BO 4.0/XI3.3. WEBI/Xcelsius/Dashboards/Crystal Reports, ABAP/4, SAP ECC 6.0/5.0/4.7/4.6/ 4.0 B/3.1I, CRM, Oracle 10g/ 9.2/8.1.7/8.0.6/7.3 , Java, HTML, C.

PROFESSIONAL EXPERIENCE:

Confidential

Architect (Hadoop/BigData)

Responsibilities:

• Successfully virtualized Hadoop
• Adopted Linux KVM as the virtualization container. Optimized disk IO path and network IO path between virtual machines and hosts to provide optimal IO performance for Hadoop.
• Developed a custom File System plugin for Hadoop so it can access files on Hitachi Data Platform. This plugin allows Hadoop MapReduce programs, HBase, Pig and Hive to work unmodified and access files directly. The plugin also provided data locality for Hadoop across host nodes and virtual machines.
• Advised file system team on optimizing IO for Hadoop / analytics work loads.
• Setup and benchmarked Hadoop/HBase clusters for internal use
• Mentored interns working on recommendation engine on big data.
• Activated BI content related to PM in ECC (Data Sources) and BW (DSOs, Info Cubes and Transformations).
• Customized Data sources and Info Cubes based on reporting requirement.
• Developed BEx Queries and BO reports using Web Intelligence.

Confidential

Sr. Consultant

Responsibilities:

• Involved in Upgrading various BW systems 3.0/3.5/7.x.
• Helped create a fully functional offshore data movement and migration practice
• Developed system that enabled mobile business intelligence as well as cloud - based business intelligent solutions
• Developed enterprise level strategies for our clients
• Manage large data related projects
• Defined NoSQL/Hadoop solutions

Confidential, San Jose, CA

Sr. Consultant

Responsibilities:

• Architect a large data federation/virtualized data warehousing solution that includes the following architectural layers: portal, security, active data model(s), appliances(Exalytics, Exadata), and mobile business intelligence and analytics
• Defining the following standards: Data Warehousing, Data Management, Teradata and SAP BW integration, Data Governance, Master Data Management, Data Quality
• Defined and implemented large enterprise Operational Data Store and Big Data which consisted of Exadata, Oracle Big Data Appliance (Hadoop) and Exalytics
• Successful operation of onsite - offshore model
• Defined and established production support processes
• Staging System Refresh & Outage planning

Confidential, Atlanta, GA

Sr. Consultant

Responsibilities:

• Analyze data which included investigation and analysis, documentation, filtering of bad data through generation of crystal reports.
• Building workflows for sequential execution of data transfers.
• Establishing standards & guidelines for data conversion.
• Managed the conversion of a large data warehouse from mainframe to UNIX environment
• Profiled the mainframe data warehouse and the staging data loaded into the data warehouse
• Designed data transformations and processes for capturing and redefining metrics and facts

Confidential

Lead Consultant

Responsibilities:

• Operation Coordinator managing Enterprise Data warehouse Project.
• Performed routine source system to target system mapping enhancement and correction to keep the correctness of EDW data element mapping from source system
• SLA monitoring for all technologies improved customer satisfaction and allowed organization to plan for new projects.
• Maintained and enhanced enterprise Teradata data model development standards.
• Designed Global Business Solution and conducted rollout resulting in Common business model for the program Data Warehouse.
• Primary BI technical resource for the 30 person team. Responsible for backend and frontend configuration (extraction/transformation/reporting/process chains) and for advising on rollout, support, and stabilization of the global template. Led development and implementation of a layered and scalable architecture and built and managed 20 person onshore support team.
• Demand Planner upgrade to Demand Manager requires, implementing Product, Hierarchy, Geography Hierarchy, and Time Hierarchy Excel Based Inputs.
• Implemented Data Warehouse strategy using Business Objects ETL tool - Data Integrator and the Oracle, DB2 and UDB database platforms
• Managed the design and implementation of a large data warehouse to support financial reporting
• Designed data mining strategy and the RDBMS needed in order to support SAS processing
• Designed integration strategy and created data models. Performed application and data integration.
• This project encompasses all work required to successfully transfer only the Extended Warranty Cancellation and Transfer procedures from LRNA control to APCO. This encompasses the ftp from APCO to LRNA to cancel the contract on the LRNA AS400 as well as disengagement of the interface to financials during month end.
• Designed a Teradata data warehouse that captured transaction level data
• Managed the design / implementation of a large data warehouse supporting CRM and financial reporting.
• Selected ETL, reporting, RDBMS as well as hardware in order to support data warehouse architecture.
• Designed integration strategy and created data models. Performed application and data integration.
• Data Modelling Techniques (Basic Cube, Multicube, ODS and Info source, Info objects, Info source, Info packages )Activation of Standard Business Contents
• Data Extraction using Generic Data Extractors, Standard Business Content
• Creation of generic data source, info source, info packages
• Creation of Info providers like Info cubes, ODS, Multicube, Remote Cubes
• Upgraded SAP BW 3.1 to SAP BW 3.5 and BW 3.5 to BI 7.0. Migrated BW 3.x objects to 7.0. Migration included queries, workbooks and web templates. Modified the data flow to use Transformations.
• Involved in migration of Database from Oracle 10g to IBM - DB6.

Confidential

Project Lead

Responsibilities:

• Prepared detailed task plan, continuous monitoring and execution. Work distribution between offshore and onshore teams.
• Analyzing impact of the upgrade on technical infrastructure as per business processes for a highly modified system.
• Conducted regression testing plan for simulation of 600 users logins for post upgrade scenario and performance tuning SUN E10 Machine.
• Installed and implemented Oracle ROLAP and MOLAP products.
• Web enabled Express products such as Sales Analyzer and Express Server. Rolled out DSS support tools to end - users.

Confidential

System Consultant

Responsibilities:

• Translated business requirements into data needs and developed detail E - R and dimensional models.
• Worked closely with Business Analyst to implement data loading specifications.
• Developed enterprise data model management process to manage multiple data models developed by different groups.
• Suggestions for Performance improvement of the system, Supported a Marketing Data warehouse with to provide relational organization data and capability to generate complex ad hoc reports in retail marketing activities.
• Assisted with tuning and optimizing the data warehouse Oracle8 RDBMS and built two datamarts using MOLAP and OLAP tools such as Oracle Sales Analyzer and RAA/RAM