SUMMARY

• Over Sixteen + years of experience in the field of Information Technology with an emphasis on Business Intelligence concepts like data reporting, data analysis, design, development, data migration, implementation and testing of database/Data Warehousing applications using Data Modeling, ETL and reporting tools.
• 11 years of experience in Business Objects Products(XI 4.1/4.0, XI 3.1, XIR2, 6.x, 5.x) Central Management Console (CMC Administration), Web Intelligence, Crystal Reports, Microstrategy.
• Experience in creating reports in Genesys Infomart.
• Have Public Trust Clearance.
• Have experience with Tableau.
• Experience with Data Modeling tool i.e. ERWIN.
• Excellent communication, interpersonal, presentation skills and leadership abilities with very good analytical capability.
• Expertise in Requirement Gathering, Analysis, Design and Maintenance of the system.
• Created Master Test plans and participated in all the aspects of UAT Testing.
• Expertise in writing Business Requirements Document (BRD), System Requirement Document (SRD).
• Results driven Analyst and a strong team player with a proven ability to deliver organizational improvements supporting business objectives and streamline procedures across the enterprise.
• Excellent command in conducting training sessions and presentations.
• Exceptional ability to manage multicultural staff and skilled to prioritize and execute tasks in a high - pressure environment.
• Strong analytical and problem solving skills.
• Strong knowledge of Data modeling (Star schema & Snowflake schema), Data Warehousing and Business Intelligence Concepts with emphasis on ETL and Data Warehouse / Data Mart Life Cycle Development
• Strong experience in RDMS using Sybase, Teradata, DB2, Oracle, SQL Server, MS Access.
• Excellent programming skills in Java, J2EE

TECHNICAL SKILLS

BI/OLAP Tools: Business Objects XI 4.1/4.0/ 3.1, XIR2, Crystal Reports XI R2/XI/10, MicroStrategy

J2EE Technologies: Servlets, JSP, XML, JNDI, EJB 1.1, 2.0, JAXP, JDBC, RMI, JMS, MVC, Struts1.1, ANT, Applets, JFC-Swing

Web UI Technologies: Adobe,HTML

Packages: Microsoft Office Suite, CVS, Sharepoint, Merant Tracker

Web Servers: Apache HTTP Server, IIS

Application Servers: Jboss4.3, Weblogic 8.1/7.1,Tomcat 5.0/4.0

Operating Systems: Windows 2000/98/95/98 , Windows NT, MS DOS

RDBMS: Sybase 15, Oracle 10g/9i/8, SQL SERVER, DB2,MS Acess

PROFESSIONAL EXPERIENCE

Confidential, DC

Senior BI Consultant

Responsibilities:

• Performed BOXI Admin tasks such as creating and adding new users and assigning them the required privileges and access based on the business needs.
• Involved in migrating the Universes & reports from DEV to QA and Pre-Prod environments.
• Created technical specifications as SME (subject matter expert), which ensured overall integrity of the application.
• Designed and implemented cross check methodologies for testing and report data validation.
• Responsible for meetings with QA and PROD team members to identify problems, resolve issues and to improve the process to ensure a stable and accurate solution.
• Provided suggestions in modifying the existing Universes based on the business requirements.
• Implemented row level security in Universe according to the business needs.
• Support existing Data Warehouse reporting platform and applications to ensure operational availability and scalability.
• Involved in performing Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Involved in designing Data Model & Database using ERWIN.
• Interacted with Business users to resolve data and application issues.

Environment: Business Objects XI 4.0, IDT, Curam, Oracle 10g, SVN, ERWIN

Confidential, VA

BI Architect

Responsibilities:

• As an Architect person was responsible for installing & configuring the BOXI Environment along with the middleware team.
• Involved in all phases of the design and software development of the BOXI environment.
• Helped the middleware team in resolving the issues encountered in setting up the BOXI environment.
• Involved in creating technical and functional specifications as SME (subject matter expert) and ensure overall integrity of the application.
• Designed and implemented cross check methodologies for testing and report data validation.
• Interacted with Business users and created System Design Document (SDD) which guides as requirements document for the development of the reports.
• Performed BOXI Admin tasks such as creating and adding new users and assigning them the required privileges and access based on the business needs.
• Helped the team in creating Interactive Dashboards using different components available using Xcelsius Dashboard tool & Live Office.
• Created a document which will guide the users through the use &functionality of the BOXI.
• Created Tableau dashboards and reports for the Users.
• Used filters, sets, quick filters, parameters in the Tableau reports.
• Worked in an Agile methodology, attended the daily Scrum status meeting & provided the updates and uploaded the documents in Team Forge.

