SUMMARY

• Over 11.8 years of IT experience in all the Software Development Life Cycle (SDLC) such as Requirement Gathering, Requirement Analysis, Estimations, Planning, Coding, Testing and Post Production Support.
• Hands on technical experience in Data Warehousing, Business Intelligence (BI), Data Modeling and OLAP, ETL tools, application development and Reports Generation, Data visualization & Analytics.
• Experience in working with Cognos 8.x/10.x. (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio and Cognos Connection).
• Expertise in Framework Manager Modeling (Database Layer, Intermediate Layer, Presentation Layer, Packages, Dimensional Data modeling) and Complex Report building with Report Studio.
• Experience with Healthcare, Health Insurance, Banking & Finance reports and Dashboards for analysis.
• Strong Complex Reporting skills - - complex Drill-Through, Dashboards, Discontinuous Cross-Tabs, Summary Reports, Burst Reports, ad-hoc reporting and advanced report authoring.
• Excellent working Skills with Power play Transformer 8.x/10.x in building cubes.
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment & upgrading Impromptu series 7 versions to higher version Cognos 8.x/10.x.
• Provided technical and functional consulting to corporate and divisional users for Cognos & Business Objects.
• Experience in implementing the Security for the Reports, folders and package and also played Cognos Administrator role.
• Experience in implementing the Security for SAP Business Objects Documents, Folders and Universe and also played CMC Administrator role.
• Experience in creating Dashboards using data visualization tool Tableau - desktop and Server
• Designed and developed Metadata model in Relational and Multidimensional databases.
• Worked extensively with Transformer 8.x/10.x to design Dimensional models and analyze the Power Cubes.
• Good knowledge in COGNOS Impromptu, Impromptu Web Reports and Power Prompts.
• Experience in BI Tool Cognos v.10.x (Business Insight, Business Insight Advanced, and Report Studio).
• Experience in developing the Active report and very good exposure on Cognos Workspace and Workspace Advance.
• Experienced in installation and configuration of Cognos BI v8 and v10 Suites.
• Experience in building CognosTM1 cubes using Turbo Integrator.
• Involved in the full Project Life Cycle of the Data Warehouse Project and exposure to client interaction and user-requirement analysis.
• Mentored and trained users for the successful execution of the project.
• Carried out Requirement Gathering, Requirement Analysis, Estimations, Planning, Coding, Testing and Post Production Support.
• Have 2+ years of project management experience with waterfall and agile methodologies (SCRUM).
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in Relational, Dimensional and Multidimensional modeling.
• Creating ZPTS Investigate & Test Tasks to fix the programs that upload database tables and transactions.
• Proficient in coding using SQL, Scripting, Stored Procedures, Functions and Triggers.
• Experience in collaborating with various internal as well as external teams for the successful and timely delivery of the multiple projects.
• Managed project teams of 4-8 members in an onshore-offshore model to successfully meet project deadlines and commitments.
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Good knowledge on IBM SPSS and SAS analytics. Studied both the tools and demonstrated to a client about the Pros and Cons to do the predictive analytics.
• Experienced in preparing technical specification documents such as Global requirement Gathering Documents (GRG), New Product Development (NPD).
• Experience in developing new reports and customizing existing reports and change request processing.
• Expertise in problem analysis, problem solving and performance tuning.
• Excellent communication and writing skills. Ability to get along with the team well and proven leadership qualities.
• Experience on Tableau Desktop and Tableau Online and Servers.
• Well trained in Big Data - Hadoop.

TECHNICAL SKILLS

BI Tools: Cognos 10, Cognos 8 Suite, Cognos 8 Transformer, SAP BO 4.0, Tableau 8.3, Cognos 7.3.

BI Planning Tools: Cognos TM1.

ETL Tools: IBM Cognos Data Stage, MS DTS.

Databases: Oracle 9i, 10g 11g, DB2, MS SQL Server 2000, SAP BW, Sybase

Software Languages: JavaScript

Internet Technology: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, NY

Technical Lead Analyst

Responsibilities:

• Interacted with the users extensively and gathered the requirements, and analyzed the needs of the end users.
• Enhancement and Modify the Existing BI - Cognos environment Reports and FM Models.
• Implemented the Object level security and Data level security in the Multi source FM Model.
• Interacting with the client/ Confidential France team for new requirements and Clarifications on current task in BI-Cognos Reports, Active Reports and FM.
• Fixing report bugs in the existing report and taking regular content store backup.
• Guiding offshore team members in development and fixing the technical issues or problems.
• Developed Complex Multilingual, Multiple Data source Framework Manager Models.
• Maintained and monitored the 250 daily ETL batches and 2 Tb of Data into the Data warehouse Environment.
• Provided the security for 1500+ Users with 300 users connected daily to the Cognos Environment.
• Requirement Gathered from France team for new FM Model and doing gap analysis for development of New FM against the Data sources (DW).
• Requirement Gathering for new report development in report studio.
• Fixing the issues during the development of FM and Reports that is challenging to the Team members.
• Worked on analyzing the issues that causes the Data Stage - ETL Job Failure and report to the France Team before coming to the Office.

Environment: IBM Cognos Suite, IBM Datastage, IBM Cognos TM1, Cognos - Report Studio, Event Studio, Query Studio, Analysis Studio, Advance Workspace

Confidential

Technical Lead Analyst

Responsibilities:

• Designing the Document wireframes and developed HI - HIX BO Reports using Webi.
• Prepare the Best practice document to develop the Universe using IDT & develop the reports using BO - Webi.
• Developed Complex Dashboards using SAP BO Dashboard.
• Interacting with the client/Onsite team for new requirements and Clarifications on task in BO Reports and Universe updating Work.
• Provided training to the team on MDX Functionality & make then up to the mark to deliver the reports and assigned task in BI- BO.
• Guiding team members in development and technical issues or problems.
• Reviewing the reports done by the team members to make sure it is matching the 100% report specification before it move to UAT.
• Managing and leading 4 members Team technically.

Environment: SAP Business Objects 4.0., Webi / Web Intelligence Rich Client, Information Design Tool/Universe Design Tool, CMC, Dashboard. Oracle 11g, PL/SQL, T-SQL, SAP CRM

Confidential

Lead Analyst

Responsibilities:

• Review & Understand the Project HLD & LLD of Cognos Report Implementation.
• Preparing the Effort estimation for MassHealth ETL and Report Development and working with the team to deliver it within the time frame.
• Interacting with the client/Onsite team for new requirements and Clarifications on task in BI-Cognos Reports and FM Work.
• Designing the report wireframes and develop MA - HIX Cognos Developer guidelines.
• Prepare the Best practice document to develop the package using Framework manager & develop the reports using Report Studio.
• Provided training to the team on MDX Functionality reporting using Report studio & make then up to the mark to deliver the reports and assigned task in BI-Cognos 8.x / 10.x
• Guiding team members in development and technical issues or problems.
• Testing the ETL data in the DW and reviewing the reports done by the team members to make sure it is matching the 100% report specification before it move to UAT.
• Discuss with the onsite to provide the status on the task & Managing and leading 8 members ETL and Reporting Team technically.

Environment: IBM Cognos 8.x/10.x.Report Studio, Query Studio, Analysis Studio, Event Studio, Framework Manger, Transformer, Map Manager, Administration, Relational Modelling, Dimensional Modelling, Oracle 11g, PL/SQL, T-SQL

Confidential

Technical Lead

Responsibilities:

• Enhancement and Modify the Existing BI - Cognos environment Reports and FM Models.
• Helping team by solving Technical challenges in report development and enhancement.
• Interacting with the client for new requirements and Clarifications on current task in BI-Cognos Reports and FM.
• Fixed report migration bugs while migrating reports from Cognos 8.x to Cognos 10.1 version.
• Provided training to the team to make then up to the mark to deliver the reports and assigned task in BI-Cognos 8.x / 10.x
• Guiding team members in development and technical issues or problems.
• Reviewing changes by the team members.
• Managing and leading 4 members Team technically.

Environment: IBM Cognos 8.x/10.x, Relational Modelling, Dimensional Modelling, Oracle 9i/10g/11g and SQL Server 2000/05/08, DB2, Sybase, SAP BW, PL/SQL, T-SQL.

Confidential

Cognos - Sr. Technical Lead

Responsibilities:

• HLD design for the canned & Ad-hoc reporting requirements.
• Preparing the FM and Cube development work estimations and taking the signoff from the Client
• Project design for the MFL canned & Ad-hoc project user needs.
• Schema objects-Attribute, Facts definition, Public objects-Filters, Prompts & Metrics definition for projects, Business Rules definition & validation within various reporting needs.
• LLD design for each set of canned Reporting as well as Ad-hoc Reporting requirement.
• Conducting Design walkthrough sessions with BIR & Business SME groups and design signoff
• Unit & System test case design --Test data load into warehouse from (SAP BW) source system
• Performed OLAP services and MDX query design for advanced analytics and Trend analysis reporting.
• Developed and published Packages in Framework manger & Designed and published Cube using Transformer.
• Leading the team of 4 Cognos consultant by assigning the task.

