Executive Summary

• 12 years of IT experience that involves architect, design, develop and implement Data Warehouse and Business Intelligence solutions.
• Experienced in diversified domains that involves supply chain, manufacturing, financial, healthcare, health insurance, surveys, teaching training.
• Excelled in various BI roles that include BI Architect, BI Analyst, Infrastructure Administrator, Application Developer, BI Support Analyst, BI Lead and SME.
• Expert areas include Framework Manger implement best and proven practices, reusable, recover lost and corrupted models, and performance tune , PowerPlay Transformer larger cube builds, secured models, and performance optimise , Migration between Cognos 7 Cognos 8 Cognos10 environments.
• 7 years of strong experience in Cognos series 7 suite involving Access Manager, Impromptu, PowerPlay cubes, Powerplay client, PowerPlay Transformer and Upfront.
• 6 years of rich experience in designing and building Framework and transformer models, creating ad-hoc reports, dashboard reports and active reports using Cognos ReportNet / IBM Cognos series 8x Query Studio, Report Studio, Framework Manager, PowerPlay Transformer, PowerPlay Analysis Studio .
• Working on IBM Cognos 10 since its inception. Expertise in business insight/workspace and interactive reports.
• 8 years of strong experience in Cognos Support and Administration, performing RCA for Cognos issues, Coordinating with vendor, administering the Cognos servers, monitoring and performance tuning, installing the software patches and fixes, handling security structure.
• 2 years of Cognos TM1 9.5 /10.1 building simple to mid-complex reports and infrastructure administration support.
• 2 years of SAP Business Objects XI 3.1/BI 4.0 experience in writing queries and designing reports across Web Intelligence Webi , Desktop Intelligence Deski , Business Objects Dashboards, Infoview.
• 5 years of onsite-offshore team lead experience leading 6 to 8 staff members. 50 hours of presenting and training on wide variety of BI tools including Business-Insight, Workspace and Ad-Hoc Query Studio.
• Working Knowledge of ETL tools involving DataStage, Informatica and Hands on experience of the campaigning application - Unica.
• Strong database skills involving DB2, SQL Server, SAP BW, Teradata, Salesforce.com, Oracle, MS SQL Server 2008/2005, SQL Developer, MS Access.
• Proven track record in self-train and implement new subject areas within minimal time period.

Project Experience

Role: BI Architect/Consultant

Confidential

Confidential . The migration involves architecting and designing the server's infrastructure plus moving all of the content. I lead all phases of life system development life cycle of migration which includes infrastructure and applications.

Achievements

• Design and refine multi server topology that suites best to the business, growing user community and their usage.
• Cognos content migration from lower to latest and greatest version using non-traditional hybrid strategies.
• Install and configure dispatchers in distributed environment using CQM leveraging both 32 bit 64 bit services and DQM leveraging 64 bit services .

Responsibilities

• Implement the advance routing rules and disseminate the complex and huge reports through a dispatcher and avoid impact on the whole environment.
• Devise different services across distributed servers and draft the IA diagrams for different environments.
• Installing 64 bit gateway running IIS 7.5 web server and configure report servers for both 32 bit and 64 bit processes.
• Installed and configured dynamic query analyzer to help and analyze the DQM queries.
• Install and configure Content Manager/Gateway with failover strategy in distributed environment.
• Install and configure transformer cube build processes and dynamic cube build processes.
• Help the development team by configuring dynamic cubes for the query service.
• Best practices involved in upgrade/migrate content store from Cognos 10.1 to Cognos 10.2.1
• Presented the POC and displayed the road map on how I would lead the migration plan.

Environment: Cognos 10.1/10.2.1, Oracle 10g/11g, SQL Server 2005 /2008, Sybase, IBM DB2

Confidential Worked with the supply chain department of Abbott labs. The project involved designing data warehouse and Bi solution that could render advance reports within the fastest timeline. The solution leverages new data warehouse involving data from Purchase Order and Sales and Distribution modules of SAP ERP. Drawing data from various databases, the managers and executives were enabled with in depth, simple inventory availability and future orders information and thus easing up their complex decision making process for business growth.

Achievements

