SUMMARY

• Over 8 years of experience in requirement gathering, System Analysis, Design, Reporting, Development and Implementation of customized Business Intelligence Solutions.
• Successfully obtained ITIL V3 Foundation Certification.
• Experience in leading, planning, organizing and Project Management.
• Expertise in different versions of Business Objects namely BO XI R2/R3,4.0.
• Extensive experience in Business Objects reports/Desktop Intelligence, Designer, Supervisor, Web Intelligence, Infoview.
• Expert in handling migration issues from earlier versions of BO or earlier version of crystal enterprise to XI/4.0.
• Involved in creating user roles, security access, server administration, password management using the Central Management Console (CMC).
• Extensive experience in development with Version 9.0/2008/2011 of Crystal Reports.
• Carried out analysis and provided specifications to the ETL developers for creation of ETL programs to extract data from different sources in OLAP models.
• Strong knowledge of Oracle Reports for Reports Development.
• Knowledge about different tools such as Pentaho, OBIEE, Cognos.
• Design and Development of Database applications accessing differnt database systems like Oracle, SQL Server, MS - Access, Teradata, Netezza.
• Good working knowledge of Database Design, Relational Data Modeling and development.
• Experienced in all phases of Software Development Life Cycle (SDLC).
• Expert level working knowledge in tools like Golden, SQL developer.
• Proficient in using Visual Studio 2010 to develop web applications.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, C#.

Databases: Oracle 8.x/9.x/10.x/11g, SQL Server 2000 & 2005, MS Access

Operating Systems: Windows (98/NT/XP)

Reporting Tools: Business Objects 6.x/ Xi R2/ R3/4.0/4.1, Crystal Reports 2011/2008/9.0 , Business Intelligence Universe Designer, Desktop Intelligence, Web Intelligence, Infoview, CMC, Crystal Enterprise 8.5/9.0, Xcelsius 2008, Pentaho.

Web Technologies: ASP.NET(2.0,3.0,3.5)

Application Development Tools: Visual Studio 2010

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Applications System Programmer/Systems Analyst

Responsibilities:

• Gather requirements from the end-user and develop specifications for future development.
• Involved in all stages of Project Life Cycle namely Design, Analysis, Development, Testing and Support.
• Develop custom business intelligence solutions to enable the users to make better decisions.
• Create new work flow and data flow processes.
• Provide customer support to the applications and interact with the end-user to better understand their business needs.
• Develop Data Entry systems giving the capability to users in analyzing what-if scenarios with Crystal Reports.
• Optimize the performance of the current reports.
• Assume Lead role for new report development projects, and customer interaction.
• Work as the Primary Contact for the customer support team to resolve issues related to reporting.
• Member of the workgroup formed to analyze and define business processes for handling customer issues according to ITIL standards.
• Develop knowledge about EPIC system used for patient care.
• Evaluate new BI tools such as OBIEE for potential implementation of the tool.
• Reduced the processing time of the reports by 80%in my first month, by re-pointing sub-reports to views in lieu of universes.
• Moved filters from report level to Universe Level for critical parameters to speed up processing time of the reports.
• Optimized universes by removing List of Values from every object and using them only for the chart fields.
• Implemented Row Level Security using @BOUSER variable.
• Utilized Contexts to solve loops in universes.
• Created aggregate tables in the database, and used @AggregateAware Function to leverage hierarchies defined in the dimension tables.
• Worked as a Project Lead with different departments, in training and Implementation of Report Bursting technology in Business Objects by utilizing @BOUSER variable functionality to maintain data security and deliver invoices to departments, thereby helping university in its Green Initiatives.
• Stepped in on projects which hit a roadblock and developed creative solutions to make sure they are available on time for validation and approval.
• Project Lead to plan, market, strategize and develop Premium Departmental Reports.
• Project Lead to analyze, plan, implement and document Business Objects Upgrade project from 3.1 to 4.0.
• Technical Lead for re-pointing the reports, and maintaining Production, Test and Development reporting environments during the PeopleSoft Upgrade project.
• Played an active role in technical discussions with DBA's to modify ETL's during the People Soft Upgrade Project.
• Analyzed the clinical system moving between SQL Server and Oracle environments and reduced the number of views required for reporting in Oracle system by 90%.
• For the first time in the university, worked with and analyzed Financials, HR, Grants databases built as silos, and identified integration points for reporting during the Grants Management Project.
• As a part of the Grants Project built custom schema to capture user data, entered into the system to provide what-if scenario capability.
• The first report built as a part of the Grants management project reduced 40 hours of work time to a few minutes.
• Developed web application, allowing departments to project future scenarios for managing Grants.
• Developed variance analysis reports in liaison with Vice President - Business Affairs to achieve the university’s goal of reducing the time taken in reconciling the figures on the reports.
• Attended OBIEE workshop, which introduced the dashboard creation.
• Attended Smart View training, used to view, import, manipulate, distribute and share data. It is a tool to integrate EPM and BI Content from Microsoft Office products.
• Created dashboards with KPI's, trending graphs using Xcelsius to garner support from top management for a full fledged implementation.
• Worked with the network team to install and configure Pentaho, to evaluate the product for on-demand reporting requirements at the university.

