Manager Data

PROFESSIONAL SUMMARY

Over ** years experience in Information Technology. Over 10 years of professional expertise in implementing Data Warehouses, Expertise in BI (Business Intelligence) using COGNOS Enterprise BI Suite, Cognos Enterprise Planning / TM1 Tools, Informatica Tools.

Expertise in Architecting Solutions for Implementing Enterprise wide Data warehouses using COGNOS 10.2.x Tools

Developed, implemented Cognos Enterprise Planning Models using Enterprise Planning suite.

Hands on experience on Visualization tools TABLEAU and location intelligence tools ESRI.

Hands on experience of Cognos TM1 10.2.x.

Expertise in Architecting Solutions for ETL Processes using COGNOS Decision Stream and Microsoft DTS, Informatica Power Mart Tools .

Expertise in Administering and supporting COGNOS Environment

Project Management activities: Managed a Team (maintaining the project schedule, preparing reports, time sheets, and preparing testing Reports).

Well versed with Datawarehouse Concepts of Star Schema and Snow Flake Schema.

Well versed with SDLC (software development life cycle)

Well Versed with Database Administration.

Strong experience in client interaction and understanding business application, business data flow and data relations from them.

Expertise in Designing, Developing and Deployment Data models using COGNOS FRAMEWORK MANAGER in COGNOS Environment, Physical and Logical Implementation using ERWIN.

Excellent communication and interpersonal skills.

Knowledge on other BI Tools like MicroStrategy, proclarity, BRIO tools.

Skilled in Testing applications and the design of the applications.

Domain knowledge in Banking, Insurance, Education Industries.

TECHNICAL SUMMARY

Business Intelligence

COGNOS 10.2.x Suite, LDAP, Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Score carding, Workspace, Active reports.

BI Visualization Tools

Tableau

Planning Tools

COGNOS Planning : Analyst, Contributor and Planning Manager, TM1 10.2.x

ETL Tools

SSIS, COGNOS Decision Stream, Microsoft SQL Server DTS 2000/7.0, Informatica

Data Modeling

ERWIN

Databases and

Tools

MS SQL Server 7.0/2000/2005, Oracle 8i/9i, MS Access, SQL*Plus, SQL*Loader,

Teradata

Reporting Tools

Crystal Reports, COGNOS REPORTNET, BRIO QUERY, SSRS, Business Objects

Project Planning Tools

Microsoft Project.

Web Technologies

IIS, ASP, MS Site Server Commerce Edition 3.0, HTML, DHTML, Active X, COM, VBScript, JavaScript, Visual Interdev, MTS

Front End

Visual Basic 5.0/6.0, ASP

Operating Systems

Windows, UNIX

CERTIFICATIONS/TRAINING:

COGNOS Certification

Microsoft Certification

Brain Bench Certification

PMP Training from Affiliated Institute of PMI.

ACEDEMIC QUALIFICATIONS:

Master of Science, Osmania University, Hyderabad, India

Post Graduate Diploma in Computer Applications.

PROFESSIONAL EXPERIENCE

Safelite Auto Snr Consultant March 16 – Till Date

BI Analytic Solutions Project: Defining and designing of Various Data Analytical metrics and providing a platform of Metrics to the Business users through transactional reporting, Data Visualization, dash boarding.

Responsibilities:

Designing BI solutions for various departments in the enterprise based on Data discovery and data availability.

Collaborating with different teams (Data management, Quality assurance, Systems) for Optimization.

Gathering Requirements from different categories of Users.

Accountable for delivery of the Deliverables.

Ensuring of implementation of Best practices across all the stages of the Solution.

Developed Dashboards using various Dash boarding tools.

Have done training on Cognos V11(Analytics).

Developed reports, cubes and done performance tuning.

Knowledge of Hadoop, Big Data Environment.

DeVry Inc Snr Consultant August 14 – Jan 16

Marketing Analytics Project: Reporting on various Marketing Leading Indicators for Higher Management for visibility into the marketing business cycle starting from Student Admission to Student Graduation.

Daily, weekly, monthly reporting of leading marketing indicators and complex transactional reporting for various sources (web, media, Marketing Channels etc).

Have developed Cognos Cubes, Data Models using Framework Manager and reported using Cognos report and query studio.

Have been the front face for the senior management meetings for better understanding of the requirements and collaborated with various departments across Marketing, student admissions, evaluations, finance and IT Departments.

Have converted budgeting and planning models into Cognos TM1 for Planning purposes.

working experience in TM1 including all aspects of design and implementation including: Perspectives, Active Forms, Architect, TM1 Contributor, Web, Café, Turbo Integrator, Feeders, cube design, reporting & security

Have Developed Dashboards for Top level management utilizing TM1 Cubes.

Have Designed and Deployed Dashboards using TABLEAU Tools.

