OBJECTIVE:

A challenging position in the IT industry in the BI space to leverage my technical background and industry knowledge to architect BI solutions.

SUMMARY:

• Energetic technology professional with over 12 years of experience in Business Intelligence space, performing various roles like BI Lead, Solution Architect, Senior Developer and Cognos Administrator.
• Strong working knowledge in data warehousing environment by designing schema from staging to operational data store to Star Schema, and OLAP data using multi - dimensional cubes.
• Domain knowledge in Healthcare, Life Science, Telecom, Retail, Finance & Airline sectors.
• Demonstrated and proven ability to provide Database solutions for EDW using Informatica as ETL tool and BI solutions using Cognos 10.2.1 as the Enterprise BI platform and the tools include - (Active Reports for Mobile, Cognos Workspace Advanced, Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager, Cube Designer, Dynamic Cubes, Transformer, and PowerPlay Studio).
• Extensively worked on BI platform using SAP Business Objects (Universe, OLAP Intelligence Report, and Crystal Report).
• Track record of increasing responsibility with supervisory roles in application design, systems analysis/development of full life cycle development, including feasibility studies, design and coding for large and medium projects along with project management and leadership skills.
• Expert in designing multi-dimensional cubes, dashboards, scorecards and operational reports in the BI space.
• Explored various BI tools like Tableau, Qlikview, and SSRS.
• Expert in ETL, SQL Scripts, PL-SQL packages, SSIS, Transact SQL, procedures and functions on multiple database platforms, performance tuning and troubleshooting
• Excellent communication, interpersonal, leadership skills and passionate towards working and achieving the company goals.

TECHNICAL SKILLS:

Business Intelligence: IBM Cognos 10.2.1, 10.1.0, 8v4, 8v2, Cognos Go OfficeBusiness Objects XI R2, EssBase 7.x

BI Tools: Transformer 10.x/8.4/7.4, Cube Designer, IBM Cognos Framework Manager 10.x/8.4/8.2, Cognos TM1, Data Manager

Reporting Tool: Cognos Studios (Active Reports, Cognos Workspace/Business Insight, Dynamic Cubes, Cube Designer, Report Studio, Query Studio, Analysis Studio, Powerplay Studio, Metric Studio, Event Studio), CAF, ReportNet, Powerplay Web, Impromptu, IWR, Cognos Upfront,Cognos Scripts, Macros, SDK, Schedule Management,SAP BO XI - Crystal XI, Crystal Enterprise 9.0, 8.5,Tableau, Qlikview

Server Administration: Cognos Configuration Management, Report Server Administration, Powerplay Enterprise Server, SAP BO Central Management Console

Directory Server: Microsoft Active Directory, Sun One Directory Server

Database: Oracle 11i, 10g/9i/8i, SQL Server 2008/2005/2000

Database Tools: Oracle PL-SQL, SQL Management Studio - SSIS, DTS, TSQL, DB2, MS-Access, Informatica 9x

Internet/Intranet: ASP, VBScript, JavaScript, HTML/DHTML, XML, XSL, IIS

Scheduler: IBM Tivoli, Opalis 4.0

CRM: Siebel 7.x, Clarify (eFrontOffice) - Clear Sales, ClearSupport, ClearCallCenter, Clear Basic language

Data Modeling: Erwin 3.0, ER Studio, Visio

PROFESSIONAL EXPERIENCE:

Confidential

BI Lead Architect

Responsibilities:

• Participated in business requirements gathering, created architectural and design documentation, technical specification documents for each projects.
• Architected Solutions based on the business needs and the best usage of tools using ROLAP, OLAP and MOLAP.
• Designed Framework Manager Models for the Enterprise using EDW as the source that involved Clinical Information, Survey Data and Financial Data
• Designed Dashboard using Active Reports for Cardiovascular department using Cognos Mobile and extensively used RAVE visualization from Analytics Zone.
• Extensively used Workspace and Workspace Advanced for designing dashboards.
• Designed Dashboard for the CEO’s office and implemented using Cognos Go Office that can be refreshed monthly and utilized for the CEOs board meetings.
• Designed Nursing Dashboard for the Chief Nursing Officer and nurses across Baylor Hospitals.
• Designed Service Line dashboard for product lines like Oncology, Neurology, Women’s Health, Orthopedic, Cardiovascular etc. using multi-dimensional cube as the source and use mdx functions.
• Designed Lean Scorecard with KPIs that helps identifying the gaps and improve efficiency and performance to better server patients during emergency admits.
• Design multi-dimensional cubes and Dashboard for Radiology Information Services and Laboratory Information Services to analyze data from Orders to Specimen to Test results.
• Created drill through reports from the dashboard to get into relational details and used hybrid solution by using cube and relational models.
• Extensively used Cognos suite of Products like Report Studio, Query Studio, Analysis Studio, Go Office and Metric Studio.
• Performing the role of a Cognos Administrator in monitoring and maintaining the environment, also have upgraded from Cognos 10.1.0 to Cognos 10.2.1 and from Cognos 8.4 to Cognos 10.1.0.
• Worked on project to virtualize all Cognos environments from physical servers.
• Managing Cognos developers in assigning development work, accountable for their deliverables, mentoring team members
• Responsibilities also include creating BI standards and Standard Operating Procedures (SOPs) for the organization.
• Worked with external projects teams in helping with Cognos standards and best practices, provided training and also designed metadata for them.
• Involved in providing and maintaining data security using Active Directory and Cognos Connection.

