SUMMARY

• Around 7 Years of IT Industry experience in analysis, design, testing, development and implementation of client/server applications. Experience covers areas of development in BI reporting tools like SAP Business Objects XI R3, SAP BI 4.0, Qlikview 9, Crystal Reports XI R2 and Crystal Xcelsius .
• Extensively worked on Business Objects Tools like Desktop Intelligence, Web Intelligence, Universe Designer and Information Design Tool.
• Involved in major migration of Business objects from Deski and BOXI R3 to BI4.0.
• Experience working with BOLO (Business Objects Live Office) Tool and created information spaces using Business Objects Explorer.
• Worked on Crystal Reports XI R2 Tool and involved in migrating Crystal reports to Web Intelligence XI R3. Relatively good experience working with Crystal Xcelsius Dashboard tool.
• Very good experience working with Qlikview 9 Tool and have been involved in major developmnent activities. Key mentions are working on Set Analysis functionalities, QVD’s, Incremental Load Process, Macros, Complex BI Dashboards, Qlikview Administration (Creating jobs and other Server activities) and to some extent on Qlikview Mobile.
• Experience in optimizing existing QlikView reports with a focus on usability, performance, flexibility, testability, and standardization.
• Experienced in creating QlikView Access point for Client application rollout and administrator security by Active Directory technology using QlikView Publisher.
• Good knowledge on Datawarehousing Concepts, RDBMS, SQL, PL/SQL languages.
• Excellent analytical, co - ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.
• Headed various Innovation Campaigns at client location and been awarded for some innovations which brought value and reputuation to client.

TECHNICAL SKILLS

Business Intelligence: Qlikview 9.x, Business Objects XI R2, XI R3 and SAP BI 4.0,BOLO, Crystal Reports XI R2, Crystal Xcelsius Dashboard

Computer Languages: SQL, PL/SQL,C/C++

Databases: Oracle 9i, MS SQL Server 2005, Teradata.

Operating Systems: Windows 7/Vista/XP/ NT/ 95/98/2003/2000

Windows Utility: Excel, Access, PowerPoint, Word, Visio

PROFESSIONAL EXPERIENCE

Confidential, Maplewood, Minnesota

BI Developer

Responsibilities:

• Plan, design, deploy and maintain enterprise-level Business Intelligence and Data Warehousing applications.
• Prepare strategic dashboards and reports for analysis, optimization, streamlining and to improve leadership visibility in the key areas of operations.
• Educate prospective clients on the importance of Business Intelligence and make them use it effectively.
• Evaluate, review and recommend tools, technology and methodology and provide consultancy service to design and spell out best-practices for a new or existing business intelligence initiative of a client.
• Collaborate with end users to identify needs and opportunities for improved data management and delivery followed by pilot phase definition, business requirements gathering and addressing current issues.
• Work with users to understand business process and to develop detailed design specifications for data collection, reporting repositories and processes, to ensure that BI functionality addresses user requirements.
• Demonstrate strong verbal and written communication skills and be able to interface with all levels of client's business users, functional leaders and IT organizations
• Provide reasonable and accurate estimates of time for projects based on information provided by client about technical and functional requirements.
• Design the ER model after gathering requirements.
• Desigining universe model from scratch.
• Creating Ad hoc and Shared reports for clients based on requirements.
• Analyze data in reports and provided Gap analysis to client for better data management.
• Schedule reports to Users Inbox or Email or Shared location.
• Maintain reports security by organizing users into right BI Role security groups.

Environment: /Tools Used: SAP Business Objects 4.0, Teradata v2 R6, SQL Server 2005.

Confidential, Maplewood, Minnesota

BI Developer

Responsibilities:

• Interact with Top level sales managers and key stake holders for gathering requirements and presenting them with Sales analytical information.
• Developed dashboards for data analysis using advanced knowledge of KPIs and strong programming skills.
• Creating dashboards by extracting data from database write and externalise the load scripts, store the data as QVD files and designing the UI based on business/user requirements.
• Use of Set analysis and aggregation functions for sheet objects.
• Created macros in VBScript to meet the business requirements.
• Involved in creating Qlikview Server jobs for all of the GBI applications and publishing them to accesspoint portal.
• Monitoring QlikView Server/Publisher daily tasks.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using Qlikview Publisher and error notifications by email to assigned users.
• Involved in doing the Incremental Data load using Qlikview scripts. Also involved in tuning the data and Queries for better performance.
• Developing unit testing report modules prior to QA submission.
• Performed internal testing and support in resolving QA defects.
• Providing user acceptance testing group support/training.
• Go-Live support.
• Training the end users on the Qlikview Tool for using it effectively and provide Customer support.
• Designed and developed user manuals, product documentation using technical skills

Environment: /Tools Used: Qlikview 9, Teradata, SQL Server 2005.

Confidential, Maplewood, Minnesota

BI Developer

Responsibilities:

• Involved in analyzing the complex Stored Procedures used in Crystal reports and rewrite the SQL in most simpler format understandle for desigining the Universe Structure.
• Involved in design phase the Universe development from scratch by creating tables, joins, hierarchies, contexts and resolving the loops.
• Developed Business Objects XIR2 reports from scratch replicating the Crystal reports formats and by the utilizing the well defined universe.
• Extensively used the Cascading and Dynamic Cascading Prompts functionalities in reports.
• Created Sub reports and Linked reports where required so different tabbed reports are in single report and applied techniques to pass the parameters from main report to sub reports & links reports.
• Worked with many variety of charts and Cross tab reports with drill functionalities.
• Created variety of dashboard reports using Crystal Xcelsius tool and then embedding them into web site portals as flash files.
• Performed different modes of testing on reports in QA environment and fixed any bugs before they went for UAT.
• Prepapred Test case and High Level Design Documents for all reports, and performed any new enhancements on reports as required.
• Adhered to strict timelines and was responsible for in time delivery of reports to users.
• Scheduling reports to users BI Inbox or Email or shared location.
• Provided security to BI reports by organizing users into their respective BI Security role groups.

Environment: /Tools Used: Crystal Reports XIR2, SQL Server 2005, Business Objects XI R2.