• Provided the out of the box solution to write back to the database using stored procedure which helped in commenting and communicating between diverse business groups.
• Devised and implemented the quick reporting processes for advance report studio reports based on the database SQL and replicate ERP forms/reports.
• Worked for two different managers and balanced the work load for both the teams.

Responsibilities

• Involved in designing the data warehouse with the ERP and database teams thus forming the bridge between DBA and BI team.
• Responsible for requirement gatherings, technical specifications and providing proof of concepts to business users as pre-development process.
• Implemented a template based, parameter driven approach for minimizing the number of source reports.
• Provided my Cognos expertise on developing Optimized Framework Manager and improved the data handling tactics and strategies by employing reusability policies.
• Developed mid-level to complex report studio reports, dynamic dashboards using parameter maps and macros and also dashboards using Cognos workspace.
• Responsible for streamlining the deployment process between various environments and backup strategies.
• Responsible for migrating the reports and packages from Cognos 8.4 to 10.2 environments. Used Life cycle manager to test reports and identify issues between two environments.
• Provided unsolicited help to the Cognos application and administration team in all possible migration issues while migrating from Cognos 8.4 to Cognos 10.2.
• Implemented best practices for SLA to attain in time delivery and complete application support handling process supported by in-detail documentation.
• Expertise in training end users for business insight advance and help them explore data in more advance and analytical form.

Environment: Cognos 8.4 /10.2, Oracle 10g, SQL Server 6.0, MS Access 2007, Toad

Role: BI Architect/Consultant

Scope: Worked for Enterprise Infrastructure Management EIM group within caterpillar and enriched my career with diversified technologies and exceled in both application development and infrastructure administration. EIM is a division within Caterpillar responsible for managing applications/infrastructure for Business Intelligence Reporting Cognos 7/8/10, Business Objects 3.1/4.X, Teradata 13.10/14 and MDMD PIMS . I Exceled and proved my expertise by managing multiple versions of Cognos and multiple domains of software/tools enacting with variety of roles.

Achievements

• Provided Infrastructure solution integrating the third party tax return applications Vertex with existing environment.
• Introduced and implemented the composite layer Virtual View Manager for sourcing data from SAP BW and salesforce.com for Cognos 8.4 and cognos10.1
• Drafted and automated the Perl scripts on Linux to monitor and send tel-alerts for the services within Business Objects servers.
• Self-trained on Teradata to backfill on administration, security and support role. Helped the Teradata team towards migrating from version Teradata 13.10 to Teradata 14.

Responsibilities

• Provided BI solution by leveraging my infrastructure and development expertise and bridging the gap between administration and development team.
• Expertise for Cognos security model using Active Directory and also helped implement and migrate the Cognos security structure from LDAP to ADAMS.
• Hands on troubleshooting experience on Web Servers involving IIS and Apache.
• Proficient in recovering lost and corrupted framework manager models.
• Helped application groups by improving their report execution time using administrative strategies like creating advance routing rules, improving the processor speed and number of processors etc.
• Hands on experience in capacity planning and sizing the infrastructure implementing the best practices.
• Coordinated and worked extensively with vendor for the P1 and P2 issues creating service request and Coordinating with our Cognos architecture and infrastructure .
• Performed end-to-end BI projects including but not limited to coordinating with ETL team for data presentation layer, business requirement gathering to helping device tests for testing community.
• Provided support for non-Cognos BI platforms which involve Business Objects, Teradata and MDM PIMS.
• Hands on experience in coordinating with Teradata corporate by opening service requests and field requests. And also coordinating with NCR towards physical infrastructure onsite.
• Worked extensively on Framework Manger Models Relational and DMRs and also integrated the external data before publishing packages.
• Enabled manager's decision-making process by creating and analyzing data using Analysis Studio reports, Active reports, dynamic dashboard reports and Business Insight dashboards and also Business Insight Advance reports.
• Provided unsolicited non-technical help and Implemented social networking using IBM Connections thus collaborating EIM team, project managers and end-user community making easier for the groups to communicate and disseminate technical information and/or advisories and assign tasks among the team.
• As a Cognos specialist, exerted all of my Cognos expertise for concerns like performance tuning Reports/ Cubes and Servers , errors pertaining any report/ cube, security and administration issues etc..
• Working knowledge in development of Cognos TM1 models and cube builds using Turbo integrator process. Eventually used these cubes as data source to develop report studio and analysis studio reports.
• Create agents within Event Studio for sending emails to decision makers and also to run the reports.
• Focal point and primary approver for all of the semantic layer models assuring the company standards and BI best practices.
• Extensive hands on experience in creating query and drafting reports using Web Intelligence. Also have experience of creating reports with Desktop Intelligence. Working experience in designing and developing reports using Crystal reports XI version.