Environment: Cognos 10.2.1, 10.1.0, 8.4 (Cognos Connection - Active Reports, Workspace Advanced, Cognos Go Office, Report Studio, Analysis Studio, Query Studio, Metric Studio), Framework Manager, Cube Builder, Dynamic Cubes, Transformer), Oracle 11i, SQL Server, Sybase.

Confidential,Fortworth, TX

BI Architect

Responsibilities:

• Performed the role of BI Architect that involved providing BI solutions, metadata modeling, multi dimensional modeling and dashboard designing.
• Authored BI standards documents for FM model design, Report Design and Transformer model design and published as SOPs.
• Worked with functional managers and end-users to gather requirements for the BI team.
• Created and maintained framework models for S&M, Technical Services, Integrity reporting, Sales Performance and Call Activity.
• Designed and maintaining interactive dashboard using portlets and reports.
• Extensively used functionalities like parameterized URL, parameter maps, conditional formatting, conditional layout, report bursting, standard and stand-alone filters, calculation prompts, conditions and drill through reports.
• Designed solution to geographically represent data using Pitney Bowes MapInfo within Cognos.
• Involved in the logical and physical database design that involves defining data structures, creating tables, indexes, views.
• Extensive knowledge and experience on ETL using SSIS, SQL scripts and Stored Procedures.
• Involved in providing and maintaining data security using Active Directory and Cognos Connection.
• Managing external resources by assigning work, periodic status meeting, enforcing BI standards, motivation and mentoring them.
• Involved in demonstration, training and working with users troubleshooting their problems.

Environment: Cognos 8.4, 8.2 (Cognos Connection - Report Studio, Analysis Studio, Query Studio, Framework Manager, Powerplay, Transformer, Impromptu), Data Manager, Cognos SDK, SQL Server 2008, Transact SQL, Procedures and Functions.

Confidential,Fort Worth, TX

Sharp HR System

Responsibilities:

• Performed the role of an IT Consultant for Business Intelligence reporting.
• Worked with Project Managers, Department Program Managers and end-users to gather requirements and recommending various BI solutions.
• Involved in designing framework models, create/manage packages and external IQD’s.
• Created multi-dimensional OLAP cubes for Analysis type reports by using IQD and Excel as data sources.
• Extensively designed multi-dimensional modeling, parameters maps, object diagrams, query subjects in framework manager.
• Created reports with data using List, Cross Tab, Repeater and graphs using Charts in Report Studio for managed reports and Ad-hoc reports in Query Studio.
• Worked on converting impromptu reports to framework model.
• Involved in demonstration, training and working with users troubleshooting their problems.

Environment: Cognos 8.2 (Cognos Connection - Report Studio, Query Studio, Framework manager, Powerplay, Transformer, Impromptu), SQL Server, Transact SQL, DB2 database, Procedures and Functions SAP system, Aviva for desktop.

Confidential,DFW Airport, TX

Senior BI Architect

Responsibilities:

• Performed the role of a project leader managing a 7 member team handling multiple projects.
• Involved in interviewing and hiring contractors, assigning roles and performing schedule management.
• Extensively worked on understanding the business and gathered requirements by interacting with customers.
• Designed multi-dimensional model, parameters maps, object diagrams, query subjects and published packages using Framework Manager.
• Created reports with data using List, Cross Tab, Repeater and graphs using Charts in Report Studio and Ad-hoc reports in Query Studio.
• Extensively used functionalities like conditional formatting, conditional layout, report bursting, standard and stand-alone filters, calculation prompts, conditions and drill through reports.
• Created macros using Cognos scripts to create backup, generate and publish cube as a job schedule on a daily/weekly/monthly basis.
• Involved in Administration, Troubleshooting, Maintenance and migration of Cognos Enterprise products.
• Created ETL-SQL Loader scripts, SQL Scripts and PL-SQL packages.
• Interacted with end-users for technical assistance, troubleshoot and fix program bugs, enhance new functionalities.

Environment: COGNOS 8.0/7.3, Cognos Connection, ReportStudio, QueryStudio, Analysis Studio,, Framework Manager, PowerPlay Transformer, Impromptu, PPES, Upfront, Visualizer, Metrics Manager, Cognos ReportNet v1.1 MR3, Content Manager, Cognos Scripts, Access Manager, SDK, Microsoft Active Directory, ORACLE 10g/9i/8i, SQLLoader, ASP, VBScript, JavaScript, TOAD 7.2, Opalis 4.0, Windows Scheduler, ReportNet Schedule Management, Crystal Enterprise Server, Access 2000, Windows NT/2000.

