SUMMARY:

• Proficient in Cognos version 8, 10, and 11 especially designing and formatting new and existing reports.
• Efficiently utilized various Cognos products to build high - end reports using different studios such as Query
• Studio, Report studio, Analysis studio, Event studio, Metric studio, workspace and workspace advanced.
• Proficient in building packages in framework manager, create TM1 cubes in performance modeler and power cubes in Transformer.
• Sound technical and functional expertise in BI, SQL, Oracle and the full development lifecycle.
• Fulfilled multiple roles within the project because of extensive technical, analytical and management skills as Well as the ability to multi-task.
• Experience in database, data warehousing, OLAP, MOLAP, ROLAP data, Star or Snowflake schema.
• Experienced in creating SQL queries and reports using Oracle database software.
• Provide customization of IBM Cognos Administration security settings.
• Extensively worked on Cognos applications, installation and troubleshooting the system.
• Frequently demonstrated hands on work experience performing requirement gathering, technical documentations and regularly meeting with business users.
• Have demonstrated sound business judgments, decisiveness, and well-developed planning, analytical, managerial, and communication skills at a consistently high level of performance in a variety of progressively more responsible and challenging assignments.
• Very well rounded individual with excellent communication skills. Ability to work independently, with less supervision, is proactive and deadline oriented across several tasks.

PROFESSIONAL EXPERIENCE:

Confidential, Fairfax, VA

Lead Cognos BI Developer

• Designed, developed and supported the overall Cognos reporting model by writing reports in Cognos 10 and Cognos Analytics (Cognos 11).
• Extensive hands on working experience developing reports using different types of sources such as Framework manager packages, IBM Cognos planning, Oracle 11, SAP, MS SharePoint, Oracle Apex and TM1 cubes as the data sources.
• Designed star and snowflake schema packages in Cognos framework manager.
• Architected the dimensional and relational models in Cognos framework manager.
• Sound technical experience in designing and developing Olap data cubes in TM1 and Transformer
• Developed cubes in TM1 Performance Modeler and Architect.
• Developed extremely complex reports using Report studio, Metric studio, and Query studio with a backend using TM1 dimensional cubes and DMR data packages. (I.E. Income Statement, Balance Sheet, Resume, Waterfall and Waterfall comparison, Rank reports, Top Count reports).
• Designed and developed complex dashboards for Executives which focused on using aggregate functions, Macro Token, tuple, exceptions, top-counts, Rank, and other various complex reports and charts.
• Setup complex Source report and target report and then provided drill-through from parent to child report
• Set up drill up-down report functionality and set up master detail relationships in reports.
• Migrated reports from Cognos 10.x to Cognos Analytics (Cognos 11).
• Developed complex Active reports that inherited dashboards, complex reports and data projections.
• Developed render variables, conditional styles style variables, page break, sections, calculations, slicers, filters, prompts, layout calculations, and visualization graphs in Reports.
• Extensive hands on experience administering and setting up the Cognos product security.
• Designed data warehousing structure such as, OLAP, Star schema and Snowflake Schema.
• Experienced SQL and Database concepts in a large (OLAP) dimensional data warehouse environment.
• Write & utilized very complex SQL scripts by using sql functions such as ( Select, Join, insert, delete, update, Group by, like and more)
• Created data set and data modules in Cognos Analytics.
• Collaborate with other developers to share Cognos knowledge and make sure we implement best practices.
• Ability to work independently with development and project management teams as well as communicated any defects which needed escalation.
• Scheduled report views, Reports and Dashboards to run on timely matter.
• Set Event jobs and schedule to run on weekly bases.
• Set security authentication in IBM Cognos based on Users, Groups, and Roles.
• Set security for Cognos Planning Models in the Contributor Administration.
• Design IBM Cognos Planning Models using the Cognos Planning tool, Set Libraries, D-Cubes, D-Lists, D-Item.
• Extract data from accounting Software to database based on ETL tools.
• Check and Troubleshoot Database and Servers.
• Lead & Managed Cognos team. Mentor staff and end users with assistance.
• Work directly with end users to develop and test new reports.
• Provided Cognos Analytics training to new Cognos developers and users.
• Worked independently and remotely.

Confidential

Cognos Developer

