PROFESSIONAL SUMMARY:

Data ware Housing BI:

• Good Understanding and Working Knowledge of Data Ware Housing concepts. Experience in coding and analysis of SQL and PL/SQL in Oracle, DB2, SQL Server and Teradata. Good Experience in design and development of tables, views, procedures and functions. Good Knowledge and Experience in OLAP and OLTP Systems.
• Over 8 Years of hands on Experience in Enterprise Business Intelligence lifecycle implementation, Cognos 8.4 BI tools Power play, Impromptu, Architect, Framework Manager, Metrics Manager, Report Studio, Query Studio, Analysis Studio, Event Studio and metrics Studio and Security Administration tools Access Manager, LDAP and Cognos Server administration . Experienced in architecting Series 6.x, 7.x 8.x Cognos Frame work manager models, Transformer models and developing Dashboards Reports using report studio, query studio and analysis studio. Experience in developing Enterprise-wide multi dimensional relational meta-data models using Frame Work Manager and Transformer.

BI Administration:

Well versed with Cognos Architecture, infrastructure and data flow. Well versed with Installations, configurations of Cognos Suit of tools, ensuring the server installs are optimal, deploying Cognos Metrics and reporting applications. Experience in Server Installations and configurations. Knowledge of basic java.

Methodologies Analysis:

Over 5 Years of hands on Experience in Data Analysis, Business Analysis, Requirement gathering and documentation with adherence to the Development life cycle methodologies. Well versed with the SDM and SDLC methodologies. Proficient in usage of SQL and PL/SQL for data analysis and development needs. Performed the same role with over 4 clients in a 5 year span.

Industries:

Experienced in developing reporting solutions in Enterprise Data Warehouse EDW , Human Resources, Healthcare, Financial, Commodity and Landscaping industries. Hands on experience in training end users on the usage of Query Studio, metric related queries, Reports, scheduler, scorecards and dashboards etc.

Excellent analytical and communication skills. A keen team player with reliable functionality in any development team.

Skills:

PROFESSIONAL EXPERIENCE:

Cognos Consultant/Validation Engineer

Confidential

Alcon Labs is a Precision device manufacturing company with emphasis on medical and surgical instrument manufacturing. The cognos reporting being a brand new installation, efforts had to be put in setting up the architecture for their dev and test environment, setting up security infrastructure and implement a process-oriented approach right from the scratch. Primary goal of the project was to utilize Cognos Reporting to re-write the Lot Reports and Quality indicator Reports from Microsoft reporting services. The reports were written using direct entry SQL and PL/SQL procedures. Efforts had to be put in to convert the same into Cognos. Developing a proof of concept for electronic Device History Record based of JD Edwards was also added to the scope in later stages of the project.

Deliverables:

Performed a Business Analyst role to begin with and eventually performed Development. Gathered and analyzed their current reporting requirements and implemented the security infrastructure on cognos through windows active directory. Performed Evaluations and reviews for database connectivity's and suggested best possible approach for reporting. Reviewed their current Windows based reporting and prepared a process-oriented approach towards converting the reports to cognos environment. Converted the Lot Data Report SQL's and PL/SQL procedures written for Microsoft Reporting Services, to work with Cognos 8.4 reporting services. Developed Ad-hoc Model for the Quality Engineers, for their day to day reporting. Created views and PLSQL procedures where needed for the Ad-hoc Model. Developed Work Order Device History Record report and Quality Indicator Reports Sourced out of JDE Environment and excel based Electronic Source systems. Worked on dashboards portraying the performance of the company as a whole in quality and performance using the quality indicator reports. Documented the development efforts and technical details involved in framework manager models and reporting. Received training on validation processes involved in validating the end product and also the protocols involved in the procedure. Documented and trained the employee's on best practices in modeling and reporting for future needs.

Environment: Cognos 8.4, Windows 2003 Server, SQL Server 2005, Microsoft Reporting Services, JD Edwards, Windows Active Directory.

Cognos Consultant

Confidential

The IT team SMART an acronym for Sunkist Management and Reporting Team, supported financial reporting needs for executives to compare Actual Vs Projected Vs Budgeted Revenue and volumes. Cognos SDK was used to run all 70 reports for various iterations and then finally merge the out put PDF's into 3 consolidated Board package PDF's using a Java merge script. The initial scope of the project was to modify existing 64 reports and create 6 new reports as per business needs. The Scope was extended to work on Power Play Cubes, which involved updating the existing Model to include new dimensions for Sales Claims Subject Area.

