PROFESSIONAL SUMMARY

Business Intelligence developer with extensive knowledge in IBM Cognos tools and Crystal Reports.

Well versed with Data Warehousing concepts and Data Modeling techniques.

Supported multiple Cognos upgrades in the capacity of Cognos Architect.

Experience in writing T-SQL and PL/SQL Programs, Stored Procedures and functions for report development.

Experience in Finance and Insurance industry vertical.

Excellent proven leadership qualities and a great team player.

Worked with multiple DBMS like Oracle, SQL Server and Ms-Access as back end.

Expertise in Application Development & Programming with extensive exposure to Quality Assurance Methodologies. Involved in all phases of the Software Development Life Cycle including Analysis, Design, Coding, Testing, Implementation, Maintenance and end user training.

Excellent written and verbal communication skills.

TECHNICAL EXPERIENCE

Business Intelligence Tools: Cognos 10.2.1, Cognos 8. x Suite: Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio, Metric Studio, Cognos workspace, workspace Advance, Crystal Reports 8.x /9.x / 10.x, Oracle Forms 4.5 / 6i

Databases: Teradata, SQL Server 2005 / 2008/ 2012, Oracle 8i / 9i/11g, MS -Access, SAP BW

Querying/Reporting: T-SQL, PL/SQL, TOAD, ORACLE

Applications: MS-Office, MS-Visio, Lotus Notes, Macromedia Studio

Programming Languages: C, C++, JavaScript, HTML, XML, Visual basic

Operating Systems: Windows 7, Windows NT/2000/XP/2003/2000/98/95, Windows Server 2000

Database Connections: JDBC, OLEDB and ODBC

PROFESSIONAL EXPERIENCE

Accenture, Chicago November 2013 to Present

Clients:

Abbott Labs, Verizon, Duke Energy, Chrysler, Baxter Laboratories

Responsibilities:

Modified and enhanced existing Sales Consolidation reports

Analyzed Framework Manager data model and made changed

Updated Functional design documents

Co-ordinated with offshore team

Implemented data level security on Framework Manager

Processed Business End-User Requirements and Verizon Design Guidelines in order to create multi-source data reports

Lead Cognos developer for creation of reports for BI Visualization suite

Developed 6 DEFEND Dashboards in Cognos Report Studio 10.2.1 and Workspace aimed at Executive-Level and Sales/Market Level End-Users

Data modeler for automation of data updates from Verizon's Data Warehouse using Framework Manager

Worked interactively with business to gather report requirements

Designed and documented SSRS Reports and Excel Ad Hoc Reports

Coordinated with offshore team in designing and documenting the SSRS Reports.

Identified database elements used for reporting

Created SQL Queries to build trending reports and views to build Excel Ad Hoc Reports.

Implement Data level Security that provides the ability to control the data that is shown to users when they build and run the reports

Peer reviewed Cognos reports developed by off shore team and gave feedback to improve performance

Created event base trigger on Cognos Connection to trigger the report execution after the database is refreshed

Created Constraint Analysis and Consumption Report daily summary version for European Market

Created tables in Oracle 11g database

Imported data from excel sheets to populate tables

Created a store procedure to replicate data in the tables for volume to test the reports performance

Involved in the metadata modeling in Cognos Framework Manager

Created Subject Area level reports in Cognos to track ETL Processes Run

Created drill through reports to give details on each job status

Environment: Cognos 10.1/10.2/10.2.1 (Framework Manager, Query Studio, Report Studio), Oracle 11g, Teradata, SQLServer 2012, Window 7 & Windows XP.

Dearborn National, Downers Grove IL July 2007 – May 2013

Business Intelligence Architect

Dearborn National underwrites and markets group life, disability, dental, worksite and voluntary products, and individual solutions. They have several internal as well as external reporting solutions

Responsibilities:

Led several projects that for creating new and supporting existing reporting solutions

Supported the Cognos 8.2 to Cognos 8.3 as well as Cognos 8.3 to Cognos 8.4 upgrades in the capacity of BI Architect

Upgraded both models and reports and resolved upgrade errors

Involved in gathering business requirements from the business

Built models using Framework Manager per user requirements

Created Active reports and Business Insights

Provided numerous demos to current and prospective users

Created and managed several Jobs and Schedules for business

Leveraged bursting capabilities in Report Studio

Created Simple and Complex Reports using Report Studio with Lists, Charts, Crosstabs and templates

Extensively used detailed and summary Filters

Created Drill- through reports and Master detail reports

Developed reports with cascaded and Value prompt per requirements

Used Query Studio for Ad-hoc Reporting

Extensively used Prompts, Conditional Variables and Bookmarks

Environment: Cognos 8.2/8.3/10.1 (Framework Manager, Query Studio, Report Studio), Crystal Reports 8 / 9 / 10 / 11, SQL Server 2000 / 2005 / 2008, Windows XP.

