SUMMARY:

• Over 10 years of IT experience in Data Warehousing technologies, Requirement and Data Analysis, Requirements Gathering, Application Design and Development.
• Excellent knowledge and 8 years of working experience with Cognos Tools (Cognos 11.x/10.x/ 8.4.1/8.4/8.3/8.2/8.1 Report Net, Powerplay Transformer, PowerPlay, Impromptu, IWR, Powerplay web).
• Over 3 years of experience on Tableau 10.x/9.x with Tableau Desktop/Server.
• Experience in Installation, Configuration and administration of Tableau Server in a multi - server and multi-tier environment. Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from (Tableau 9.x to 10.x).
• Experience on Cognos 11.x/10.x/8.x with Framework Manager, Analysis Studio, Cognos Connection, Report Studio, Query Studio.
• Expert in creating publishing packages in the Framework Manager from various data sources in Cognos.
• Generated various kinds of reports, end user dashboards, created templates, multilingual reports and complex books containing large number discrete reports using Cognos.
• Expert in creating complex reports using Java Script in Cognos Report Studio.
• Expert in creating Dash Board Reports using Cognos Go Dashboard.
• Expert in Cognos SDK and integration with Portal.
• Expert in design and development of various dashboards/ reports utilizing Tableau advance visualizations like Bars (Horizontal, Stacked, Side by Side), Lines (Continuous, discrete), Bullet Graphs, Scatter Plots, Circle Views, Pie-Charts, Packed Bubbles, Funnel Charts, Geographic Maps (Symbol, Filled) to represent different datasets.
• Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Solid understanding of data warehousing, OLTP and OLAP concepts. Performed data extracts.
• Expertise in Data Warehousing and Data Modeling.
• Working knowledge of designing multidimensional architecture for Extract, Transform and Load environment with Informatica.
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Good team player with excellent communication skills, analytical and learning new technologies.
• Experienced in Data Mining, Multidimensional Data Analysis using Power Cubes.
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them. Experience in assisting with help desk related issues and assisting users with advanced reporting
• Created various daily monitoring reports for the Informatica ETL processes to be delivered to management
• Supported loading of payroll data using developed Informatica ETL scripts
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/NT, MS DOS and UNIX (Linux, AIX, HP-UX, Solaris)

BI/Reporting: Tableau 10.x/9.x, Cognos 11.x/10.x/ 8.4.1/8.4/8.3/8.2/8.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio), Report Net, Cognos SDK, Cognos EP Series 7 (Cognos Impromptu, Cognos Power play, Cognos Visualizer, Access Manager, Impromptu Web reports (IWR), Cognos IWR administration), Erwin 3.5/3.5.2, DTS (Data Transformation Server), Crystal reports XI/ 10/9.0/8.0/8.5/5.0, Brio Intelligence 5.0

Languages: C, C++, SQL, SQL*Loader, PL/SQL, UNIX Shell ScriptsJava2.0, Perl5, HTML, DHTML, XML, XSLT

Web Technologies: Visual Studio, Visual Source Safe, ASP, COM, DCOM, COM+ and RMI, Cognos Enterprise Server, IIS 8.0/7.0, PWS, MTS, MSMQ, Apache, Tomcat

Databases: Oracle 7.x/8.x/8i/9i/10g/11g/12c, MS Access, MS SQL Server6.5/7/2000, DB2, Sybase and Teradata v2 R4, DB2UDB

ETL: Informatica Power Mart 5.1/ 4.7, Power Centre 9.6.1/9.1/5.1/4.7

PROFESSIONAL EXPERIENCE:

Confidential

Senior Cognos/Tableau Developer

Responsibilities:

• Interacting with the users for understanding of Data Analysis and gathering business requirements.
• Developed Relational Data models and Dimensional Data models using Framework Manager to represent the business information.
• Developed Relational Data model and Dimensional Data model in Framework Manager using Essbase Cube.
• Upgraded the environment from Cognos 8.4.to Cognos 10.1 and Cognos 10.1 to Cognos 11.x.
• Developed User Groups, Roles in Cognos Connection to implement the Security Filters in Framework Manager Model.
• Maintained and supported current or new enhancements as necessitated by the users, DC council or legally mandated for existing or new applications.
• Provided support for the users in creation of reports using Report Studio.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Developed Ad-Hoc reports using Query Studio.
• Developed Variables for Complex Formatting Reports.
• Developed cascading prompts in Report Studio to help users refine their search.
• Involved in Admin Tasks Like Maintaining Portal, Assigning Securities, Scheduling Reports
• Involved in improving the performance of the Reports for this involved in creating Indexes and views.
• Developed dashboard reports, which will provide Capital Budget Information and Operating Budget Summary for Agency using Cognos Go Dash Board.
• Developed dashboards using Cognos Analytics.
• Developed reports for Oracle Financials.
• Developed Hyperion planning reports in Cognos.
• Developed OCFO Automated Budget Chapters, Operating and Capital Budget book using Cognos Report studio.
• Developed Cube for Capital Budget using Powerplay Transformer.
• Developed Analysis Studio Reports and cubes using Analysis Studio.
• Developed Customize and Burst Reports using Report Studio.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Developed reports using Cognos SDK and integration with Portal.
• Developed Complex reports using Java Script in Report Studio.
• Involved into move to Deployment to UAT and Production.
• Created Events using Event Studio.
• Scheduled reports, maintained public and individual folders, user groups and roles using Cognos Connection.
• Involved loading files into tables using Informatica (ETL).
• Upgraded the environment from Tableau 9.x to Tableau 10.x in QA and Production.
• Created Budget Execution and Operating and Capital Budget Formulation dashboards using Tableau 10.x/9. x.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Advanced Tableau experience from dashboard design and development. Expertise with use of action filters, user filters, advanced navigation techniques, complex Level-of- Detail (LOD) expressions.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Managed Tableau ‘s application security integrating with Active Directory and SAML.
• Set up projects/workbook security by using groups, roles and permissions in Tableau Server.
• Integration of Tableau reports with Asp.Net web applications and usage of JavaScript API for performance improvement.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Involved in testing the Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Supported day to day-basic reporting systems, which will include help desk issues, end user support.

Environment: Cognos 11.x/ 10.2.1/10.1/8.4.1/8.4 BI (Framework Manager, Report Studio, Event Studio, Query Studio, Analysis Studio), Tableau Desktop 10.x/9.x, Tableau Server, Cognos Transformer, Cognos Power Play, Cognos SDK, Java, J2EE, HTML, Web Services, Informatica 9.6.1/9.1, Hyperion, Essbase, Oracle 12c/11g, Toad, Visual Studio, Perl, Windows 2016/2000

Confidential, Minnetonka, MN

Senior Cognos Developer

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, develop, testing, deployment and user training of analytical &transactional reporting system.
• Upgraded the environment from Cognos 8.3 to Cognos 8.4
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Design and Developed the Framework Manager models and Published into server.
• Setting Data and Object security, giving access permission to objects and Packages. Created folders, Embedded and Standalone filters, prompts and complex calculations in Framework Manager.
• Created User Groups, Roles in Cognos Connection to implement the Security Filters in Framework Manager Model.
• Created Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Created Complex Reports using Report Studio.
• Created Variables for Complex Formatting Reports.
• Created cascading prompts in Report Studio to help users refine their search.
• Created dashboards reports, which will provide Asset Class Name for each Portfolio on Deal Names.
• Produced Queries and Reports in Multiple Languages, Format, Present and Distribute Reports utilizing Different Layouts, Multiple Report Objects and Multiple Logical Pages.
• Scheduled reports, maintained public and individual folders, user groups and roles using Cognos Connection in Report Studio.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Created Events using Event Studio.
• Customize reports using Cognos SDK and integration with Portal.
• Involved into move to Deployment to UAT and Production.
• Scheduled reports in Cognos Connection (Web Portal), Organized the folders for user convenience.

Environment: Cognos 8.4/8.3 BI (Framework Manager, Report Studio, Event Studio, Query Studio), Cognos Transformer, Cognos Power Play, Cognos SDK, Oracle 10g, Toad, Toad for Data Analytics (2.0), SqlServer 2000/2005, Windows NT/2000

Confidential, Topeka , KS

Senior Cognos developer

Responsibilities:

