SUMMARY

• Over 9+ years of IT experience in Business Intelligence and DWH/Database Applications on multiple domains. Requirements management, Business Modeling and system design/analysis of various financial applications
• Expertise in Cognos Tools such as Cognos 8/10 Suite, Cognos TM1 9.5/10.1 and Analysis Tools such as Cognos Transformer & Power Play.
• IBM Cognos Certified professional with strong experience in designing and implementing complex BI solutions using IBM Cognos 10.2.1 / 8.4.
• Expert level with developing metadata models in Framework Manager following best practices.
• Expert levels with developing OLAP models, using Power Play Transformer. Extensive understanding of MDX functions in Report Studio using Multi - dimensional sources.
• Strong understanding of designing dimensional and relational models, star and snowflake schemas.
• Skilled at training users to use Query Studio, Analysis Studio and Cognos Business Insight and Business Insight Advanced
• Expert level in Cognos Server Administration and security tasks.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, reporting and monitoring capabilities of IDQ9.6.1.
• Ability to effectively communicate with various business groups to gather requirements and prepare functional and technical documents.
• Experience in SQL, PL/SQL and query optimization techniques.
• Excellent Knowledge in planning, creating and analyzing the general ledger, APAR, profitability, budgetary control, fixed assets and employee expenses reports.
• Good Knowledge on the industry’s practices of configuration management aligning with ITIL.
• Good Experience working on SQL queries in Teradata, Oracle and Microsoft SQL Server database.
• Proficiency in converting business requirements into a Technical Design document, SAS programs and SQL queries
• In depth knowledge in SDLC including Design, development and Release Management.
• Strong functional and technical analysis skills. Excellent team player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem solving skills.

TECHNICAL SKILLS

Domain Knowledge: Finance and Banking, Corporate, POS and Retail, Supply chain management.

Operating Systems: Unix and Windows.

RDBMS: MS SQL SERVER 2008/2005/2000 , Oracle8i/9i/12c, Teradata, MS Access.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, Query Editor, MS-Access.

ETL Tools: MS SQL Server Integration Services (SSIS),Informatica, Data Stage.

Reporting Tools: Cognos 8/10 Suite, SAP BO, OBIEE, Tibco Spot Fire, Tableau.

Data modeling Tools: Framework manager, Transformer, SSAS/SSIS

Programming Languages: Unix, VB, VB.Net, C, XHTML and XML.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh PA

Sr. Cognos Developer/Administrator

Responsibilities:

• Responsible for Development, Production and Administration of Cognos BI 10.2.2
• Responsible for understanding the end to end business process and user requirements. Worked with business users from different departments (Production, Midstream, Corporate) to collect the requirements.
• Involved in Analyzing the reports from SSRS, Tibco Spotfire and re-creating them in Cognos 10.2.2.
• Analyzed SSAS and Transformer cubes and created Materialized Views which are used as source across all the BI Platforms.
• Involved in the data modeling sessions to create views which will be the under lying source to create FM
• Involved in Development, testing, deployment and Scheduling of Cognos reports.
• Developed Adhoc and Canned reports using Cognos features like Page Breaks, Simple/complex calculation, conditions, Sections, ranking, sorting, and various prompts for creating BI reports.
• Created report templates which are used for the layout component reference to meet the business requirements.
• Worked on Cognos Workspace advanced creating complex dashboards.
• Mentor report developers and modelers on best practices and complex problems
• Prepared best practices documents for Framework Manager, Report Studio, Security and Deployments.