Confidential,MA

Senior Consultant

• Created Catalog, IMR reports, Impromptu Query Definitions using Impromptu.
• Created standard filters, calculation prompts, conditions.
• Designed the model, developed the Cognos Query, IQD and PowerPlay packages.
• Published IWR reports and PowerPlay cubes on the Upfront portal using Cognos IWR report admin and PowerPlay Enterprise Server.
• Created dimensions and measures using IQD and generated power cubes using PowerPlay Transformer.
• Involved in Cognos Server administration and maintenance like backup cubes and creating macros and UNIX shell scripts to generate cubes.
• Involved in Performance Tuning of larger cubes using multiple data sources.
• Created database Triggers, PL-SQL Procedures, Functions & Packages.
• Involved in training & troubleshooting junior programmers in designing reports, stored procedures.

Environment: COGNOS 6.6, Impromptu, PowerPlay, Transformer, Upfront, PPES, Decision Stream, Access Manager, Unix Shell Scripts, Oracle 8i, SQL Loader, PL-SQL, ASP, Crystal Enterprise Server 8.5, Crystal Reports, Crystal Query Designer, CSP, HTML, DHTML, CSS, Clarify 10.1, Clarify UI Editor, Clarify DD Editor, Clear Basic, VB 6.0, ActiveX, APIs, MS-Access, TOAD 7.2, Windows NT/2000.

Confidential,Boston

Responsibilities:

• Designed PL-SQL Procedures, Functions & Packages
• Designed User Interface using VB that consists of Forms with custom & ActiveX controls, created .class, .bas modules with functions & procedures with File System objects, collection objects etc.
• Created Queries & created Work Items on the Visual Workflow for Document Imaging.
• Created COM+ objects & packaged in MTS under Windows 2000 environment.
• Effectively used API functions in the program to determine database servers, workstation info.
• Created XML file using Microsoft.XMLDOM to maintain the status of file generation in XML format.
• Designed daily transaction reports, Ageing Analysis Reports, Customer Claims Reports using Crystal reports.
• Designed reconciliation reports and various other reports from DB2 database & Oracle 8i database using ODBC Connection using Crystal Enterprise.
• Designed SQL Queries using Crystal Query Designer.
• Attended daily status meetings with Project Leader & Managers for Project Enhancements.

Environment: Oracle 8i, Oracle Enterprise Manager, TOAD, VB 6.0, MS-Access, Crystal Enterprise 8.5, Crystal Report Designer, Crystal Query Designer, Visual Workflow, Workflow Queue Services, ADO, APIs, COM+, Windows 2000, XML, DB2, IBM Panagon FileNet Imaging Server

Confidential,NY

Responsibilities:

• Involved in study of each system and documented the functionality changes using their ERD model.
• Created SQL Loader control scripts and SQL Scripts to Extract, Transform and Load data to the ODS.
• Extensively worked on writing PL-SQL, Procedures, Functions & Packages.
• Involved in merging code from multiple bank source to single source.
• Created COM objects under MTS and used DCOM protocol to communicate over the network.
• Involved in maintaining & adding features to an Intranet site using the Visual Interdev environment, which was compatible for IE & Netscape.
• Wrote ASP code to retrieve data from Mainframe using RSPs & Oracle using ODBC.
• Designed custom reports from DB2 database and Oracle using Crystal Enterprise.
• Designed Standard reports & cross tab formats using effectively used Stored Procedures in reports.
• Interacted directly with users for technical assistance, functional changes and to trouble shoot reported bugs

Environment: Oracle 8i, SQL Loader, PL-SQL, Visual Basic 6.0, ASP, VBScript, JavaScript, HTML, DHTML, XML, XLS, CSS, OEM, MS-Access 2000, TOAD 7.0, Crystal Enterprise 7.0, Crystal Info Desktop, Crystal Report Designer, Crystal Query Designer, Erwin 3.0, COM on MTS, DCOM, VSS, COBOL, Windows NT 4.0

Confidential,NC

Responsibilities:

• Created an Intranet site under the Visual Interdev environment.
• Involved in designing logical & physical data model.
• Wrote ASP code to create business logic and to access Remote Database SQL-Server
• Created custom reports screens using Crystal Enterprise using Web Scripting language, Crystal Enterprise pages.
• Created functions, stored procedures, triggers and used in the application.
• Created COM objects using Visual Basic 6.0 under MTS and used DCOM protocol to communicate over the network.
• Lead a team of 5 members included interns with designing modules & reports.

Environment: Visual Basic 6.0, Crystal Enterprise, ASP, ADO 2.x, Visual Interdev, SQL Server 7.0, HTML, JavaScript, VBScript, COM/DCOM, MTS, IIS 5.0, Windows NT 4.0