SUMMARY

• Over 19 years of experience in Software Development participating in planning, analysis, design, review and programming in various projects.
• Over 15 years of experience in Analysis, design and development of Business Intelligence applications using Cognos Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metrics Studio & Analysis Studio & Around 2 years experience on Tableau.
• Over 7 years of experience in Development, Implementation, Administration and Support of ETL processes for Large - scale Data warehouses using Informatica PowerCenter.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Very good experience on Tableau reporting tools.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions and at database.
• Around 5years of experience in designing and developing end-to-end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence (OBIEE).
• Extensively worked on Transformer for Data Modeling of the corporate data for building up of Multidimensional Cubes.
• Providing extensive services on ETL tool Power Center 7.0/8.6/9.6.1 Versions.
• Good understanding of dimensional models, slowly changing dimensions.
• Expertise in Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Expertise is in the area software design and programming of Client/Server, Web applications using VB, Oracle, SQL Server, DB2, MS Access, Java Script, VBScript, ASP, HTML, DHTML, and XML.
• Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Considerable knowledge in the analysis and design of the business requirements and specifications.
• Excellent Analytical and problem-solving skills. Team Player with the ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS

Reporting Tools: Cognos 11/10.2.1/8.4/8.3 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio, Event Studio, Metrics Studio), OBIEE, BI Publisher, BI Answers, Cognos SDK, Report Net 1.02/1.1,Cognos Impromptu 7.4/7.3,Cognos Power Play 7.4/7.3, Transformer 7.4/7.3, Impromptu Web Reports (IWR) 7.4/7.3,MSOLAP,LDAP, Access Manager7.3, Power Play Enterprise Server 7.0/7.3, Crystal Reports8.0, OBIEE 11.1.1.7.0/11.1.1.9.0 , WebFOCUS 8,Tableau 2019

ETL Tools: InformaticaPowerCenter9.6.1, Cognos Decision Stream 6.5/7.0, Oracle Warehouse Builder (OWB), ODI

Databases: Oracle12c/11.2/10g/9i/11i/R12, SQLServer 7.0/2000/2005/2008 , DB2, MS-access, P ostgreSQL, Sybase, NCR Teradata

Operating Systems: Windows 10, Windows 7 Professional, Windows NT/2000/XP Professional, UNIX, Sun Solaris, IBM AIX

Languages: C, C++, Java, SQL, PL/SQL, VB6.0, VB.NET

Web Technologies: ASP2.0, ASP.NET, ADO.NET, JSP

Scripting Languages: JavaScript, VBScript, Cognos Script (macro’s)

Tools: PL/SQL Developer, TOAD, SQL Tools, Erwin, UML

Scheduling Tools: Cognos Schedular, Control-M

Web Servers: Microsoft IIS 5.1, Apache Web Server

Source Control: CVS, Clear Case, Visual SourceSafe, TortoiseSVN, Serena Business Manager, Serena Dimensions, GitHub

PROFESSIONAL EXPERIENCE

Confidential

Sr Reports Developer / Sr BI Analyst

Responsibilities:

• Gathered requirements from business users.
• Developed a framework model and established relationships in a way that served a base for all possible business needs.
• Created various Cognos packages organized differently based on reporting needs of business purpose.
• Developed various OAGM workload reports and Dashboards .
• Developed Dashboards with drill through reports and utilized parameters, filters.
• Prepared unit test case documents and did the unit testing for the reports and Dashboards.
• Prepared the Code Review and Code Review Checklist documents for the reports and Dashboards.
• Converted Cognos Reports into Tableau Reports and Dashboards.
• Design and develop Tableau visualization solutions.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Prepare Dashboards using calculations, parameters in Tableau.
• Defined best practices for Tableau report development.
• Interacted with Cognos Admin team and Oracle DBA Team on solving the reports & dashboards issues.
• Prepared code deployment document to promote code from one environment to another environment.
• Provided the Production support and worked on CR’s, EPIC’s and tickets.
• Worked on Production Support Tickets.

Environment: IBM Cognos Analytics 11.1.2/11.1.7 , Oracle 12c, SQL, P ostgreSQL, TOAD, PL/SQL, PLSQL Developer, CAMS, PRISM, CALM, Oracle SQL Developer, Tableau Desktop 2019.4, Tableau Server 2019.4, Tableau Online 2019.4, Amazon Web Services, Amazon WorkSpaces, Jira, Confluence, UNIX, Tortoise SVN, GitHub.

Confidential, Rockville - MD

Lead Developer/Administrator

Responsibilities:

• Gathered requirements from business analysts as well as business users.
• Involved in all the stages of System Development Life Cycle (SDLC) process.
• Developed a framework model and established relationships in a way that served a base for all possible business needs.
• Created various Cognos packages organized differently based on reporting needs of business purpose.
• Created list reports, cross tabs, charts, graphs, drill-through, master-detail reports in Report Studio.
• Utilized parameters, filters, and calculations along with conditionals.
• Used data format properties in the reports to improve the readability.
• Used content administration to migrate packages and reports to QA environments.
• Prepared unit test cases, document and did the unit testing for the reports.
• Prepared the Code Review and Code Review Checklist documents.
• Attended the Bug Triage meetings for discussing the defects with QA team.
• Used Quality Center tool for checking the defects and reassigning them to QA team.
• Provided Production support and worked on Production tickets.

Environment: IBM Cognos 11/10.2.2/8.4/8.3 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio), Cognos Analytics, Oracle 11.2.0, PostgreSQL, SQL, PL/SQL, PLSQL Developer, SQL Tools, SQL Developer, IBM Rational ClearQuest, UNIX, Tortoise SVN.