Balaji Rajasekaran, PMP®

Rocky Hill CT – ***** Phone : 860-***-**** Email : krh12j@r.postjobfree.com

BI Technical\Development Manager with 10+ years of progressive IT experience predominantly in Data Warehousing & BI space. Have a very good exposure to Data Warehousing, BI Solutioning, Technical Architecture, Database technologies. Possess a solid understanding of DW & BI concepts. Have consistently met the needs of the clients in the areas of Cost, Quality, Delivery time, Technology and achieved highest customer satisfaction scores. Also have exposure to O&M projects that includes process like Service Level management, Incident Management, Change Management and Release Management. Directly managed all aspects of the projects while working in close collaboration with client management to ensure the completion of projects on time and within budget. Extensively experienced in Resource Management(Hiring,Mentoring,Review) & BI Team management across Onshore-Offshore(US -India).

AREAS OF EXPERTISE

Technology Leadership Release Management Team Leadership\Mentoring

Project Management Data warehousing Microstrategy

Resource Management BI Reporting Tools Process Standardization

Quality Management Defect Management Service Level Management

IMMIGRATION STATUS

US Permanent Resident (Green Card)

EDUCATION

• Master’s Degree in Business Administration (M.B.A) (2004-06)

• Master’s Degree in Computer Application (M.C.A) (1999-2002)

• Bachelor’s Degree in Computer Science (B.Sc) (1996-99)

CERTIFICATION & PROFESSIONAL DEVELOPMENT

• Project Management Professional (PMP) from PMI. (Since 2009)

• Microstrategy Certified Engineer (MCE) from Microstrategy

• Certified Project Designer (CPD) from Microstrategy

• Certified Report Developer (CRD) from Microstrategy

• Certified Platform Administrator (CPA) from Microstrategy

• Managed Healthcare in-house assessment\certification

• Data warehousing in-house assessment\certification

• Data Modeling in-house assessment\certification

AFFILIATIONS

• Member, Project Management Institute

• Member, Microstrategy Online Tech Support

• Member, The Data Warehouse Institute

ACCOLADES

• Received Appreciation Award for the year 2005 for delivering the product on time with zero defects.

• Have been consistently receiving appreciations from clients on successful accomplishments in the areas like Technology Leadership, Release Management & Delivery Management.

TECHNICAL PROFICIENCY

Project Management Tools Microsoft Project, Microsoft Visual Source Safe, Microsoft Office Suite, Microsoft Visio, Sharepoint

ETL & BI Tools Informatica 7.1, BO Data Integrator 6.1, Business Object 5.1, Microstrategy 8.X\9.X Suite, Microstrategy Mobile

Programming Languages and Databases JAVA/J2EE, C++, HTML, XML, JavaScript, JSP, Servlet, XML, Spring Framework, Visual Basic, VB Scripting, MS SQL Server, Oracle 9i\10g

Tools/Utilities TOAD, HP Quality Center, HP Service Manager – Ticketing System

Platforms Windows NT 4.0, Windows 9x, 2000, 2008

ASSIGNMENT DETAILS

United Health Group – Optum Health (Jan 2011 to Till Date)

Optum Health is part of United Health Group. It employs more than 14,000 people and generates more than $6 billion in annual revenue. It provides services to employers, insurance companies, health care providers and public sector organizations such as county and state governments. Also offers its services through solutions marketed by other UnitedHealth Group companies, and directly to consumers.

Projects: Parallaxi Infrastrucutre Refresh, O&M Releases, Trend View Releases, HIPAA 5010, Norms 2010, ICD 10, Teradata migration, Report Re-design\Work Bench.

Tools & Technologies: Microstategy 9.x, Oracle 10g, MS Project, MS Office, MS Visio, SVN

Roles Played : Sr.BI Project Lead, Release Manager

Responsibilities:

Technical Leadership:

• Technical leadership which includes Proposing, Executing and Managing the delivery of end-to-end BI solutions using Microstrategy and by utilizing all the latest features of the Microstrategy suite.

• Provide expert Microstrategy guidance to business and actively participate in Complex Dashboarding & Report development as and when required.

• Play the role of Microstrategy Architect and actively getting involved in critical areas of the project for providing Solutions & Dashboarding Design ideas.

• Directly participate in BI POC for new initiatives and direct the team to achieve the business goals. Demonstrate the POC to senior management.

• Extensively work on Dynamic Dashboard development using Report Services documents using multiple datasets and complex derived metrics.

• Optimization of run times for data intensive trend reports.

• Responsible for overseeing, performing and advising on the Microstategy object moves across various Dev, Test, Stage, Prod environments using Microstategy Object Manager there by following the Application Lifecycle Management.

• Be up-to-date in all new Mirostrategy product releases and evaluate the best fit of the new features that could solve the business pain areas.

Release Management:

• Prepare & publish Release plan and ensure proper handshake of various project teams.

• Open HPSM tickets and ensure appropriate approvals before deployment.

• Track and control various release activities to ensure smooth & timely deployment of the project codes to the production system.

• Obtain required business approvals to be SAS70 compliant.

• Frame back-out plans to address worst case scenarios.

• Conduct frequent meetings to track the release progress.

• Oversee the entire deployment during the production deployment which is usually during non-business hours or Weekends.

• Keep business stakeholders well informed about the deployment progress.

• Capture lessons learned and best practices and broadcast to the PMO.

Delivery Management:

• Ensures the team delivers the project on-time to the client with no compromise on quality.

• Effective Coordination of work between onsite and offshore teams.

• Ensure the work is progressing at the rate required to achieve the project milestones and deliverables.

• Prepare project plan and effectively controlling the project.

• Resolve conflicts among various team through meetings & discussions.

• Review the tasks at a very high level and discuss with progress with team leads.

• Facilitate daily onsite-offshore calls to ensure proper hand shake between the teams and to avoid gap in requirement understanding.

• Create & Present management dashboards that represent the most accurate project status.

• Perform scope verification by obtaining stakeholder’s formal acceptance\sign-off on completed deliverables.

• Ensure the team follows the change control process when there is any request to change the agreed scope.

• Monitor cost performance to detect and understand the variance.

• Manage change control efficiently to keep the project budget under control.

Resource Management:

• Managed a team of up to 12 professionals across sub-projects & various geographical locations.

• Structure the project teams based on the Module and or technology used in the project.

• Assign appropriate team leads based on the technology expertise & experience level.

• Identify & assign roles, responsibilities and reporting relationships for the team.

• Track the team performances, provide feedback, discuss and resolve issues if any.

• Set individual goals to align with project and organization goals.

• Review and perform annual appraisals for the team members. Allot appropriate performance ratings per the work performance.

• Advice on training needs to resources based on the project needs.

• Listen to resource’s concerns and if required take necessary actions to address the concerns.

• Perform resource leveling to examine unbalanced use of resources over time, and for resolving over-allocations.

• Initiate & participate in recruitment process if proper resources are not available within the organization to fulfill the project needs.

Quality Management:

• Understand & Identify relevant quality standards\process for the project work.

• Proactively incorporate lessons learnt from previous project\implementation to avoid bugs.

• Strict adherence to all Quality standards.

• Performs internal quality audits & ensure all artifacts are hosted in sharepoint.

Accomplishments :

Proactively identified all business benefits of Microstrategy 9 and reviewed with client.

Instrumental in driving the team to complete all the key analysis for migration from Microstartegy version 8 to 9.

Excellent release management of all O&M releases for Parallaxi & Trend view products.

Provided key inputs in executing tasks in parallel in order to avoid schedule slippage and thereby saving the cost of overall project.

Personal participation in Green Plum POC & delivering the performance statistics to Sr. management on time.

United Health Group – Ingenix (Jan 2009 - Dec 2010)

Ingenix provides knowledge and information services to physicians and health care professionals, health insurers, employers and other health care buyers, pharmaceutical and biotechnology companies, medical device manufacturers and government entities. Based on the Data and information Services the Company publishes reports to be accessed by the users (customers, companies etc).These reports are of a highly complex nature and covers the entire gambit of Microstrategy services.

