SUMMARY

• Accomplished BI professional wif 8 years of extensive background in full life cycle of software development process including requirements gathering, analysis, design, development, testing, debugging and maintenance of Data warehouse applications in Insurance, Healthcare, Banking and Finance domains.
• Skilled at listening and gathering information. Resourceful troubleshooter and problem solver, focused on details, utilizing analytical skills to access and resolve technical difficulties positively
• Experienced in various IBM Cognos BI 8.4 and IBM Cognos BI 10 tools that includes Report Studio, Query Studio,Analysis Studio,Framework Manager,Cognos Administrator,Transformer,IBM Cognos Business Insight, IBM Cognos Business Insight Advance
• Involved in Metadata modelling using Framework Manager - creating Projects, Models and Packages that includes Connecting and testing teh data source, creating database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and creating filters,prompts, calculations, summaries, functions, Security, Parameter mapping.
• Strong background in building Relational and Dimensional model in Framework manager.
• Proficiency in designing and developing different types of reports such as List, Cross-Tab, Drill-down, Sub reports and formatting them using IBM Cognos (Report Studio, Query Studio, Analysis Studio) by using filters customized prompts, conditional formatting,bursting, Master/detail queries, and HTML Scripting.
• Involved in designing and developing Reports, Work-spaces and Dashboards wif Area charts, Pie charts, Cross tabs and Multi-prompts in Report Studio and IBM Cognos Business Insight, testing, debugging/Validation, conducting UAT and Documentation (Unit Test Cases, Technical Design Document).
• Experience in Designing Transformer models and developing for corporate data for building Multidimensional Cubes (MOLAP/OLAP/ROLAP).
• Good exposure in Interacting wif Business users to get requirements, to fix issues or train users on ad-hoc reporting.
• Involvement in administration of Cognos packages and reports.
• Strong knowledge on Data Warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• Extensively worked on Relational databases like SQL server 2000/2005/2008, DB2, Oracle 11g/10g/9i, and MS Access.
• Having knowledge on ETL tools like Informatica and all Informatica Designer tools including (Source Analyser, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer).
• Involved in Extraction, Transformation, and Loading (ETL) Solutions using SQL server integration services (SSIS) and developing reports using SSRS and SSAS.
• Strong troubleshooting and production support skills and interaction abilities wif end users.
• Involved in projects making extensive use of Agile Methodologies, including Extreme Programming, Test-Driven Development and Scrum.
• Versatile, quick-learner, enthusiastic and project oriented team player wif excellent written, verbal communication, leadership and interpersonal skills to develop creative solutions for challenging client needs.
• Self-motivated and enjoy working in a technically challenging environment.
• Strong team player, able to interact and collaborate wif employees at all levels. Adapt easily to new concepts and cutting edge technology.

TECHNICAL SKILLS

BI Tools: IBM Cognos8.4 (Report Studio, Query Studio, Analysis Studio,Event Studio, Framework Manager, Transformer, Go Office, Administrator Cognos Connection), IBM Cognos10.1 (Report Studio, Query Studio, Analysis Studio, Framework Manager, Business Insight, Business Insight Advanced, Cognos Administrator,Cognos Connection), Informatica Power Center 8.6/8.1,Microsoft Business Intelligence - SQL Server Integration Services (SSIS) 2012, SQL Server Reporting Services (SSIS) 2012

Databases: MS SQL SERVER 2000/05/08, Oracle 8i/9i/10g

Version Control Tools: Subversion (SVN), Star Team,Visual Source Safe

Languages: SQL, PL/SQL

Operating Systems: Windows 2000/2003/ XP/ 2008, Windows 7

PROFESSIONAL EXPERIENCE

Confidential - Jersey City, NJ

Cognos Lead

Responsibilities:

• Provided technical direction in Cognos Development.
• Created Dashboards using Cognos workspace and Cognos report studio reports.
• Successfully managed and trouble shot numerous complex issues in teh Cognos environments.
• Worked as Lead Cognos Developer and mentored Offshore Cognos Team members.
• As a lead primary responsibility was to work wif onsite team, Interact wif client on teh specific requirements and get a clear understanding of teh requirements and present teh best solution.
• Assigned work to team member and ensured timely completion of work and accurate delivery of reports.
• Created User Groups and Roles by creating permissions in Cognos portal.
• Interacted wif Onshore team/client for better understanding of teh requirements.
• Gatheird and analyzed functional requirements from teh Business Users.
• Developed Framework Manager Model, keeping in sight teh best practices given by Cognos.
• Performed Unit testing of reports writing SQL statement at backend/DB and validating against Cognos report studio reports.
• Developed IBM Cognos Reports in Report Studio, Query studio and Analysis Studio
• Analyzing and providing solutions to teh various issues raised by Business users
• Responsible for delivering enhancements & change requests on time wif adherence to standard project life cycle
• Responsible for Creating Functional and Technical Specification Document and coordinating wif users and teh team
• Created Technical Design Documents and Unit Test Cases for End Users
• Responsible for writing SQL queries for QA,UA level testing
• Testing and reviewing teh application based on teh test cases
• Implementing Data level security and Scheduling teh reports for daily, weekly and monthly runs
• Support and maintenance of teh existing data warehouse setup

Environment: IBM Cognos 10.2, Framework Manager, Cognos Administrator & SQL Oracle Developer

