SUMMARY

• Around 8+ years of IT experience in Software Application Design, Development, Testing, Documentation and Maintenance of Business Intelligence solutions, OLAP tools, Data Warehousing (DW), Database, Client/Server applications with expertise in CognosTM1/BI.
• 7+ years of strong experience in designing and implementing complex reporting solutions using Cognos Series (BI suite) 8.4,10.2, includes Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio
• Experience on Data Warehouse /Business Intelligence experience using ETL,OLAP/ Cognos 10.2/8.4 Series, Cognos Report Net, Impromptu, IWR, Power Play, Transformer, Actuate, Decision Stream/Data Manager 10/8.3, Cognos 8 Go - Office, Informatica, Access Manager, Cognos Connection, Upfront on both Windows & UNIX Platforms
• 2+ Years of Migration experience from different environments (like Impromptu, Actuate) to Report Net Environment and from cognos 7.x/Report Net to cognos 8BI/ and Cognos 8 to Cognos 10.x.
• Experience inTransformer model design and Power play cube building.
• Expertise in creating Dash board reports and using Java Script in Report studio
• Designed & Developed TM1 Processes, Dimensions, Cubes and Applications.
• Expert in the development of reports and packages using Framework Manager, Report Studio, Query Studio
• Strong complex reporting skills - complex Drill-Through, List reports, Cross-Tabs, Summary Reports, Burst Reports.
• Experience with Report Net/Cognos 8/10.x Software Development Kit (SDK) to customize reports.
• Experienced in Auditing, monitoring, troubleshooting and production support for Reporting Applications and infrastructure
• Knowledge on ETL development using Data stage for Data Extraction, Transformation and Loading (ETL).
• Strong Knowledge in Planning, Designing, developing and deploying Data warehouses/Data Marts by Following Star Schema and Snowflake Schema Methodology with experience of both relational & multidimensional database design using Data Modeling tool ERwin (Physical and Logical data models)
• Experienced in User Acceptance Testing (UAT), Unit testing and Integration testing.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction
• Highly proficient in Oracle PL/SQL including writing queries, stored procedures, functions and triggers.

TECHNICAL SKILLS

BI Tools: COGNOS Series Analytics 11/10.2.2/10.1/8.4/8.3/8.2/8.1 BI Suite, Go-Office, Report Net 1.0/1.1 MR2, Impromptu6.0/7.3, Upfront, Access Manager, Cognos Scheduler

OLAP Tools: Cognos TM 1 10.2.2/10.1/9.4 , Architect, Turbo Integrator, Perspective, TM1 Web

Operating Systems: Windows 95/98/NT/2000/XP7/8, UNIX (Sun Solaris), AIX

Languages: C, C++, SQL, PL/SQL

Databases: Oracle8i/9i/10g/11.x,MS SQL server 2000/05/10/12 , DB2 UDB, MSAccess, Teradata 13.x/14.x/V2R6

Development Tools: TOAD, SQL Query Analyzer

Web Technologies: HTML, XML, JavaScript, VB Script, Microsoft FrontPage

Microsoft Tools: Microsoft Office, Visio, MS Excel, MS Word, MS Power Point

BI Tools: Data Manager 10/8.3/8.2, Data Stage 11.3 /8/7.5, Informatica 8/9

Other BI Tools: Tableau 9.03, Microstrategy, Business Objects 5.1

Methodologies: Ralph Kimball’s Data Modeling, Star and Snowflake Schema Modeling

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. Cognos BI Architect

Responsibilities:

• Worked withBusiness Analystto understand the reporting needs and converting them into technical specification for Report Development.
• Prepare/Review Technical design documents created for the tasks, requests and projects by team members.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Built Models by using Three Layer Structure.
• Created Proof of Concepts in Cognos Analytics 11.
• Developed New Cognos reports in Report Studio as per the Business Requirement documents provided by the client.
• Implemented security at Cognos and creating user & user classes.
• Migration Cognos Packages from Dev to QA.
• Created DMR model with Dimensions and Hierarchies for providing drill downs & ups in Analysis Studio.
• Created list, crosstab and chart reports and implemented drill-though conditions and Master-Detail relationships.
• Used various kinds of prompts like Value Prompt, Date and Time prompt, Cascading Prompts, etc. for better performance, also worked with customized prompts using HTML Items.
• Designed Interactive Prompt page using JavaScript and HTML Items for the report template.
• Extensively used filters, calculations, conditional variables, multiple queries for data extraction in reports.
• Created conditional variables to change the graph headers and list column headers based on the user parameter selection.
• Created multiple Report Pages usingPage Breaks and grouping/sorting.
• Created Burst Reports, distributed and scheduled reports in Cognos Connection.
• Used Union, Intersection, Except, and Join between queries in query explorer.
• Developed several active reports of Dashboard with tab control in Report Studio.
• Followed agile methodology for the project. Worked as FM modeler for Pet Sales and Impact Projects.
• Created a package and published to Cognos connection for Pet Sales.
• Created SSIS packages for Pet Sales tables.
• Converted reports from Micro Strategy to Cognos.
• Used Motio CI as a version controller for Framework Manager Model. Also used for deployment of reports from Dev to Test.

Environment: Cognos Analytics 11.0, 10.2.2, 10.1 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace, Cognos Workspace Advance).

Confidential, Lewisvillie, TX

Sr. Cognos BI Architect/TM1/Administrator

Responsibilities:

• Involved in requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Involved in requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Analyzing the specifications provided by the clients and developing specification documents for reports as per client requirements.
• Installed and configured Cognos 10.2.2 with multi-tier architecture.
• Migrated reports and packages from Cognos 8.4 to Cognos 10.2.2
• Migrated 45 reports from Business Objects to Cognos 10.2.2.
• Fixed the issues and bugs in migration process.
• Migrated content from Dev to QA and Prod.
• Integration of the Cognos environments with Enterprise environments such as Proxy, Enterprise Portals, Web Single Sign-on (WSSO), and mobile devices.
• Admin roles involve giving access to users for various groups and roles, monitoring the servers, on support calls etc.
• Implemented Audit and Audit Extension for Cognos 10.2.2.
• Worked on the tickets open by users on various issues.
• Development and enhancement of Cognos portal through Cognos SDK and develop POCs as required
• Integration of the Cognos environments with Enterprise environments such as Proxy, Enterprise Portals, Web Single Sign-on (WSSO), and mobile devices.
• Installed Cognos SDK Kit on a computer where IBM Cognos BI is installed.
• Authored numerous reports in Cognos Studios, authored custom JavaScript code to customize prompts/reports and developed several custom Cognos SDK applications
• Admin roles involve giving access to users for various groups and roles, monitoring the servers, on support calls etc.
• Worked with stake holders and ETL to formulate the transformation rules for ETL development that best suites the reporting needs.
• Worked as a Team Lead for Biostim and Biologics projects.
• Installed and Configured Cognos TM1 and various components.
• Conducted training sessions to help users generate reports to meet their daily reporting needs.
• Creation of dimensions cubes and processors using TM1 architect for Finance team.
• Creation of rules using the rules editor and adding Business Rules to Cubes. Scheduling of TM1 process for data population.
• Created TM1 Workflow process and assigned the Task to TM1 Users. Created reports using TM1 web base application.
• Creating TM1 Application by adding TM1 objects and External files to an application
• Lead a team size of 5 members and organized daily status and weekly status call meetings with off shore team.
• Followed agile methodology for both the projects. Worked as FM modeler for Biostim and Biologics projects.
• Developed Daily Auth Report, Daily Cash report for Sales Admin team.
• Created a package and published to Cognos connection for Biostim.
• Created Active reports for Othofix direct to replace APPX manual functionality vs Automated system
• Created SSIS packages for Biostim tables. Converted some reports from SSRS to Cognos 10.

Environment: Cognos 10.2.2/8.4/8.3 (Frame Work Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Cognos Workspace, Advance), Cognos TM1 0.2.2, Architect, Turbo Integrator, TM1 Web, Power play Transformer 10.2/8.4, Infoirmatica 9.6, Oracle 11.x/10g, Teradata 13.x/14.x, SQL Server 2010, Business Objects, Oracle Apps R12

Confidential, Los Angeles, CA

Sr. Cognos BI Consultant/Admin

Responsibilities:

• Participated in meetings with client to understand and gather new technical requirement and conducted feasibility tests for the new requirements
• Created most of the Documents like Technical Document, LLD, TM1 and BI integration document, Work flow Document, Project Plan, Document on report format and Standards, etc.
• Managed and assigned work to onshore and offshore resources.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Delivered advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting (including the bursting of reports) using Cognos 10.1.
• Handled Critical situations in QA and Production Support in the final Stages of the project.
• Managed and designed the Cognos BI and TM1 integration for reporting and analysis.
• Designed and implemented TM1 architecture for the corporate planning system and applications.
• Worked extensively in development of Framework Manager Model for development of dashboard style complex reports like Dashboards, Region Enrollment, Division Enrollment, Milestones and Management Reports throughout the project.
• Created solutions pertaining to financial budgeting, planning and forecasting, sales and profitability solutions for companywide analysis using Cognos TM1 suite.
• Provided technical guidance and solution to junior developers in the team
• Managed data load, batch monitoring, cube refresh schedule and production support activities
• Planned and conducted user training sessions for super level user. Trained users on TM1 Perspective, Cognos Query Studio and Event studio.

Environment: Cognos BI 10.1 (Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, Business Insight and Event Studio), Cognos TM1 10.1.1 (Architect, Contributor, and Perspective), Informatica 8.6.1 and Oracle 10g.

Confidential, Atlanta, GA

Sr.Cognos BI Consultant

Responsibilities:

• Installed and configured Cognos suite including Report Net, Cognos 8 and Framework Manager 8.2 / 1.1 MR3
• Developed more than 50 reports against the published packages while maintaining/supporting existing reports
• Updated old reports to meet current reporting standards
• Built models, packages and published them using Framework Manager
• Migrated reports from Cognos Report net to Cognos Series 8 and Involved in a data migration process between different versions of Cognos.
• Worked extensively on the New features which came with Cognos 8
• Created complex reports using Report Studio including conditional blocks, conditional formatting, stored procedures, and materialized views
• Created the Dashboards reports using Report Studio
• Created a List and Cross-tab reports, Calculations, Conditions, Prompts based on the Business requirements..
• Created Complex calculations, Various Prompts, Conditional formatting and Conditional blocking etc., accordingly
• Created Drill Through between Parent (Summary) and Child (Detail) Reports
• Created Multi-Dimensional cubes using PowerPlay transformer
• Involved in creating 7 Projects including 16 Packages, which includes Calculations Filters and Parameter Maps
• Burst the reports and setup the distribution of sub list reports to various people with in the Client
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction
• Involved in performance tuning and Production Support

Environment: Cognos 8.1/8.2 BI, Report Net 1.1,8.0, Framework Manger1.1,8.0 Query Studio, Report Studio 1.1,8.0,Analysis Studio 8.0,Event Studio 8.0 Cognos Connection 1.1, 8.0, Cognos ReportNet, Power Play 7.3, Power Play Enterprise Server, Transformer, PL/SQL, Oracle 10g,, SQL Server, Toad, Data Manager 8.0, UNIX, windows XP.