Environment: Business Objects XI 4.1, IDT, Explorer, Xcelsius 2008, Tableau 8.2, Crystal Reports, SQL Server 2008, Oracle 10g, Agile, BMC Remedy, VersionOne, ALM

Confidential, TX

BI Lead

Responsibilities:

• Worked collaboratively with development and business teams to identify and define requirements and day-to-day management of assigned project plans, schedules and test requirements as it relates to reporting needs.
• Lead a team and responsible to see the completion of tasks.
• Gathered requirements from management users for generation of reports in Web and Desktop.
• Involved in documenting the Business required documents & Unit test documents.
• Provided training to the Super users about the functionality & the interface of the reporting tool.
• Involved in providing solutions to Design and Development of Business Analysis Interactive Dashboards & Scorecards organizations HR's goals & KPI in Microstrategy Desktop and web.
• Once ETL is done and data gets loaded to Data warehouse, Defined and created MicroStrategy objects including Attributes, Filters, Cubes, Nested Filters, Hierarchies, Templates, Prompts & Nested Prompts.
• Conditional formatting on metric thresholds, limiting report data access using security filters.
• Created Ad-hoc reports with Dynamic prompt answers for the end users to generate.Created various Information Spaces (Explorers), so that the business users can easily understand & analyze the corporate data using the Explorer tool.
• Involved in performing Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Worked in an Agile methodology, attended the daily Scrum status meeting & provided the updates and uploaded the documents in Team Forge.

Environment: Microstrategy, SQL Server 2008, BMC Remedy

Confidential, VA

Data Analyst/ Business Analyst

Responsibilities:

• Interacted with business users and BSAs in gathering requirements for new reports and extracts.
• Worked directly with functional analysts and business users in understanding their needs of the business in developing BI functionalities or tools to meet their objectives/requirements.
• Lead a team of developers and testers in supporting the day-to-day enhancements and new developments.
• Worked as SME to roll out the finished product (i.e., reports/applications) to the business users as part of new initiatives, projects and product launches.
• Created thin client reports with multiple data providers using Web Intelligence for the business users based on the report requirements for multiple sales forces and franchises.
• Performing Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse
• Support existing Data Warehouse reporting platform and applications to ensure operational availability and scalability.
• Interact with business users to analyze and resolve data and application issues.
• Support existing Data Warehouse reporting platform (Business Objects XI 3.1) applications to ensure operational availability and scalability.
• Created reports using Business Objects functionality's like Drill Down, Cross Tab, Master Detail

Confidential, VA

Senior BI Developer/Analyst

Responsibilities:

• Worked collaboratively with development and business teams to identify and define requirements for Business Objects software application and day-to-day management of assigned project plans, schedules and test requirements as it relates to Business Objects and/or user reporting needs
• Implemented aggregate awareness and created Derived tables Confidential the Universe level to increase the performance of the reports.
• Implemented row level security in Universe according to the business needs.
• Extensive reporting was done using Business Objects functionality's like Drill Down, Cross Tab, Master Detail.
• Accessed corporate data Using Live Office and Query as Web Service (QaaWS) used them extensively to create visually rich Xcelsius dashboards.
• Developed complex interactive/dynamic dashboards with Xcelsius and implemented prompts, drill down capability and Applied alerts.
• Created different reports in the Genesys environment using CMS Avaya reporting tool.
• Involved in designing POC for Genesys Infomart to support creating complex and ad-hoc queries.
• Experience with reporting components such as CCPulse, CC Analyzer.
• Involved in performing Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Created Indexes and Materialized views for the better performance of the reports.
• Trained Power users/End users to use the tool and create Ad-hoc business objects reports.