Environment: Cognos Suite for Series 7/ Series 8/ Series 10, Business Objects 3.1/4.0, DB2, SQL Server, Teradata 13.10/14, Salesforce.com, SAP BW, Oracle 11, PLSQL developer, MS Access 2000, Perl on Linux and windows platforms.

Role: Senior Cognos Specialist

Confidential

The project involved implementing Cognos 8.4 integrating with Unica Affinium Campaign. Project scopes involved implementing Cognos environment from scratch and integrate with Unica environment and run the audit reports for Unica environment.

Responsibilities

• Implemented Cognos 8.4 and deployed Unica Campaign package and reports.
• Worked with Business owners and Unica technical team to scope and prioritize Unica campaigns.
• Coordinated with system analyst and project manager to setup pre-validation and validation environments to execute campaigns.
• Working experience in implementing new campaigns and enhancing/customizing the existing campaigns.
• Enhanced the IBM designed Framework Manager Model to suite the business requirement. Also designed and developed new Framework Model to address other business requirements.
• Deployed off the shelf, pre-packaged Unica Campaign's package and reports for Cognos and enhanced them as per the business requirement.
• Implemented advanced report bursting to various user groups across the nation.
• Mastered the Unica Campaign administration and was involved in implementing Unica Affinium 8.2
• Hands on experience in migrating the campaigns from Unica 7.5 to Unica 8.2

Environment: Cognos 8.4, Unica Affinium 7.5/8.2, Oracle 10g, PLSQL developer, MS Access 2000, Toad, MS Visio.

Role: Senior Cognos Specialist

Confidential is a global health service company, dedicated to helping people improve their health, well-being and security. The scope of the project deals with various Cognos applications within Confidential which involves development and provide support thereafter.

Responsibilities

• Gather business specification and requirements in co-ordinance with business analysts and convert them to technical documents.
• Designed and developed Framework Manager and Powerplay Transformer Models.
• Built mid-complex to complex cubes out of Transformer models involving security.
• Expert in dealing with performance issues over Cognos Servers, Transformer models and SQL queries.
• Enhancements on the business view of Framework Manager Models. And help customer to build ad hoc reports out of these business views.
• Support about forty different applications and design new process facilitating the business processes.
• Work in coordination with ETL, Websphere and Web server teams, for root cause analysis and also guide them for Cognos services.
• Administer the servers and provide core functionalities like deployment, scheduling and maintaining securities and capabilities.
• Worked on Projects independently and also with the team.

Environment: Cognos 8.2 /8.4, Powerplay Transformer Series 7, Cognos 8 Transformer, Data Stage Ascential, IBM DB2, Oracle 10g, MS Access 2000, Windows Server 2003

Role: System Analyst

Confidential is a global professional services firm that helps organization improve performance through effective people, risk and financial management. This project in particular deals with the international survey research arena where the legacy system consisted of the traditional methods of designing questionnaire and creating reports based on the data achieved. A web based application has been designed for the whole system that facilitate client and client's customers interact and work in a much efficient fashion.

Responsibilities

• Analyzed and recommended the enhancements for the legacy system of designing the questionnaire and disseminating the information using MS Access reports.
• Worked with Business Analysts and assisted in gathering requirements and rationalizing reports, liaising with the customers. Created high level and detail design of Cognos reports.
• Worked with System Architect and helped in designing the web application suitable for the client's business flow.
• Designed Cognos application integrating with the web application, which is suitable for more than one user community.
• Worked as Framework Manager Modeler and designed universal model that would ease both developers and business user's report development easier.
• Created high level and detail design of Cognos reports. Designed the report templates facilitating the team members in developing various reports.
• Worked extensively towards the drill through and conditional formatting reports in report studio 8.4.
• Trained business users in ad hoc query studio and Powerplay cubes enabling them to create ad hoc reports and cube analysis.
• Provided suggestions and extensive help to the ETL team in data streaming and massaging of the data.

