SUMMARY:

• Around 8 years of extensive experience in IT industry in the areas of analysis, design, development in client server environment. With focus on Data warehousing applications using Cognos with Oracle, SQL Server.
• Expertise in IBM Cognos series 11/10.2.2/10.2.1/10.1/8.4/7 (Report Studio, Workspace Advanced, Workspace Studio, Impromptu Administrator, Impromptu Web Reports, Power Play Web), (Framework Manager, Query Studio, Report Studio, and Cognos Connection)
• Expertise in FrameWork Manager for designing and developing models and publishing the package, Installation & configuration with a full project in Cognos 10/8.
• Expertise in version Up gradations of Cognos Reports from Impromptu to Cognos 10, Power play Cubes using Migration Utilities and mapping to corresponding metadata of Report Net and Cognos10.
• Worked on Security access to clients using Access Manager and worked with Data Access, Object Access, and Package Access in Frame Work Manager.
• Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Extensively worked on the ETL populating the data warehouse (OLAP) from the OLTP.
• Extensively worked on the migrating the crystal reports into Tableau and Cognos
• Extensive experience in Developing List, Cross Tab, Chart, Dynamic Reports and Drill Through Reports in Report Net & Cognos 10/8.
• Expertise in Developing Complex Reports and high impact dashboards using Report Studio in Cognos 10/8 BI Suite.
• Expert in Tableau 6.x/7.x/8.x/9.x (Desktop, Server, Mobile, Public), Tableau Desktop, Tableau Reader and Tableau Server and Experience including analysis, modeling, design, and development of Tableau reports and dashboards for analytics
• Experience in Data Analysis, Data Visualization and Business Intelligence in DWH in Client Server Technologies, Web - based Applications and Databases.
• Around 9 months of experience in developing different reports using Crystal Reports.
• ETL DataStage 10.x/9.x, IBM InfoSphere Information Server 9.1/8.7/8.5/8.1 using components like DataStage /Quality Stage Designer, Director and Administrator, Information Analyzer.
• Excellent Knowledge in Data modeling, Logical/Physical model & ER-Diagrams
• Excellent knowledge in data warehouse development life cycle, gathering requirements and analysis, dimensional modeling, metadata management and implementation of STAR, Snowflake schemas, Incremental loads/Change Data Capture and slowly changing dimensions
• Worked with heterogeneous data sources like Oracle, SQL Server 2005, Essbase, Sybase flat files, XML files, DB2 files.
• Extensively worked on tuning the SQL for faster data retrieval for both ETL and reporting.
• Extensively worked on PL/SQL as an ETL for populating the data warehouse and data marts.
• Worked extensively with ETL team for creation of the required tables and views for the Cognos reports. Have hands on experience on the IBM Data Stage tool.
• Strong experience with client interaction, understanding business applications, business data flow and data relations
• Good communication skills with strong ability to interact with end-users, customers, and team members

TECHNICAL SKILLS:

Business Intelligence Tools : Cognos 11/10.2.2,10.2.1,10.1/8.x, Report Studio, Active report Studio, Cognos Work Space, Cognos Work Space Advanced, Query Studio, Framework Manager, Analysis Studio, Metric Studio, Cognos EP 7 Series i.e Impromptu, Cognos Power Play, Cognos Transformer, Tableau

RDBMS: Oracle 12C,11G,10G, 9i/8i, 7.0, MS SQL Server 7/2000

Programming Languages : C, C++, SQL, PL/SQL Programming.

Web Technologies : HTML, ASP, XML, HTML 4.0, Front Page.

Data Modeling : Star Schema Modeling, Snow Flake Modeling, FACT Dimensions, Erwin, MS Visio

Operating Systems : Windows and Unix

PROFESSIONAL EXPERIENCE:

Confidential, Augusta, ME

Sr. Cognos Developer

Responsibilities:

• Involved in understanding existing Business Model and Customer requirements by participating in the Design Phase and user requirement gathering.
• Coordinated with the Business directly and built the TRD according to the Business requirement (BRD) and presented the walkthrough of the TRD to Business to make sure all the requirements are satisfied.
• Analyzing objectives processes and resources, and suggesting ways by which re-design, or improvements could be made by using business process modeling.
• Involved in modeling as for the user requirement using Framework Manager and also created models using different hierarchies.
• Created different data models using Framework manager for different business users. Created ad-hoc packages for reporting used by business.
• Created Metadata models using Framework Manager and published the packages to Cognos Connection.
• Built Framework Manager Model and established the cardinalities to suit the business needs.
• Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages to Cognos10 server.
• Deployed the packages to testing and production environments.
• Added Package level security to the packages and Object level security.
• Created reports having Filters, multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option for Bursting of reports.
• Developed complex reports like Drill Through and Dash Boards and Created reusable templates for developing reports.
• Implemented Conditional formatting for highlighting rows and columns and hiding individual rows.
• Used different types of Aggregate functions (including specialized calculated functions) to display detail and summarized values at different grouped levels.
• Used the Schedule Management in the Cognos connection to schedule the reports and scheduled to run the reports on a monthly, weekly and daily basis.
• Assisted users in resolving the issues using the Cognos Work Space advance. Resolved complex issues for the users in Report studio and Cognos Work Space.
• Created User groups, roles to implement the Cognos Security using LDAP.
• Created tickets in JIRA which is used to keep track of the issues/bugs and the required solution/fix.
• Extensive Knowledge on Cognos Architecture and implementation.
• Analysis of the performance issues in different environments like Dev, Test, Prod. Deployed the reports from one environment to another.
• Managing User ID’s and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Maintained Security at Query Subject as well as Query Item level for labor cost views.
• Migrated reports created in Cognos 10.1.1 to Cognos 10.2.2. This migration was handled on a report-by-report basis as the seamless migration resulted in a report feature conflicts between Cognos 10.1.1 and Cognos 10.2.2.
• Performed comprehensive Unit testing by comparing the Cognos reports against the database using SQL in Toad and documented the same.
• Created extremely big OLAP cubes using a Powerplay Transformer
• Extensively worked with tools like SQL developer.

Environment: : Cognos 11, 10.2.2,10.2.1/8.x (Report Studio, Active report Studio, Cognos Work Space, Cognos Work Space Advanced, Query Studio, Framework Manager, Analysis Studio), Tableau, ORACLE 11g, TOAD 12.6, Motio, JIRA .

Confidential, NYC, NY

Sr. Cognos Developer

Responsibilities:

• Involved in understanding existing Business Model and Customer requirements by participating in the Design Phase and user requirement gathering.
• Coordinated with the Business directly and built the TRD according to the Business requirement (BRD) and presented the walkthrough of the TRD to Business to make sure all the requirements are satisfied.
• Analyzing objectives processes and resources, and suggesting ways by which re-design, or improvements could be made by using business process modeling.
• Involved in modeling as for the user requirement using Framework Manager and also created models using different hierarchies.
• Created Metadata models using Framework Manager and published the packages to Cognos Connection.
• Built Framework Manager Model and established the cardinalities to suit the business needs.
• Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages to Cognos10 server.
• Deployed the packages to testing and production environments.
• Added Package level security to the packages and Object level security.
• Created reports having Filters, multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option for Bursting of reports.
• Developed complex reports like Drill Through hand Dash Boards and Created reusable templates for developing reports.
• Implemented Conditional formatting for highlighting rows and columns, and hiding individual rows.
• Used different types of Aggregate functions (including specialized calculated functions) to display detail and summarized values at different grouped levels.
• Used the Schedule Management in the Cognos connection to schedule the reports and scheduled to run the reports on a monthly, weekly and daily basis.
• Assisted users in resolving the issues using the Cognos Work Space advance. Resolved complex issues for the users in Report studio and Cognos Work Space.
• Created User groups, roles to implement the Cognos Security using LDAP.
• Installed, Configured Cognos8.4/10 on single and multi- server environments
• Extensive Knowledge on Cognos Architecture and implementation.
• Analysis of the performance issues in different environments like Dev, Test, Prod. Deployed the reports from one environment to another.
• Managing User ID’s and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Maintained Security at Query Subject as well as Query Item level for labor cost views.
• Migrated reports created in Cognos 8.4 to Cognos 10. This migration was handled on a report-by-report basis as the seamless migration resulted in a report feature conflicts between Cognos 8.4 and Cognos 10.
• Performed comprehensive Unit testing by comparing the Cognos reports against the database using sql in Toad and documented the same.
• Created extremely big OLAP cubes using a Poweplay Transformer
• Extensively worked with tools like SQL developer.
• Worked with the ETL team for creating the required tables, views for extracting the data for generating the reports. Have hands on experience on IBM Data Stage v9.1.