Environment: Business Objects XI 3.1/XIR2, Crystal Reports XIR2, Live Office, Oracle 10g, Clear Quest, Genesys Datamart, Avaya CMS, Genesys Infomart

Confidential, GEORGIA

BI Developer/Analyst

Responsibilities:

• Managed strategic, operational and tactical initiatives and projects.
• Provided training for technology assistance to new hire staff in project/work assignments.
• Led cross-functional teams driving the definition of project and the project plan.
• Coordinated monthly, quarterly and yearly reporting for performance monitoring and review.
• Responsible for researching product and underwriting criteria for clarification to employees.
• Executed project plans managing the scope, schedule, and cost for performance enhancements.
• Developed strategic plans to improve economic performance and improve consistency.
• Created and assessed data for software system design change with specific focus on handle time and opportunity cost for implementation decision and product improvement.
• Produced metric reports to analyze financial issues and operating performance.
• Analyzed performance of virtual call center site sales by using relational database.
• Created technical and functional specifications as SME (subject matter expert), which ensured overall integrity of the sales strategy.
• Designed and implemented cross check methodologies for testing and report data validation.
• Created & modified existing Crystal reports to meet the business needs.
• Responsible for meetings with QA and IT team members to identify problems, resolve issues and to improve the process to ensure a stable and accurate solution.
• Conducted data analysis and interpreted business performance trends by using different models.

Environment: Business Objects XI R2, Teradata, Crystal Reports, Xcelsius 3.5, BO Designer XI R2, Teradata, Clear Quest, Web Logic 8.1, CVS

Confidential, MARYLAND

Business Objects Admin / Consultant

Responsibilities:

• Involved in creating users, groups and assigning them access to the BO functionality through Central Management Console (CMC) based on their profile
• Analyzed, designed, built and tested reports while working directly with end-users and technical members of a data warehouse team.
• Formatted the Reports to meet the user requirements using Multi-Dimensional Analysis like Drill Down.
• Worked on Web Intelligence to develop and publish thin client reports. and incompatibility between the objects to make sure users can build their own reports
• Developed test-case scenarios, test plans and conducted user acceptance testing & training
• Created reports using Crystal Reports with Grouping, Sorting, Formula fields and Parameter fields.
• Performing Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Responsible for production support services and project development and implementations relative to Business Objects application
• Trained the users to use the tool and create Ad-hoc business objects reports.
• Provided end user training for basic and advanced reporting skills like how to use templates and explained the hierarchy levels.

Environment: Business Objects XI R2, CMC, BO Designer XI R2, SQL SERVER

Confidential, ILLIONIS

Business Objects Developer

Responsibilities:

• Interacted with Project Manager and other resources in understanding the requirements and writing universe, report specifications.
• Interacted with end users to develop standard and ad-hoc reports according to functional Specifications.
• Also carried out analysis and documentation of detailed requirements
• Involved in modification and creating new objects in the Universe as per the requirements.
• Resolved schema-designing problems (loops and traps) by creating aliases, defining contexts and using features available in Business Objects.
• Set up Aggregation in Business Objects to optimize query performance
• Implemented row level security in Universe to in corporate security Confidential Business level.
• Worked on Informatica Power Center 7.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Involved extensively in creating different types of transformations like source qualifier, expression, filter, aggregator, update strategy, and lookup
• Implemented various functionalities like Ranking, Sorting, Alerts in the report, to meet the users requirement.
• Used the Broadcast Agent console for auto scheduling of Business Objects Documents to perform tasks.

Environment: Business Objects 5.1.7, BO Designer 5.1, Oracle 9i, PL/SQL, Informatica 7.1

Confidential, CALIFORNIA

Business Objects Developer / Designer

Responsibilities:

• Involved in designing, developing and testing of the Universe.
• Designed and created reports based on the business requirements.
• Interacted with Project Manager and other resources in understanding the requirements and writing universe, report specifications.
• Worked very closely with other developers for their SQL requirements, with Business Analyst and end users to understand the report requirements.
• Created Universe for ad-hoc and canned reports based on the relational data model and exported to repository.
• .Developed Business Objects Universes with classes, objects and condition objects and different level of hierarchies to support drill down functionality in the reports
• Used aliases & contexts to resolve the loops while designing the Universe.
• Implemented aggregate awareness for the better performance of the query.
• Implemented various @functions like @Prompt @Select and @Where Confidential the Universe level.
• Implemented Object level security in Universe to in corporate security Confidential Business level.

