Professional Summary

• Over 13 years' of experience in IT field which includes Business Intelligence Business Objects/Crystal Reports and Micro Strategy reporting tool in area serving Telecom, Insurance and Banking Domains.
• Over 8 years of Data warehouse development experience in BO, Crystal Reports and Testing experience in Micro Strategy Report and People management and ETL testing.
• Overall 4 years of experience in Clarify CRM suit.
• Good Knowledge of iServer i.e. Intelligence server in Micro Strategy.
• Very good at Release management and Incident/problem and SLA management and reporting.
• Worked extensively with Business Objects Enterprise Suite, ETL Processes, Data mining, Data audits, Web Intelligence Reporting.
• Expert in designing, implementing, distributing and maintaining Business Objects Universes and reports.
• Excellent administration skills to manage the environment, server, users, groups and security setup for Business Objects Enterprise Suite using CMC.
• Good experience and knowledge of Data warehousing RDBMS concepts including OLAP, OLTP, dimensional modeling using Star Schema and Snow-Flake Schema designs.
• Specialized in creating complex query reports using Oracle, SQL Server 2008 and 2012
• Experience in debugging and performance tuning of Business reports.
• Involved in Full life cycle analysis, design, networking, development and deployment of Business Objects Enterprise.
• Experienced in developing QA Strategies: Test Cases, Test Scripts and Test Procedures and conducting User Acceptance Testing UAT using HP Quality Center.
• Experienced in working with various departmental teams, developing interactive relationships with business and IT colleagues, having a thorough understanding of the constraints, needs, and perspectives of both the business users and the technical team.
• Experienced in training and mentoring team members with product knowledge and business processes.
• Strong work ethic, taking ownership of all duties and responsibilities and meeting management objectives.
• Strong business acumen, analytical, problem solving, interpersonal and presentation skills.
• Excellent written and oral communication skills to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.

Skills Summary

Experience

Confidential

BI Lead/Analyst

• Responsibilities include Lead a team of 6 Test analyst. 4 Onsite and 2 located at offshore.
• Perform business analysis of client data processes and procedures.
• Design a test plan and prepare Master Test Plan for team.
• Review Crytal reports design and help team on building reports.
• Development of reports and help team on technical issues.
• Production support of the reports.
• Review the estimate given by Team and refine it as per risks and other dependencies.
• Provide enough insights to team on what to test, how to test.
• Provide realistic effort estimate to the client and discuss those estimates and get the approval for the same.
• Do project status reporting to client.
• Perform unit, integration and system testing of software solutions.
• Support acceptance testing of software solutions.
• Perform configuration management of software solutions, including release promotion.
• Perform regression testing of production-promoted solutions.
• Manage operational solution performance via application and data tuning.
• Enhance operational solution as new business features are illuminated.
• Extensive use of Quality Center, creating Master Test Strategy documents covering Scope, out of scope, Test approach and communication details etc.

Confidential

BI Lead

• Responsibilities include Lead a team of 6 developer and 1 Business Analyst in Universe Design, Web Intelligence Reporting, . Also include admin responsibilities like providing user access to reports, Folder level access.
• I had designed new gating checklist for each phase of development cycle where we will perform quality checks, once complied to those checklist, team will move to the next phase. This improved quality of the deliverables significantly.
• Used Import Wizard tool to migrate all the objects from BO XIR2 to BO 3.1.
• Designed and developed BO reports.
• Tested all the reports that are migrated and analyzed the performance of the BO 3.1and BO 4.0 using Load Runner by creating many virtual users.
• Maintained the entire Business Objects environment TEST, DEV, UAT, PROD along with 3 main servers.
• Analyzed business model and created BI Architecture plan, created Business Functional Specifications, Functional Design Specifications, and Detailed Design Specifications
• Assisting the client, through analysis of their existing system, challenges, and business needs
• Documented the reporting requirements, dashboard design requirements by thorough interactive sessions with Business users by building prototypes for developing the interactive executive level dashboards.
• Designed, Developed and Maintained Universe in BOXIR3 Designer by defining joins and indicating cardinalities between tables in star schema fact and dimension table from data warehouse, creating Aliases to resolve the Loops, subdividing into Contexts to remove cyclic dependencies. Created the objects, which are grouped into classes for convenience in Business Objects Designer. Created custom List of Values. Used Aggregate Aware,
• Defined Access Restrictions in the universe for Confidential, Non Confidential and Highly confidential User groups and applied to the groups defining the priorities for different Access Restrictions. 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
• Designed the Universe with the ability of adhoc reporting for users
• Handled query performance by created conditions in Universes and optimizing it at the Database level
• Developed Tab reports with charts, crosstabs format, master/detail report.
• The reports are built using Web Intelligence Rich Client and exported to CMS and scheduled instances of Web Intelligence reports in Infoview
• Tested the results in Business Objects Web Intelligence reports and running the queries SQL's in the Oracle Database.
• Designed and developed interactive Dashboards using Xcelsius 2008.
• Built Dashboards with various functionalities like passing parameters by selecting parameters from drop down list, also passing prompts from dashboard to Web Intelligence reports.
• Extensive use of drill down capabilities, drill through capabilities, dynamic visibilities, dynamic filtering.

Confidential

Technical Lead Business Object

