SUMMARY:

Expert in delivering complete vertical BI Solutions, I am able to leverage my significant expertise as a BI Tools (Cognos /BO) Tools, Data Modeling, SQL expertise and Java. I have current hands on experience with entire Cognos Tool Suite in planning, installing, configuring, administering installations, creating metadata, reports and incorporating them in web portals using established best practices and report design patterns.With years of experience I am skilled in developing technical solutions for business needs. The value I provide is built on in - depth business analysis, good communication, effective leadership skills and technical expertise in all phases of BI solution development.

TECHNICAL PROFICIENCY:

Languages: Java, C, Perl, Shell scripts, Awk

Operating Systems: UNIX, Windows

DBMS: Oracle, SQL Server 2000, DB2-UDB, Sybase

BI Tools: Cognos, Business Objects, MicroStrategy, Crystal Reports

Web Tools: WebSphere SAD (WSAD), WebSphere Application Server

DBA/DA Tools: Erwin, DB-Artisan, SQL-Navigator

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, Illinois

BI/Data Architect

Responsibilities:

• Joined project as a hands on architect and lead developer to develop an alternative solution to an at-risk GDW (Global Datawarehouse) project.
• Work involved discussions with SAP experts to explore alternate data sources, ensuring all attributes and measures needed for reports were available and extracted. Designed pre-load data cleansing and data file manipulation programs and tested data files for quality, accuracy and validity.
• Developed dimensional data model in Erwin ensuring corporate naming and data type standards.
• Designed SSIS ETL procedures and performance tested/tweaked them to ensure daily SLA compliances and automated the daily load process with scheduler.
• Next phase was designing reporting metadata using Framework Manager and complex Campaign Billing Reports and Dashboards.
• Tuned Cognos installation for optimal performance of high volume Daily Job reports.
• Achieved substantial cost saving in IBM User License fee by creating custom report emailing programs.
• Other duties included administering Cognos installation, upgrading of Cognos from 10.2 to Cognos 11.1.4, providing Level 2 and 3 Cognos support to resolve complex outage issues.

Software: Cognos 10.2, SQL Server 2012, Cognos 11.1.4

Confidential, Bensenville, Illinois

BI Architect/DW Lead

Responsibilities:

• Created an innovative project plan to deal with slippage of upstream modules and data source uncertainty and yet deliver project on time.
• This was achieved by creating an independent Datamart to source these new reports.
• We initially loaded this with data from old AMDOCS CARES system so report development could continue without having to wait for upstream modules to go into production.
• This scheme also came in handy when decision was made to change source from replicated ODS to XML files.
• Work involved creating data model in ER Studio, report metadata in Framework Manager and developing Cognos reports.
• The reports were written to file system using Cognos Burst feature. Implemented the CPNI security compliance feature by writing Java programs to retrieve bursted Cognos reports, group them by customer, zip, encrypt and email to customer.
• Helped QA team achieve considerable cost and time saving by writing automated test programs in Java to help them verify accuracy of reports by comparing it to actual phone bill. This program parsed out Subscriber, Usage and Charges from bill PDF file and compared it with those on the report.
• Once this project was completed, helped in designing complex Framework Manager Model for EDW with multiple subject areas.
• Other responsibilities included creating Cognos Dynamic Cubes for some projects, second level Cognos administration and support, resolving complex outage issues, writing Java/Cognos SDK programs to simplify activities like database change impact analysis by extracting and searching report SQL, analysis of older models for migration, and retrieving report outputs from backed up zip files etc.

Software: Cognos 10.2, Oracle 11g

Confidential, Chicago, Illinois

Cognos Architect

Responsibilities:

• Worked as Cognos Architect/Lead Developer for developing an integrated CRM package for hospital and other medical providers based on prospect and patient data for their marketing outreach program.

Software: Cognos 10.1, Oracle 11g

Confidential, Chicago, Illinois

Technical Data Architect/Dev Lead

Responsibilities:

• Functioned as Development Team Lead and Architect to design and implement real-time Datamart (CDPS) for CME's Clearing Division. CDPS reads trades in real-time via Golden Gate, persists them and provides real time trade and volume information to the market and web site.
• It is also used for CME’s trades and volume reporting, providing trade position information for end of day settlement cycles.
• Successful implementation and timely delivery of this project achieved sun-setting of mainframe based end of cycle processing.
• For each exchange migration prepared project plan with work effort estimates and ensured that timelines meshed with enterprise wide conversion project plan.
• Constantly communicated with other teams to avoid/understand last minute requirement gaps and designed alternative solutions and reworked project plan to manage project deadlines.
• Technical responsibilities included design and development of dimensional data model in Erwin, developing and performance testing ETL procedures to ensure SLA compliances
• Designing BO Universes for client reports. Establishing development environments, QA procedures for testing and automating production deployments.
• Successfully migrated all exchanges to new Datamart
• Spearheaded a team of 4 Java/SQL developers, 2 QA testers, and one mainframe resource and successfully completed a failed outsourced vendor effort to convert 154 legacy mainframe reports.
• Devised an aggressive project plan with weekly reports deliverables to clients.
• This project was completed in just six months despite sparse legacy system documentation, and it allowed mainframe replacement program to finish in time and thus avoid expensive mainframe lease renewal cost.
• Technical responsibilities included tweaking Datamart to add new aggregate tables and load processes to help report performance and develop some of the complex reports.

