PROFILE:

• An accomplished IT professional having 13+ years of experience, specialized in Business Intelligence with extensive exposure on full life cycle (E2E) of the reporting and dashboarding process; including project management, client management, requirement analysis, installation, prototyping, proof of concept, metadata design, report development, scheduling, testing, troubleshooting, support, estimation, performance tuning and documentation.
• Professional experience in planning, development and managing Business Intelligence projects.
• Extensive knowledge of business intelligence concept and business management activities.
• Knowledge of project cost estimation and financial applications.
• Technically competent with excellent leadership and monitoring skills.
• Possess excellent communication skills and has the ability to work effectively in a team environment.
• Proven skills in value added development of BI Reporting projects using SAP Business Objects, QlikView and Cognos BI.
• Worked with agile and waterfall methodologies.

CORE COMPETENCIES:

• Eye for detail
• Good knowledge of the industrial quality standards
• Posses the ability to inspire/mentor teams
• Proactive, tactical team builder, creative and initiative
• Presentation and technology lead skills
• Results - oriented person
• Planned and organized approach towards work
• Familiarity with the tools and concepts in Business Intelligence
• Excellent communication skills
• Proficient team handling abilities

TECHNICAL EXPERTISE:

Operating Systems: Windows NT/2000/2003

Languages: Visual Basic, Java, ASP

BI Tools: Business Objects (5.x, 6.5, XIR2, 3.1, 4.0), Universe Designer / Information Design Tool, Web Intelligence, WebI Rich Client, Desktop Intelligence, Reporter, Xcelsius

Crystal Reports: CMC / Supervisor, QaaWS, SAP Infoview / Launch Pad, Informatica 7.1.3

Designer: Power Center, Workflow Manager,Cognos 10

Framework Manager: Report Studio, Query Studio, Analysis Studio,TM1 - 10.1,RTM, Insight, QlikView (10, 11) - Desktop, Server and Publisher, Hyperion Intelligence, BRIO, MS Visio 2010, Erwin 6

RDBMS Technologies: ORACLE (8i, 9i, 10g, 11g), SQL Server (2000, 2005, 2008), DB2, IBM Optim Development Studio 2.1.0,Teradata 13.10

Web Servers: Tomcat, IIS, Jrun

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, Illinois

Project/Tech Lead

Technical Environment: BO Designer 3.1, WebI Rich Client and Web Intelligence 3.1, Cognos 10.1 FrameWork Manager, Report Studio, TM1 - 10.1, DB2

Responsibilities:

• Responsible for requirement gathering, business and claims department coordination, mockups, documentation and sign-off
• Create documentation for report specification/design, reporting team progress, report development checklist, report validation checklist, format and standards and format and standards for reports and universe development
• Effort estimation, project planning, task allocation, project meetings, regular follow-ups and business updates
• Data modeling, universe designing, security setup and report development in Business Objects 3.1 environment.
• Rebuilding the existing BO reports into Cognos 10.1 environment as sun setting Business Objects by 2015.
• Designing and Building TM1 cubes for Powerful analysis for COL, Catastrophe, Auto Claims and payments.
• Dashboards design and development using QlikView 10.
• Project deployment and support/service
• Adhere to attend daily scrum calls and provide inputs for sprint backlogs

Confidential, Bloomington, Illinois

Project/Tech Lead

Technical Environment: BO Designer 3.1, WebI Rich Client and Web Intelligence 3.1, Cognos 10.1 FrameWork Manager, Report Studio, TM1 - 10.1, DB2

Responsibilities:

• Responsible for requirement gathering, business and underwriters coordination, mockups, documentation and sign-off
• Create documentation for report specification/design, reporting team progress, report development checklist, report validation checklist, format and standards and format and standards for reports and universe development
• Effort estimation, project planning, task allocation, project meetings, regular follow-ups and business updates
• Data modeling, universe designing, security setup and report development in Business Objects 3.1 environment.
• Project deployment and support/service
• Rebuilding the existing BO reports into Cognos 10.1 environment as sun setting Business Objects by 2015.
• Designing and Building TM1 cubes for Powerful analysis for Policies, Agents performance, business and Market area wise revenue.
• Adhere to attend daily scrum calls and provide inputs for sprint backlogs.

Confidential, St. Louis, Missouri

