Manager Data

SUMMARY OF EXPERIENCE:

Around *+ 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 Administration.

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 Web Sphere.

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 in Transformer 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.

Expertise in Installing Fix Packs, Feature packs and Migrating to latest versions of WebSphere Application/Process servers.

5+ Years of strong experience in Teradata 13.x/14.x/V2R6

Strong Database & UNIX OS troubleshooting.

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

Well versed with WebSphere Clustering, Work Load Management (WLM) and Fail Over techniques including horizontal and vertical scaling, Web Server load balancing and backup/recovery processes, and BCP failover process.

Highly proficient in Oracle PL/SQL including writing queries, stored procedures, functions and triggers.

Extensive database experience using Oracle 11/10g/9i/8i, MS SQL Server, DB2, Teradata, MS Access, SQL, PL/SQL.

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,Big Data developer, Cognos Scheduler BI Administration.

OLAP Tools Cognos TM1 10.2.2/10.1/9.4, Architect, Turbo Integrator, Perspective, TM1 Big data,Web

Operating Systems Windows 95/98/NT/2000/XP7/8, UNIX (Sun Solaris), AIX, Web Sphere 8.5.5/7.0

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:

GameStop, Grapevine, TX Oct 2015’ – Till Date

Sr. Cognos Developer/BI Developer/TM1

GameStop Corporation is an American video game, consumer electronics, and wireless services retailer. The company is headquartered in Grapevine, Texas, United States, and operates 6,457 retail stores throughout the United States, Canada, Australia, New Zealand, and Europe. The company's retail stores primarily operate under the GameStop, EB Games, and Micro mania brands.

Responsibilities:

Installed and Configured Cognos 10.2.2 on distributed environment.

Implemented security using AD and assigned users to roles and groups.

Worked with IBM on installing and configuring Cognos Analytics 11 on cloud platform.

Developed Cognos Framework Manager Models and packages for metadata layer using Cognos best practices like Star Schema Groupings.

Conduct troubleshooting, root cause analysis, Data Validation, and problem resolution for Cognos Framework Manager models/packages

Added business rules to the Cognos Framework models by creating calculations, filters, prompts, session parameters and parameter maps, cardinalities.

Implemented object/row/package level security in Cognos Framework Manager models

Developed DMR model for Collectibles project.

Applied Dynamic Query Mode (DQM) for intelligent data caching mechanism for improving the performance of OLAP style queries in Cognos Framework Manager

Created complex dashboards Collectible Stats with area charts, pie charts, crosstab and multi prompts in Report Studio.

Created reports using Cognos Analytics 11.

Used HTML items and Java scripts in the Dashboards and reports to make them every interactive and show more content during layering functionality.

Created drill through reports for the pie charts created in the interactive dashboard as per the requirement.

Developed new Headquarters management reporting system (HQMR) for Sales, Balance Sheet, P&L and PPL with advanced allocation calculations, Actuals and forecasting using Cognos TM1 to replace Essbase system.

Developed Turbo Integrator (TI) processes (PROLOG, METADATA, and DATA& EPILOG) to build and update dimension hierarchies.

Manage user accounts and provide help-desk support for users in a mixed Windows and Unix environment.

Worked on Teradata database as a source for developing cubes using Turbo Integrator (ETL).

Developed TI wrapper process to handle hierarchy changes of dimensions, deleting consolidated elements and adding them back from data source.

Created Rejected Cube populated with TI’s to capture missing metadata either in master/transactional levels.

Developed Information Log Cube to count number of elements in each dimension with recent updated date.

Created TI to generate subsets for all dimension levels dynamically and assigning them to user views

Installed and Administered WebSphere Process Server.

Involved in Deployment of portlets and war files on WebSphere Portal.

Created TI’s to export data from TM1 cubes to text files. Dynamically created views by developing subsets using MDX functions in PROLOG and assigning them to required view.

Created Turbo Integrator processes to populate TM1 Cubes with latest forecast data from Data Repository.

Worked on skip checks and Feeders while updating Cube Rules.

Developed web sheets for user to automate monthly forecasting cycles.

Created rules on Element security cubes and assigned security based on user groups

Responsible for adding TM1 users, roles, and maintaining security.

Published Framework Manager Model using TM1 cube as Data source and publish packages in Cognos Connection for developing Analysis Reports.

Created multidimensional crosstab, multi prompt, conditional reports from published TM1 cubes in report studio.

