PROFESSIONAL SUMMARY:

• 8+yearsof IT Industry Experience in Data warehousing & Business Intelligence Solutions extensively worked on Domain areas like Banking & Financial, Defense & Aviation,Food &Retail and Healthcare.
• Expertise on Data warehousing products IBMCognos10.2.1,CognosInsight, Cognos Dynamic cubes, CognosMobile,CognosGo office,Cognos8 BI SuiteTools,CognosTM1,CognosReport net 1.2,TransformerandCognosEP 7 Series, Micro Strategy, SQL Server, Oracle Database, DB2, Data stage 7.5 Informatica,SSISand SSRS.
• Expertise in Framework Manager Modeling for relational and dimensional modeling
• Expertise in Report studio, Query studio, Analysisstudio, Event studio& Metric studio's
• Strong Knowledge with Power play Transformer model design and Power play cube building.
• Migrated reports fromCognosEP Series 7.2 toCognos8 BI 8.4 andCognos8 toCognos10.
• Expertise in Administration, Security and deployment of Cgonos Business Intelligence applications.
• Strong Experience in star, snowflake schema designs, DWSDLC and Performance tuning.
• Good exposure on Software Development life cycle including requirement gathering, analysis, design, development, testing, implementation and User acceptance
• Good Technical Knowledge, Analytical and Problem Solving skills, Communication skills, exhibiting leadership qualities in a Team and ability to get on well with across the people.
• Sound development Knowledge on Data warehousingOLAPapplication.

TECHNICAL SKILLS:

BI Tools: IBM Cogonos 10.2.1, 10.1 & 8 suite, IBM Cognos Insight, Cognos Dynamic Cubes, Cognos Report net, cognos Mobile, Cognos TM1, Cognos Go Office, Cognos EP 7 Series, Transformer and Micro Strategy 9.0.1.

Meta Data Modeling Tools: Cognos Frame Work Manager

ETL Tools: SSIS, Informatica, Datastage 7.1

Databases: SQL Server 2000/2005 & 2008, Oracle 11G, DB2.

Version Control Systems: Visual Source Safe

Operating Systems: Windows 95/98/NT/00/XP

Production Support Tool: HP Open view Service Desk/HP Quality Center.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Senior Cognos Consultant

Responsibilities:

• Providing the Technical solutions to the team andclient on major issues on the Cognos Application and providing the implementation approach.
• Involving Day to day client and business interactions, requirement gathering and design document preparation.
• Designingrelational &multi - dimensional package usingFMmodel and created reports & dash boards/workspace.
• Working onCognosDynamic cubes and CreatedCognosWorkspace usingCognosInsight.
• Working onTransformerto design the cube model and building the cubesand developing analysis studio reports.
• Developingdrill through reports, master detail reports, burstreports, RAVE visualizationcharts and testing the reports andcubes.
• DevelopingActivereports for usersto use offline and on I pad / mobile devices.
• Maintaining and Reviewing the Issues, clarifications Trackers, design and Coding
• Installed and configuredCognossuit BI Applicationsand tuning the server.

Environment: IBMCognos10.2.1,CognosDQM, Cognos Mobile,CognosInsight, Framework Manager, Transformer, Sql server2008,Oracle 11g, Windows XP,Unix

Confidential, NJ

Senior Cognos Lead

Responsibilities:

• Understanding the business process and gathering business requirements for the reports.
• Designing the functional specification document (FSD )and Technical design documents (TDD)
• Design review with the Team members and Meet the Project Plans in time.
• Workedon Relational& Dimensional modelusing Framework manger
• Developedon Complex reports with huge data sets and providing the technical solutions on complex issues.
• WorkedScorecards and Dashboards/workspace&CognosGo office
• Authoring drill through reports, master detail reports, burstreports,Active reports& MDX reports
• Workedon Securities using AccessManager andAdministration tasks.
• Worked on Transformer modeldesign and Power play cube building.
• WorkedCognosSDK tointerface web service integration.
• Developingof TM1 Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creatingdimensions, hierarchies, and cubes.
• Created rules to transfer data between cubes And Used Replication to copy the Cubes from one server to other server.
• IntegratingCognosTM1 and IBMCognosBI & Configure TM1 Port lets in IBMCognosBI
• Written SQL queries in Database to testCognosreports before reports moving to QA testing.
• Worked in JIRA /QC's ticket tracking tool to resolve the issues raised by the end users.

Environment: IBM Cognos 10.1.1 & 10.2, Framework manager, Cognos Go office, Transformer, Windows XP, SQL DBX, SQL Developer, Teradata, Sybase, Oracle 11G & SVN.

Confidential, New York

Cognos Developer

Responsibilities:

• Interacted with Development and Management Teams and provided technical assistance to Developers
• DesignedMetadataModelsusingFramework Managerandpublished packages to the Cognos connection.
• Created new Query Subjects and arranged indifferent Folder structure for Business View
• Created Row levelsecuritiesfor all Framework structures
• Formulation of Joins, resolvingrelationship, cardinalityinFramework Manager
• CreatedPredefined Filtersin the metadata models.
• UpgradedFramework Manager Models, Transformer CubesfromCognosVersion 8.3 to 8.4and solved the issues in the existing model.
• Developed StandardDashboard ReportsusingMulti-dimensional data,Charts,Drill-through Reports, Master Detail Reports andBurstReportsusing Report Studio and Query Studio
• CreatedConditional Blocks, Filters and other prompts fordynamic selectionfor users
• Scheduled and Run Reports throughSchedule ManagementinCognosConnection
• Extensively worked onAnalysis Studioto developmulti-dimensional reports
• Deployed Cubes and ReportsonPowerPlay Enterprise Serverand also published toCognosConnection
• Ensured all project related documentation is accurate, comprehensive, and current

Environment: Cognos8.3/8.4(Framework manager,CognosConnection, Report Studio, Query Studio, Analysis Studio), Power Play v7.3, Power Play Transformer, MS Excel, SQL Server 2005, Oracle10g.

Confidential, Madison, WI

Cognos Developer

Responsibilities:

• Involved in requirement gathering from Business users and prepared documentations.
• Implemented modeling in Framework manager
• Implemented Relational modeling in Framework Manager and created query subjects, relationships, filters and calculations in the model.
• Setting up the security in frame work manager at package level, Query subject level.
• Involved in Migrating reports from Impromptu to Cognos Report Net.
• Created various Reports based on Technical Specification.
• Created drill thru reports and enabled the drill-thru feature on the current master reports to manage more complex business reporting requirements.
• Developed Stored Procedures and Database Triggers in T-SQL
• Involved in the design and development of reports in Report Studio
• Published cubes and created Power play Reports for the web users.
• Implemented security using Access Manager
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos
• Worked on securing Cognos Connection and setup ReportNet security by assigning users to the groups and roles defined in Cognos Namespace.
• Involved in testing of reports with the existing live data via VPN

Environment: CognosReport Net 1.1 Report Studio, Framework Manager, Query Studio, Cognos Connection Oracle 9i, Windows 2000 Server, MS Excel 2000

Confidential, FL

Cognos Developer

Responsibilities:

• Created various reports using different lists in single and multiple pages according to filter conditions.
• Requirement gathering from business and client interaction.
• Created highly Complex Reports using OLAP CUBES as Data Source forMulti-DimensionalAnalysis.
• Used Conditional Variable to display different colors and for text according to format.
• Used Designing the reports and bursting the reports.
• Used Schedule Management to schedule the reports.
• Involved in migration ofCognosReportNet toCognos8.

Environment: Cognos8.1, Windows XP, SQL Server - 2005,Powerplay ransformer 7.2

Confidential, Beaverton, OR

Cognos Developer

Responsibilities:

• Collecting andanalyzinginformation requirements from users and translate those needs into requirements documentation
• Responsible for Designing and developing the reports for a NACS (North American Customer Service)
• Working with Data Warehouse team as needed to define new data warehouse tables needed for reporting,
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Burst Reports against database.
• Created custom prompted reports in Report Studio.
• Coordinate/assist /developCognosframework manager model adjustments to accommodate new and existing business requirements.
• Training end users to effectively use the reporting tool tobuild and customize their BI and BIA reports.
• Fine-tuned the performance of the reports using performance parameters

Environment: Cognos10.2/10.1 (CognosConnection, Framework Manger, Report Studio, Cognos Workspace, CognosWorkspace Advanced, Active Reports),CognosGo Office, Teradata, Java Scripts (HTML).

Confidential

Database Developer

Responsibilities:

• Developed tables, views, stored procedures, functions, and user-defined data types
• Created table structures along with thetriggers,indexes like bitmap and function based indexes
• Monitored indexes and analyzed their status forperformance tuningandquery optimization
• Maintained the data integrity and security usingconstraintsanddatabase triggers
• Involved in programming database triggers forautomatically updating the tables and views
• Used various forms of control structures includingCase, Decode, If-Then-Else, For loops, Whileloopswhile developing procedures
• Implemented table partitioning and sub-partitioning to improve performance and data management
• Troubleshoot performance issues within packages and stored procedures usingExplain plananddbms output
• Responsible for tuning the application with the help of team members & Oracle support
• Improved the query performance using better joins and hints appropriately
• Developed packages, proceduresand functions for complex reports
• UsedSQL*Loaderfor loading the data into the tables from files
• Participated in the design and code reviews and verified compliance with the project's plan
• Documented the whole process flow, PL/SQL packages, locations and descriptions, and possible error messages

Environment: Oracle 8.0, SQL, PL/SQL, SQL plus, Sun Solaris 2.6, SQL loader,UNIX.