Environment: Cognos 8.4, Informatica Power Centre 8.6, Oracle 10g, PLSQL developer, MS Access 2000, ERWin, Toad, MS Visio.

Role: Computer System Analyst

Confidential is an international, high-performance company, making it affordable, reliable and convenient to send and receive money or make payments. This project is an answer to the new European Union EU set of laws whose purpose was to have a modern and fully synchronized framework for an efficient payment process throughout the EU. Banks and money transfer companies like Money Gram had until November 2009 to comply with new requirements under the EU's Payment Services Directive PSD , which establishes a comprehensive regulatory system for the payments industry in Europe. The PSD was not a business as usual matter. It represented a sea change in the way Money Gram will do business and be regulated in Europe.

Responsibilities

• Designed the BI solution for the European unit of Money Gram and provide complete design of the solution data and reporting that satisfies reporting needs across all three clusters Finance, Compliance and Customers that best balances SLAs, data availability, future state of the data warehouse and reusability.
• Designed and built the Framework Manager Models and Cognos 8.2 Ad Hoc Report Studio reports.
• Manage projects and packages within Framework manager and apply advance modelling techniques like resolving recursive relationships, creating star schemas groupings and resolving dimensional level ambiguity.
• Created simple List, Group, repeated and cross tab reports to complex reports including conditional formatting, drill through reports Cascading to third granular level , bursting.
• Lead acceptance testing of system development or process improvements to ensure implementation meets with documented specifications.
• Provide directives for the performance tuning for slow running, calculation intensive complex reports.
• Provide technical oversight and subject matter expertise to developers and database administrators in support of the construction of Facts, Dimension and confidence in data, and other user facing business intelligence applications.
• Provide Suggestions and directions to ETL team for data streaming, data quality issues, ETL scripts and Event trigger for Cognos schedules reports.
• Documented Cognos test plans, test cases, test scripts, test procedures, assumptions and validations, expected results, installation and troubleshooting process in production.

Environment: Cognos 8.2, Informatica Power Centre 8.6, Oracle 10g/9i, PLSQL developer, MS SQL Server 2008/2005, MS Access 2000, ERWin, Toad, MS Visio.

Roles: Systems Analyst / Team Lead /Sr BI Consultant

Confidential is the worlds leading manufacturer of construction and mining equipments, diesel and natural gas engines, natural gas turbines and various other earth moving equipments. Caterpillar delivers products, services and technologies in three principal lines of business: Machinery, Engines and Financial Products

Scope: I provided extensive and proficient support to all of the Caterpillar Cognos Environments. I was involved in performance tuning, architecting and all of the possible events and infrastructure projects within GIS team.

Environment: Cognos 7.4 Access Manager, PowerPlay Transformer, PowerPlay Client, Upfront, Impromptu, PPES Cognos ReportNet, Cognos 8.2/8.3/8.4 Data Stage Ascential, IBM DB2, MS Access, SQL Server, Oracle, Unix,

Role: Senior Cognos Developer

Scope: Confidential has reported a significant SOX deficiency in system access. System access controls need to be improved, including: Automated notification when an employee leaves the company, automated check for users with incompatible access according to the segregation of duties. Notification for Access Removal System NARS is developed to support SOX compliance. NARS processes notifications and creates work orders for Terminations Segregation of duties conflict s

Environment: Cognos ReportNet 1.1, Cognos 8.3, Informix, Data Stage Ascential, MS SQL Server 2005, Oracle 9i, IBM DB2, Windows XP

Role: Senior Cognos Developer

Scope: This project was generation 1 of multi generation project plan MGPP that focuses on cat insurance's Executive Team, Accounting Department, Program Managers and Auditor's post-closing financial data and reporting analytics. The project utilized JD Edwards's post-closing financial data as the major data source supplemented with other supporting data sources. The aim was to improve the quality and availability of reporting data for business users while driving cultural change to improve operational efficiency and decision-making. By achieving these goals allowed Caterpillar Insurance to promote profitable growth more effectively while reducing risk exposure and improving employee satisfaction.