Deliverables:

Worked on creating models in transformer for inventory projection and sales claims cubes based of IQD's sourced from a cognos framework manager model to accommodate business analysts in their analyzing their sales projection verses budget and sales claims data. Developed Complex Comparison reports to compare Budget Vs Projection for current year and prior year revenue. Delivered the same across Divisional, Departmental and Accounts levels. Worked on Fiscal Year, Full Year and Year to Date FY and YTD Reports which involved custom formatting to meet financial needs. Worked extensively on conditional formatting to enable hiding and highlighting exceptional data according to the requirements. Major Reporting revolved around Income statements, Balance Sheets, Earnings, Costs, Expenses, Financial ratios and Market Assessments. Delivered over 70 reports in total, to be added to the deck, which were used by the executives for presentations. Worked on updating the SDK code to include the new reports in the deck and to accommodate any report specification changes. Worked on Reports based off of SQL Server Data Ware house and excel spread sheets. Delivered about 5 new Reports based off of excel spread sheets. Provided with the capability of handling report formatting through excel. Worked on various dashboards using portal pages.

Environment : Cognos 8.4, Frame Work Manager, Report Studio, Cognos transformer 7.3, Windows 2003 Server, SQL Server 2005.

Cognos Consultant Business Analyst

Confidential

United States Marine Corps Community services provided IT support for US Marines. The Scope of the Project was Primarily AIMS an Acronym for All Invoice Management Systems, which primarily involved converting IBIS AIMS Application Reports into Cognos with more functionality and improved performance when compared to IBIS. These reports were being utilized by the Central Accounts Payable CAP department to determine the amounts due for pay and as well as performance of their employees in processing the invoices. Initially provided solution by hitting real time IRDB Invoice reconciliation Database , later provided data mart design structure, which pulled data from the real time systems on a daily basis. Once the data mart was ready, make a switch to provide reporting and analysis on the data mart. This was decided in order to avoid hitting the real time systems, which was used mainly for transactional purposes.

Deliverables:

• Gathered the user requirements and worked closely with the DBA's to understand their current IRDB structure and the IBIS web Reports. Analyzed and documented the requirements. Designed and developed the AIMS Framework manger model to include row level security and future growth. Created views using database links to reutilize the security table from data mart in IRDB. Implemented Row Level security using the view. Manually maintained the security table. Maintenance involved updating the table with new users and deleting the users who have left the organization. Worked minimally on the ETL of required tables from OLTP to Oracle data Warehouse. Developed various Dashboards using Report Studio to display invoice matching and unmatched statistics at vendor, command, account, supervisor and technician levels. Developed various drill thru reports to support detailed information for the above mentioned Dashboards
• Re-Wrote the IBIS unmatched invoice statistics, invoices past due, vendor validation, duplicate invoices, all invoices, invoice aging, vendor stats and technician stats reports in cognos to help accommodate the users move away from the Application for reporting and analysis purpose.
• Worked extensively on performance analysis of available stored procedures for the retail and finance sector of CAP Central Accounts Payable department. Used Forced Indexes and Oracle Hints to improve performance on the Sub queries and stored procedures.

Environment : Cognos 8.4, Framework manger 8.4, Transformer 8.4, Oracle Warehouse Builder 10g OWB , OID Security, Toad, SQL Developer and Aqua Data Studio, Linux OS.

Consultant/Data Analyst

Confidential

Health Care Service Corporation HCSC is one of the market leading health care service providers, it owns the blue cross blue shield of IL, NM, OK and TX. Corporate head quarters are located in the mid-downtown Chicago, IL and Richardson, TX. Implemented over 7 different projects 3 tier one projects over a period of 3 years. Primary role being framework manager Architect modeler , also worked as a developer. Designed and developed Framework manager models and reports against Claims, Providers and Member data in OK Merger Project. Created and modified reports using PL/SQL procedures in eIVR and DNOA projects. Worked as a Lead for Seibel ODS, Form ware and ODS Load Metrics projects, to develop CSR Dashboard reports for FSU's across all the above mentioned states with Row Level Security implemented in the Frame work manager Model, Develop Complex CMS 1500 and UB 04 Reports for Form ware, and Develop reports for Internal ETL team providing them the ease of analyzing their day to day ETL Load Metrics. Extensively trained users through Microsoft live meetings, power point presentation and hands-on demo in group meetings. Gathered and documented the requirements and changes for most of the projects.