Software: Oracle 10g, GoldenGate, BOXI R3, Custom Java Reporting Framework, MS-Project

Confidential, Deerfield, Illinois

Cognos Consultant

Responsibilities:

• Was brought in to replace an at-risk offshore effort to convert clinical payment systems (eCLIPS) from Sybase / PowerBuilder to using Oracle and Cognos.
• As the Cognos expert on the team I analyzed old legacy reports, underlying report stored procedures and new data model.
• Developed Framework Manager model, published packages and developed twenty plus reports.
• Developed various utility Cognos SDK java programs for tasks to simplify day to day activity.

Software: Cognos 8.4, Oracle 10g

Confidential, Chicago, Illinois

Cognos Architect/Team Lead

Responsibilities:

• Led Business Intelligence reporting team tasked with developing reports using new Confidential .
• Prepared cost optimal project plan by abstracting report requirements to common templates with subject area tweaks. This helped reduce overall development cost. It also made the report code reusable and resource agnostic which helped in production support down the road.
• Used my Cognos expertise in planning, installation and configuration of new Cognos Version 8 environment for the project. Also provided rotational administration support. Held discussions with data architect to ensure data model was BI Tools friendly.
• Designed FM models and established best practices for developing reports in Report Studio.
• Designed standard report templates for developers to follow.
• Created report design patterns for complex KPI reports.
• Developed and supported Cognos Transformer models and cubes to support timely sales operations.
• Used my database expertise in resolving slow running reports by analyzing explain plans, tweaking reports, FM models and in some cases using indexes and aggregated join indexes. Advised senior management with working POC’s about different approaches for delivering reports via either a custom developed Java SDK portal or using Cognos Portlets in WebSphere Portal Server.
• Administered Cognos installation, upgrades, maintenance releases and provided Level 1 and 2 administration support.
• Developed custom java authentication provider to implement security with for application groups using security stored in database instead of LDAP
• Helped company improve sales by reducing Website downtime, by developing Real-Time Reporting solutions using StreamBase, Cognos and SL to track web site user behavior as it happens. This tracked errors and helped in providing instant corrective actions to rectify problems on Web Site to improve sales.

Software: Cognos 8.3, Teradata, Oracle, SQL Server 2000, WSAD, StreamBase, SL, MS-Project

Confidential, Chicago, Illinois

Cognos Architect

Responsibilities:

• Was brought in to lead Enterprise Informatics and Reporting team migrate applications from Cognos Series 7 to Cognos ReportNET 1.1 and establish development, QA and production environments for new development.
• Duties included estimating required capacity based on number of users and reports, installing and configuring Cognos ReportNET 1.1 on multi-server platforms on WebSphere 5.0.2 and using SQL Server 2000 for content store. Administered Cognos installations, upgrades, maintenance releases and provided Level2 administration support.
• Developed custom java authentication provider to implement security with Novell e-Directory to allow for LDAP schema customizations did similar custom provider solution for smaller application groups using security stored in database instead of LDAP.
• Designed and developed web portal for some user groups to run canned reports using ReportNET Java/SDK. Java development work was done using IBM’s WSAD 5.0.Established and documented best practices for FM model and report development.
• Mentored junior developers by analyzing their slow reports by running SQL Server or DB2 explain plans on SQL to check if appropriate indexes and optimal paths were chosen and then suggesting improvements.

Software: Cognos ReportNET 1.1 & Series 7, DB2 UDB, SQL Server 2000

Confidential, Northfield, Illinois

Senior BI Developer

Responsibilities:

• Assigned to support Supply Chain Management and Transportation systems reporting needs I used my Business Objects expertise to optimize underperforming reports and fine tune their existing universes.
• Conducted discussion sessions with users and data modelers and fine-tuned data model for two new universes being developed.
• Used features such as aggregate awareness to take advantage of summarized tables and hierarchies for drill down reporting.
• Helped daily maintenance activities by creating a searchable database catalog containing BO universe information such as tables used joins, objects and contexts; this speeded up any inquiries about the universe and helped expedite issue resolutions.
• Led an effort to streamline BO installation by using BO Auditor in conjunction with Universe Domain Analysis and Broadcast Agent Analysis universes to remove redundant and unused objects.

Software: Business Objects, Oracle, Erwin, SQL-Navigator

Confidential, Chicago, Illinois

Data Architect

Responsibilities:

• Consumer lending division was upgrading its Confidential loan management software and the vendor had refused to migrate data from its older version to the newer version of its software.
• After few in-house efforts I was provided an opportunity to create a consolidated reporting ODS to be fed from both old and new loan applications.
• Provided client with software architecture document about existing system, new ODS layout and data load strategy.
• Using Erwin created the data model and provided size estimates.
• Using SQLServer Replication set up transactional replication for high volume transactional tables, snap shot replication for lookup tables.
• After successful implementation of ODS client also requested additional work on migrating reports from Crystal 7.5 to 8.5.
• Using parameterized SQL and using Crystal functions consolidated reports to a 3:1 ratio.

Software: SQLSERVER 2000, Crystal Reports