Environment: Cognos ReportNet 1.1, Cognos 8.3, Data Stage Ascential, SQL Server 2005, MS Access 2000, IBM DB2, Java script, Windows XP

Role: Senior Cognos Designer / Team Lead

Scope: The CPPD process is initiated when a NPI New Product Introduction or non-NPI idea is captured. Caterpillar expressed the necessity of analysis of data involved in CPPD process. And so did the CPPD application came into existence leveraging Cognos capabilities.

Environment: Cognos ReportNet 1.1, Cognos 8.3, SAS 9.1, Data Stage Ascential, Oracle 10G, Windows XP

Role: Senior Cognos Developer / Team Lead

Scope: Caterpillar North American Dealers were experiencing problems with the current implementation in regards to performance and accuracy of the data reflected in Cognos Reports and Cube due to hierarchy issues. The cube and reports already existed on Cognos 7 environment but low performance and a weak architect. The main objective of this project is to provide Dealers significantly improved Cognos Reports and Cube with regards to Performance, Security and hierarchy.

Environment: Cognos ReportNet 1.1, Cognos 8.3, Cognos 8.3 SDK, SAS 9.1, Data Stage Ascential, Oracle 10g, Windows XP

Role: Senior BI Developer / Team Lead

Scope: Caterpillar's Cost tracking was mainly divided into annual ongoing and OTO One time only projects. Design the complex reports to track Caterpillar's material costs DMCR globally and analyze the purchase orders. The primary purpose of this project was to leverage Cognos functionalities and calibre and provide reports which can forecast for direct material costs and global material costs tracking.

Environment: Cognos 7.4 Access Manager, PowerPlay Transformer, PowerPlay Client, Upfront, Impromptu, PPES, Report Administrator , Cognos 8.4, Data Stage Ascential, IBM DB2, Windows XP

Role: Cognos Lead / Team Lead

Scope: This project was to facilitate both Caterpillar employers and external dealers where they can get to the shopping cart report and the daily reports to get the updated information. Dealers were supposed to have the ability to view shopping carts that have been ordered, emailed, emptied and expired. The cube was also built for the sake of analysis of ordered parts data. The data involved all parts of world APD, EAME, LACD and NACD.

Environment: Cognos 7.4 Access Manager, PowerPlay Transformer, PowerPlay Client, Upfront, Impromptu, PPES, Report Administrator , SAS 9.1, Data Stage Ascential, IBM DB2, Windows XP

Role: Solution Architect / Team Lead

Scope: Caterpillar customers required auditing for series 7 for 40 different applications. The necessity and demand to know the usage of the cubes and reports over the upfront gave birth to the Usage reporting cubes solution. This cube would provide the extensive analysis as of who accessed what cube or report on what time. Caterpillar customers would make use of this data in various ways and sometimes come back with a clean house request.

Environment: Cognos 7.4 Access Manager, PowerPlay Transformer, PowerPlay Client, Upfront, Impromptu, PPES, Report Administrator , Visual basic 6, MS Access, SAS 9.1, Data Stage Ascential, IBM DB2, Windows XP

Role: Cognos Developer / Cognos Support Lead

Scope: Caterpillar would run numerous projects that would involve huge teams such as Financial Reps, Black Belts, Master Black belts, Project Sponsor, Business Manager. And these projects would run for various Groups-divisions-Business Units- Sub Business units. The data would multiply on daily basis and crystal reports were not a good answer for reporting this big data and moreover the analysis question was a growing concern. The purpose of the project was to provide a business solution leveraging BI technology to enable a dramatic improvement in the ability and performance of the reporting structure. The project involved 3 different transformer models and cubes responsible for Financial Reporting System, Portfolio Cubes and Project Execution Cubes.

Environment: Cognos 7.4 Access Manager, PowerPlay Transformer, PowerPlay Client, Upfront, Impromptu, PPES, Report Administrator , Data Stage Ascential, IBM DB2