PROFESSIONAL SUMMARY:

• Experience with theBI tools Cognos, Cognos TM1, Tibco Spotfire Professional and Web Player.
• A proficient professional with 12+ years of experience with System Analysis, Development & Testing in the field of Data warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS), Customer OLAP, Reports Generation and Web development.
• Adept at designing and development of data warehousing reports using COGNOS 11, COGNOS 10, COGNOS 8 (Report Studio, Query Studio, Analysis studio, Event studio, Active Reports, workspace, workspace advanced, RAVE visualizations and OLAP cubes).
• Proficient in developing Business models using Framework Manager (Relational & DMR) and published packages to Cognos Connection in Cognos 10 and 8 series depending on business requirements.
• Expertise in Framework Manager Meta Data Modeling (Database Layer, Intermediate Layer, Presentation Layer, Packages, Dimensional Data Modeling).
• Involved in migration of Cognos models and reports from Development to Stage, Stage to Production and administering users/groups/roles.
• Export/Import the Cognos reports between the environments (DEV, STAGE & PROD).
• Involved in data source creation through cognos administration during migration.
• Involved in cognos upgrade from Cognos 8.2 to Cognos 8.4.
• Involved in the full Development Life Cycle Process of the Data Warehouse Project and exposure to client interaction and user - requirement analysis.
• Experience spans all the phases of life cycle of software development such as Requirement Gathering, Requirement Analysis, Estimations, Planning, Coding, Testing and Post Production Support.
• Involved in creating Data Source connections, Security and Experience in Deployment (Export, Import) from one environment to another environment.
• Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Good in Cognos Connection Administration Works: Scheduling Jobs, Event Creations, Creating User Groups, folders and assign permissions.
• Developed complex executive Dashboards with multiple charts and cross tab reports and drilling down from the graphs.
• Have diverse experience in Cognos Report Testing and Quality Assurance, with expert level skills in strategic areas into Functional Testing, Integration/System Testing.
• Extensively worked on Cognos Reports Development, testing and validating the report against the databases (Netezza, Oracle, and SQL Server).
• Experience in creating ComplexSpotfire Dashboardsor Reports UsingTibco Spotfire Professional
• Developedcross table, Bar chart,Tree mapandcomplex reportswhich involvesProperty Controls, Custom Expressions.
• Created ComplexInformation Linksto pull the data from Oracle 10g/11g and Denodo.
• Expert in Writing SQL Queries on Oracle.
• Experience in Financial Planning Solutions using Cognos TM1 10.2 Applications (Architect, Contributor, Perspectives and TurboIntegrator) from requirements through design and testing, implementation and production support (full SDLC).
• Expertise in TurboIntegrator processes to load and retrieve data from database tables and other data sources, creating complex Active Forms.
• Familiar with TM1 rules editor to create various calculations, What if analysis for TM1 planning, budgeting and forecasting.
• Good technical expertise in SQL, MS Office tools, Data Analysis and Data modeling.
• Experienced in preparing technical design documents such as Global requirement Gathering Documents (GRG).
• Having good knowledge on Tableau Desktop, Tableau Reader and Tableau Server
• Knowledge in building BI components like Info objects, data sources, Info cube, DSO, Transformations, Data Transfer Process DTP, Multi providers and Master data Info Objects, Transfer Structures, Transfer Rules and Update Rules.
• Produced attractive Tableau visuals/dashboards to convey the story inside the data.
• Having good knowledge on Agile Methodology.
• Expertise in OLTP/OLAP System Study, Analysis, developing Database Schemas like Star Schema & Snowflake Schema used in Relational, Dimensional and Multidimensional modeling.
• Possess strong oral, written and organization skills, excellent time and project management skills and a strong ability to prioritize tasks. Self-motivated and industrious professional with good technical, communication and leadership skills.
• Carries a positive attitude, enthusiastic and a firm believer of team work.
• Mentored and trained users for the successful execution of the project
• Managed project teams of more than 8 members in an onshore-offshore model to successfully meet project deadlines and commitments

TECHNICAL SKILLS:

OLAP/BI: COGNOS 11.x, COGNOS 10.x, COGNOS 8.x (Report Studio, Query Studio, Analysis studio, Event studio, Workspace, Workspace Advanced, Active Reports, Transformer(OLAP Cubes) & Framework Manager), Tibco Spotfire 6.5 (Professional and Webplayer), Cognos TM1 10.2 (TM1 Architect,TM1 Perspective, TM1 Web and TM1 Contributor), Tableau Desktop 7.0

Languages/Tools: PL/SQL, SQL, JavaScript, AJAX, JQuery, HTML, DHTML, PHP, Perl, Flex