Onshore Project Lead / Offshore Build Manager

Responsibilities:

• Performed the role of Pune location lead for delivery and support.
• Project Delivery Management, 100% ownership of the project. Resource Allocation, Efforts Estimation, Project Planning.
• Had daily knowledge sharing sessions with onshore client to understand the systems which needs to be transitioned to offshore?
• Efforts estimation to calculate the financial costing. Established the onshore offshore resource role model.
• Actively involved as a mobilization manager for offshore location (Pune)
• Project Delivery Management, 100% ownership of the project. Resource Allocation, Efforts Estimation, Project Planning.
• Tasks assignment. Accepting the work request from the business and end customers, estimation of the work and sign off from the client on the completed work
• Liaison with the client managers and product managers on the planning of future work assignments and enhancements.
• Coordinating with HR for interview and recruitment.
• Interact with clients and users to understand requirements and to validate design specifications.
• Develops the detailed work plan for assigned scope of responsibility. Help facilitate coordination of work performed in different locations such as design hand-over.
• Participate in defining project standards and procedures, improvement activities related to issues management or quality processes.
• Identify and act on application incidents/resolution in support of service level agreements
• Maintaining Request workflow functionality which was used for non-problem related support activities
• Use OLAP tool Business Objects 4/5.x/6.0 /XIR2/3.1/4.0 (Reports, Designer, Web Intelligence, Info view, and CMC) and Accenture proprietary tools for development and enhancement work.
• Extensive experience in creating complex universes using multi-star schema, contexts and alias for resolving loops/traps, cascading prompts
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions and setup Hierarchies for Multi dimensional Analysis in Business Objects Universes.
• Creation of business objects reports of various presentation styles such as charts, cross tabs, slice and dice, alerts, prompts, nested loops, and filters.
• Expert in tuning the performance of SQL queries and ETL process using BO Performance diagnostic tool.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Worked with Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Highly motivated with excellent interpersonal, communication skills and makes efforts to do the work at hand effectively
• Follow agile and waterfall practices as applied

Confidential, Houston, Texas

Project Lead

Responsibilities:

• Delivery Management and resource allocation.
• Efforts estimation, project planning, task allotment.
• Client coordination and direct interaction with business for requirements.
• Involved in Systems Study, Analysis of base system and technical aspects. Coordinating with the team members to explain the business functionalities and technical reporting development and deployment.
• Coordinating with team members for preparing simple and complex reports using Business Objects.
• Universe design with definitions of Joins, Context, Aliases and Hierarchies for drilling of the reports using BO Designer.
• Coordinating with team members for preparing simple and complex reports using Business Objects.
• Manage user access, creation of user and maintain the security policy by using Supervisor.
• Conducting training to train users and online supports
• Designing the process flow, time sequences to extract the data from various sources.
• Tuning of the system so as to achieve high performance for retrieval of the data for fast access.
• Optimization of universe and reports at query level.

Confidential

Project Lead

Responsibilities:

• Offshore Delivery Management and resource allocation.
• Efforts estimation, project planning, task allotment.
• Client coordination and direct interaction with business for requirements.
• Involved in Systems Study, Analysis of base system and technical aspects. Coordinating with the team members to explain the business functionalities and technical reporting development and deployment.
• Coordinating with team members for preparing simple and complex reports using Business Objects.
• Universe design with definitions of Joins, Context, Aliases and Hierarchies for drilling of the reports using BO Designer.
• Coordinating with team members for preparing simple and complex reports using Business Objects.
• Manage user access, creation of user and maintain the security policy by using Supervisor.
• Conducting training to train users and online supports
• Designing the process flow, time sequences to extract the data from various sources.
• Tuning of the system so as to achieve high performance for retrieval of the data for fast access.
• Optimization of universe and reports at query level.

Confidential

Senior Consultant (Senior Software Engineer)

Responsibilities:

• Universe design with definitions of Joins, Context, Aliases and Hierarchies for drilling of the reports using BO Designer.
• Preparing simple and complex reports using Business Objects.
• Manage user access, creation of user and maintain the security policy by using Supervisor.
• Conducting training to train users and online supports
• Designing the process flow, time sequences to extract the data from various sources.
• Tuning of the system so as to achieve high performance for retrieval of the data for fast access.