Professional Profile
About ** years of experience in Information Technology Industry with 3 plus years of expertise in developing SAP Business Objects 4.0, Xir3.1, Xi3, Xi2 and Data Warehouse applications.
Experience with data warehouse and dimensional data modelling.
Thorough understanding of data warehouse and dimensional data modelling.
Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/2003/2008/XP
Technical hands-on expertise using OLAP tools like SAP Business Objects Xi3.1 (Webi Reports, Webi Rich Client, Universe Designer, Info view, Dashboard Builder, Crystal Xcelsius and CMC)
Expert in tuning and optimized the performance of SAP Business Objects Xi3.1 queries
Proficient knowledge on SAP BO XI Architecture and new features.
Expert in Universe designing and development
Design and implement of x-Celsius Engage 2008 Dashboard and visualization with dimensional data connection by using ‘Query as a Web Service (QAAWS), and Live Office
Expert in designing and developing the complex corporate report, Ad hoc reports, and dashboard Reports
Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
Worked with Webi and Webi Rich Client Xi3.1 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
Design, development and coding with ORACLE 10g/9.2/8.x/7.x, SQL Server 2012/2008
An enthusiastic and project-oriented team player with solid communication and leadership skills
Ability to develop creative solutions for challenging client needs
Experienced in interacting with business users to analyse the business process and requirements, documenting and rolling out the deliverable on time
Technology
Report/OLAP Tools
Business Objects Xir2, Xi3.0, Xi3.1, 4.0, Universe Designer, Web-Intelligence, Web-Intelligence Rich Client, Info View, CMC Administrator, Dashboard Builder, Qlik View Analytics,Crystal Report, Crystal Xcelsius 2008, 4.5, Report Conversion tool, Import Wizard and Life Cycle Management (LCM)
ETL Tools
SSIS,SAP Data Integrator Xir2, Xi3, Informatica 8
Web/Application Servers
Tomcat Apache Server, IIS 6.0,5.0,4.0, BEA Weblogic 5.1/6.1
Database/RDBMS
Oracle 9i/10g, SQL Server 2000/05/08, MS Access 07/10, DB2, Netezza, Sybase, SQL*Loader
Languages
SQL, PL/SQL, T-SQL, C, C++, Java1.2,2
Testing Tools
Win Runner, Test Director, QTP, Quality Center, Load Runner
Web Publication Tools
MS Front Page, MS Publisher, CSP, ASP, HTML, DHTML, JavaScript, JSP, Java 1.2
Operating Systems
Win NT Server 2003/08, Ms DOS, Win XP/Vista/Win 7, AIX, UNIX
Educational Qualifications
MSc Computer Science 2007
Sikkim Manipal University New Delhi, India
Advanced Diploma in Computer Hardware 2002
ET&T Govt.of India New Delhi, India
Certificate in Software technology 2005
Software Technology Group New Delhi, India.
Bachelor’s in Electronics 2000
New Delhi, India.
Trainings & Certifications
SAP Data Analysis for BI and DW Developer
Java, Web Services, MVC Architecture
Oracle 9i DBA
Networking
Work Experience
ERP Technicals Inc. Calgary July 2013 – Present
SAP Business Objects Analyst/Developer
Responsibilities:
Translated business-reporting requirements into universe strategies and design.
Updated about 40 existing universes as per daily report development requirements.
Updated the universes by defining parameters, inserting tables, creating classes and objects, making joins, resolving the loops, creating aliases and contexts, testing universe structure, performing integrity tests and fixing cardinalities.
Resolved the loop issues through aliases and contexts.
Developed Business Objects Reports from simple to complex levels by using linking, sub-queries and union functionalities when developing reports from many Data Providers.
On the basis of the requirements recommended and made changes on the Business Objects universes and developed business objects reports.
Analysed the SQL when developing reports.
Dimensional data modelling experience star schema / snowflake schema/Fact Constellation
Analysed, prepared and maintained the system documentation.
Environment:
Business Objects 5.1/6.5.1 Crystal Report, Web-Intelligence, Desktop-Intelligence, Designer, Info View, Supervisor, SQL Server2003, 2008, 2012, Oracle 9i, SQL, PL/SQL, Windows 2000/XP
BirdEye Inc. USA(Remotely) Jan 2015-Dec.2015
Software Consultant Sunnyvale USA
Administration of a range of business applications and Analytics
Training customers on the applications and dashboard
Ensuring availability and performance of business applications
Maintaining high quality documentation
Communicating effectively with the user community
Writing advanced SQL queries for data retrieval
Technical hands-on expertise using OLAP tools like SAP Business Objects Xi3.1 (Webi Reports, Webi Rich Client, Universe Designer, Info view, Dashboard Builder, Crystal Xcelsius and CMC)
Technical Instructor Dec.2011- April2013
Dalhousie University Halifax NS
Area of Instruction: UNIX, Linux, Shell scripting, Windows, MAC, LAN Networks
Developed IPMS (Networks) Delta training curriculum for Royal Canadian Navy.
Conduct, monitor, evaluate, and record training activities or program effectiveness. Organize and develop training procedure manuals, guides and course materials such as handouts visual materials, Lab. Exercises for hands on training materials.
Working with Moodle LMS, Blackboard system at Dalhousie University and Smart boards for day to day conduction work
Technical Consultant Oct.2011 – Nov.2011
NTT Data Halifax NS
Application and implementation of Microsoft Active Directory,Citrix and VM technologies
SQL server 2012
Remote Administration software: Managing Active Directory, users and groups, servers, and application modules with remote administration software from Dame Ware.
PB Learning /Database Analyst June 2004 – Sep. 2011
KVS Ministry of Education, Govt. of India New Delhi India.
Analyzed, designed and developed data model for a fictional travel agency database system
Captured and documented business requirements in detail project plan and text documents
Installed, configured, maintained and supported Oracle 9i,on Windows and Linux platforms
Created Oracle databases and required Objects, ERD, physical and logical design
Defined and created users, roles, views and profiles to provide the security of the database system
Analyzed, designed and implemented Star Schema data warehouse for an Educational Institution and data analysis
Generated BI reports using Excel (Pivot Table)
Performed database backup (full, differential, partial) and restore activities