Cognos Developer
Resume:
Muhammad Choudri [pic]
*********@*****.***
CERTIFIED
Professional Summary:
. Over 5 years of experience in IT industry in all phases of software
development life cycle developing various Data Warehouse, Business
Intelligence applications and Client/Server applications.
. Over 4+ years of experience with Cognos 8 Business Intelligence Series
8.4.1/8.4/8.x Suite (Report Studio, Analysis Studio, Query Studio,
Framework Manager and Cognos Connection), Cognos Report Net 1.1 MR3,
Cognos EP Series 7.3(Impromptu, IWR, Power Play Transformer and Power
Play Windows/Web).
. Excellent understanding and hands-on experience of Extraction,
Transformation and Loading ETL of data into Data warehouse/Data Marts/
Online Data Stores using tools like Informatica and Data stage.
. Experience in Full Life Cycle Project Development, including design,
Development, testing and implementation and ongoing product support.
. Experience in working with various databases that include Oracle, SQL
Server Databases, DB2 and .
. Experience working with Oracle 11g/10g/9i/8i, SQL server databases on
UNIX, Linux and Windows enterprise platforms.
. Experience in OLTP/OLAP System Study, Analysis and E-R modeling,
developing Database Schemas like Star Schema and Snowflake Schema used
in relational, dimensional and multidimensional modeling.
. Experience in analyzing business needs and translate them into
technical specs and maintain the information flow in the team and
Created standard Lists reports and Cross-tab reports and Ad hoc
reports using Report Studio and Query Studio.
. Developed standard Reports and Templates, Dashboards, Master Detail
Reports, Bursting Reports and Multilingual Reports using Report Studio
and Query studio.
. Hands on experience in Unit Testing, System Testing, Functional
Testing, User Acceptance testing, and Testing Documentation.
. Expertise in installation and configuration of Cognos 8, Cognos Report
Net and EP 7 series suites.
. Strong design and programming technical skills, ability to learn new
emerging technologies and adapt quickly.
. Cognos 10, Active Reports, Workspace and Workspace Advance.
Education and Certification:
IBM Certified Designer - Cognos 8.4 BI Report Author
Testing ID: SR5681564
TECHNICAL SUMMARY:
BI Tools: Cognos Series 10/ 8.4/8.2 BI Suite(Framework Manager, Report
Studio, Query Studio, Analysis Studio, Metrics Studio), Cognos ReportNet
1.x Suite, Cognos Series 7.x Suite, Cognos PowerPlay Transformer
6.6/7.0/7.1, Impromptu Web Reports
ETL Tools: Decision Stream, Data Manager, Informatica PS 8. X/7. X/6 .x,
DTS, SSIS.
RDBMS: Maximo 6, Oracle 11g/10g/9i/8 .x, SQL Server7/2000/2005, DB2 and
Access.
Data Modeling Tools: TOAD 8.0/7.x, SQL *PLUS, iSQL*PLUS, Erwin, VSD Visio
soft diagram.
OS:UNIX, Windows 95/98/2000/XP/NT.
Languages: C++, C, SQL, MDX, PL/SQL, UNIX shell scripting.
Web-servers: Java Web Server, Apache Web Server, IIS 5.0, MTS, Web
Logic 7.0.
Operating System: UNIX, Windows 95/98/2000/XP/NT.
Project Experience:
Ceridian Payroll Minnesota: Nov 2014 to
Feb2015
Role: Cognos Developer
. Developed the model in Framework Manager which suits the Reporting
requirements.
. Involved in taking over the day to day support activities like updating
Fuel Surcharges and Cost files received from Logistic Service Providers
(LSP's) into a local MS access database which serves as an input into an
oracle database.
. Developed reports against DMR model and cubes.
. Dev Involved in gathering and analyzing business requirements.
. eloped Complex reports which involved Dashboards, complex drill through
and cross tab reports.
. Developed reports which involved in providing solutions to DWS like
Calculating Carbon emissions, Unit level data Quality reports, Gross
Weight and Cube issue Report and Lane Level Transit Time Reports.
. Used Conditional formatting to identify shipments exceeding the
specified Gross Weight and enabled drill through feature to identify more
details about the shipments.
. Created Complex, multipage reports using the reporting features like
Conditional Formatting, Conditional Page layout, Sections, page Breaks,
Master-detail, Drill Through, Drill Down, and Drill Up.
. Developed Dashboards to Provide high level shipment cost analysis and
Regional Report for top three countries in Region.
. Worked on list reports, cross-tab reports and chart reports using
multiple queries in a single report.
. Worked on improving the performance of the Query/Reports and used
optimizations techniques like Star-Query optimization.
. Scheduled the Reports Unit Level info and Transit Time Settings one
monthly and weekly basis.
. Deployed packages, folders and content store from a development
environment to test and to production environments.
. Implemented role based security to allow users to view reports and data
based on their login.
. Documented SOPs for updating Fuel Surcharges, Cost Files, Ship From and
Ship to and Exchange Daily Rates received from LSP's (Logistic Service
Providers).
. Trained end users on how to use Cognos Connection, Query Studio and
Analysis Studio.
Microport, Memphis, TN Dec 2012 -
Oct 2014
Role: Cognos Developer
. Closely worked with Data Analysts to get the complete knowledge of
the data and Data mart database design as part of gather requirements
and designing templates.
. Develop new Cognos reports and Dashboards (using workspace and
workspace advanced also known as business insight and business insight
advanced in older version) based on the requirement formulated by the
business owners
. Developed and published models using Framework Manager on to Cognos
Connection.
. Developed list, cross tab, nested cross tab, master-detail, chart and
complex reports which involved multiple prompts, filters,
calculations, multi - page, multi-query reports against multiple
databases.
. Involve in User interactive JAD sessions (Joint Application Design
sessions) to understand the exact requirement which serves their
business need.
. Support the existing Reports and Cubes in Production
. Involve in performance tuning of existing Cognos reports.
. Suggest Report enhancements of the existing reports which would
improve the readability of the reports to help the higher management
for faster decision making.
. Involve in User Acceptance Testing of the created reporting objects
. Provide user training on the various reports created as part of the
EDW Project.
. Work with the Client's infrastructure team to migrate the reports to
production servers
. Actively involved in Quality assurance activities related to Project
ensuring the delivery of quality process and adherence to client
standards
. Work with ETL Architects/Developers to design database objects
necessary for reporting needs.
. Create documentations of the reports and framework manager to be
maintained as part of the project artifacts.
Environment: Cognos 10.2, 10.1.1, Cognos 8.4 (Framework Manager,
Report Studio, Query Studio, Cognos Connection), Business insight/advanced, Workspace and workspace advanced, TM1,Oracle 9i, SQL Server 2005, Toad,
Windows 7.
UBS, Stamford, CT
July 2011 to Dec 2012
Role: Cognos Developer
UBS is one of the world's premier advisory and securities businesses, UBS
Investment Bank provides clients with expert advice, innovative solutions,
outstanding execution and comprehensive access to the world's capital
markets. The Project is to develop Financial Data Reporting for the
Investment Banking.
. Responsibilities:
. Developed technical specifications, data identification and also
recommendations on the preferred solution for development, and deploy
efficient BI solutions.
. Worked on technical design specifications for Framework manager, and
reporting per the requirements.
. Used Framework Manager to build projects, packages based on business
requirements and publish packages to the Cognos connection. Created
relational models and dimensional models in Framework manager according
to requirements.
. Designed projects in Framework manager based on two tier model (Physical
view and Presentation view). Improved long running reports performance
thru writing SQL queries, resolving complex joins in framework manager,
filters, and importing only necessary query subjects.
. Implemented package level security and object level security while
creating models in Framework manager.
. Designed & developed reports using Cognos 10.1.1 Report Studio, Query
Studio and Analysis Studio.
. Created various List Reports, Grouped Reports, Cross Tab Reports, Charts
and Drill- Through Reports using Conditional Formatting, multiple Prompts
and queries, Filters, Slicers, master-detail relationship, aggregation
function.
. Created reports in Analysis Studio by using cubes and multi dimension
models.
. Developed Dashboards Using Business Insight and Business Advanced Insight
and created Drill through reports from Dashboard to all summary reports
and Summary to Detail reports.
. Scheduled and distributed reports to the end users by schedule management
in Cognos connection. Implemented bursting and event trigger function
when it's needed.
. Analyzed the reports which are in SSRS format and implemented these
reports to Cognos Report Studio.
. Developed Cognos Portal integration & Cognos portal design.
. Customized Cognos Connection with appropriate reports and security
measures.
. Created user groups and roles in Cognos Connection and applied data
level and group level security for various entries.
. Provided technical assistance and training to Users.
Environment: Cognos 10.1.1 (Report Studio, Query Studio, Metric Studio,
Analysis Studio, Framework Manager, Cognos Connection, Transformer 8.4),
Informatica, PeopleSoft 8.9, Oracle 11g, SQL server 2008, SSRS, Apache
webserver, Windows XP and Unix.
GlaxoSmithKline, NC Sep '10 - June
2011
Role: Cognos Developer
GSK is a global pharmaceutical, biologics, vaccines and consumer healthcare
company headquartered in London, United Kingdom. The scope of the project
was to provide Reporting services for Distribution & Warehousing and Supply
chain management (DWS DWS have command and ownership of the technical
expertise and information to ensure the organization understands the supply
chain implications and maintains the optimum relationship between cost,
service, speed, and quality to support GSK's commercial ambition.
. Developed the model in Framework Manager which suits the Reporting
requirements.
. Involved in taking over the day to day support activities like updating
Fuel Surcharges and Cost files received from Logistic Service Providers
(LSP's) into a local MS access database which serves as an input into an
oracle database.
. Developed reports against DMR model and cubes.
. Dev Involved in gathering and analyzing business requirements.
. eloped Complex reports which involved Dashboards, complex drill through
and cross tab reports.
. Developed reports which involved in providing solutions to DWS like
Calculating Carbon emissions, Unit level data Quality reports, Gross
Weight and Cube issue Report and Lane Level Transit Time Reports.
. Used Conditional formatting to identify shipments exceeding the
specified Gross Weight and enabled drill through feature to identify more
details about the shipments.
. Created Complex, multipage reports using the reporting features like
Conditional Formatting, Conditional Page layout, Sections, page Breaks,
Master-detail, Drill Through, Drill Down, and Drill Up.
. Developed Dashboards to Provide high level shipment cost analysis and
Regional Report for top three countries in Region.
. Worked on list reports, cross-tab reports and chart reports using
multiple queries in a single report.
. Worked on improving the performance of the Query/Reports and used
optimizations techniques like Star-Query optimization.
. Scheduled the Reports Unit Level info and Transit Time Settings one
monthly and weekly basis.
. Deployed packages, folders and content store from a development
environment to test and to production environments.
. Implemented role based security to allow users to view reports and data
based on their login.
. Documented SOPs for updating Fuel Surcharges, Cost Files, Ship From and
Ship to and Exchange Daily Rates received from LSP's (Logistic Service
Providers).
. Trained end users on how to use Cognos Connection, Query Studio and
Analysis Studio.
Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio,
Analysis Studio), Access Manager, Cognos Power Play Transformer, Report net, Toad 8.5, Erwin,6, Oracle 11i, MS Access, MS Excel, Windows .
Contact this candidate