Having 9 years of software experience with over six years of technical Lead & managerial experience in data warehouse development as Business Intelligence/ Data Warehouse Manager, Architect. Created Model Diagrams and ARCHITECTURED the BI Systems- using various ETL tools such as SQL Server SSIS, INFORMATICA , SSAS-(Microsoft analysis services for OLAP cube creation), Microsoft BI â?? MSBI - SSAS, SSIS,SSRS, SAP BODS â?? Business Objects Dataservices , OLAP Tools like -SAP Business Objects, Oracle Business Intelligence Enterprise- OBIEE, Qlik View and Modeled system for QlikView, Tableau & TIBCO SPOTFIRE. Extensive experience in software size estimation, cost and resource estimation, RFP - proposal writing, due diligence study and preparation of statement of work and project management skills, technical presentation and client liaison. Architected data warehouse from requirements gathering to conceptualization to creation of data marts using Immon and Kimball methodologies Expertise in Conceptual Data Modelling, Enterprise Data Modelling, Logical Data Modelling, Physical Data Modelling, Enterprise Data Warehouse Design, Datamart Design , Metadata , Data Quality , Master Data Management and Master Data/Data Governance In depth and thorough knowledge of development and design with RDBMS (OLTP), dimensional modelling using data modelling tool ERWIN, MS VISIO, Sybase PowerDesigner and TOAD DATA MODELLING TOOL . Involved in analysis, development and migration of Stored Procedures, Triggers, Views and other related database objects with solid experience in MS-SQL Server 6.x to 2008, Sybase 10.12 , Sybase 4.2 and Oracle, IBM-DB2 . Implemented and lead projects at all stages of SDLC. Managed offshore onsite resources. Good working knowledge of Unified Modelling Language (UML) for Object Oriented Analysis & Design methodologies , Rational Unified Process -RUP & Extreme Programming -XP, Agile Development Proficient in SEI-CMM standards of quality assurance. Good knowledge of GISB, SOX,HIPAA standards. Excellent documentation skills for Database Design Document , Technical design document. Engaged by several clients to understand and reengineer their business processes Architected data warehouse from requirements gathering to conceptualisation to creation of data marts using Inmon and Kimball methodologies Co-ordinate with business owners, DBAs, reporting team to address system improvements. Managed the project in breaking down the existing EDW to manageable Data marts. Experienced in various verticals- Oil and Natural Gas, Health Services, Insurance, Finance, Transportation, Sales and Marketing SAP BUSINESS OBJECTS, SAP BODS, SAP HANA and SAP BW work experience: SAP HANA Experience: SAP HANA Data provisioning using SAP Landscape Transformation and SAP Data services, DXC, Flat File uploader, SAP HANA Architecture. Worked with SAP HANA SPS 09 - SAP HANA Enterprise Cloud Used SAP HANA Web-based Development Workbench for SQLScript editor, SQL Script debugger and a Calculation View editor. Used Visual Application Function Modeler (AFM) is used to build reusable application functions based on complex algorithms.Used AFM to made integration with predictive analysis libraries (PAL), business function libraries (BFL). Used smart data integration and smart data quality in SAP HANA SPS09. Used Pre-built adapters for common data sources such as IBM DB2, Oracle, Microsoft SQL Server, OData, Hadoop and Twitter, and an open SDK to build new adapters. Good understanding of HANA appliance architecture and hardware, can work in HANA installation and configuration phases. Involved in installation of SAP HANA SPS09. Expertise in SAP HANA data modelling and Data replication using flat file source. Implemented Modelling scenarios and activities such as adding a system, creating schemas, importing table definitions, adding connections in HANA Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects ( packages, Attribute views, Analytic and Calculation views etc .) Modifying the Existing Technical Documentation for various models. Translate Business KPI\'s into HANA models. Ease to write HANA SQL. Experience in HANA Procedures, Studio modeling, Calculation, Attribute, Analytical view design, SLT replication configuration, Query design & development and HANA XS and API Development, etc. Used SAP BW/SAP CRM/Oracle as source and HANA as target with SAP Data Services as the Integrator. Configured SAP Connections, Listeners, Notifications and Adapter services (RFCs) for communication between SAP and Web methods. Conducted Trainings on SAP HANA, SAP BODS & BO to end users/ Junior Associates. SAP BODS, SAP BO experience: Worked with End-To-End implementation . Proficient in SAP BO-Business Objects and SAP HANA Interacting with clients and Business Analysts for gathering requirements, analyzing the requirements. Having Work experience on SAP LUMIRA and LUMIRA CLOUD. Created LUMIRA Visualizations and User Stories. Done Data Appending, Data Merging and Calculated KPIâ??S. Created the Technical specification, Detail Design documents for developing the Universe and reports. Done END-END Business Objects Project roll-outs with most success. Having Rich experience with SAP BODS 4.1 â??Designer, Management Console, Server Manager, Repository Manager, Management Console and CMC. Proficient in ETL â?? SAP BODS- Data Services. Used BODS to load data from SAP BW and SAP ECC 6.0 .Used Pre built ADAPTORS for getting data from ECC. Used ABAP Dataflow for reading Data from SAP ECC System Created RFC connections , IDCOS , BAPI to Load data to SAP BW System . Done Performance Tuning for BODS Mappings. Extensively Used Scheduling tools like UC4, Control-M and AUTOSYS. Having Work Experience with SAP BODS & SAP BO 4.1/4.0 Product suite . Excellent experience in Universe Designer , Information Design Tool ( IDT ). Extensively Worked in Designing Single Source Universes , Multi Source and OLAP Universes on top of (by selecting SAP BW Cubes) Bex Queries. Created the different corporate Dashboards Dash Board Designer Tool 4.1. Experience with BOBJ Designer Studio- Worked on BEx Queries, InfoCubes. Experience in using CMC-Promotion Management to deploy the universes, reports from development environment to all other environments. (QA, UAT ) Done Unit Testing on the BODS mappings, BO-Universe and WEBI reports before deploying to QA environment and prepare Test Case Documents. SAP Business Warehouse 7.x/ SAP BW7.X: Used SAP BEx Query Designer, Web Application Designer Used SAP BEx Analyzer. Used BODS as ETL tool for Loading/Reading from BW Cubes . Used SAP BO Designer Studio for Bex Queries. Created DSO, InfoPackages, MultiProviders Developed BW Transformation Logic for loading SAP BW Cubes and DSO . Designing the INFOCUBE and Used DELTA and Direct Loads in to InfoCubes .
Key Skills: