Summary:

• Over ten years of professional experience in Detail-oriented Data Analyst / Business Intelligence / Architect with a proven record of success. Substantial analytical, technical and problem solving skills combined with a strong cross-functional understanding of business processes and information technology needs.

IT Skills:

Reporting Tool : Business Objects XIR1/R2/R3/4.0, Crystal Reports 8.5/9/10/XIR2, BO Enterprise XI R1/R2/R3, SSRS 2005/2008, Tableau

RDBMS : Oracle 8i/9i/10G, MS Access 2000/2003, SQL Server 2005/2008.

Languages : SQL, C .Net, XML

Data Modeling Tool : Erwin / Toad / Red Gate

ETL Tools : SSIS Midlevel

Analysis Tools : SSAS, ProClarity, BO WebI, Cizer, Prism Cube

Computer Packages : MS-office, Ms-Visio, Ms-Project, Compare Beyond, Data Factory, TOAD

Version controls /

Content Management Portals: Visual source safe, Share Point, Team Site, Team Foundation Server

Products / Tools / Systems : AllScripts / Sunrise Clinical Manager 3.5/4.5/5.0/5.5, Black Board - Angel

PROFESSIONAL EXPERIENCE:

Confidential

Role : Business Intelligence Consultant

Environment:

Business Objects Universe 3.0/4.0, WebI, BEx Web, XCelsius, Crystal reports, SSRS/SSIS/SSAS 2005/2008, SQL Server 2005/2008, MS Visual Studio 2005/2008, Tableau 7, Team Foundation Server, Share Point, .Net. , RedGate/ERWIN

Description: Council on PostSecondary Education IT department is responsible for collect and housing student and staff data from public and private institutions. Housed data is used by numerous reporting system and agencies legislative, senate, governor office, workforce, education cabinet and many more .

Responsibilities:

• Work closely with business users in agencies to understand their reporting needs and suggest solutions.
• Database Modelling / Designing E-R model, Dimensional modelling.
• Data collection, Data profiling / Data integrity / Data quality check through edits/audits process.
• Implement and maintain Enterprise data solution and roll out process.
• Architect BI solutions.
• Setup, Configure and administer BI/reporting environment.
• Implement and manage Business Intelligence Solutions

o Database Database Designing / Modelling, Keeping database in sync across environments, Scripts, SQL/PL SQL

o Edit / ETL process Edits/Audits/Cleanup data, Data Profiling, Quality check, create scripts for ETL process

o Warehouse / Data Marts Design and Manage warehouse, host external data, create and manage meta data.

o SAP Business Objects Universe

o Reporting SAP Web Intelligence, SQL server Reporting Server, Crystal etc

o Dash board Tableau, XCelsius , excel

o Analysis / OLAP/Cubes Create SSAS cubes, summarize tables and dashboard.

o Administration SQL server users, groups, job agent management. SAP BO CMC environment / SSRS Report Manager Create/Manage Users/Security, Folder etc

o Distribution of Document / Reports : Create, publish, schedule and distribute reports

Create user documents /training materials and conduct training for internal BO users.

Health Care Industry Experience:

Over 4 years experience in designing and developed reporting solutions on Health care products like AllScripts Sunrise clinical Manager, ED Manager, Health Information System and other health care products. I handled multiple projects in developing and providing reporting solutions for health care clients.

Environment:

Crystal Reports, SQL Server 2002/2005/2008, SSRS 2005/2008/2008 R2/2012

Confidential

Role : Business Intelligence consultant / Report Writing Specialist.

Description:

• Reports were developed to meet, but not limited to the following requirements:
• Extract and Track Patients Information.
• Orders, Work List / Tasks, Medications, Documents, Notes, Vital Signs / Flow Sheets.
• Compliance check on assessments: Stroke, Pain, fall, Bradon, DVT, Education, Restraint, Wound care etc.
• Legal Medical Record reports
• Monitoring and follow up on staff to use system.
• Data Quality Maintenance and Integration.
• Downtime Reports.
• Activity Summary, Check treatment and patient care standards.
• Emergency Department, Research Analysis reports.
• Compliance with regulatory requirements of Joint commission requirements / State bodies.
• HPF Backup and storage.

Achievements / Accomplishments:

• Saved average 6 minutes per patient per day for Physicians on compiling and handling data during Sign off and Rounding. Created a comprehensive report 5-6 patients/page with patient's demographic, Allergies, Events, Comments, Vital Signs, Results and Medications.
• Increased compliance rate to 98 on critical assessment areas like Stroke, Pain, fall, Bradon, Education etc.
• Reduced 5 hr weekly manual work by creating a performance indication reports for unit directors.
• Developed reports avoiding care providers having to access multiple systems.

Responsibilities:

• Data Collection, requirement gathering, analyzing, and documenting reporting specifications / requirements.
• Interacting with users to understand reporting needs, advice and accommodate enhancements.
• Designing and developing reporting solutions.
• Extracting, processing data, combing, Reporting data from HIS system and MethOD using SSIS with whole control and audit.
• Created complex stored procedures, and functions using PL/SQL to produce the reports.
• Designed and developed Reports using BO, Crystal Reports and SSRS.
• Deployment and maintenance of scheduled reports in Report Manager, CMC.
• Creating Templates, Versions and Integrating reports in Sunrise Clinical Manager.
• Converting Reports from Crystal Reports to SSRS for SCM5.5 upgrade
• Report validation and obtaining user approval and sign off.
• Provide training and knowledge to user on the reports.
• Production Maintenance and back data runs
• Investigating and answering user s questions related to report data.
• Performed tuning and maintenance of SQL / Stored Procedures and reports.

Confidential

Environment: BOEnterpriseXIR2, Web Intelligence, Crystal Reports XI, Oracle9i, Erwin4.1, Informatica7.2

Role : Business Intelligence consultant

Achievements / Accomplishments:

• 65 increase in clicks to the website.
• 30 rise in subscriptions in 1st month.
• Substantial increase in advertisers and revenue.

Responsibilities:

• Involved in Architectural Design and Data Model.
• Designed data model using Erwin and generated Schemas.
• Designed and developed BO Universe.
• Created Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked the Integrity of the Universes.
• Exported the Universes to the Repository to make resources available to the users.
• Developed reports using Web Intelligence and Crystal Reports.
• Developed Web Intelligence reports using Filters, Combining Queries, Sub queries, Ranks, Breaks, Sections, Alerts, Graphs, Drill down, Formulas, and Variables etc.
• Worked on BO Enterprise CMC and Infoview like creating users, providing security, scheduling reports, creating events, User groups, Users, Notifications, Email Distribution etc.
• Worked on Dashboard and Performance Management.
• Promoted / Deployed reports in Production.
• Prepared reporting document depicting the data roadmap from source, data mart, Universe.
• Provided production support and maintenance.
• Worked on performance enhancement.

Confidential

Environment : Windows XP Professional, C .Net, MS SQL Server 2000, Crystal Reports XIR2, MS Visual SourceSafe 2005, Visual Studio 2005, JIRA

Role : Report Developer and Analyst

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications Reports.
• Designed and developed Crystal Reports which included standard reports, cross-tab reports, summary reports according to the requirements. These reports used complex SQL, Crystal formulae, Selection Criteria, Sub Reports, Graphs, functions, Parameters fields, and Group selection.
• Created views, triggers, complex stored procedures, and functions using PL/SQL to produce the reports.
• Involved in using crystal syntax for Formula field and Selection Expert in designing of reports.
• Developed various Charts and Graphs like Bar Chart Side by Side, Stacked , Line graphs, Pie Charts etc by using Chart expert of Crystal Reports XI.
• Study and understanding the business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules.
• Exported reports into various formats like XML, PDF, HTML, and EXCEL for user.
• Involved in unit testing and data validation of Reports.
• Performed maintenance and tuning of SQL and newly created report.
• These reports are published on web using Crystal reports Viewer in C .Net

Confidential

Environment: Crystal Reports XI, BOEnterpriseXIR1, WebI, Oracle9i,Erwin4.1,Informatica7.2

Role : Reports Developer Tester

Responsibilities:

• Prepared the Reporting Specification interacting with business users and understanding business scenarios.
• Involved in Architectural Design and Data Model.
• Designed data model using Erwin and generated Schemas.
• Simulated data mart with test data using Data factory and TOAD.
• Formulated ETL Transformation specification from the source to Data Mart.
• Involved in the Designing and Building of Universes, Classes and Objects for
• Developed reports using Crystal Reports and Web Intelligence.
• Developed Web Intelligence reports using Breaks, Sections, Alerts, Graphs, Formulas, and Variables etc.
• Implemented Formulas, Parameter, Cross tab Reports, Sub Reports etc using Crystal Reports.
• Worked on BO Enterprise CMC and Infoview like providing security, permissions, scheduling reports etc.
• Prepared validation document and validated reports against source, data mart and Universe.
• Worked on performance enhancement.
• Provided training to the users in Infoview and Ad hoc reporting using Web Intelligence.

Confidential

Environment : Crystal Reports 10, C ,.NET, XML, ChartFx, WinXP,2000/2003, IIS, Oracle, BO 6.5.

Role : Reports Developer Tester

Responsibilities:

• Understanding and analyze the requirements based on business scenarios.
• Involved in Designing Application Architecture and System development.
• Developed reports based on scenarios using various features like fields, formulas and conditional formatting using Crystal Reports.
• Implemented Cross tab Reports, Sub Reports using Crystal Reports Designer.
• Designed ad hoc reports using Desk top Intelligence.
• Created bar, pie graphs using chartfx and called them in the crystal reports.
• Worked along with team on .Net for Dataset creation and data binding.
• Worked on XML processing Serialization and data definition.
• Review and update test plans depending as per changes in technical and functional requirement.
• Conducted Functional Testing, GUI Testing, Web Testing, and Regression Testing during the various phases of application development.
• Performed Cross-browser and Cross-platform Testing.
• Performed user Functional User Acceptance testing, Tracked Fixed bugs.
• Worked on performance enhancement.
• Interacting with the users to implement the requirement changes and enhance Reports.

Confidential

Environment : Crystal Reports 9, Power Builder , SQL Server, WinNT

Role : Business Analyst and Report Developer

Description

• Raffle Education Group is a parent organization for Olympia College and World wide Education Council. It has about 15 education centers in Asia pacific region.
• KISS Knowledge Information Student System is a developed to maintain the following:
• o Course Information Course Details, Universities details
• o Enquiry Details, Promotions.
• o Basic details of students - Registration Details, Fee Payment Terms, Contact details, Exams Appeared, Results, Attendance etc.
• o Class Time Tables / Exam Schedules / Meeting Schedules / Counseling schedules / Promotion / Events / Activities.
• o Resources utilization matrix
• o Student Feedback
• o Reports Registration Summary Report, Result Report, Resource Utilization Report, Revenue Reports, Outstanding Collection Report etc.
• Responsibilities
• Analyzed the business requirements and created Business Model.
• Interacting with users and students to gather requirements.
• Developed use cases, coordinate with development team.
• Developed several reports using various features like section / break report, drill down, parameterized fields, formulas and alters.
• Implemented charts and graphs like Bar Charts, Pie Charts, Line graphs for financial reports.
• Performed manual testing and automated testing.
• Interacted with Development team in fixing crucial bugs.
• Involved in entire Development life cycle.

Confidential

Environment : Oracle, Crystal Reports 6, RS/400, Insulator ,UNIX, Dos,C, C , VC .

Role : Member of Technical Support

Description

Working on Anti-Collision Device which deals with Communication among GPS system, Radio modems etc. The main aim of this product is to avoid the collision of communication. This software is divided into various modules. This software is embedded in to a device.

Responsibilities

• Coding, Troubleshooting, Designing and Documentation

Confidential

Environment : Channel DIDO,UNIX, Dos, Microsoft/ANSI C, C , MS ACCESS, MS Reporting

Role : Technical Analyst

Description

• Manac Info tech is involved in developing wireless applications like mobile games and retrieving data.

Responsibilities

• Product Testing, Installation, Troubleshooting.
• Involved in product Designing and Documentation
• Interacting with coding team.