• Played the role of Technical lead for this reporting project using Business Object . Used to directly interact with client on daily basis and help offshore team to build the system knowledge and help them technically as well. This project was for reporting requirement of Kohl's daily/weekly and monthly sales and some flash reports.
• Performed requirement gathering, analyzed the new requirements, wrote the functional requirement documentation and estimated man-hours.
• Facilitated and participated in Joint Application Development JAD sessions for requirements gathering, resolving open issues and change requests
• Worked with BO Designer, Infoview, Web Intelligence, Web Intelligence Rich Client, Desktop Intelligence, CMC..
• Worked with Business Objects XI 3.1/XI R2 Administration e.g., Creation of Users , Groups and controlling their rights to reports, security set up at folder level, group level, Installation, Windows AD Configuration, Certification to use server authentication
• Executing system test and validating the applications against defined requirements according to the documented scripts and success criteria.
• The data migration included identifying various databases where the information laid scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Prepared technical specifications
• Developed data models using MS Visio.
• Designed and developed data mart to produce logical and physical snapshot models
• Designed ER diagrams, logical model relationship, cardinality, attributes, and, candidate keys and physical database capacity planning, object creation and aggregation strategies for Oracle and MS SQL per business requirements using Erwin
• Unit testing is performed on Dashboards, Reports and Universe using HP Quality Center and updated the results in HPQC.
• Published Dashboards to Infoview and shared to the users in SharePoint through OpenDoc links.
• Tested the reports thoroughly created by other developers, as per the report specifications
• Modify report content and export reports in multiple formats, based on user input
• Designed best practices for production support for day-to-day end user requirements for reporting.
• Worked extensively on Central Management Console and Infoview to perform Business Objects Server side Administrator role to manage users, objects, security at both user level and object level. Participated in scheduling the reports using Central Management Console and Infoview.
• Gathered required information from Business users and created universes for Sales, Decision Support System, Operations, Budget and Forecast using Business Objects XI 3.1/ XI R2.
• Provided production support for Business Objects reports and universes
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes
• Wrote documentation for Universe and Reports
• Developed functional requirements and data specifications for ETL Process
• Created several simple, complex and ad hoc reports, utilizing: Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula
• Generated Web reports, using Business Objects Web Intelligence
• Created reports that included formatting options such as Grouping, Sorting, Drill-down, Parameter prompts, Hyperlinking
• Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports
• Exported reports into various formats like PDF, Excel, and Word for the convenience of the end users

Confidential

Technical Support Analyst

• This project's aim was to calculate emissions of the different refineries of British Petroleum.
• Created various kind of regulatory report required by the US government. We had to calculate emissions using complex formulas as provided by the business so that regulatory reports are accurate and consistent.
• We used Oracle and Micro Strategy /Business Object to achieve these reports.
• I also had designed disaster recovery plan for this project and we had live DR test which was successful and client had appreciated it a lot. DR drill is to make sure that incise of primary server fails, all application services are moved over to secondary server.
• Gathered required information from Business users and created universes for Sales, Decision Support System, Operations, Budget and Forecast using Business Objects XI 3.1/ XI R2.
• Provided production support for Business Objects reports and universes
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops.
• Developed Tab reports with charts, crosstabs format, master/detail report.
• The reports are built using Web Intelligence Rich Client and exported to CMS and scheduled instances of Web Intelligence reports in Infoview
• Tested the results in Business Objects Web Intelligence reports and running the queries SQL's in the Oracle Database.

Confidential

Sr BO Developer

• I was leading this SFDC reporting project.
• I used to gather a customer requirement and convert it into a design document and share the same with development team. If there are any critical issues then I also used to do the hands on. I also managed the project plan and make sure that deliverables are provided to customer on time.
• This project used to use SFDC salesforce.com as data source for reporting and publish those reports on crystalreports.com so that end users can run or schedule them on web.
• Tested the reports thoroughly created by other developers, as per the report specifications
• Modify report content and export reports in multiple formats, based on user input
• Designed best practices for production support for day-to-day end user requirements for reporting.

Confidential

• At France Telecom, Clarify CRM version 12.1 SR1.37 has been implemented on Oracle version 9.2.0.4 and Sun Solaris platform.
• Modules that are implemented and in use are Clear Support, Clear Contracts and Clear Logistics along with Rule manager, DataEx, CB Batch, DDEditor DDComp utilities. France Telecom provides support and services to the customers through contracts and service level agreements. These contracts and SLA are managed through different clarify modules. Using these modules France Telecom maintains high-level customer commitment and service. Clarify application is tightly integrated with GOLD CRM to provide field service functionality. The application is also integrated with other applications through various technologies like Java, Clarify Business Objects CBOs , Pro C,Oracle Advance Queues, Triggers, Stored Procedures etc.
• My role was lead a support team and analyze the customer issue and guides the developers to take appropriate actions. I handle customer interaction part also. We do customization using Clear Basic language, Oracle as database

Confidential

Sr. Technical Support Engg.

• As this was support project, we used to track the defect queue and work on those Clarify CRM related issues. Fix them and provide solution to the customer.
• Whenever there is issue, customer will create a case i.e. ticket, we used to work on those cases till it is tested by customer and happy to close that tickets.
• I used to gather CSAT from customer at the end of every month and provide CSAT report to management.

Confidential

Developer

• I was working for reputed client Citi Bank I was working as developer for Demand draft processing, ECS, DD Printing and Paid Data modules of the RAPID project.
• I used to provide production support for the users of RAPID banking application.
• Application was built using Visual Basic and SQL server 2000.
• I used to design and develop reports using Crystal Reports.
• Legacy system AS400 used to have different kind of COBOL programs/jobs to run behind the scene to validate the customer account and amount on cheque to be cleared through ECS.