Projects Executed: PXI Scorecard, PXI O&M Releases, Trend View Releases

Project Description: The project involves creation of Microstrategy dashboards for various quadrants like Financial Management, Plan Management, RX Management. The dashboards are highly complex in nature with various key business metrics displayed and high level graphs & grids. The end user should have the capacity to navigate to the detail dashboard from the Executive Scorecard.

Tools & Technologies: Microstategy 8.x, Oracle 10g, MS Project, MS Office, MS Visio, SVN

Roles Played: Sr.BI Project Lead, Release Manager

Responsibilities:

• Building Microstrategy schema objects like role based attributes, fact extensions, hierarchies, transformations and maintained the warehouse catalog.

• Involve in building reports objects like level metrics, metrics using pass through functions, element list prompts, complex filters, customs groups and consolidations.

• Design complex MicroStrategy reports according to specifications and handled the Application Lifecycle Management for the project.

• Extensively worked on Dynamic Dashboard development using Report Services documents using multiple datasets and complex derived metrics.

• Optimization of run times for data intensive trend reports.

• Architecting and Providing expert guidance in Microstrategy Suite to team and Actively getting involved in critical areas of the project

• Be up-to-date in all new Mirostrategy product releases and evaluate the best fit of the new features that could solve business pain areas.

• Directly participate in POC for new initiatives and direct team to achieve the business goals.

• Involve in Business requirement gathering & actively participate in review meetings.

• Estimate effort for all projects activities.

• Lead a team of BI resources and Rigorous follow-up with team in completing the tasks.

• Involve in Business requirement gathering & actively participate in review meetings.

• As a Release Manager, responsible for all release management activites which involves but not limited to Prepare, publish Release plan, Log HPSM tickets and obtain appropriate approvals before deployment from the Change Advisory Board, Track and control various release activities to ensure smooth & timely deployment of the project codes to the production system.

• Obtain required business approvals & place all release artifacts in sharepoint to be SAS70 compliant, Frame back-out plans to address worst case scenarios, Oversee the entire deployment during the production deployment which is usually during non-business hours.

• Delivery management by ensuring the team delivers the project on-time to the client with no compromise on quality And Effective Coordination of work between onsite and offshore(India) teams.

• Prepare project plan, effectively control the project and Manage business continuity\disaster recovery efforts.

• Resolve conflicts among various team through meetings & discussions.

• Review the tasks at a very high level and discuss with progress with team leads.

• Create & Present management dashboards that represent the most accurate project status.

• Perform scope verification by obtaining stakeholder’s formal acceptance\sign-off on completed deliverables.

• Ensure the team follows the change control process when there is any request to change the agreed scope.

• Monitor cost performance to detect and understand the variance.

• Maintain the Cost of the project within approved budget.

• Manage change control efficiently to keep the project budget under control.

• Effective resource management by structuring the project teams based on the Module and or technology used in the project, Identify & assign roles, responsibilities and reporting relationships for the team.

• Track the team performances, provide feedback, discuss and resolve issues if any.

• Set individual goals to align with project and organization goals.

• Review and perform annual appraisals for the team members. Allot appropriate performance ratings per the work performance.

• Advice on training needs to resources based on the project needs.

• Perform resource leveling to examine unbalanced use of resources over time, and for resolving over-allocations.

• Initiate & participate in recruitment process if proper resources are not available within the organization to fulfill the project needs.

• Strict adherence to all Quality standards And Proactive incorporation of lessons learnt from previous project\implementation to avoid bugs.

• Performs internal quality audits & ensure all artifacts are hosted in sharepoint.

Accomplishments :

Standardization of all release related activities in order to ensure smooth release.

Received accolades from Client management for successfully handling all the releases & for introducing release progress charts.

Project delivery on time per project schedule & within project budget.

United Health Group – Ingenix (May 2008 - Sep 2009)

Projects Executed: NCBD Optum Reporting

