SUMMARY:

• 9 years of experience in Business Analysis, Business Intelligence and Reporting
• Experienced in Requirement gathering, Data Analysis and gap Analysis to meet the business goal
• Document the functional/non - functional requirements, system requirements and system design
• Experienced in Data Profiling for testing the Data Quality for EDW
• Worked on Dimensional Modeling, OLAP Data Marts and Data Warehouses
• Strong in SQL, PL/SQL, Stored Procedure
• Experienced in designing/developing BO Universes, Ad-hoc reports, Webi reports, Crystal Reports
• Experienced in Informatica ETL process
• Extensively used Excel for data analysis; used Pivot Tables, Index, Array, Lookup functions and Charts
• Managed/Supported defect tracking tool Atlassian JIRA (both front end and back end)
• Supported test and requirement management tool SmartBear ALM Complete (both front end and back end)
• Ability to support multiple tasks allowed my employer to consolidate and reduce headcount
• Automated reporting process allowed to reduce management reporting time
• IT professional dedicated to client success
• Experience in IT Healthcare and financial services

TECHNICAL SKILLS:

Reporting Tool: SAP BO 4.2/4.1/ 4.0/ XI 3.1/ R2/ R1, Designer, Desktop Intelligence, Web Intelligence, Crystal Reports 2016/2008/XI, Xcelsius 2008, Fusion Chart, Tableau Desktop 9.2/10, SSRS

Programming Languages: SQL, PL/SQL, Stored Procedure, Triggers

RDBMS: ORACLE 12g/11g/10g/9i/8i, SQL Server, MS ACCESS

Tools: TOADSSIS, Informatica 9.5.1, Software Planner ALM Complete, Atlassian Tool JIRA, MS Office, SharePoint

Other: ITIL, Accounting and Financial Management, MIS, LAN, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. BI Report Developer/ Sr. Data Analyst

Responsibilities:

• Gathered end user requirements and analyzed requirements for creating the universe for the reports
• Developed webi reports, crystal reports and modifying existing reports based on client’s requirements
• Created test scenarios and run the test cases for the reports accuracy
• Managed production deployment for the release
• Write complex SQL queries for ad-hoc data requirements
• Analyzed metrics by using Tableau
• Involved in the ETL process for data mapping
• Conduct meetings with the stakeholders for requirement gathering for the reports
• Develop Oracle BI reports for the RAM (Registration Account Management) database which is for the Lenders and Brokers
• Involved in BO upgrading from 4.1 to 4.2
• Work on agile methodology, MyServices and BMC Remedy tool

Environment: Business Object 4.2, Crystal Reports 2016, BI Launch Pad, CMC, Tableau Desktop 9.2, Oracle 12g, SQL Server 2008, TOAD, Informatica 9.5.1, Windows 8, UNIX

Confidential, Reston, VA

Sr. BI Developer/ Sr. Data Analyst

Responsibilities:

• Involved in gathering and analyzing requirements and data for developing Crystal Reports and Webi reports
• My contribution in reporting helped the company got certified for CMMI-3
• Conduct meetings with project managers for requirements gathering and solution providing which helped managing resources and their time
• As a member of the CCB I decided on any global change in reports or applications
• Designed and developed Universes
• Developed complex Webi reports like Drill down, Slice and Dice, master/detail reports for the top management analysis
• Created complex Crystal Reports by using multiple data sources, cascading dynamic parameters, complex formulas, functions, charts and sub-reports
• Developed Requirement Traceability Matrix(RTM) which helped in testing
• Created test plan for reports and conducted system testing
• Scheduled reports as per user requirements
• Wrote complex SQL queries; create views for data analysis; and develop reports as per business need
• Wrote Triggers, Stored Procedure, PL/SQL block to update data in the backend
• Worked on data loading from different sources using Informatica ETL tool
• Administered JIRA Defect tracking tool and ALM Complete Requirement and Testing Tool
• Supported the integration of JIRA and ALM Complete with outside vendor