Confidential, Detroit-MI

Sr. Cognos Developer

Responsibilities:

• Involved in gathering reporting requirements from end users.
• Involved in tracking effort and schedule of teh project understanding and participating teh planning activities Identifies risks and prepares mitigation plans.
• Strategy & Planning, Results Accountability Complete ownership of end to end project.
• Analyzing teh complexity of teh requirements and reframing them to get teh better clarity.
• Leading teh team by assigning teh work and accountability of results
• Conduct Weekly Status Meetings and Report Weekly Status to Client/Management.
• Created more TEMPthan 250 reports for various sectors i.e., Audits, Outstanding, Dealer Performance, Risk, Review
• Modified teh Cognos models for adding teh data elements using COGNOS Frame Work Manager.
• Involve in testing teh modified models in different environments.
• Played a key role while modifying existing reports to have a better view from teh point of end users.
• Involve in teh process of moving teh reports to productions through a specified process.
• Schedule teh reports to limited audience on a monthly, weekly and daily basis.
• Interact wif teh offshore team and assign teh work based on teh criticalities.

Environment: Cognos Report Studio, Event studio, Query Studio, Frame Work Manager.

Confidential, St. Louis, MO

Cognos Consultant

Responsibilities:

• Involved into business requirements and report specifications.
• Created relational and dimensional Framework Manager Models, packages, IQD files and configured them wif appropriate security.
• Created Transformer models, generated OLAP cubes and published them to teh Web portal.
• Developed various reports which include simple lists, cross tabs, charts, complex reports wif tables in them, conditional block, static choices in prompt etc.
• Expertise in creating reports by using Master Details, Drill through, Drill up and Drilldown.
• Expertise in developing Prompt pages and Cascaded input prompts.
• Expertise in using Query Studio for developing Ad hoc reports.
• Expertise in developing Dash Boards using Report Studio.
• Used joins to extract data from different tables.
• Created portal pages for various departments and assigned security to portal pages and reports in Cognos connection.
• Scheduled and distributed reports using Schedule Management in Cognos Connection.
• Created Dashboards to present critical company data in a single report.
• Performed comprehensive Unit testing by comparing teh Cognos reports against teh database using SQL by using Toad and documented teh same.
• Involved in designing of Test Plans, Test Cases, and Executed Test Cases.
• Involved in System and Integration testing as required to provide a Quality product.
• Training users to use teh Cognos Connection to access their corresponding reports.
• Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure teh completeness of batch processes, Scripts and processes.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Extensive use of Agile Methodologies, including test-Driven Development and Scrum.

Environment: Cognos 8.3/8.4 (Report Studio, Query Studio, Analysis Studio and Frame work manager), Cognos Go dashboard 8.4, PowerPlay Transformer 8.3, Toad 9.5, Oracle 10g

Confidential

Cognos Developer

Responsibilities:

• Designed teh Model according to teh Business Requirements by creating a Presentation Layer.
• Interaction wif teh Management and Development teams for gathering information for creating teh Framework Model.
• Involved in Data Modeling and published teh Model using Framework Manager.
• Worked extensively on creating teh Model and publishing teh package on Cognos Connection for Reporting purposes.
• Used conditional formatting and conditional blocks to display different sets of data based on different conditions in Report Studio.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Extensively worked on Query Studio for Ad-Hoc Reporting
• Created filters wifin teh Model for improving teh performance of teh Model.
• Developed Prompt pages and Conditional Variables.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Created Catalog in Impromptu Administrator to create Web Reports, Created Cubes by using Cognos Power Play for analysis.
• Optimized teh cube performance and teh report response time.
• Created Stored Procedures for Updating and Inserting data into teh database.

Environment: Cognos 8.0 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Cognos 7.0 (Power Play web, Transformer, Power Play Enterprise Server), Oracle 9i, MS SQL Server 2000, Windows 2000.

Confidential 

Cognos Developer

Responsibilities:

• Involved in data gathering and developing models in Framework Manager and publishing packages onto Cognos Connection.
• Created model query subjects, parameter maps and established relationships required between different model query subjects and between model query subjects and data source query subjects according to teh business needs.
• Deployed packages, folders and content store from a development environment to test and production environments.
• Extensively used prompts, master-detail query relationships and summaries, conditional formats, grouping and sorting features of ReportNet to generate efficient and user-friendly reports.
• Carried out Bursting of reports.
• Scheduled reports using Cognos Connection.
• Created Power Play multidimensional cubes using Power Play Transformer and created drill-through to ReportNet.
• Formatted data to analyze in drill mode and slice & dice mode.
• Responsible in teh weekly refresh of multiple multi-dimensional cubes.
• Worked on Cognos Security Administration to restrict teh Users.
• Maintain teh Cube Security by Category level and Dimension level.
• Used Cognos PowerPlay to Analyze, and display teh Cube in different types of Charts.
• Coordinated in training sessions and demonstration of Cognos tools to End-users.
• Assisted users in troubleshooting their reports.

Environment: Cognos ReportNet 1.1 MR2 (Report Studio, Query Studio, Framework Manager, Cognos Configuration, Cognos Connection), Cognos Power Play 7.2/7.3, Cognos Upfront 7.3, Power Play Enterprise Server 7.3, Power Play Transformer 7.2/7.3, Access Manager, Oracle 9i, Windows NT/2000, UNIX.