Database Architect/Data Analyst for platform SAP/Microsoft

• 10 years of IT experience with an emphasis on Enterprise Software Development using Client/Server Technology. Worked closely with department users and staff to understand and document business requirements, functional requirements, and design specifications for new applications along with enhancements to the existing applications. Worked closely with IT-team members throughout the project life cycle including: development of project scope, collection and documentation of business requirements, preparation of related process documentation, preparation of change control documentation, and coordination for user acceptance testing. Monitor, control and maintain Application Servers of Group Company situated at different locations remotely in order to do proper support of department users.
• Exceptional analysis skills with an ability to transform the needs of business users into functional/technical requirements.
• Expert at analyzing, designing, and reengineering systems applications and business processes.
• Have knowledge and understanding of DATA MODELING technique of SAP HANA[Attribute, Analytical, Calculation views]
• Sound knowledge and understanding of SAP Business Object Business Intelligence Platform 4.0.
• Extensively worked in Crystal Reports 2008/2011/2013 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, drilling reports, and analysis reports.
• Created Universes on top of HANA Calculation views and developed the WEBI reports using IDT (Information design tool).
• Proficient in MS SQL Server 2005/2008.Extensively created stored procedures, functions, database triggers, materialized views and database constraints.
• Have great understanding of different DATA PROVISIONING tools of SAP like BODS,LT,DXC
• Have sound knowledge of OLAP-MS SSAS and SAP HANA.
• Used SAP ECC/BW/MS SQL as source and HANA as target with SAP Data Services as the Integrator.
• Developed Jobs in SAP Business Objects Data services which do the ETL between BW/ SAP ECC/MS SQL and HANA.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio
• Created Dashboards and different Analysis report using BI tool TABLEAU.

Development Tools: SAP HANA Studio, Visual Studio 2005/2008
Programming Languages: SQL, C#, SQLScript
OLTP Database: SQL-Server 2005, SQL-Server 2008, SAP HANA
OLAP Database: SSAS,SAP HANA
ETL Tools: SSIS,BODS
Data Modeling Tool: SAP HANA Studio
Data Provisioning Tools: SLT,BODS,DXC
Reporting Tools: Crystal Report 2008/2011/2013,Web Intelligence, SAP Explorer, Tableau
Operating System: DOS, Windows 98/2000, Windows XP , Windows Server 2003/2008/2012
Web Technologies: HTML, ASP, JavaScript, ASP.NET, ADO.NET
Version Control: SVN, TFS, RedGate
Application Server: IIS 6/7
Platform: SAP/Microsoft