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*LoaderTeradata

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: Teradata (Database), Cognos, QlikView, ERWin

Confidential

Tech Lead/Architect

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

Tech Lead/Architect

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

Tech Lead/Architect

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

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

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