Environment: Cognos 10.1 - Framework manager, Transformer, Report studio, Analysis studio, Query Studio, Cognos Administration, SAP BW, Oracle

Confidential

Technical Lead - Offshore

Responsibilities:

• Preparing the design document for the new set of report requirements.
• Preparing the Effort estimation plan for the set of reports for each model.
• Allocating the Resources to the newly started project model reports and giving the KT.
• Preparing the Daily status and Weekly status report of offshore Cognos team activity and share the same with the Onsite project Director/Manager.
• Attending the daily conference call with the onsite Managers to get the approval for new changes or enhancement in the reports and address the technical concerns/issues and discussing on the issues and clarifications on the new changes.
• Assign the work to the Cognos team and take the status update on the assigned report development activity..
• Sitting with team and solving the technical challenges by providing the technical solution in an efficient way.
• Unit & System test case design --Test data load into warehouse from (SAP BW) source system.
• Worked on to tune up the performance of report using MDX query design for advanced analytics and Trend analysis reporting.
• Developed and published Packages in Framework manger & Designed and published Cube using Transformer.
• Leading the team of about 7 Cognos consultant by assigning the task and providing the training on MDX.

Environment: Cognos 10.1 - Framework manager, Transformer, Report studio, Analysis studio, Query Studio, Oracle 10g.

Confidential

BI Cognos - Architect

Responsibilities:

• Understanding the SRS Document provided by Client.
• Preparing the High level designing document and Requirement gathering from the Client.
• Clarifying the concern, issues and Demo given to the Client based on the High level Design document and developing the POC based on the HLD document.
• Designing the model using Cognos Framework Manager.
• Implementing the Role based and Row based security model in the FM.
• Implementing the Data security in FM for Standard, Country and Competitive Security model.
• Analyzing the requirement, Finalizing the Wire frame by Gathering the requirement from the Client and Analyzing the requirement.
• Configured Cognos Audit to the MPI Cognos environment.
• Created User Groups and Roles based on the User role in the Organization to provide the Authentication and Authorization to the Cognos connection contents.

Environment: Cognos 8.4.2 BI - Framework manager, Transformer, Report studio, Analysis Studio, Query Studio, Cognos Administration, LDAP, SQL Server .

Confidential

BI Cognos - Technical Lead.

Responsibilities:

• Understanding the SRS Document provided by Client.
• Analyzing the Client existing system and Designing the reports wire frames.
• Finalizing the Wire frame by Gathering the requirement from the User Group.
• Preparing the High level, Low Level and Cube Designing Document.
• Analyzing the requirement and preparing the report specifications.
• Designing and Developing Dashboards, Scorecard.
• Creating the Events in the Cognos connection and scheduling it to update the data, Bursting the reports.
• Creating Cube and publishing it for CAFÉ Users.
• Giving Demo to the End user and taking input for further Enhancement.
• Integrating Reports with BPM process and Bursting report and providing the Security and access control for Busted Output.
• Resolving the technical issues and providing the new logics that may Increase report performance.
• Reviewing the reports newly developed from the team members and pushed to Production and checking the performance.
• Prepared TDD for the Cognos Reports.

Environment: Cognos 8 BI - Framework manager, Event Studio, Transformer, Report studio, Analysis Studio, CAFÉ, Oracle 9i, DB2.

Confidential

Sr. Cognos - Developer

Responsibilities:

• Understanding the SRS Document provided by Client.
• Gathering the requirement from the Client.
• Analyzing the requirement and preparing the report specifications.
• Development and Enhancement of Dashboards and Scorecards.
• Reviewing the reports newly developed from the team members and pushed to Production and checking the performance.
• Reviewing the reports, which are newly developed by Offshore and checking the test script.
• Analyzed technical design document and report specification document of Cognos report.
• Development and testing of Cognos report with bursting option.
• Prepared TDD for the Cognos Reports.

Environment: Cognos 8 BI suite, FM, Transformer, Cognos Administration.

Confidential

Jr. BI Consultant

Responsibilities:

• Testing the mapping and preparing the test cases
• Testing Report's as Report Tester.

Environment: Cognos-Report Net, DTS.

Confidential

Jr. Engineer.

Responsibilities:

• Understanding the requirements
• Understanding the work plan
• Writing the JSP pages and (Action) Servlet

Environment: Java, J2EE and Struts Frameworks and Broad Vision 1 to 1 server.