Environment: Business Object 4.1, Crystal Reports 2008, BI Launch Pad, CMC, Oracle 11g, SQL Server 2008, TOAD, Informatica 9.5, Windows 7

Confidential, Vienna, VA

BI Consultant/ Crystal Reports Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements, and data specifications for Crystal Reports
• Followed Agile methodologies for the entire SDLC
• Worked extensively with business users to validate requirements; attended requirements gathering meetings and captured business requirements
• Conducted user meetings regarding business rule clarification related various data analysis requirements.
• Wrote complex SQL queries for getting data to develop reports
• Designed relational database as the part of the project, loaded data from source to SQL Server database and analyzed data for reporting
• Developed reports for the top management for budgeting decision, and billets decision for hiring new employees or consultants
• Migrated reports from Microsoft Visual Studio to Crystal Reports
• Created complex Crystal Reports by using multiple data sources, cascading dynamic parameters, complex formulas, functions, charts and sub-reports
• Created cross-tab, drill-down, detail and summary reports
• Deployed the reports from development to QA and production environment in Business Object Enterprise
• Scheduled the reports as per user requirements
• Created test plan for the reports and conducted system testing
• Involved in UAT and provide training to the users and communicate test results
• Evaluated reporting environment for performance and efficiency, and suggested recommendations for better performance

Environment: Business Object XI 3.1, Crystal Reports 2008, Xcelsius 2008, Info View, CMC, Oracle 10g, SQL Server 2008, TOAD, Windows 7

Confidential, Richmond, VA

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for creating Universe and reports
• Followed agile methodologies in the analysis and development process
• Build the new universes as per the user requirements by identifying the required tables from Data Mart and by defining the universe connections
• Used derived tables to create the universe for best performance, and used context and alias tables to solve the loops in universe
• Created complex crystal reports using the universe as a main data provider, sub-reports, alerters, functions and formulas
• Developed complex Webi reports like Drill down, Slice and Dice, master/detail for the top management analysis
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure
• Created KPIs using Xcelsius Dashboards
• Performed data transformation and loading to the target database using Informatica ETL tool

Environment: BO XI R3.1, Designer, Web Intelligence, Crystal Reports 2008, Xcelsius, Designer 4.5, Oracle 9i, SQL Server 2008, Informatica, Windows XP

Confidential, Bethesda, MD

Business Objects Developer

Responsibilities:

• Involved in requirement gathering and data analysis
• Responsible for designing the universes by joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and involved in design, development and maintenance of Clinical Trial Data Mart (CTDB) and universes.
• Created user defined @prompts, Cascading prompts and complex conditions at Universe level for better performance
• Created various LOVs and Filter objects for ease of ad-hoc reporting
• Designed, developed and tested business objects reports, both in Deski and Webi
• Involved in UAT and provided training to the users
• Migrating from 6.5.x to Business Objects XI R2

Environment: Business Objects XI R1/R2, Designer, Desktop Intelligence, Web Intelligence, Central Management Console, Info View, Windows, SQL Server 2005, TOAD

Confidential, Salem, OR

Business Objects Developer

Responsibilities:

• Participated in requirements gathering from the end users
• Worked comprehensively on Logical schemas, Physical schemas, Physical Data models, in creating facts and dimensions to make sure that it serves purpose of the business needs and follow the business guidelines and logics
• Performed Data Analysis, Data Validation, Source-to-Target Mappings using SQL Server Management Studio
• Designed aggregated tables on the most frequently queried data for monthly & yearly reports
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements
• Converted Deski Reports to Web Intelligence using Report Conversion Tool
• Created various LOVs and Filter objects for ease of Ad-hoc reporting
• Designed, developed and tested business objects reports - both Deski and Webi reports
• Involved in UAT and provided training to the users
• Evaluated reporting environment for performance and efficiency and presented recommendations to senior management

Environment: Business Objects Designer XI R2, Web Intelligence, Info View, Oracle 9i, TOAD, SQL Server 2005, Windows XP