Discover Financial Services Team Lead/Snr Associate August 12 – Aug 14

Projects Worked for various Internal Departments : CRMS (Counter party Risk Management System), Solicitations, Amortization reporting, Teradata Usage Statistics, PULSE Payment Services, Discover Home Loans, Discover Student Loan Programs.

Front face for the Business in analyzing the Requirements Design part and helped in converting the Business Requirements into Technical Specs.

Provided detailed analysis of tools which can best suit the Requirements.

Have implemented transactional Reports from Cognos 10.2.x suite.

Have Demonstrated the usage of reports through Mobile app.

Have worked on Dynamic Cubes Implementation.

Provided Training to Business Users for all the projects above. .

Leading a team of 4 from offshore.

Built Executive Dashboards for Data Visualization using TABLEAU desktop and TABLEAU server for higher Management.

Developed TM1 Cubes for users for contributing their quarterly, annual numbers for budgeting and forcasting periods.

Have used Cognos Insight to represent data from TM1 Cubes.

Building Processes that feed cubes and running multiple processes in parallel in TM1.

Scripting business rules in TM1

Data Modeling in TM1.

. Environment

Cognos 10.2, Oracle, Teradata, Tableau,

DeVry Inc, IL Senior Cognos Consultant Oct 2009 – Jul 2012

DELTA Project is a key business platform for the DeVry’s Business Model. It has various components out of which Business Reporting is a major valuable component. The Project comprises of extraction of Data from various legacy systems such as Banner, SalesForce.com, loading into various data marts and building reports out of the Data warehouse.

Responsibilities

Provided best practices for Modeling

Developed a Data Model out of SalesForce.com Transactional System.

Developed Reports using report Studio, Query Studio (adhoc).

Provided Support for the Reports and Model.

Involved in Cognos TM1 Cubes development.

Developed Dashboards and designed Bursting feature for Distributing the Data.

Leading a team of 4 people.

Written Complex PL/SQL and SQL Queries.

Mentored users for the Cubes and the DashBoards.

Implemented Best practices in design.

Prepare and review technical and logical design and artifacts

Recommended various aspects of improving the solution delivery.

Environment

Cognos 8.4 / TM1 9.x, Oracle, SalesForce.com, Sungard Banner

Medco (healthcare), NJ Cognos Data Architect April 2009 – Sep 2009

Medco is an healthcare Pharmacy Company which has over 1500 plus retail outlets for supply of prescribed or General Drugs to the drug stores. The project CHP(Consumer Health Plan) is designed to see how the patient is performing on the medication and provide him a detailed checkup plan.

Responsibilities

Involved in Data modeling, Provided best practices for Modeling

Did Data profiling, Data Mining, Developed and maintained Cubes.

Developed Cognos Meta Data model for reporting.

Relational and multi-dimensional data modeling, including the use of standard data modeling tools

Lead all aspects of the delivery of Business Intelligence (BI) solutions and related components.

Analyze business challenges and translate into requirements/solutions. Understand and articulate complex BI implementation.

Work with BI Competency Center to define BI strategic roadmap.

Convert requests into requirements. Design logical models to meet business requirements.

Developed Healthcare Dashboards for senior Management.

Environment

Cognos 8.4, Teradata, Oracle, IBM AIX

DeVry Inc, IL Cognos Consultant Feb 2008 – Mar 2009.

Project involves architecting of BI Metadata model based on the Dimensional Modeling Concepts (DMR) with implementation of Data Security for various Departments for Financial Analysis and Reporting. Good Understanding and working knowledge of Cognos Enterprise Planning using Analyst and Contributor Tools. Integration of BI and Planning Environments.

Responsibilities

Implemented DMR techniques for aggregations, Drill down, Drill Up and drill through capabilities.

Created segments and re-linked the segments.

Implemented Security in the Framework Model.

Implemented Business Modeling using Star Schema Grouping approach to work with Conformed Dimensions.

Used Best Practices to achieve Model performance.

Writing Technical Specifications for Reporting.

Created a Framework Model from Planning Applications.

Used Prompts to provide user Interface for the reports to filter out based on a selection of user inputs.

Externalized IQD's for development of Cubes.

Developing of BI Framework Model with Dimensional Concepts

Implementation of Data Security for the BI Model

Development of Financial Reports

Planning Analyst Models design

Managing of Contributor Tool

Worked with SSIS Packages (developing, deploying, scheduling and automating).

Installed, Configured Planning Components.

Design and Developed Budget and Forecasting Models using Planning Tools.

Created D-Lists, D-Cubes and D-Links for applications like Income Statement and forecast Budgeting applications

Followed with Best Practices from Cognos Corporation with Administration and Configuration of Analyst and Contributor Applications

Used Allocation Tables in a D-Link to import data from another application and to copy data between D-Cubes

Used file maps in D-Links to import data from text/csv files and other sources.

Using Planning Manager designed Flow Chart reports with macros to update the Cubes

Created contributor web application by using Contributor Administration after developing the model in Analyst tool

Involved in Configuring Contributor Administration Console and Managing Job Servers

Created Publish Containers

Developed architecture for Integrating Planning Models with Cognos BI Components for Reporting

Environment

Cognos 8.3 & 8.4, Framework Manager 8.3 & 8.4, ReportStudio, Query Studio, Cognos Planning(Analyst, Contributor).

Travelport, IL Senior Developer/Report Architect Nov 2006 – Jan 2008

Project involves of developing Travel Data warehouse for a Large Online Travel Company. The Data warehouse provides financial, Key performance Indicators for the Online Business in terms of Bookings, Revenue and Cancellations. Deliverables includes ETL work to Cleanse, Process and Load the data into the Data warehouse, Produce Dashboard Reports for the Middle Level management for Business Decisions, Maintain and support the ongoing informatica jobs and Cognos reports.

Responsibilities

Designing the Data Model using Cognos Framework manager on Version 8

Developing ETL routines using Informatica and deploying the routines.

Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment

Worked with Informatica PowerMart client tools like Source Analyzer, Warehouse Designer, and Mapping Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse

Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

Involved in developing source to target mappings and scheduling Informatica sessions

Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.

Developing Cognos Reports on Version 8

Developing Cognos Cubes using Transformer and testing them using Analysis Studio on ver 8

Educating the business users on how to do adhoc queries using Query Studio ver 8

As a senior developer, suggesting best practices to the team.

Designed and developed Cubes.

Environment : Cognos 8.2, Informatica, Teradata.

Discover Financial Services, IL Senior Associate/Business Analyst Apr 2006 – Oct 2006.

The Project is designed to provide reports done using ReportNET based on Merchants. Discover Financial Services keeps track of Fraud Transactions and Acquired Merchant Level Information. The Reports were developed using COGNOS ReportNET. Data model was designed using COGNOS Framework Manager.

Responsibilities:

Designing and Architecting the Data Model using Cognos Enterprise Suite .

Interacting with the Business Users, Data Modelers and Database Team

Managing the Offshore Resources.

Reviewing the Work done by the offshore and fixing the Bugs.

Responsible in delivering the reports to the Business at the said deadline.

Converted Crystal Reports to Cognos .

Environment: COGNOS ReportNET 1.1, Teradata,

AIG Sunamerica, CA Cognos Administrator Jun 2005- Mar 2006

Description:

EDW BI Reports are developed and posted on a common portal for the Business users to access and view. The Portal is based on a Security Model for each user class. Security is implemented using Access Manager and Sun One Directory Server.

Responsibilities:

Involved in Disaster Recovery Plan and Implementation.

Configured, Installed COGNOS Components.

Involved in up gradation, migration of COGNOS products.

Installed, Configured ReportNET 1.1 for Windows.

Installed, Framework Manager Components. Administering and Managing the ReportNET Server.

Developed Framework model from the EDW BI Data warehouse using Framework Objects (Query Subject, Filter, Namespace, Parameters, and Calculation).

Generated Packages out of the Framework Model.

Published Packages to the COGNOS ReportNET Server.

Imported Packages into the ReportNET Server.

Using Report Studio, Developed various Reports(List, Cross Tab, Chart)

Deployed Reports and Granted Permissions (Read, write, Execute etc) to the user Classes.

Implemented security using Access Manager.

Maintenance of Decision Stream Jobs.

Creation of Decision Stream Processes.

Production Support for Business Intelligence.

Enhancing, Maintenance of BI Portal using Upfront server

Expertise in building and maintaining of Impromptu Catalogs.

Environment: COGNOS EP series 7 version 3, ReportNET 1.1, UNIX,, Oracle 9i, Toad, Upfront, Impromptu, Access manager, Transformer, Impromptu Web reports, SUN ONE, Decision Stream

Hewlett Packard, Singapore Project Lead /COGNOS Administrator Jun 2000 – March 2005

Information Data warehouse caters to the needs of all users in all the Departments of the Client region and country. The project is intended to provide information of Financial, Marketing, Manufacturing information for the users to do analysis and assist them in taking decisions. Information Data Warehouse (IDW) is based on Multi Dimensional Model. Star Schema is used as a Dimensional Model

Responsibilities:

Involved in building logical and physical data model using ERWIN Tool.

Managing project activities, coordinating with users to understand the requirements.

Involved in defining the process flow, designing interfaces for users for maintenance.

Decision Stream.

oCreated Decision Stream Catalogs to Extract, Transform and Deliver the Data.

oCreated a Connection to SQL Server 2000 using OLEDB.

oBuilt DataStream to Connect to the Data Sources.

oDesigned Dimensional Framework (Reference structures, Templates).

oDesigned, Created and Executed the Dimension Builds, Fact Builds.

oDesigned a Transformation Model (Attributes, Derivations, Dimensions and Measures). Mapped DataStream’s to the Transformation Model, Added the Transformation Model Element to the Fact Builds.

oAdded Fact Deliveries to the Fact Build while creating a Fact Build using Wizard.

oBuilt Job Streams for automation of the Building Tasks.

Involved in setting up the star schema.

Involved in designing the cube structures using COGNOS Powerplay Tool.

Involved in setting the infrastructure for the implementation.

Involved in designing high end financial reports for the top floor (Dashboards).

Will be responsible to promote the features and market the warehouse.

Developed reports and quries using BRIO tools.

Environment: ReportNET 1.02/1.1, Framework Manager, Query Studio, Impromptu 7.0, Power Play 7.0, Powerplay Transformer, Impromptu Web Reports, Upfront, Access Manager, Power Play Enterprise Server, Windows NT/2000, Oracle 9i.

Adesta.com, INDIA Senior Systems Analyst Nov 1999 – May 2000

Description : The project is a web site for on line shopping. Different stores present are books, gifts, music, video and audio etc. Different technologies are implemented such as intelligence search with full text search, product differentiation etc. College Texts is one of the most advanced features for the web site.

Roles and Responsibilities:

Database Design with concept of Normalization to Reduce the Redundancy of Data and enable Less Data Retrieval time.

User Friendly Interface Design for Checking the Website Orders By using appropriate Images, Active X Controls.

Coding – Used the Powerful Features of ASP 2.0, Visual Basic 5.0/6.0 features

Written Database Triggers to Build Efficiency.

Protecting Work and Data (e.g. Online & Offline database backup)

Testing Activities: Did Stress Test, Black Box Testing (Module Level), White Box Testing.

Data Base Backup from the SQL Server 7.0 enterprise manager.

Automation of Mail System using stored procedures of SQL Server.

Environment: ASP, Visual Basic 5.0/6.0, Internet Information Server, Windows NT Sever, Crystal Reports, SQL Server 7.0, Java Script, VB Script, MS Site Server Commerce Edition 3.0

Softstar Computer Consultancy Pvt Ltd, INDIA Snr Software Engineer Feb 1999 – Oct 1999.

Description : This is an Accounting Project with two levels of Password security i.e., lower level & higher level. The Lower lever security is only for viewing or adding vouchers, viewing Balance Sheet and Ledgers. The Higher Level is for Adding, Updating, deleting Ledger Accounts, and Group Accounts & Vouchers. Numeric Text Boxes (Active X Controls) are used for Numeric Data, Bitmap Files for User Account Logos. Reports like Date wise, Monthly & Yearly can be generated. Individual Ledger Accounts are generated basing on the Group Accounts.

Responsibilities:

Maintaining the Time Sheets of the Software Engineers in the team.

Communicating with the Client and the Software Engineers, and making the Work done in the stipulated Time.

Design of Database with Normalization, Security by granting permissions through Roles.

Written DLL’s (Dynamic Linked Libraries) using Visual Basic 5.0 to Impart Security for the package like if the package is installed more than 3 times, the next installation cannot be done.

Online database backup

Testing Activities: Boundary Value Test, Stress Test, and Security Test.

Developing Reports: Designed various types of Reports using Crystal Reports.

Documentation: Documented Every Piece of work for Programmer Compatibility to reduce the labor of rewriting the code.

Presentation: Given Technical demo Presentation to the Client about the package, and the Policies for up gradation

Environment:

Visual Basic 5.0/6.0, Crystal Reports, Oracle 7.3

JPR INDUSTRIES, INDIA Programmer Apr 1996- Nov 1998

This Project is for Poultry Industry and nearly fulfills all the Needs of the Industry. Basically the project is divided into 3 Modules: Enquiry Module: This is useful to have a pre-detailed idea of having current estimation of birds, material, cost statistics, and material design requirements. Production: Detailed reporting can be generated ensuring the production of eggs, birds per batch/per shed which is useful in estimating the profit rate per batch/per shed. Feed Inventory: Details about the feed purchased, current stock with different compositions and consumed feed is generated

Responsibilities:

Interface Design using Visual Basic.

Formulating the Equations and building empirical formulas for Calculation.

Developed Algorithm for Project of Moving Mesh Sizes.

Coding: Used Advanced features of Visual Basic for Database Accessing using RDO interface.

Developing Reports: Designed various types of Reports using Crystal Reports.

Environment: Visual Basic 5.0, Crystal Reports, Oracle 7.1

Contact this candidate