SUMMARY:

• Around Seven years of experience in IT Industry with strong background in analysis, design, development, Administration, testing, documentation and implementation of Applications in building data warehousing solutions using Cognos Analytics 11.x, Cognos 10.2.2/ 10.2.1/ 10.1/ 8.4/ 8.3/ 8. x Suite/7.0 (Report Studio, Active Reports, Query Studio, Analysis Studio, Business Insight, Framework Manager, Cognos Connection, Power play, Transformer).
• Data modelling experience using Cognos Analytics 11.x Framework Manager with concepts of Star Schema/Snowflake modelling, FACT & Dimensions tables and Logical & Physical data modelling.
• Expertise in Cognos 10/8 BI Suite (Framework Manager, Cognos connection, Report Studio, Business insight, Business insight advanced, Event Studio and Query Studio).
• Expert in using SQL for various data sources (like Oracle, SQL server) in development of reports, analyzing data in tables, cardinality between tables and joining tables.
• Good experience in relational, dimensional (DMR) and DQM (Dynamic query mode) modeling in Framework Manager.
• Hands on Experience with Framework Manager Modelling (Physical Layer, Logical Layer and Business Layer, Packages) and Complex Reports (List, Cross tab, Charts, Maps, Drill - through, Master-Detail, Active and Cascading) and Dashboards building with Report Studio.
• Experience in developing procedures, packages and functions in Data Warehousing environment and to use them in creating models in FM.
• Expert level with developing OLAP models using Power play Transformer, DMR models in Framework Manager, Multidimensional reports using MDX Functions in Report Studio.
• Experience in Software Development Life Cycle (SDLC) including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle
• Experience transforming raw data into actionable strategic knowledge to gain insight into business processes, and thereby guide and help businesses in their decision-making and run efficiently . Extensive experience in in-depth data analysis on different data bases and structures.
• Strong knowledge in writing SQL and PL\SQL Queries, Dynamic-queries, sub-queries and complex joins. Strong experience in Data Profiling very large data sets to identify system behavior.
• Extensively worked on building prompts and prompt pages using Java Script.
• Worked as a team member to assist in the transition from Crystal Reports to Cognos and Cognos to Tableau Visualizations
• Experience in deploying packages from one environment to other.
• Experienced with Multiple Relational Databases including Oracle10g, MS SQL Server 2005/2000.
• Excellent Team Player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem-solving skills.

TECHNICAL SKILLS:

Reporting Tools: Cognos 10.2.1(Report Studio, Workspace Advanced), Cognos 10.1.1 (Report Studio, Cognos Connection, Active reports, Business insightBusiness insight advanced), Cognos 8.1/8.2/8.3/8.4 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio).

ETL: Informatica designer, Data Stage.

Databases: Oracle 8i/9i/10g/11g/12c, PL/SQL, SQL Server 2000/5.0

Operating Systems: Windows 2003 Enterprise Server, XP, Windows 2000, Windows 7,8,10,LINUX

Servers: Application Servers (WAS, Tomcat), IIS server.

PROFESSIONAL EXPERIENCE:

Cognos Developer/Admin

Confidential, DFW, TX

• Involved in the entire life cycle of the project gathering Functional Specifications, Data Definitions, Source to Target Mapping, Data Validation, and Solution Validations
• Assisted in recent Migration of existing reports and visualizations from Cognos 10 to Cognos 11 Analytics
• Designed and developed Training data metadata models, transformer model and packages using transformer and Framework Manager respectively.
• Developed Infographic summary easily visualize data utilizing the built-in shapes available in dashboards in Cognos Analytics 11.0.4
• Implemented Data Level Security, Object Level Security and Package Level Security
• Created Multidimensional reports (Drill-Up Drill-Down) by implementing Multi-Dimensional Cubes using Transformer.
• Created complex reports such as Customer Invoice, Table of Contents, Bookmark, Product Analysis and Multi-Prompt and Multi page reports
• Designed and developed a portal page for dashboards and reports using portal functionality.
• Deploying the Reports, Packages & dashboards from testing environment to production environment.
• Applied Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports & dashboards.
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, master-detail, charts, various calculations and joins using tabular sets and tabular models
• Responsible in creating Active Reports and conversion of existing reports to an Active Report in Cognos using Report Studio.
• Training end users to effectively use the reporting tool to build and customize their Cognos Workspace and Cognos Workspace Advanced reports
• Implemented prompt validation and added various functionalities to prompt pages using JavaScript.
• Worked with advanced BI tool topics such as complex calculations, table calculations, geographic mapping, data blending and optimization of data extracts. Design, develop and optimize workbooks for Senior leaders
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Hands on experience with Cognos solutions using Framework Manager and Cognos Cube Designer and Report Studio
• Closely worked with ETL team to extract the relevant data from OLTP by understanding user requirements
• Strong understanding of database & SQL. Experience with improving query performance and analyzing Cognos Query and Native Query. Create SQL queries against Oracle/SQL Server for data profiling, troubleshooting and tactical ad hoc reporting.