Databases: Oracle 9i & 10g, MS SQL, Server 2005 & 2008, MS Access, My SQL

Operating Systems: Windows NT/95/98/XP/Vista/7, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Cognos Lead / Senior Cognos Developer

Responsibilities:

• Responsibility to build a reporting platform per requirement from customers.
• Involved in gathering the requirements and took it from white board to implement reports using Cognos.
• Created appropriate FM models and created reports out of it.
• Response in identifying data for decisional BI reporting
• Response in creating metadata from different data sources
• Response in delivering complete reporting application to business
• Involved in complete data analysis in terms of reporting requirement perspective.
• Developed dashboards from the sources of package and external files.

Environment: COGNOS 11.0.4 (Framework Manager, Reports, Dashboards), RAVE Visualizations, Oracle 10g, Javascript, Tableau Desktop, Tableau Reader, Tableau Server, Service Manager, Rally.

Confidential, Stamford, CT

Cognos Tech Lead/Cognos TM1 Consultant/Sr. Spotfire Consultant

Responsibilities:

• Participate in meetings with Client\Onsite counterpart to understand requirement and identify the key milestone during the project execution
• Understand\Document the project requirement as per the Business needs and converted the Business specification document into Technical design document according to User requirement.
• Implemented Failure notification mail alters in Production, if any scheduled report will be fail in Production, immediately we will get mail alerts.
• Extensively worked on performance issues with queries and reports.
• Created complex reports using active reports.
• Involved in the Enhancements of reports, Framework Manager model and report bug fixes as per the User request.
• Monitoring the scheduling jobs and reports in the Production and delivered the reports successfully to end users.
• Created power play OLAP cubes using Cognos power play transformer on .iqd(Impromptu query definition) and created reports in analysis studio.
• Created the reports on RDM (Relational Data modeling), DDM (Dimensional Data modeling) and DMR (Dimensional Data modeling on Relational model).
• Created Data sources for Report creation in Spotfire Professional.
• Created various complexesCross tables, Bar Charts, Line Charts and Tree map.
• Customized data by addingProperty Controls,Filters, Calculations, SummariesandFunctions.
• Created Information Links By using Information Designer to pull the data from Oracle Database and Denodo (Virtualization tool) required to create the reports.
• Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
• Development of TurboIntegrator(TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Maintenance of TM1 users, roles, and security.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Created rules to transfer data between cubes.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Used Replication to copy the Cubes from one server to other server.
• Involved in the UAT and TUT while deploying the reports from Dev to QA environments
• Using Rally tool to track all production issues and development tasks.
• Managing/Leading offshore team of 8 members.

Environment: COGNOS 10.2, Active Reports, Cognos TM1 10.2, Spotfire 6.5, Oracle 10g, Javascript, SVN, Rally

Confidential

Cognos Lead / Spotfire Consultant

Responsibilities:

• Gathered Business Requirements to develop reports using IBM Cognos 10.1, Spotfire 6.0.
• Involved in discussion with business to understand requirements and prepare requirements document.
• Involved in estimation of cognos/spotfire development and preparing SOW for the same.
• Involved in modifying the cognos models, according to the user requirement.
• Involved in testing the updated/new packages and fix the issues.
• Analyzed, designed, built and tested reporting solutions based on business requirements.
• Created Cognos 10.1 Framework Manager models including relationships, filters, calculations, organized folders, merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer, and have setup data/object security and successfully published the packages.
• Created Star Schema Models in Frame work manager.
• Developed various reports like List reports, Cross Tab reports and Drill through Reports using Report studio.
• Developed several complex reports using cascaded prompts, Drill Through, master-detail relationships, Page sets, Joins, Unions using report studio.
• Worked on conditional variables utilizing conditional explorer in report studio.
• Created, organized and formatted reports, folders and other contents on Cognos
• Created joins with queries in Report Studio to generate the required Report queries.
• Extensively worked on Dashboards using report studio including render variables, master-detail relationships, prompts, filters, conditional variables, HTML items, layout component reference and formatting the objects within report design.
• Applied Security and User Authentication to the various User Groups.
• Involved in migration of Cognos models and reports from Development to Stage, Stage to Production.
• Data source creation during migration.
• Emport/Import of bulk reports between environments during migration.
• Developed various reports including Summary tables, Pie Charts, Combination Charts and Heat map.
• Experience in using cascaded filters, detailed visualizations, property controls,filtering scheme, calculations, summariesandfunctions in spotfire reports.
• CreatedAction Controls using Python Scripting.
• Created, organized and formatted reports, folders and other contents on Spotfire.
• Created datasources, extract columns, created joins and filters then by using Information Designer to create Information Links to pull the data from Oracle Database.
• Created visualization data tables across multiple pages and used different filtering scheme.
• Implemented row level security using personalized information links.
• Creation of Jira tickets for the cognos/spotfire development.
• Involved in updating/addition of cognos models/spotfire dashboards into SVN.
• Managing the team of around 6 people

Environment: COGNOS 10, Spotfire 6.0, Oracle 10g, Javascript, Transformer, JIRA, Python, SVN.

Confidential, Houston, TX

Senior Cognos Developer

Responsibilities:

• Interacting with the key Business Associates for understanding the as-is process flow and new business requirements or enhancement activities.
• Documenting the Business Requirements for report development, coding and passing it to Client Review.
• Design & Enhance the Framework Model based on the business requirements.
• Design & Enhance Cognos Reports and Dashboards.
• Interact with Offshore team for technical discussions and product delivery.
• Troubleshoot and enhance the existing reports with recommendations to suit the business requirements.
• Performance tuning of the reports.
• Prepare SQL Test scripts for COGNOS Reports.
• Carrying out Unit testing based on the unit test plans and test cases.
• Managing the deliverables to the client.
• Up gradation from Cognos 8.2 to 8.4, 8.4 to 10.
• Allocating tasks and delegating responsibilities to the team members for the successful execution of the project.
• Daily reviews and status monitoring of the project.
• Conduct Team Meetings and address the issues faced by the Team Members and come up with solutions for the same.

Environment: COGNOS 10, 8.4, 8.2, IBM AIX Server, SQL SERVER 2005 & 2008.

Confidential

Senior Cognos Developer

Responsibilities:

• Interact with Business users to gather requirements for the model and Cognos reports.
• Design & Enhance the Framework Model based on the business requirements.
• Design & Enhance Cognos Reports and Dashboards.
• Interact with Offshore team for technical discussions and product delivery.
• Troubleshoot and enhance the existing reports with recommendations to suit the business requirements.
• Performance tuning of the reports.
• Prepare SQL Test scripts for COGNOS Reports.
• Allocating tasks and delegating responsibilities to the team members for the successful execution of the project.
• Daily reviews and status monitoring of the project.
• Conduct Team Meetings and address the issues faced by the Team Members and come up with solutions for the same.

Confidential

Spotfire Developer

Responsibilities:

• Understanding existing business and customer requirements.
• Created Data sources for Report creation.
• Created various complexesCross tables, Bar Charts, Line Charts and Tree map.
• Customized data by addingProperty Controls,Filters, Calculations, SummariesandFunctions.
• UsedAutomation Job Service Builderto Export DXP file during Migration Process
• Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
• Created various prototypes and showed them to the users.
• CreatedAction Controls using Python Scripting.
• Experience in Handling Multiple data tables in Analysis.
• Experience in creatingBookmarks.
• Conducting Unit testing of the reports developed in Spotfire Professional.
• Responsible for the migrating the reports from Development to Acceptance / Production Server.

Confidential

MSBI SSAS Developer

Responsibilities:

• Understanding existing business and customer requirements.
• Creating functional and technical design documents.
• Created a proof of concept on SSAS cubes based on existing Cognos reports.
• Gave a presentation to the client on the cubes and their functionality.
• Acted as one of the key members responsible for getting the MSBI work from the client.

Environment: MSBI SSAS, SQL Server 2008, Excel.

Confidential

Cognos Developer

Responsibilities:

• Interpreted complex Business specifications developed by the client and generated reports to meet customer specifications.
• Development of Packages.
• Enhancement and development of existing/new reports.
• Bug-fixes on the report.
• Maintenance and support of Client, Operational and Ad hoc reports.
• Created Standard Reports using Report Studio like List Reports, Crosstab Reports and Chart Reports with drill through functionality and Ad-Hoc Reports using Query Studio.
• Created reports using Cascading Prompts, Conditional Variables, Render Variables and Data Formatting properties.

Environment: COGNOS BI Series 8, Java Script, TOAD 6.5.0, Oracle 10g, Windows XP.

Confidential

Cognos Developer

Responsibilities:

• Analysis of Business Specifications.
• Development of Cognos Reports using Report Studio.
• Enhancement and development of existing/new reports.
• Bug-fixes on the report.
• Developed different kinds of cognos reports like List Reports, Grouped Reports, Cross Tab Reports, Chart Reports and Drill-through Reports.
• Worked on different kind of Prompts and customize the reports as per Client Requirements.
• Preparation of Unit Test Cases and performed testing in the development environment.

Environment: COGNOS BI Series 8, Java Script, Oracle 10g, Toad.