SUMMARY:

• Experienced Tableau & Cognos BI Analyst having in - depth and comprehensive experience in design, development, testing, Security and support of Data warehousing and Client/server projects.
• Certified as IBM Cognos 10 BI Administrator, Cognos BI Report studio.
• Experience on Teradata SQL assistant 14.1.0, MS SQL server, writing SQL queries, PL/SQL operations - functions, triggers and PL/SQL block statements
• Proficient in various Business Intelligence tools - Tableau, Qlik Sense, Cognos
• Thorough understanding of Software development life cycles (SDLC) designing, developing and implementing enterprise scale information management applications, reporting and handling multiple projects
• Proven experience in development and implementation of applications in various domains viz. Financial services, Pharmaceuticals, IT and Telecommunications Sector .
• Experience in developing reports and dashboards using Tableau desktop BI tool and publishing reports on Tableau server.
• Used Tableau server for managing sites, user profiles, assign user permission, roles, schedule report refresh operations
• Experience in analyzing large data, extracted in data marts, excel files, or through SQL codes to perform statistical analysis, report development or dashboard design using various BI tools.
• Developed and tested Tableau dashboards on various environments (DEV, UAT,PROD)
• Used complex calculations, filters, charts, maps, actions, database connections operations in Tableau
• Used MS Excel, Oracle, Teradata as input data in Tableau database connection and use database extract for publishing database on Tableau server.
• Experience on analyzing large amount of data, used statistical tools like Minitab, JMP pro, SAS enterprise minor, VBA.
• Experience in JAVA, JSP, HTML, XML and scripting language.
• Perform complex MS excel operations - Pivot table, filter operations on the underlying data
• Experienced application developer with expertise in designing and developing Business Intelligence solutions in Data Warehousing using Cognos suite (Framework Manager, Cognos connection, Report Studio)
• Developed logical models providing Business Relations implementing star schema and Snowflake schema (multidimensional) concepts.
• Expertise in developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modelling.
• Complex Report building with Report Studio to customize the functionality in prompt page, Master detail Relationships, Drill through in Report page, Customized Prompts and Conditional Formatting and Ad-hoc reports using Cognos Query Studio.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.
• Designed documentation in Confluence, maintained JIRA issue tracking in confluence and used MS office, sharepoint for sharing project documentation.
• Provide clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL tool like Informatica and Life Cycle development.
• Involved in training end users and providing technical support and documentation.
• Knowledge of ETL tool Informatica, supply chain management.
• Integrated third party portals using Cognos Java SDK
• Knowledge of reporting tool Qlik Sense, Qlik view and statistical tools like SAS, Advanced Excel (v-lookup, charts, dashboard design), Visual Basic using visual studio 8, MS office, MS Access (advanced)
• Possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Ability to adapt and learn new technologies and get quickly proficient with them.

TECHNICAL SKILLS:

BI Tools: Tableau desktop version 9.0, 9.2, 10.0 - Tableau Desktop, Tableau Reports and Dashboard Design, Data visualization and analysis, Tableau Server Qlik Sense desktop version 10.7.3 - Reports and Dashboard design Cognos 10.X(10.1,10.2) (Report Studio, Query Studio, Cognos Connection, Cognos Administration, Framework Manager)

Languages: SQL, PL/SQL,T-SQL, SQL Plus, TOAD

Databases: Teradata SQL Assistant 14.1.0, ORACLE 8i, 9i, 10g,11g, MS SQL Server 2008/2012 and MS Access (Advance), DB2

Servers: Application Servers (Tomcat), Web Servers (IIS, Apache)

Statistical Tools: SAS Enterprise Minor, JMP Pro, MS Excel (Advanced V-lookups, charts, dashboard design), Data mining, Predictive analysis, Logistic regression using SAS Enterprise Minor tool

Programming Skills: Cognos SDK toolkit - 10.X, Struts 2.0, Eclipse IDE, JAVA/J2EE, HTML, CSS, JavaScript, Visual Basic using MS Visual Studio 8.

Documentation: Confluence, JIRA issue tracking, SharePoint, MS Office professional 2013 - Advanced MS Excel (Pivot table, V-lookup), MS office 2013.

PROFESSIONAL EXPERIENCE:

Confidential, Blue Bell, PA

Business Intelligence Analyst

Responsibilities:

• Worked in BI analytics and insights team with major clients in pharmaceutical & IT to articulate the results, trends and forecast possibilities by analyzing data using various business Intelligence tools - Tableau desktop, Qlik Sense, brand watch
• Accessed reports, analyzed raw data received from various sources - tableau data extracts, Excel and database. Transformed the data into creative and compelling insights.
• Involved in full life cycle report development using BI tools - Tableau. Performed data blending, Join, union operation on data by connecting to data from multiple sources.
• Reviewed trends in data sets, used SQL query operations to filter the data to understand the opportunities for brands and clients.
• Used filters, calculations, parameters and charts to understand the opportunities for brands and clients.
• Clearly displayed consumer insights for the products in the form of report, dashboard. Involved in contributing ideas during team brainstorming activity.
• Managed Tableau server tasks like publishing dashboard on server, creating user profiles, subscribing, scheduling full refresh, assigning user roles and permissions and managing user security roles.
• Administered user, user groups and scheduled instances for reports in Tableau
• Used complex calculations, parameters, filters in the worksheet.
• Co-ordinated with ETL & support team to perform full refresh and manage database operations on Tableau server.
• Collaborated with the managers and team members to ensure that the deliverables meet the client’s needs. Participated in client’s meetings.
• Worked on projects with sales, marketing and pharmaceutical firm and provided support through all phases of report development life cycle.
• Maintained project documentation in SharePoint. Curated the dashboard to resolve any technical errors and provided 24/7 production support.

Confidential, Delaware

Business Data Analyst

Responsibilities:

• Worked as a primary IT resource in developing reports using Tableau BI tool.
• Developed a technical spec by analyzing the business from the gathered BPR.
• Designed the dashboard templates and created various dashboard reports for the business users.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines. Groups, hierarchies to create detail level summary report and Dashboard using KPI’s.
• Developed various reports, and they include, simple lists, cross tabs, charts, complex reports with tables in them.
• Extensively used Teradata to query data, to validate reports and to write views for some reports.
• Worked on Creating complex dashboards using Tableau Desktop and published to Tableau Server for general user consumption.
• Tested Tableau dashboards on various environments before publishing on production server, tracked issues in JIRA and resolved the technical errors before deployment
• Installed and configured Cognos BI for IT team, created Cognos roles, performed Cognos security setup for the project.
• Identified and mapped various database fields for reporting purpose using Teradata SQL assistant and documented the results in the excel file.
• Maintained project documentation in confluence for both Tableau and cognos reports.
• Installed Cognos framework manager, report studio for reporting purpose. Created Cognos framework manager model and tested report in the report studio.
• Scheduled Tableau dashboard for full refresh on the tableau server and manage security
• Co-ordinate with developers and ETL team identifying and verifying the database fields.
• Worked extensively with developers, ETL team, users in tracking issues, providing training and resolving the errors.

Confidential

Application Developer

Responsibilities:

• Worked as a Technical Lead, defined scope (requirements) and objective based on user needs and thorough understanding of business processes.
• Gathered and analyzed requirements and provide recommendations to address and resolve root causes.
• Responsible for development and enhancement of Cognos portal through Cognos SDK.
• Set up POC environment.
• Designed high level and low level technical design documents.
• Troubleshot production issues and provide end-user training to the client.
• Involved in knowledge transfer to the team members and educate the end-users regarding the technical components.
• Involved in all phases of (SDLC) software development life cycle phase - design, coding, testing and production support.
• Received appreciation from client for developing an application which satisfies the current as well as future needs of each client like Finance, Marketing, Commercial and Sales, marking the project as an IT initiative - Black Belt Project.
• Participated in design and implementation of reports using Cognos business intelligence reporting tool
• Develop filter, calculations and prompts using Cognos Report Studio. Created list, cross-tab and Drill-through reports.
• Troubleshoot production issues and provide end-user training to the client.
• Involved in knowledge transfer to the team members and educate the end-users regarding the technical components.
• Work on large dataset, create dashboard design and analysis in Report Studio, define master detail relationship between reports and perform drill-through operations, charts.
• Format the reports according to the client needs, perform conditional formatting
• Remove duplicates using group/un-group functions, provide aggregated summarized data
• Utilized Cognos BI Reporting tool to identify risks in the department and used best practices to manage such risks.
• Gathered business requirements by conducting user interviews and document user requirements
• Analyzed current vs. past trends, profit/loss trends using charts.
• Worked with BI team to resolve database and technical issues.
• Designed functional and technical design documents
• Extensively worked on creating packages in Framework Manager as per BO Universe, create different Layers in FM Model and published Packages in Framework Manager
• Defined joins and cardinality between different tables.
• Interacted with Business User for any enhancements or Updates in Cognos FM model.

Confidential

Intern Project Analyst

Responsibilities:

• Developed an application designed to track activities and issues in server system and produce a performance report
• Captured and tracked critical business data.
• Monitored project progress by tracking activity and resolving problems.
• Published progress reports and recommend actions.
• Determined number of loops involved in the server processing activity
• Generated meaningful analytical web reports
• Presented analytical reports and technical results during project discussions and meetings.