Environment: Oracle 9i/10g/11g,Business Objects XI R3/ 4.0/4.1, BO Designer, Infoview, Crystal Reports 9.0/2008/2011 , Xcelsius 2008, SQL Tools - Golden 32, SQL Developer, SQL Server 2005, Windows XP, Visual Studio Express 2010, OBIEE, Pentaho, Oracle Hyperion Smart View.

Confidential, Cincinnati, OH

Business Intelligence Consultant

Responsibilities:

• Responsible for creation and maintenance of universes using Business Objects XI/3.1.
• Provide reporting solutions to companies by understanding their business requirements.
• Creation of ad-hoc reports using Web Intelligence as per the requirements.
• Creation and maintenance of reports using Crystal Reports 2008.
• Perform requirement gathering and create customized reports.
• Worked closely with the data warehousing team helping them understand the business needs while designing loading processes for data.
• Coordinate with the training team to help design training curriculum for end-users in the info view environment and in creation of ad-hoc reports using Web Intelligence.
• Provide ongoing production support, and resolving issues faced by the end-users.
• Consolidated the number of universes to manage them efficiently.
• Optimized and increased the report performance by 25%, for complex reports.
• Optimized universes supporting close to 100 ad-hoc reports, by eliminating unwanted LOV's, checking joins between tables.
• Created user profiles, user groups and handled the user security, built Cross-Tab reports.
• Provided reporting solutions for simple to complex scenarios.
• Created Charts, Drill-Down reports, Formulae, hyperlinks, percentage reports, Prompts using Crystal Reports.
• Created dashboards to help conduct what-if analysis.
• Created reports using Free-Hand SQL & Stored Procedures.
• Performed data validation by creating ad-hoc reports.
• Involved in preparation of users guide and fine-tuning the specification.
• Complex reports were developed using Web intelligence (WEBI XI) and complex full client Business Objects Reports were developed and published in corporate documents under various categories.
• Extensively used multiple data providers for building reports and dashboards.
• Implemented change methodology to track incoming change requests and prioritize them according to their scope.
• Designed strategies to handle data security for the reports.
• Gathered specifications for developing dashboards tailored to meet business requirements.

Environment: Oracle 9i/10g, Business Objects 6.1a/6.5/ XI R2/R3, Business Intelligence Universe Designer, Web intelligence, Infoview, QAAWS, Crystal Reports 10.0/XI R2/2008, Xcelsius 2008, SQL Tools - Toad, PL/SQL, SQL server 2005, Windows XP/2000/2003 Server.

Confidential, IL

Developer/Reports Analyst

Responsibilities:

• Translate business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Tasks include defining requirements, design, develop, test, implement and maintain reports using Crystal Reports.
• Develop ad-hoc reports to monitor performance using KPIs.
• Optimize the current reports and identify potential areas for development of reports.
• Integrate different data systems, to provide data reliable for reporting.
• Analyze, document and formulate an upgrade plan from current version of BO and Crystal report to BO XI 3.0 and CR 2008.
• Migration of management reports from version 8, 9, 10 and XI in Crystal Reports to 2008.
• Increased report performance by 20%, by optimizing the data sources and universe.
• Successfully generated new reports, to cater to the different business requirements, aiding in the productivity of the users.
• Worked with top management in prioritizing the different requirements and laid out a project plan for upgrades.
• Created reusable report templates to maintain a uniform standard across all the reports.
• Migration of Business Objects WebI reports from ver 6.5 to XI.
• Developed PL/SQL routines like Packages, Stored Procedures, Cursors and Functions using dynamic SQL.
• Used Crystal Management Console to perform administrative tasks of report publishing and folder management.
• Collected business requirements, designed data maps and data models. Created Internal and External Design Documents and Transaction Definition Documents.
• Interacted with cross-functional technical project teams, end-users and management in multiple business functional areas.
• Understood the clinical methodology and used CPT codes to track performance.
• Created and maintained reports required for Audit and regulatory purposes.

Environment: BO 6.x/ XI, Crystal Reports 9.0/10.0/Xi, Crystal Enterprise 9.0/10.0, Web Intelligence, Infoview, Oracle 9i, PL/SQL, SQL*Plus.

Confidential

Developer/Reports Analyst

Responsibilities:

• Created a database in MS Access and then migrated to SQL Server in the first 6 months.
• Designed and created 95% of all the reports using Crystal Reports 9.
• Handled all the user support for the reporting.
• Assisted in ETL processes to effectively load data.
• Responsible for streamlining of operations, documenting and establishing of procedures to load customer data, order information.

Environment: Crystal Reports 9, Crystal Enterprise, Windows NT, SQL Server 2005MS Access 2000.