Environment: Cognos 11 analytics/ Cognos 10.2 BI (Framework Manager, Report Studio, Workspace, Cognos Workspace Advanced, Query Studio, Analysis Studio, Cognos Connection, Active Reports, Power Play Transformer, Tableau BI 10, Oracle PL/SQL, MS Access

BI Developer/SQL Developer

Confidential, Maryland Heights, MO

• Hosted, participated in meetings, working with users to understanding the business requirement.
• Creating Business Design document (functional document) and Business Analysis document (Technical requirement), get approvals from the business for development of the report.
• Creating Framework models and updating models to support enhancements or based on the client requirements. Publishing the package.
• Developing Cognos reports as per the user requirements .
• Performance Tuning of reports and Framework models.
• Working on defects, enhancements, compliance tickets with strict deadlines.
• Writing complex SQL queries for adhoc reporting-creating tables, indexes.
• Assisting customers in extracting and analyzing large complex data.
• Updating the DBA team on any data conversion issues and bad data.
• Validating, Debugging and troubleshooting the reports and the SQL.
• Coordinating with Cognos admin and Change Control team in deploying Cognos folders and Reports from a development environment to Testing and Production environment.
• Updating windows batch files and moving FTP’d files to shared drive.
• Worked and validated the reports on database objects like Queries, joins to test and review the data integrity between Cognos and Oracle database
• Create batch jobs, scheduling, bursting of reports in Cognos connection.
• Creating customized reports and enhancement as per the requirement.
• Developing test scenarios, test cases, test data to be used in testing based on business and user requirements.
• Creating Development checklist for Quality Assurance before delivering to the end users.
• Understanding and documenting Root cause analysis (RCA) of the defects.
• Coordinating with off-site team and assisting other team members.

Environment: Cognos 10.2.1, Oracle 11g/12c Database, SQL Developer 3.2.2, Windows 7 Professional, HP ALM - Quality Center 11.00, Cognos Framework, Cognos Transformer, Share point, Control-M.

Cognos Developer

Confidential, Washington, DC

• Gathering the Report requirements from the Users to Design the FM Model and developing the Dashboards, Cubes and Complex reports.
• Designed the Dashboard Templates and Created Various Dashboard reports for the Business Users.
• Design the Model for Different Business Areas and analyzing the indexes and Keys and creating star schema.
• Participating in the User meetings to analyze and prepare the reporting and analysis requirements of users.
• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Powerplay Models.
• Created a Framework Manager Models with Multiple Namespaces.
• Created a Framework Manager Models with calculated columns, filters and Macros from different data source and created packages to suit the reporting needs of the client.
• Created dimension views and Custom views to implement the data security in the Powerplay Transformer Model.
• Involved in installation Cognos 8.4 Suite on UNIX and Windows.
• Created Multiple Power cubes from Single Model.
• Created Dashboard reports from the OLAP source.
• Implemented the Dashboard reports with the various Cognos Dimensional Functions.
• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting using the Rendering and Conditional Variables.
• Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, Tree prompt, date prompt, type in, cascading prompt, Select & Search Prompt and using conditional formatting as well.
• Created Powerplay cubes using multiple data sources, which are retrieved by Cognos Packages and Reports.
• Extensively worked on the OLAP Data source Reports.
• Created UNIX shell scripts for atomization of the Cubes Refresh using the Crontab on the Cognos AIX Server.
• Involved in Performance Tuning of the reports.
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Involved in the Cognos Administration like creating new Data source Connections and Creating Packages, handling the Deployment of reports copying from Development to Production server and also handling the user permissions on the Packages and Folders.
• Collecting and sharing best practices and tips in Framework Manager modeling, security setup, Report Authoring, Stress testing and Performance tuning.
• Addressing the Performance and other Production issues with the Cognos 8 reports and Powerplay cubes.
• Created various SQL for the test cases and also used some User-Defined SQL’s In Framework Manager.
• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.

Environment: Cognos 8.4/8.3, (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Powerplay Studio), Cognos 8.4 Transformer, Cognos 8.1.1, Business Glossary, SDK, Data stage 6.0, Oracle 10g, SQL Server, TOAD, AIX, Windows 2000/2003/XP.

Cognos Developer

Confidential, VA

• Developed multiple Metadata Models in Framework Manager relational and DMR models and deployed packages
• Closely worked with ETL team to extract the relevant data from OLTP by understanding user requirements
• Modified existing Cubes to comply with changes in the Requirements
• Implemented Data Level Security, Object Level Security and Package Level Security
• Designed and developed adhoc reports in query studio and standard reports in report studio.
• Created Multidimensional reports (Drill-Up Drill-Down) by implementing Multi-Dimensional Cubes using Transformer.
• Created complex reports such as Customer Invoice, Table of Contents, Bookmark, Product Analysis and Multi-Prompt and Multi page reports
• Designed and developed a portal page for dashboards and reports using portal functionality.
• Deploying the Reports, Packages & dashboards from testing environment to production environment.
• Applied Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports & dashboards.
• Implemented prompt validation and added various functionalities to prompt pages using JavaScript.
• Created commonly used calculations, filters and prompts in framework manager and user defined functions, procedures and packages at the database level as per the requirements.
• Prepared best practices documentation for Cognos applications
• Performed unit testing and functional testing to finalize the developed reports

Environment: Cognos10.2 & 8.4.1 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Active Reports, PowerPlay Transformer, DB2, Oracle PL/SQL, MS Access

Cognos Developer

Confidential

• Built the metadata models using Framework Manager to best suit the Business Requirements for Supplier Management, Brokerage and Transportation Modules.
• Created multi-dimensional cubes using Transformer for analysis.
• Created standard report template for each business module.
• Created most commonly used calculations and filters in framework manager and organized metadata into different namespaces, query subjects and folders in business view.
• Created ad-hoc reports in Query Studio and Standard Reports in Report Studio.
• Implemented prompt validation and added various functionalities like multi-select auto submit prompts, check box and radio button prompts (for better display) etc., to prompt pages using JavaScript.
• Scheduled reports, maintained public and individual folders, created users, groups and roles in Cognos Connection.
• Created complex reports using tabular sets and master-detail queries.
• Provided data security, object security and package access in Framework Manager. And also secured the folders by setting up access permission in Cognos Connection.
• Implemented cube security by using dimension views and user class views/customs views.
• Implemented complex report logic by writing SQL queries and creating stored procedures in the database.

Environment: Cognos 8.2 /8.4 (Framework Manager, Report Studio, Query, Schedule Manager, Access Manager), Data stage, Oracle 9i/10g, PL/SQL, Db2, Microsoft Excel, Unix and Windows Server 2003.

Cognos Developer

Confidential

• Analyzed & defined customer requirements/ specifications and offered solutions to fit the customer’s need.
• Applied appropriate client/database server balancing for the reports.
• Created User Classes that reflects the business hierarchy and provided security.
• Designed Catalogs, Reports and IQDs using Impromptu Administrator.
• Created standard filters, calculation, prompts, and conditions.
• Published reports to the upfront web portal to provide accessibility to the staff.
• Created cascading prompts in Impromptu reports to help users refine their search.
• Created Drill-Through reports to provide users with more detailed information.
• Published Impromptu Web Reports using Distribution Shuttle Builder created posting folders, plp file to NT server.
• Published cubes and power play reports to UPFRONT through PPES administration.
• Trouble shoot and evaluated report effectiveness by tuning query data’s and controlling user access.
• Participated in architectural review and revised (working closely with the clients) requirements to reflect technical feasibility of desired features.
• Prepared workshop manuals for users.

Environment : Cognos (Impromptu, Power Play, Upfront, IWR), MS SQL Server, MS Excel, MS Visio, Windows.