SUMMARY:

• Over 10 years of IT experience with emphasis on Analysis, Design, Development, Validation and Reporting under different environments.
• Over 8 years of experience in data warehousing Technologies as developer in BI tools like Cognos and Tableau.
• Worked on Cognos and Tableau requests simultaneously based on business need.
• Expertise in Framework Manager Cognos BI Modeling and Report Authoring using Cognos 10.2.2 10.1 8.4.
• Strong knowledge on Data Warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP.
• Created, modeled and published packages in Framework Manager from multiple databases for use with Report Studio, Query Studio and Analysis Studios.
• In-depth knowledge on Tableau Desktop and designed dashboards and reports in Tableau 8.3 and 9.2
• Developed different kinds of visualizations using Tableau Desktop and variety of worksheets to build dashboards.
• Thorough understanding of System Development Life Cycle (SDLC) experience from requirement analysis through Design & Development.
• Interacted with Business Analysts and core business group to design/develop/maintain database reporting and perform data analysis.
• Expertise in developing standard Reports and Templates, Dashboards, Master Detail Reports using Report Studio.
• Involved in training end users and providing technical support and documentation.
• Good experience and knowledge on Cognos multi server installation and Cognos Administration.
• Good experience on migration process.
• Excellent communication, interpersonal skills with strong analytical and problem solving skills. Ability to learn quickly and take up new tasks and responsibilities

TECHNICAL SKILLS:

Languages: C, C++, Java, SQL

Databases: Oracle 9i, SQL Server, Teradata, MS Access, Redshift

Reporting Tools: Cognos(10.2.2,10.1,8.4), Tableau, TM1, Business Objects

Ms office: Microsoft Word, Excel, PowerPoint, Visio

Operating systems: Windows (10,8,7, XP)

PROFESSIONAL EXPERIENCE:

Confidential, Plano-TX

Data Analyst BI

Responsibilities:

• Developed dashboards for data analysis as per client’s requirement.
• Designed and executed various number of weekly and monthly business monitoring reports.
• Implemented best practices like LCR and Custom classes for reusability and consistency.
• Handled ad hoc reporting requests to analyze and support new opportunities, strategies or product specific questions.
• Developed campaign waterfall reports per the business requirements to facilitate highly accurate decisions.
• Designed reports using Cognos functionalities like Drill through, Master/Detail.
• Performed testing of reports by writing SQl queries.
• Worked on different types of Ad-hoc campaigns.
• Built and Drove Email Campaign execution and analysis, create test cases and adjust strategies accordingly.
• Implemented end to end cycle of Marketing campaigns, response tracking, analytics, reporting and revising strategies.
• Marketing campaign deployment - Scheduling, audience segmentation, analyzing campaign KPI's within Salesforce Marketing Cloud (Exact Target).
• Assess the Post analysis Campaign performance.
• Provided technical assistance by responding to inquiries from client regarding issues and questions about reports.

Environment: Cognos 10.2.2 (Report Studio), Cognos Connection, Tableau, Teradata, Redshift, Visio.

Senior Consultant

Responsibilities:

• Lead offshore BI team and coordination with onshore.
• Gathered the requirements from clients and provided analysis for designing framework manager model and reports.
• Understanding the requirements and provided gap analysis documents to the client for building efficient framework model and reports.
• Designed framework manager models for ad-hoc analysis and reporting, also resolved loops utilizing shortcuts and Alias shortcuts in Cognos framework manager.
• Resolved double counting of multi granular data between tables using determinants in Cognos framework.
• Developed reports for customers/users at various levels for analysis of data and driving decisions.
• Analyzed existing report capabilities and provided recommendations to the clients.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up), List, crosstab etc. using Tableau.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc.,.
• Analyzed existing source systems and designed data model for building data warehouse/data mart.
• Evaluated Current Report Capabilities with other tools and provided recommendations of the analysis.
• Applied security features of Cognos like row level, report level, object level security in the framework manager to make the sensitive data secure.
• Performed testing of reports with an independent SQl.
• Implemented security to the reports based on user requirements.
• Created Prompts, Conditions and Filters to improve the report generation.

Environment: Cognos 10.2.2 (Framework Manager, Report Studio), Cognos Connection, Teradata, Tableau, Redshift, Visio.

Senior Specialist

Responsibilities:

• Product owner for DWH initiative from offshore.
• Involved in Full life cycle design and development of Cognos reporting Applications.
• Interacted with Business Analysts and end users to develop ad-hoc reports and dashboards according to functional specifications. Also carried out analysis, documentation of detailed requirements.
• Implemented multi-tier installation of servers in Cognos environment.
• Developed dashboards for data analysis as per client’s requirement.
• Designed reports that open in mobile for online and offline analysis of data by the users.
• Designed and executed various number of business monitoring reports on monthly and quarterly basis.
• Developed Complex dashboards that involved multiple objects, Master/Detail charts, cross tab, bar charts, pie charts, complex variables and calculation contexts.
• Created reports using Cognos functionalities like Drill through, Drill up/down, Cross Tab, Master/Detail, Formulas and variables etc. Generated pictorial views in the form of 2D, 3D Pie Charts from existing Reports and Chart Wizard etc.
• Applied security features of Cognos like row level, report level, object level security in the framework manager to make the sensitive data secure.
• Migrated reports from Cognos 8.4 to Cognos 10.1, 10.2 and provided impact analysis to the business users.
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Designed user guide/customer handling documents and given training sessions to business users on how to use/run the reports in Cognos.
• Provided continuity and accuracy in reporting by validating and testing data, identifying missing data, inconsistencies between data sources as well as validating accuracy and consistency with stated business rules.
• Effectively handled modifications and enhancements to the dashboards as per the requirement changes from business.

Environment: Cognos 8.4, 10 (Framework Manager, Report Studio), Cognos Connection, Cognos Administration, Oracle.

Senior Software Engineer

Responsibilities:

• Gathered Business requirements from the end users, business analysts and project managers.
• Communicated with users to understand their requirements to create and modify framework manager and reports.
• Successfully upgraded/migrated reports that are to be generated for 7500+ active users from cognos 7.4(Impromptu) to 8.4.
• Developed framework manager according to the technical specifications and made sure they were free of loops and traps.
• Tested the reports for data accuracy and made sure they met the look and feel requirements of the end Users.
• Maintained admin activities like export, import packages across the different environments such as development, testing and production.
• Used Cognos administration to schedule and distribute the reports automatically as per the business needs.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment: Cognos 8.4 (Framework Manager, Report Studio), Cognos Connection, DB2.

Software Engineer

Responsibilities:

• Involved in Understanding the requirements of Business analysts and Corporate Managers.
• Developed framework manager according to the technical specifications and made sure they were free of loops and traps.
• Maintained team’s project lists and work with Users to determine priorities, and reports progress on projects (status reports) to the Users.
• Involved in the development of the modules like Internal Message, Student Leave, Log Audit and Change Password in Java
• Involved in developing UI screens using JSP and HTML.
• Involved in developing DAOs using ORM Tools (Hibernate).
• Involved in coding for controllers using Springs Framework between presentation layer to business layer.
• Involved in Unit Testing of the user interfaces and provided testing results with the client.
• Participated in Code reviews with the clients and made sure that the coding is as per standards.

Environment: Cognos 8.4 (Framework Manager, Report Studio), Cognos Connection, SQL Server, Java, Spring, Hibernate.