SUMMARY:

• Over Sixteen + years of experience in teh field of Information Technology wif 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 wif Tableau.
• Experience wif Data Modeling tool i.e. ERWIN.
• Excellent communication, interpersonal, presentation skills and leadership abilities wif very good analytical capability.
• Expertise in Requirement Gathering, Analysis, Design and Maintenance of teh system.
• Created Master Test plans and participated in all teh aspects of UAT Testing.
• Expertise in writing Business Requirements Document (BRD), System Requirement Document (SRD).
• Results driven Analyst and a strong team player wif a proven ability to deliver organizational improvements supporting business objectives and streamline procedures across teh 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 wif 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

Sr BI Consultant

Responsibilities:

• Performed BOXI Admin tasks such as creating and adding new users and assigning them teh required privileges and access based on teh business needs.
• Involved in migrating teh Universes & reports from DEV to QA and Pre-Prod environments.
• Created technical specifications as SME (subject matter expert), which ensured overall integrity of teh application.
• Designed and implemented cross check methodologies for testing and report data validation.
• Responsible for meetings wif QA and PROD team members to identify problems, resolve issues and to improve teh process to ensure a stable and accurate solution.
• Provided suggestions in modifying teh existing Universes based on teh business requirements.
• Implemented row level security in Universe according to teh 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 wif 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 teh BOXI Environment along wif teh middleware team.
• Involved in all phases of teh design and software development of teh BOXI environment.
• Helped teh middleware team in resolving teh issues encountered in setting up teh BOXI environment.
• Involved in creating technical and functional specifications as SME (subject matter expert) and ensure overall integrity of teh application.
• Designed and implemented cross check methodologies for testing and report data validation.
• Interacted wif Business users and created System Design Document (SDD) which guides as requirements document for teh development of teh reports.
• Performed BOXI Admin tasks such as creating and adding new users and assigning them teh required privileges and access based on teh business needs.
• Helped teh team in creating Interactive Dashboards using different components available using Xcelsius Dashboard tool & Live Office.
• Created a document which will guide teh users through teh use &functionality of teh BOXI.
• Created Tableau dashboards and reports for teh Users.
• Used filters, sets, quick filters, parameters in teh Tableau reports.
• Worked in an Agile methodology, attended teh daily Scrum status meeting & provided teh updates and uploaded teh 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 wif 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 teh completion of tasks.
• Gatheird requirements from management users for generation of reports in Web and Desktop.
• Involved in documenting teh Business required documents & Unit test documents.
• Provided training to teh Super users about teh functionality & teh interface of teh 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 wif Dynamic prompt answers for teh end users to generate.Created various Information Spaces (Explorers), so that teh business users can easily understand & analyze teh corporate data using teh Explorer tool.
• Involved in performing Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Worked in an Agile methodology, attended teh daily Scrum status meeting & provided teh updates and uploaded teh documents in Team Forge.

Environment: Microstrategy, SQL Server 2008, BMC Remedy

Confidential, VA

Data Analyst/ Business Analyst

Responsibilities:

• Interacted wif business users and BSAs in gathering requirements for new reports and extracts.
• Worked directly wif functional analysts and business users in understanding their needs of teh business in developing BI functionalities or tools to meet their objectives/requirements.
• Lead a team of developers and testers in supporting teh day-to-day enhancements and new developments.
• Worked as SME to roll out teh finished product (i.e., reports/applications) to teh business users as part of new initiatives, projects and product launches.
• Created thin client reports wif multiple data providers using Web Intelligence for teh business users based on teh 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 wif 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 wif 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 teh Universe level to increase teh performance of teh reports.
• Implemented row level security in Universe according to teh 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 wif Xcelsius and implemented prompts, drill down capability and Applied alerts.
• Created different reports in teh Genesys environment using CMS Avaya reporting tool.
• Involved in designing POC for Genesys Infomart to support creating complex and ad-hoc queries.
• Experience wif 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 teh better performance of teh reports.
• Trained Power users/End users to use teh 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 teh definition of project and teh 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 teh 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 wif 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 teh sales strategy.
• Designed and implemented cross check methodologies for testing and report data validation.
• Created & modified existing Crystal reports to meet teh business needs.
• Responsible for meetings wif QA and IT team members to identify problems, resolve issues and to improve teh 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 teh BO functionality through Central Management Console (CMC) based on their profile
• Analyzed, designed, built and tested reports while working directly wif end-users and technical members of a data warehouse team.
• Formatted teh Reports to meet teh user requirements using Multi-Dimensional Analysis like Drill Down.
• Worked on Web Intelligence to develop and publish thin client reports. and incompatibility between teh 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 wif 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 teh users to use teh 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 teh hierarchy levels.

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

Confidential

Business Objects Developer

Responsibilities:

• Interacted wif Project Manager and other resources in understanding teh requirements and writing universe, report specifications.
• Interacted wif 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 teh Universe as per teh 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 incorporate 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 teh report, to meet teh users requirement.
• Used teh 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 teh Universe.
• Designed and created reports based on teh business requirements.
• Interacted wif Project Manager and other resources in understanding teh requirements and writing universe, report specifications.
• Worked very closely wif other developers for their SQL requirements, wif Business Analyst and end users to understand teh report requirements.
• Created Universe for ad-hoc and canned reports based on teh relational data model and exported to repository.
• .Developed Business Objects Universes wif classes, objects and condition objects and different level of hierarchies to support drill down functionality in teh reports
• Used aliases & contexts to resolve teh loops while designing teh Universe.
• Implemented aggregate awareness for teh better performance of teh query.
• Implemented various @functions like @Prompt @Select and @Where Confidential teh Universe level.
• Implemented Object level security in Universe to incorporate 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 wif 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 wif end-users and technical members of a data warehouse team.
• Created users, groups and assigned them access to teh BO functionality.
• Granted profiles & privileges to teh users based on teh requirement.
• Created both Full Client( Desktop) and Thin Client(Web Intelligence) reports based on teh user requirement using teh 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 wif 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 wif end-users and halped them in teh migration process.
• Analyzed, designed, built and tested reports while working directly wif end-users and technical members of a data warehouse team.
• Created different users, groups and assigned them access to teh BO functionality.
• Used teh Broadcast Agent console for auto scheduling of Business Objects Documents to perform tasks.
• Involved in creating Dashboards using Application Foundation tool.
• Modified teh Universe by creating classes, objects & Pre-defined objects based on teh requirements.
• Supervisory functions include giving access to teh users to certain configurations.
• Formatted teh Reports to meet teh user requirements using Multi-Dimensional Analysis like Slice & Dice, Drill Down.
• Worked on Web Intelligence to develop and publish thin client reports.
• Interacted wif 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 teh 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 teh Database issues

Confidential

Responsibilities:

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

Confidential

Responsibilities:

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

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