SUMMARY

• Over 14 years experience in Information Technology.
• Over 10 years of professional expertise in implementing Data Warehouses, Expertise in BI (Business Intelligence) using various 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 SKILLS

Business Intelligence: COGNOS, LDAP, Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Score carding, Workspace, Active reports.

BI Visualization Tools: Tableau, MS Power BI

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

PROFESSIONAL EXPERIENCE

Confidential

Tech Lead/Architect

Responsibilities:

• Worked with Purchase SME’s to discover various data sources required to build the metric equations.
• Analysed Data from raw sources for Data relationships.
• Developed Logical Data Model for Staging, QA and Prod environment.
• Articulated the design into ETL Design for the ETL team to work on Data Loading.
• Working with Reporting and Analytical Tools to author reports, Cubes and Dashboards for better Data visibility in Cognos V11 version
• Working on Site - offshore models to guide the team for Data Reporting, Data loading.
• Worked on Migration from cognos 10.2.2 to Cognos V11 .

Environment: /Tools: Teradata (Database), Cognos, QlikView, ERWin

Confidential

Snr Consultant

Responsibilities:

• Designing BI solutions for various departments in the enterprise based on Data discovery and data availability.
• Gathering Requirements from different categories of Users.
• Developed cubes.
• Developed Dashboards .
• Developed transactional reports, tuned for performance.

Confidential

Snr Consultant

Responsibilities:

• Designing BI solutions for various departments in the enterprise based on Data discovery and data availability.
• Developed cubes.
• 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.

Confidential

Snr Consultant

Responsibilities:

• 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 Developed Dashboards for Top level management utilizing TM1 Cubes.
• Have Designed and Deployed Dashboards using TABLEAU Tools.

Confidential

Team Lead/Snr Associate

Responsibilities:

• 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

Confidential, IL

Senior Cognos Consultant

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

Confidential, NJ

Cognos Data Architect

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

Confidential, IL

Cognos Consultant

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).

Confidential, IL

Senior Developer/Report Architect

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
• 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.

Confidential, IL

Senior Associate/Business Analyst

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

Confidential, CA

Cognos Administrator

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.
• 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

Confidential

Project Lead /COGNOS Administrator

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.
• Created Decision Stream Catalogs to Extract, Transform and Deliver the Data.
• Created a Connection to SQL Server 2000 using OLEDB.
• Built DataStream to Connect to the Data Sources.
• Designed Dimensional Framework (Reference structures, Templates).
• Designed, Created and Executed the Dimension Builds, Fact Builds.
• Added Fact Deliveries to the Fact Build while creating a Fact Build using Wizard.
• Built 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.

Confidential

Senior Systems Analyst

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

Confidential

Snr Software Engineer

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.
• 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

Confidential

Programmer

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