Environment: Cognos 10.2.2,10.2.1/8.x (Report Studio, Active report Studio, Cognos Work Space, Cognos Work Space Advanced, Query Studio, Framework Manager, Analysis Studio), ORACLE 10g, TOAD 9.1, IIS, Windows 2003 Server Transformer 10, SQL HTML, Cognos data manager, IBM Data Stage v9.1, Autosys, Erwin 4.0.

Confidential, Bridgewater, NJ

Cognos Developer

Responsibilities:

• Involved in understanding existing Business Model and Customer requirements by participating in the Design Phase and user requirement gathering.
• Analyzing objectives processes and resources, and suggesting ways by which re-design, or improvements could be made by using business process modeling.
• Designed mapping documents for source to target data sources.
• Involved in modeling as for the user requirement using Framework Manager and also created models using different hierarchies.
• Created Metadata models using Framework Manager and published the packages to Cognos Connection.
• Developed List, Cross Tab, Chart and Drill through Reports in Report Studio
• Created User groups, roles to implement the Cognos Security using LDAP.
• Managing User ID’s and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Used the Schedule Management in the Cognos connection to schedule the reports and scheduled to run the reports on a monthly, weekly and daily basis.
• Added Package level security to the packages and Object level security.
• Maintained Security at Query Subject as well as Query Item level for labor cost views.
• Used different types of Aggregate functions (including specialized calculated functions) to display detail and summarized values at different grouped levels.
• Migrated reports created in Cognos 8.4 into Cognos 10. This migration was handled on a report-by-report basis as the seamless migration resulted in a report feature conflicts between Impromptu and Cognos 8.4.
• Created reports having Filters, multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option for Bursting of reports.
• Developed complex reports like Drill Through hand Dash Boards and Created reusable templates for developing reports.
• Prepared technical specification document and turn over document to the administration.
• Extensively Used RAVE or Data Visualizations in the canned reports and Dashboards.
• Implemented Conditional formatting for highlighting rows and columns and hiding individual rows.
• Performed comprehensive Unit testing by comparing the Cognos reports against the database using sql in Toad and documented the same.
• Coordinated with other teams to resolve data related issues.
• Tracking jobs using IBM Data Stage 7.5.
• Deployed the packages to testing and production environments.
• Created O LAP cubes using a Powerplay Transformer and published the cubes on portal.
• Created analysis reports using analysis studio.
• Extensively worked with tools like SQL developer and TOAD.

Environment: Cognos 10 & 8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio), ORACLE 10g, TOAD 9.1, IIS, Windows 2003 Server Powerplay Transformer 7.4, SQL HTML, Cognos data manager, Informatica 8.5, Erwin 4.0.

Confidential

SQL Server Developer

Responsibilities:

• Understanding the requirement and technical direction of the programming from BAs and Architectures
• Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules
• Designed and implemented Stored Procedures and Triggers for automating tasks
• Managed all indexing, debugging, optimization and performance tuning using T-SQL
• Created and used complex stored procedures and views to store data of the clients and optimized stored procedure to improve its performance
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval
• Created UDFs, triggers to store data in appropriate tables and when data arrived, created indexes on least updated table to improve query performance
• Conducted optimization of queries and enhanced the performance of the database using SQL profiler
• Generated reports on account information, health insurance claims, annual reports of the company using ad-hoc reporting to be used by the company heads

Environment: MS SQL Server, SSRS, SSMS, T-SQL, Oracle, Access and Excel