Deliverables:

• Extensively worked on PL/SQL to create and modify procedures for eIVR enterprise Interactive Voice Response and DNOA dental projects. The Detail and Summary PL/SQL procedures were used to capture IVR Calls from the database and segregate them into pertinent Line of businesses L.O.B . The detail PL/SQL procedures were used to display transaction level data, Typically 4 day limit on data to be displayed in report. The summary PL/SQL Procedures were used to aggregate the total transfers, attempts, completed inquiries and Total calls at a monthly level, segregated for each L.O.B. PL/SQL procedures for DNOA are dental related inquiries.
• Extensively worked on architecting Frame Work Models/packages and Reports for internal ODS teams, using the SQL's produced by the ODS team, to help them analyze their ODS Load metrics.
• Worked with the Siebel operations team to implement complex CSR Dashboard reports Service Request Search Report and Activity Search Report in Cognos Report Net and then in Cognos 8, to reduce the work load on their Seibel application. Created Aging and Productivity Reports at Service Request and Activity Levels for the Siebel customers to help them analyze their performance. Created complex prompting capability in SR, Activity and Productivity Reports to deliver Seibel Application level filtering capability in cognos reports. Developed sample scorecards for presentation to the Siebel customers.
• Architected and developed enterprise wide OK Merger frame work manager metadata model using the T-SQL given to us by the Business analysts. Developed Complex PCP and HMO Reports pertinent to the OK Merger Project. Worked in the Oklahoma merger project to Develop, test and performance tune the queries for better processing.
• Worked on Form ware Image and Audit projects to deliver Inventory and statistics of scanned Claims and Audit Reports. Built Complex multipage reports CMS1500 and UB04 to satisfy the need of displaying all 400 database columns in a row fashion in one single report.
• Worked in several other projects such as Unclaimed Properties, eIVR, DNOA and External RX Data to help the team members in resolving bugs and issues in model and reports. Worked on Unclaimed Properties project in fixing and testing the pre-developed reports. Worked with the HR department in fixing bugs in their vendor given, pre-developed, impromptu reports.
• Worked on production support. Worked extensively in resolving the issues filed by working directly with the customer, using remote work station control to analyze the exact problem and resolving it in minimal time. Conducted various training sessions to train the customers in using Cognos connection and query studio. Prepared/Presented various power point presentations to the customers to help set up the schedules, security and sharing of their folders. Conducted various live meetings to demonstrate the reports developed of their capability and limitations to help them utilize the reports in the most effective method. Worked on creating test cases for UAT. Worked on creating the SDM documentation for most of the above projects. Demonstrated the cognos usage from a user perspective for the projects thru live meetings.

Environment: Cognos 8, Cognos Report Net 1.1, Framework Manager, Report Studio, Metrics Studio, Query Studio, Impromptu 7.3, DB2, Teradata, SQL Server, Seibel 6, Windows.

Business Analyst

Confidential

Baxter is one of the top health care industries in the current market. Corporate head quarters are located in Deerfield, IL. Worked with the Human Resources H.R. team to implement some data modeling using native SQL and further use the same for reporting purpose. The challenges involved were to implement a new dimensional data model for reporting purpose as opposed to usage of flat tables. The data needed for reporting was sourced out of flat tables until that point. Due to limitations of flat tables the need for creating a relational database aroused. Once the data model was ready our team used Framework manager to design the appropriate packages for reporting needs. The reports created were strictly HR purpose, mostly cross tab reports with employee data. The type of reports was employee month/year to date salary payments reported against various manually created dimensions and levels. Designed and developed 14 reports.

Deliverables:

Worked with business users and DBA's to analyze the Reporting requirements and create the data model appropriate for reporting use. Sourced the above data model as data source in framework manager to further specify the cardinality, security and create appropriate business view for further usage in the reports. Created complex Charts, Crosstabs and List reports using Report Studio.

Environment: Cognos Report Net 1.1, Oracle, PeopleSoft and Windows.

Systems Analyst

Confidential