Federal Home Loan Bank (FHBL), Chicago, IL June 2006 – May 2007

Crystal Report Consultant

Responsibilities:

Migrated MS Access reports to Crystal Enterprise 10.0

Created 70 New Reports and 50 Store procedures and Views

Used all formatting tools of Crystal Enterprise

Created Reports for Credit Card Customers

Developed Financial Information Summary Reports

MPF (Mortgage Partnership Finance Program) Reports

MPF Monthly Volume Reports

MPF Monthly Credit Enhancement Reports

MPF Monthly Mortgage Insurance Reports

Environment: Crystal Enterprise 10.0, MS Access 2000, SQL Server 2000 Data Warehouse, Windows 2000.

State Bank of India, Chicago, IL July 2004 – June 2006

Crystal Report Consultant

State Bank of India, Chicago is one of the foreign branches of India's largest commercial bank.

Responsibilities:

Developed Remittances system that generated monthly, quarterly, half yearly and yearly reports

Primary responsibilities included creating Reports and publishing them on Enterprise for Federal Auditors and Upper management.

Created new reports incorporating multiple sub-reports within a main report

Developed parameters for dynamic sorting, grouping for ease of functionality to users

Published reports on Enterprise with pre defined filters, selection criteria for corresponding sections at run time

Fine-tuned SQL to achieve best performance

Performed regular tasks like creating stored procedures, views to improve query performance

Created reports to generate Monthly, Quarterly, Half yearly statements by beneficiary and remitter

Involved in Migration of entire system from 8.5 to 10.0

Monitored the data loads

Created user interfaces

Generated standard templates for Custom Reports and Standard Reports

Generated due date Reminders for Commercial Loan section using Microsoft Scheduled Tasks

Backup and recovery of database

Designed a solution to consolidate the data files

Environment: SQL, VBA, Windows XP, SQLServer2000, VB6.0. Crystal Enterprise 10/9.0.

Unique Data Services, Chicago, IL June 2002 – April 2004

Lead Programmer

Unique Data Services is a bulk mailing services company.

Responsibilities:

Developed and supported both applications and Reporting Solutions for the company

Developed coding standards for Crystal Reports

Generated various Templates with necessary format like logo, date and project description

Tested Reports using test plan to ensure data integrity, accuracy of formula calculations

Generated Reports using multiple criteria and trained end users

Developed a user interface to scan ISB details and save information in the database

Developed a program to cleanup data

Generated thousands of personalized letters

Merged data with multiple forms

Developed a client Server Inventory application

System testing and performed data validation

Technical support

Used Visual Source Safe for version control

Environment: PL/SQL, VB6.0, Crystal Enterprise 9.0, jet2000, WidowsXP, SQLServer7.0 and Oracle8i.

International Business List Inc., Chicago, IL October 2000 – May 2002

Lead Programmer

This is a largest Business and Residential address selling company. The application uses multiple variable criteria to perform complex Internet-based selection and retrieval of information from a database of 15,000,000 records using dynamic SQL.

Responsibilities:

Created complex reports with combination of multiple sub reports with parameters

Worked with Formula fields, Parameters, Sub totals/Grand totals, Grouping options, and Record Selection Formulas, Graphs and Section options

Exported and published reports to various formats

Built various Master/Detail, Cross tab, Drill down, Sub reports

Maintained and performed multiple variable criteria to retrieval of information

All reports are formatted with Crystal Report functionalities

Developed form like Bill to and Ship to Customer

Developed Maintenance Application in Oracle Forms

Developed PL/SQL Stored Procedures, triggers to implemented business rules

Documented Biznet and Resnet Count Systems. Involved in Design and Development of complete reporting application using Crystal Reports

Environment: PL/SQL, Oracle 8i and SQL *Loader Utilities, Oracle Forms 6i, Crystal Reports 8.5. VB 6.0.

Aon Corporation, Chicago, IL February 2000 – September 2000

Crystal Report Consultant

Responsibilities:

Involved in Design and Development of complete reporting application using Crystal Reports

Created financial reports based on data collected over quarterly periods

Defined scope of analysis on different Midwest states used in the reports

Formatted all Reports with Crystal reports functionalities like drill down, prompts, applying breaks and sorting

Used prompts for taking inputs from users and by the use of formulas, grouping and sorting functions are done dynamically

Environment: Oracle 8.0 & 9i, Crystal Reports 7.0, Crystal Info 7.0 and MS Access, Windows 2000.

EDUCATION

B.S. Degree in Business Management and Accountancy

Associate Degree in Computer Information Systems

Certificate in Cognos 8.3 BI Report Studio (IBM)

Certificate in Cognos Framework Manager Designing (IBM)

Trained in SQLServer 2008R2

Certificate in RDBMS and Application Development

Contact this candidate