Support DEV, QA and PROD environments including daily administration, batch processing, configuration management, environment migration, and tool automation

Delivered Cognos TM1 integrated with Cognos BI Solutions to a range of areas within the business.

Environment: Cognos Analytics 11, Cognos 10.1/10.2.2, Big data Cognos BI developer (Cognos Connection, Framework Manger, Report Studio, Analysis studio, Workspace, Workspace Advanced), Cognos TM1 10.1 (Architect, Web, Perspectives, cognos admin,Active Form, Turbo Integrator), SQL Server 2008/2010 (SSIS and SSMS), Teradata 12/15 BI Administration, UNIX (Sun Solaris), Web Sphere 8.5.5/7.0, Teradata 13.x/14.x/V2R6.

Orthofix, Lewisvillie, TX Feb’ 13 – Sept’ 15

Sr. Cognos developer/Admin

Orthofix International is a diversified, global medical device company focused on improving patients' lives by providing superior reconstructive and regenerative orthopedic and spine solutions to physicians worldwide. Headquartered in Lewisville, TX, the company has four strategic business units that include BioStim, Biologics, Extremity Fixation and Spine Fixation. Our products are distributed in more than 50 countries around the world via Orthofix sales representatives, stocking distributors and subsidiaries.

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.

Applying patches and plug-ins for WebSphere Application Server and Process server.

Involved in trouble shooting application server, web server and plug-in logs and analyzed them using Log Analyzer in case of any critical issue.

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.

Worked on Teradata database as a source for developing cubes using Turbo Integrator (ETL).

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

Loading and Maintain Data in Cube using Turbo Integrator. Optimize the Rule Performance by adding SKIPCHECK and FEEDERS. Integrated TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio.

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 Framework Manager Models with Physical layer, Logical Layer and Presentation Layer to cater the various business needs (Folders, Filters, and Macros), appropriate relationship between query subjects and fact tables.

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), Big data Developer Cognos BI developer, 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, UNIX (Sun Solaris), Web Sphere 7.0.

Morgan Stanley, NYC, NY Jan ’11 – Feb’ 13

Sr. Cognos developer/ BI Developer

Morgan Stanley is a global financial services firm headquartered in New York City serving a diversified group of corporations, governments, financial institutions, and individuals. The Company operates in three businesses Segments Institutional Securities, Global Wealth Management Group, and Asset Management

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.

Sun Trust Bank, Atlanta, GA Nov ‘10 – Dec ’11

Sr.Cognos BI Consultant

SunTrust Banks, Inc., is an American bank holding company. The largest subsidiary is SunTrust Bank. It had US$175 billion in assets as of December 31, 2013. SunTrust Bank's most direct corporate parent was established in 1891 in Atlanta, where its headquarters remain.

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, Teradata 13.x/14.x/V2R6, Data Manager 8.0, UNIX, windows XP.

MetLife, Chennai, India May ’08 – Oct’ 10

Cognos Consultant

MetLife has bought an Insurance product INGENIUM from Insurance Solutions Corporation (SOLCORP). LTC Replatforming deals with developing a ‘Total Long Term Care System’ for Metlife. This will replace the current LTC system in Clipper.

Responsibilities:

Involved in the System Analysis, Design and Development of the project.

Created List, Group report, Master and Detail, Cross Tab Drill-Through.

Created Cascade prompt.

Involved in creating Reports using Cognos Report studio/Query Studio.

Created the reports daily, weekly and monthly basis.

Provided client reporting (Batch), Scheduling & On-Demand scheduling.

Created weekly, monthly, quarterly and yearly reports.

Reporter Operations such as Sum and Average.

Exception highlighting, Sorting, Ranking.

Used SQL tools like TOAD, SQL Developer, SQL *PLUS to run SQL queries and troubleshoot.

Created Database and Tables structures for storing user information in SQL Server 2005.

Developed Stored Procedures and functions to accomplish several computations.

Involved in Testing and Debugging.

Involved in designing of Test Plans, Test Cases, and Executed Test Cases.

Created and managed Jobs and schedules.

Environment: Cognos 8 BI, Report Net 1.1MR2, Framework Manger1.1MR2, Query Studio, Report Studio,Analysis Studio, Event Studio, Cognos Connection, Cognos Power Play 7.3, Power Play Enterprise Server Transformer, Scheduler, PL/SQL, Oracle 9i, DB2,Windows 2000/XP, UNIX.

EDUCATION:

Bachelor of Technology in Computer Science from JNTU, India

Contact this candidate