Project Description: This project is addition of new report for Ingenix client Optum with respect to NCBD data housed by Optum. This is a separate subject area that contains its own population set those who have attended the healthcare program. This population set is used to report against the metric from other subject areas like medical, drug etc. Thereby evaluating the amount utilized by them before and after enrolling into the program. This involves creation of additional reports for the OPTUM client only.

Tools & Technologies: Microstategy 8.x, Oracle 10g, MS Project, MS Office, MS Visio, VSS

Roles Played: Delivery Lead\Manager, BI Project Lead

Responsibilities:

• Involve in Design, Datamodelling meetings and perform feasibility study if required.

• Work with the DW team to ensure appropriate aggregations are created in support of reporting and analytics needs.

• Directly participate in POC for new initiatives and direct team to achieve the business goals.

• Defined and created MicroStrategy objects including attributes, filters, metrics, hierarchies, templates, prompts and reports.

• Design and Development of Business Analysis Dynamic Dashboards, Scorecards according to design specifications.

• Interact with DBA and Data Modeler to build Dimensional Data Modeling (Star Schema and Snow-Flake Schema).

• Worked on Migration of report from existing business environment to Microstrategy environment.

• Conditional formatting on metric thresholds, limiting report data access using security filters

• Lead a team of BI consultants and mentor the team as required.

• Actively getting involved in critical areas of the project and providing Microstrategy architecting solutions\ideas.

• Validation of report data using test cases.

• Involve in Business requirement gathering & actively participate in review meetings.

• Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy Desktop.

• Effort Estimation for all projects activities.

• Delivery management for all project modules

Accomplishments :

Tracked the project performance and progress using Earned Value methods

Received appreciations from senior management for delivering the projects on time

Provided innovative ideas & Technical guidance to report against different subject areas

Completed analysis and design phase well ahead of plan that significantly reduced the cost for those phases.

United Health Group – Ingenix (Aug 2006 - Apr 2008)

Projects Executed: Non-Claims Based Data Reporting

Project Description: This project involves creating Microstrategy analytical reports for the Non-Claims Based Data for various clients. This is a separate subject area that contains its own population sets. This population is used to report against the metric from other subject areas like medical, drug etc.

Tools & Technologies: Microstategy 8.x, Oracle, MS Project, MS Office, MS Visio, VSS

Roles Played: Sr. Microstrategy\BI Consultant

Responsibilities:

• Served as key person for Effort Estimation and Resource planning. And take care of all client level communications.

• Guided the efforts of the entire team.

• Involved in Microstrategy Architecting and Report development.

• Responsible for designing complex report logic and dashboards based on business requirement.

• Served as technical subject matter expertise for microstrategy & provided tuning suggestions by recommending appropriate VLDB settings.

• Involved in writing complex SQL queries to validate the report results.

• Responsible for reviewing the Team’s work

• Responsible for deploying the appropriate resources for the project.

• Ensure project costing is within the budget & provide innovative ideas to reduce the overall cost of the project.

• Provide presentations to senior management on the project status and its progress.

• Involved in allocating tasks to the team members and oversee the daily activities of the team.

• Conducted daily review meetings with the team to ensure the team has completed the day’s task without any slippage in the time lines.

• Conducted ad-hoc internal quality review meetings to ensure the team is maintaining all standard documents.

• Supervise & motivate the team members to complete the release tasks on time.

Accomplishments :

Provided Microstrategy Technical guidance to report Non-Claims based data against existing subject areas like eligibility, medical, workers-comp etc.

Came up with a game plan and executed, apart from project plan, to perform continuous build of reports.

United Health Group – Ingenix (Jan 2005 - Jul 2006)

Projects Executed: CBIZ Reporting, Report Consolidation, Fiserv Reporting

Project Description: This project involves extracting the SQL generated from the Microstrategy tool and then converting it into a generic framework. The SQL are then converted into SQL packages as per the framework. The framework contains Constructor which constructs all the temp & final table, Accessor which is used to access the metric values returned by the constructor package and Destructor which deletes the unwanted temporary table created for metric calculation. The Accessor is in turn used by Microsoft reporting services to generate the reports with the required formatting. With this approach we are able to isolate work load from i-server to Microsoft reporting services.