• IBM Cognos BI Administration, Reporting and Planning, Transformer Power-Cubes and framework modeler.
• Design Relational Models & Dimensional models in Framework Manager, Set relationships, Filters, and Formation.
• Generate Power-Cubes using the IBM Cognos Transformers and Set Dimensions/Hierarchies/Members.
• Design reports in IBM Cognos Report Studio, Metrics Studio, Query Studio, and Analysis Studio & Event Studio.
• Design dashboards in Report Studio. Design Scorecards/Matrix in Metrics Studio.
• Create Reports and graphs using the Power cubes.
• Set Drill Down/Up behavior on Reports.
• Create master detail relationships in reports and dashboards.
• Write SQL Queries using MS SQL Server 2005. Join Queries using Primary/Foreign Keys.
• Design IBM Cognos Planning Models using the Cognos Planning, Set Libraries, D-Cubes, D-Lists, D-Item.
• Design Source, target report and set the drill-through function.
• Setup Conditional styles, Render and Style variables in reports and dashboards.
• Set Event jobs and schedule to run on weekly bases.
• Set report Security, Page break, sectioning, Calculations, filters, prompts, and lock and unlock reports.
• Schedule single and multiple Reports and Dashboards to run on weekly bases.
• Set security authentication in IBM Cognos based on Users, Groups, and Roles.
• Set security for Cognos Planning Models in the Contributor Administration.
• Extract data from Accounting Software to database based on ETL tools.
• Check and Troubleshoot Database and Servers.
• Lead & Managed Cognos team. Mentor staff and end users with assistance.
• Work directly with end users to develop and test new reports.
• Work independently on new and existing Cognos projects.

Confidential

Cognos Report Developer

• Maintained IBM Cognos, Administration, Security, Installation, and Migration.
• Modeled and published packages in Framework Manager, and Cubes in transformer
• Designed and test reports using the Report Studio, Query Studio, Metric Studio, Event Studio and Analysis Studio.
• Designed List, Crosstab, Chart tab Reports for team and upper managers.
• Set up master detail relationships in reports and dashboards.
• Efficiently designed and built scorecards. Worked closely with other Cognos team members.
• Designed and maintained reports using the drill down/up.
• Built efficient Dimensional queries and set up Filter, Parameters, Value prompts and Tree Prompt.
• Setup Conditional styles, Render and Style variables in reports and dashboards.
• Created, Grouped, Sorted, Format, Filtered, and Calculated data in each Query.
• Used the Join, Union, except and Intersect reporting tools to create complex reports.
• Created new Cognos security groups and roles in Cognos Connection.
• Design Source, target report and set the drill-through function.
• Worked on SQL queries and reports in Teradata Oracle.
• Set Event jobs and schedule to run on weekly bases.
• Set report Security, Sections, Page Breaks, Calculations, filters, prompts and lock, unlock reports.
• Enhanced report performance. Create professional IBM Cognos reports.
• Gathered requirements from end users and developed reports and dashboards.
• Constantly worked in Dev, Testing and Prod environment.
• Worked with IBM Cognos team in India.

Confidential

Cognos Developer

• Efficiently worked on IBM Cognos, Administration, Installation, Migration and Set security.
• Designed and built new Star Schema and Snowflakes framework manager packages.
• Designed Power-Cubes in Transformers.
• Create, test, and deploy all reports in Report Studio, Ad-hoc Studio, Analysis Studio, Metric Studio, and Event Studio.
• Designed List, Crosstab, Charts and Maps in IBM Cognos to meet the business requirements for end users.
• Built Dashboards & scorecards in IBM Cognos.
• Generated Ad-Hoc reports and dashboards in Business Insight Advanced.
• Built drill-down and drill-through in reports.
• Setup Conditional styles, Render and Style variables in reports and dashboards.
• Created SQL reports and queries in Teradata, Oracle 9i and solved complex report Errors.
• Created standard filters, Parameters, calculation prompts, and conditions.
• Built high-end reports for upper management.
• Set report Security, Sections, Page Breaks, Calculations, filters, prompts and lock, unlock reports.
• Troubleshoot Debugging IBM Cognos performance issues as well as administrative Issues, Test all reports.
• Enhanced report performance. Create professional IBM Cognos reports.
• Gathered requirements from end users and developed reports and dashboards.
• Searched and solved complex report errors in all Cognos Studios.
• Worked in various OS environments using Linux, Unix, Cognos, Framework Manager, Oracle9i
• Provided training to other staff members and IT groups.
• Worked independently and as a team player.

TECHNICAL SKILLS:

• IBM Cognos Analytics (11)
• IBM Cognos 10
• IBM Cognos Administration
• IBM TM1 Performance Modeler cubes.
• IBM Cognos Planning
• IBM Cognos Framework Manager,
• IBM Cognos Business Insight (Advanced)
• Transformer Cubes
• Tableau
• Power BI
• Oracle Database v9i, 10g, 11g
• Oracle Application Express (APEX),
• Microsoft SQL Server,
• Crystal Reports,
• SAP, ETL, Great Plains, Peachtree, MS Share Point, Toad
• Visual Basic, MS Suite, IE, MS Office.