Service Master is a well-established, multi billion dollar landscaping company. Corporate head quarters are based in Memphis and the related IT department serving the company is located in North West Chicago suburbs. Our BI team provided support and development for various branch offices of the company, spread all over United Stated of America. Report Net, Power Play and impromptu were extensively used to support the existing reports and to design new reports as well as to create new versions of reports with bursting and repeating capability. Framework Modeling, Power Play Cube design, Report Development using Frame work Manager Packages, Power Play Cubes, development of various Burst and repeater reports and Performance enhancements were the key aspects of the project.

Confidential

Genentec is a leading Pharmaceutical company with multiple protein-based products on the market for serious or life-threatening medical conditions. Customer Call Center was used by the company's end users to enhance relationship with all callers by providing accurate information and sending timely fulfillment and adverse event monitoring. Report Net was used to provide reporting and analytical support for the CCC management team. The solution was used to generate pre-defined standard reports, such as Call Source Statistics and Service Issues Report, as well as allow CCC management team to generate ad-hoc reports and perform analysis on information obtained.

Deliverables:

Used Frame Work Manager to build the Models and Packages out of Audit Databases. Used Report Studio to build Audit reports that were used to analyze the performance of the employees Customer Service Representatives . Created Dashboards for Member ID and Corp ID Reports to show at a glance the performance across the FSU's. Built Reports that compared data between scanned OCR and the completed Data C . Built drill thru reports from the above dashboards to display detailed employee level statistics for a given DCN. Scheduled the reports for timely fulfillment of the analysis. Used Cognos connection to apply data and object level security. Administered and maintained the report server. Conducted user training to familiarize them with the new tool and help them create their own ad-hoc reports according to their requirements.

Environment: Cognos ReportNet, Framework Manager, Deployment Manager Cognos Configuration, Oracle9i, MS SQL Server 2000 Database, Windows NT.

Confidential

Hartford Hospital is one of the largest medical centers in New England. It is a major tertiary care and community health care center, serving a statewide patient population. Scope of the project was to provide a BI solution to the existing data warehouse. Building models from the existing data warehouse for summary level and detail level reporting of their patients and hospital staff data was the key aspect of the project.

Deliverables:

Created custom packages in architect. Used Power Play Transformer for modeling and creating power cubes. Created Claim and Provider reports from the packages that were being exported to Impromptu and Power Play for further creation of catalogs and Cubes. Implemented security using access manager. Set up web based infrastructure using IWR Server, PPES and upfront portal. Administered and maintained the server group. Provided training to the staff for running the reports according to their requirements. Designed an efficient change control and sustenance process.

Products and Tools: Cognos Impromptu, Cognos Transformer, Cognos Power Play, Cognos Access Manager, Architect, Impromptu Web Reports, PPES, Oracle 9i Database, Windows NT.

Cognos Developer Administrator

Confidential

Hill-Rom Company is a leading provider of healthcare facilities in U.S. with included care process and environment solutions that help caregivers deliver effective and efficient care to their patients in sensitive, long term and home care environments. Scope of the project was to develop Reporting infrastructure for the sales department of the company for analyzing their performance.

Deliverables:

Designed and built the reporting infrastructure. Developed Cognos Impromptu Reports and Power play cubes to eliminating more than 100 paper reports. Successfully implemented web based BI infrastructure using Cognos to support all reporting and analysis needs for the online organization. Authored development requirements documentation based on marketing priorities and project schedule constraints. Used Oracle database schemas for multiple products in order to create complex Cognos Models.

Environment: Cognos impromptu, Cognos power play, Impromptu Web Reports, PPES, Upfront, Oracle 9i, Windows 2000.

Cognos Developer

Confidential

Liberty Mutual Group is a Boston-based group of insurance companies whose largest line of business is personal auto. Scope of the project was to conduct user requirement analysis, design detail level Impromptu reports based on knowledge management components, data warehouse, data marts and operational data stores.

Deliverables:

Designed and built impromptu Catalogs.Mapped user profiles in impromptu with access manager security. Build complex reports according to the specifications of the user. Created basic visualizations using impromptu for the management team to analyze their data. Trained the end users to effectively use the reporting tool to build and customize their own reports.

Products and Tools: Impromptu 6, Cognos Access Manager, Oracle 8i Database, Windows NT.