• Interacting with the users for understanding of Data Analysis and gathering business requirements.
• Prepared all the required documents for Cognos objects like design documents, unit test plan documents.
• Imported data from Heterogeneous Databases based in SQL Server 2005, DB2 UDB and Oracle.
• Presented proof of concept to demonstrate that heterogeneous data sources can be used in Cognos.
• Developed Framework Manager Model to integrate data from Oracle, SQL Server and DB2 UDB in a single model.
• Performed model refinement from time to time to enhance performance by incorporating lookup tables to avoid CASE and DECODE statements used at Framework Manager Level.
• Involved in defining mappings to build the Framework Manager Model and Package with customized Query Subjects and Query items and published package from Framework Manager to Cognos Connection.
• Created folders, filters, prompts, and complex business calculations in Framework Manager Model.
• Expertise in developing Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Created Ad-hoc reports in Query Studio for users.
• Developed dashboards reports for Complaints and Replacements for Policies on daily basis.
• Scheduled reports, maintained public and individual folders, user groups and roles using Cognos Connection in Report Studio.
• Extensively worked on Performance tuning, Testing and validating the data in Cognos.

Environment: Cognos 8.3/8.2 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio), Cognos Transformer, Cognos PowerPlay, Oracle 10g, DB2, SqlServer 2000/2005, Windows NT/2000

Confidential, Plano, TX

Senior Cognos developer

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Created Relational Data models and Dimension Data models using Framework Manager to represent the business information.
• Setting Data and Object security, giving access permission to objects and Packages. Created folders, Embedded and Standalone filters, prompts and complex calculations in Framework Manager.
• Migrated existing Brio Intelligence Reports to Cognos 8.3 Report Studio Environment.
• Created User Groups, Roles in Cognos Connection to implement the Security Filters in Framework Manager Model.
• Created Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Developed dashboards reports, which will provide call volume for incoming and outgoing calls on daily basis.
• Created, organized and formatted reports, folders and other contents on Cognos Connection Portal.
• Developed Cognos transformer models using Cognos Powerplay Transformer.
• Developed Analysis Studio Reports and cubes using Analysis Studio.
• Developed Customize and Burst Reports using Report Studio.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Created Run and Schedule Reports and Jobs using Cognos Connection.
• Provided technical assistance, training and mentoring to Users and Business Partners.
• Developed and Published Powerplay Cubes on to upfront using the Power Play Enterprise Server.
• Developed Analysis Studio Reports and cubes using Analysis Studio.
• Created Drill down / Drill Up reports and Combine Filter, User-Defined Filters, Custom Ranking using Analysis Studio.
• Developed Top ‘N’ and Bottom ‘N’ reports in Analysis Studio.
• Involved in Cube optimization and troubleshooting to run the cubes in effective manner.
• Developed and Published the Impromptu Reports on to the server using Report Administrator.
• Scheduled reports in Cognos Connection (Web Portal), Organized the folders for user convenience

Environment: Cognos 8.3 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio), Cognos ReportNet1.1, Cognos Impromptu v 7.3, Cognos Power play v7.0, Cognos Transformer, PowerPlay Enterprise Server(PPES), Cognos Access Manager, Brio Intelligence 5.0, Oracle 10g, Windows NT/2000

Confidential, Chicago, IL

Cognos Report Net Consultant

Responsibilities:

• Study and analysis of the business requirements gathering and analysis, understanding client's data warehousing requirements and system analysis of business process and requirements.
• Interacting with the users for understanding of Data Analysis and gathering business requirements.
• Prepared all the required documents for Cognos objects like design documents, unit test plan documents.
• Created Models and Packages in Framework Manager.
• Creating Reports using Report Studio and created adhoc queries using Query Studio.
• Involved with testing team of seven during two phases of retract/rebill development project. Assigned work, managed test scope, managed defect stack.
• Testing and improving Report Performance upon report completion for validation of Calculations & data.
• Created User Groups, Roles in Cognos Connection to implement the Security Filters in Framework Manager Model.
• Setting Data and Object security, giving access permission to objects and Packages. Created folders, Embedded and Standalone filters, prompts and complex calculations in Framework Manager.
• Expertise in developing Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Good in creating Query Prompts, Calculations, Conditions, Filters, Bursting Reports and Multilingual Reports Using Report Studio.
• Scheduled reports in Cognos Connection (Web Portal), Organized the folders for user convenience.

Environment: Cognos8, Analysis Studio, Cognos ReportNet1.1, Impromptu, Powerplay, Oracle 8i/9i, Toad (Oracle Tool), Windows 2000, Cognos Impromptu v 7.3, Cognos Power play v7.0, Windows NT, IWR Server, Powerplay Enterprise Server, Access Manager, Testing tools