Environment: Business Objects 6.1, BO Designer 6.1, Web intelligence 6.1, Oracle, PL/SQL

Confidential, WASHINGTON, DC

Business Objects Developer/ Supervisor

Responsibilities:

• Worked collaboratively with development and business teams to identify and define requirements for Business Objects software application and day-to-day management of assigned project plans, schedules and test requirements as it relates to Business Objects and/or user reporting needs
• Analyzed, designed, built and tested reports while working directly with end-users and technical members of a data warehouse team.
• Created users, groups and assigned them access to the BO functionality.
• Granted profiles & privileges to the users based on the requirement.
• Created both Full Client( Desktop) and Thin Client(Web Intelligence) reports based on the user requirement using the Business Object reporting tool.
• Created complex formulae’s, variables, classes, user and measure objects.
• Extensive reporting was done using Business Objects functionality's like slice and Dice, Drill Down, Cross Tab, Master Detail, Alerters
• Created different types of reports such as Master/Detail Cross Tab & Charts.
• Interacted with end users to develop standard and ad-hoc reports according to functional Specifications.
• Also carried out analysis and documentation of detailed requirements

Environment: Business Objects 6.5.1, BO Supervisor 6.5.1, Web intelligence 6.5.1,Oracle 9i, PL/SQL

Confidential, CONNECTICUT

Business Objects Developer/ Supervisor

Responsibilities:

• Involved in migration of reports & Universes from BO 5.1.7 to 6.5.1
• Interacted directly with end-users and helped them in the migration process.
• Analyzed, designed, built and tested reports while working directly with end-users and technical members of a data warehouse team.
• Created different users, groups and assigned them access to the BO functionality.
• Used the Broadcast Agent console for auto scheduling of Business Objects Documents to perform tasks.
• Involved in creating Dashboards using Application Foundation tool.
• Modified the Universe by creating classes, objects & Pre-defined objects based on the requirements.
• Supervisory functions include giving access to the users to certain configurations.
• Formatted the Reports to meet the user requirements using Multi-Dimensional Analysis like Slice & Dice, Drill Down.
• Worked on Web Intelligence to develop and publish thin client reports.
• Interacted with Business Analysts and end users to develop standard and ad-hoc reports according to functional specifications.
• Performed Data Analysis by writing SQL Queries for Testing and Troubleshooting against Data Warehouse.

Environment: Business Objects 6.5.1, Supervisor 6.5.1, Web intelligence 6.5.1, Oracle 9i, PL/SQL, Business Broadcast Agent

Confidential

Responsibilities:

• Involved in Software Specifications Design and Documentation.
• Analyzing and designing the application
• Generated necessary tables using SQL Server
• Designed dynamic web pages JSP, Servlets, HTML and DHTML.
• Coding, Testing, and implementation through out.
• Used ANT to generate jars, ejb jars, war and ear file for deployment
• Designing and coding using EJBs (Session Beans and Entity Beans), XML and Deployment descriptors.
• Generated Remote, Home classes and deployment descriptor file
• Developed SQL queries and coded for many JDBC Transactions to perform various interrelated Database operations taking into account the Database issues

Confidential

Responsibilities:

• Analyzing and designing the application
• Involved in designing and developing Servlets, JSPs, JAVA classes
• Involved in implementation of JSP’s
• Developed Java Servlets to communicate with server
• Created the required tables using SQL Server
• Developed SQL queries and coded for many JDBC Transactions to perform various interrelated Database operations taking into account the Database issues
• Extensively involved in system testing and module integration

Confidential

Responsibilities:

• Designed the specifications as per the requirement
• Created tables using DB2 as the database
• Maintained all the information related to the materials and calculated the profit and loss on a particular material
• Used COBOL as the programming language

Environment: IBM-3090, COBOL, JCL, CICS, DB2