Environment: Cognos 10.2.2 Suite, (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace and Workspace advanced, XML, SSRS, SSAS, Tibco Sporfire, Informatica Power Center 9.0.1, Informatica Power Exchange, IDQ 9.5.1, HTML, Tera Data, SQL Server 2012

Confidential, Wilmington DE

Sr. Cognos Developer /Business & Mortgage Data Analyst

Responsibilities:

• Responsible for leading the offshore team in Agile Environment.
• Worked on system Migration initiative from the Legacy VLS/CMS systems to the new java technology based MSP systems. Expertise in capturing collection and recovery change request, ICAT and related life cycle management.
• Analyzed mortgage and consumer loan requirements, data needs and business Processes.
• Analyzed business data required to drive the mortgage and consumer loans - Home equity and Personal banking, Customer Payments and Promise-to-Pay transactions, Collections & Recovery, Foreclosures.
• Developed functional design documents relating to the new workflows to be built into the ICAT collections and recovery web application. The artifacts include process models, use cases, UML diagrams, Functions & Nonfunctional specifications, Feed & reporting data message mapping, systems & technical Specifications, Schema Definitions, Table structures and XML data tags.
• Responsible for understanding the end to end business process and user requirements
• Responsible for building mock up reports using external data sources like xls, txt based on business requirement.
• Involved in the data modeling sessions to create views which will be the under lying source to create FM
• Developed complex reports- Drill-Through Reports, Active Reports, Dashboard Reports, Master-Detail Reports, burst reports using Report Studio.
• Developed Adhoc and Canned reports using cognos features like Page Breaks, Simple/complex calculation, conditions, Sections, ranking, sorting, and various prompts for creating BI reports.
• Created reports with conditional formatting using Cognos variables such as Text source variable, Style variable, Block variable, and Render variable.
• Created report templates which are used for the layout component reference to meet the business requirements.
• Involved in Development, testing, deployment and Scheduling of Cognos reports.
• Worked on Cognos Workspace advanced creating complex dashboards.
• Mentor report developers and modelers on best practices and complex problems
• Prepared best practices documents for Framework Manager, Report Studio, Security and Deployments.
• Worked on resolving the Performance issues of the Cognos reports and testing the reports against the manual SQL’s based on BRD’s.
• Involved in development and maintenance of Cubes in Cognos Cube Designer.

Environment: Cognos 10.2.2 Suite, (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric studio Cognos Office Connection) XML, Cognos Analytics (Version 11), IDQ 8.5.1, HTML, Tera Data, Cognos Workspace and Workspace advanced.

Confidential,‎ Seattle WA

Sr BI Developer/Framework Modeler

Responsibilities:

• Designed complex Relational/DMR framework manager models for Forecast using all the best practices.
• Implement data level security in all the FM models using the security table and macros. Implemented Object Level Security based on AD Groups.
• Involved in cognos prod support, Monitored Cognos jobs (Views Refresh) and performed trouble shooting.
• Developed complex reports, Charts, conditional formatting, block variables, Master- Detail relationships, Multi page.
• Worked extensively on Active reports and developed various dashboards using cognos 10.1 report studio.
• Responsible for developing the Cognos 10.1 analysis studio reports, query studio templates, report studio reports using tree prompts, value prompts, cascading prompts, drill up and drill down, advanced charts etc.
• Worked very closely with database team to analyze the requirements and implemented best practices with the DB team.
• Developing the Dashboards using Business Insight and Business Insight Advanced.
• Developed knowledge transfer documentation on various levels of the project phases.
• Involved in deploying a pre-built and pre-populated demo environment onto the client Infrastructure with applications like Oracle Financial Analysis, Oracle Procurement and Spending Analysis, Human Resource Analysis, Student Information Analysis
• Analyzed the reports Picked by the users from the list of Oracle delivered Financial GL reports.
• Generated Erwin Diagrams for the limited set of OBIEE tables needed for the list of the reports
• Generated Cognos Framework Manager models and Developed reports to replicate the list of reports selected from OBIE
• Involved in selecting the list of reports from OBIA and the reports are ported to Cognos for a demo from Cognos.

Environment: Cognos 10.1.1 suite (Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Active Reports, Cognos Connection, Cognos Configuration, Access Manager), Power play Transformer, Oracle Business Intelligence applications 11.1, Toad, DB Visualizer 8.0.4.

Confidential, Montvale NJ

Sr Cognos Developer/Administrator

Responsibilities:

• Worked closely with business analysts and end users to analyze the business process and user requirements to cater their needs for reports.
• Worked on Report studio and Analysis Studio to develop reports having multiple dimensions like time dimension, cost center, revenue, locations, etc. for analysis purpose to be used by the top management.
• Worked on the Key Financial Reports summarizes Income and Expense related activities based On Prior Period End Balance, Current Period Activity, and End Balance of the Current Period providing a basis for users
• Developed complex reports- Conditional Block Reports, Drill-Through Reports, Advance Sorting Reports, Active Reports, Dashboard Reports, Master-Detail Reports, burst reports using Report Studio.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Involved in Development, testing, deployment and Scheduling of Cognos reports.
• Worked on resolving the Performance issues of the Cognos reports and increased the performance of the reports by tuning SQL.
• COGNOS Administration for Data Warehouse Portal, Group Security, Reports, Cube definition, Cognos Workspace, Cognos Workspace Advanced, Cognos Insight.
• Involved in Installing, configuring, and upgrading Cognos software, including setting up load balancing for Cognos Environment FROM 10.2.1 to 10.2.2 FP3
• Upgrading the audit database tables using the SQL Scripts
• Involved in development and maintenance of Cubes in Cognos Transformer

Environment: Cognos 8.4 Suite, (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric studio Cognos Office Connection) XML, HTML, UNIX, DB2, SQL server 2008 R2

Confidential, Dublin, OH.

Sr Cognos Developer

Responsibilities:

• Involved in the complete installation and configuration of all the suites of Cognos 10.1 BI products and setting up Content store database, Active directory configuration
• Provided Production support through problem analysis and resolution to correct deficiencies
• Tracked the weekly bug or issue report updates from the developers in the form of the QA Error Log
• Creating Framework models to support complex financial reporting requirements.
• Built the Company sales dashboard to provide high level overview of current spend metrics by agency, location and position.
• Created custom scripts to automate regular cognos maintenance activities.
• Performance tuning of reports and SQL tuning.
• Modify Framework package and reports to better support the Cognos production environment.
• Developed Framework Models, Reports and Stored Procedures as per the Technical Design documents
• Responsible for various tasks including user communication, follow ups, reports and Power cubes development, testing
• Developed Multi-Dimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos 10.1
• Created different Dashboards in report studio using combination of List, Cross tab, and Graph and Map reports.
• Created Turbo Integrator processes to load the data and to save them in the respective cube
• Maintained Cognos TM1 database, monthly internal reporting activities, monthly & annual both forecasting activities and budgeting activities.
• Extracted data from the SQL database Transform and Load the data in to Cognos TM1 through TI Processes

Environment: Cognos 10.2, Cognos 8.4 Suite, (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric studio Cognos Office Connection) Transformer 8.4, Cognos TM1 9.5, Java script, XML, HTML, Oracle 11g, SQL server 2008 R2

Confidential

Cognos Developer

Responsibilities:

• Interacted with team members to transform the business specification into technical requirements.
• Involved in logical, physical and relational modeling of data as per the information available in the organization.
• Involved in creating models and packages in Framework Manager.
• Wrote SQL Queries and Procedures to simplify some of the jobs.
• Developed List, Crosstab, Drill-through, Master-Detail, Charts and complex reports which involved Multiple Prompts, Filters, Pages, Multi-Queries against multiple databases using Report Studio.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created standard and Ad-hoc reports using Cognos Query Studio.
• Implemented security for the developed Models, Data and Packages
• Involved in various stages like Development, System Analysis and Design.
• Involved in optimizing SQL Queries for performance tuning.
• Created users and applied user level security to the data.
• Developed/Modified scripts to create tables, views and executed them using SQL Plus.
• Involved in troubleshooting and fine-tuning of databases for its performance and high availability.

Environment: Cognos Report net 1.1, Impromptu 7.3, Transformer 7.3, Upfront, Oracle 9i, MS SQL Server 2000/2005