Tools & Technologies: Microstategy 8.x, Oracle, MS Office, MS Visio, VSS

Roles Played: BI Project Lead

Responsibilities:

• Technical leadership for Microstrategy

• Microstrategy Architecting and Report development

• Involved in creation of procedure, functions, packages and triggers.

• Involved in creation of prototype document and test case document.

• Involved in daily deliverables of this project and review the code, prepared the process flow document of deliverables.

• Involved in report testing and compare report output and SQL output.

• Writing complex SQL query and procedures to get the appropriate output.

• Delivery management for the responsible modules

• Offshore Resource Management

Accomplishments :

Provided innovative reporting solutions to cater the needs of business.

Received Appreciation Award for delivering the product on time with zero defects.

United Health Group – Ingenix (Sep 2004 - Dec 2004)

Projects Executed: DSO Web Reporting

Tools & Technologies: Microstategy 8.x, Oracle, MS Office, MS Visio, VSS, Java,HTML, JSP

Responsibilities:

• Technical leadership for Microstrategy

• Extensively worked on Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports.

• Created documents with both Grids and graphs as per user requirements.

• Microstrategy Architecting and Report development, Worked with source systems to understand the data flow and interacting with user groups to collect the business requirements.

• Implemented star schema for data warehouse for logical/physical data modeling and dimensional modelling.

• Involved in architecting Fact columns and development of Hierarchies with related Attributes required for reporting.

• Created advanced grid reports, consisting of data analysis by combining a template with Filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.

Amerisource Bergen Drug Corporation (Jun 2004 - Aug 2004)

Projects Executed: Service Level Reporting, PO RCV Data Mart

Project Environment: Win NT, Informatica 7.1, DB2, UNIX.

Role: ETL Developer

Responsibilities:

• Understanding the Source System.

• Developing and executing the ETL process using Informatica.

• Create ETL mappings using various tranformation objects.

• Conduct peer review of codes.

• Data validation and testing.

• Estimate effort for all projects activities.

• Independently and actively host Technical review meetings.

• Rigorous follow-up with team in completing the tasks.

Procter & Gamble (Sep 2003 - Dec 2003)

Project Executed: Australian IM Reporting

Project Environment: Win NT, SQL Server 2000, Microstrategy 7.1.4.

Role: ETL and Report Developer.

Responsibilities:

• Interact with users and gather the requirements.

• Design logical and physical data model.

• Involve in the internal reviews/design review sessions to provide architectural inputs

• Design extraction, transformation and load procedure using SQL Scripts.

• Identified facts and attributes required to create a MicroStrategy project.

• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.

• Designed report templates to generate reports in grid and graph mode and Developed Custom Groups with different qualifications (metric, filter, attribute) for grouping of required elements to be shown in reports.

• Track and prioritize schema object development to meet the report development schedule

• Identifying and preparing suitable unit test cases to satisfy both positive and negative test scenarios.

• Create manual SQL to perform report data validation.

Spice Telecom (Jun 2003 - Aug 2003)

Project Environment: Win NT, SQL Server 2000, Business Objects 5.1, SQL Scripts.

Role: ETL and Report Developer.

Responsibilities:

• Understanding the client requirements.

• Design logical and physical data model.

• Design extraction, transformation and load procedure.

• Creating required report objects and report generation.

• Designing Universe, Classes, and Objects using Business Objects Designer.

• Create reports and related objects: filters, user objects, calculations, variables, Drill Downs and Slice & Dice.

• Data validation and testing.

Supply Chain Management – L`Oreal (Jun 2002 – May 2003)

Project Environment: Servlets, JavaScript, HTML, JSP, Oracle 8, Web Logic Server 5.1,

Role : Programmer.

Responsibilities:

• Understanding the client requirements.

• Participate in business requirement gatherings.

• Create Data Flow Diagrams

• Design UI screens & Business functions

• Develop UI Screens

• Unit testing the screens & perform peer review.

Contact this candidate