SUMMARY

• 12 plus years of IT experience with Sound knowledge and experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production.
• Strong understanding of relational database design concepts and in - depth knowledge of OLAP solutions, Cognos Insight, Cognos 11/10.x/8.x BI, PowerPlay Transformer, PowerPlay, Cognos TM1 9.5, SSIS, SSRS, Power BI, Tableau.
• 10 plus years of hands-on experience with the Cognos Reportnet suite (Framework Manager, Cognos Connection, Report Studio, and Query Studio) on Windows, as developer and as an administrator.
• 2 years of hands on experience on Informatica in creating ETL mappings and validating the mappings.
• More than 6 plus years of experience in Cognos 10 BI components which include Framework Manager, Report Studio, Query Studio and Analysis Studio
• Involved in migration of Reportnet 1.1 MR2 reports to Cognos 8.1.
• Developed OLAP applications using Cognos suite of tools and extracted data from the enterprise data warehouse to support the analytical and reporting for all Corporate Business Units.
• Hands on experience in administering, deploying and maintaining Models, reports, and cubes using Cognos 11/10.x/8.x, Tableau Desktop, Tableau Server.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files using delimiters in Informatica.
• Worked in creating SSIS packages for Reporting databases with Error Handling scheduled job notifications.
• Worked extensively in enhancing and deploying the SSIS Packages from development server.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union and Aggregators.
• Created Tableau Dashboards, using different kinds of graphs, bar, pie charts, scattered plots, geographical maps etc. in Tableau Desktop.
• Created Dashboards with help of Power BI tool, utilizing crosstabs, maps, scatter plots etc.
• Proficient in using best practices to support the reporting activities. Adept in using performance tuning and optimization techniques such as load balancing and partitioning.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Participated in training new version of Cognos, Tableau and Power BI.
• Experienced in developing, designing Dashboard and Reports in Tableau and Power BI.
• Worked as Project Coordinator/Expeditor and oversee multiple phases of the projects for my clients and gained experience in developing status, milestone reports.
• Pursuing the Project Management Professional (PMP) certification and processes involved.

TECHNICAL SKILLS

Reporting Tools: COGNOS 11/10.2/10.1/8.4/ , TM1 9.5/10.2, MicroStrategy, Power Play Transformer, Tableau, SAP BW, Microsoft Power BI, QlikView 11

ETL Tools: Informatica (Power Mart/Power Center /8.1/7.1/5.1), SSIS, OWB

Web Servers: Internet Information Server (IIS), Internet Explorer, and Netscape.

Languages: HTML, Java Script, VBScript, and ASP.

RDBMS: ORACLE 8.X/9.X/10i, SQL Server 2016/2014/2012/2008/2005/2000 , AQT, TOAD.

OS: Windows 2000/NT Servers, Windows NT/95/98/XP Workstations, Windows XP Professional.

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Sr. BI/Data Analyst

Responsibilities:

• Dimensional data modeling using Star Schema for the various metrics related reports utilizing Framework Manager.
• Involved in creating Data mapping documents from Source (PeopleSoft 8.9) to Target (Mega DB)
• Involved in PeopleSoft Integration and DW Integration efforts from ILG brands to MVW systems.
• Involved in writing complex adhoc report SQL queries for testing the PeopleSoft conversion data from 8.9 to 9.2 and conversion data from ILG source to MVW source.
• Analysis, design, development, enhancement, testing, maintenance and technical support for BI applications and participated in Cross-functional team discussions.
• Performed Admin task for creation of user’s roles and groups in active directory, added data security for ILG and MVW users based on the brand.
• Involved in requirements gathering with different stakeholders and analyzed data with Mega DB to nVision Reports which is sourced through PeopleSoft DB and involved in integration of ILG PeopleSoft financials into MVW.
• Effectively used filters, hierarchies, and actions features in Tableau worksheets.
• Developed a business dashboard with multiple panels and parameters in Tableau, which was used by upper management for decision-making on Sales target (budget and forecasting).
• Provide timely resolution of incidents, service calls, and work orders assigned and document repeating problems and solutions as knowledge base for the team.
• Develop complex reports, modifications and testing of existing models and reports.
• Document detailed application specifications translate technical requirements into programmed application modules and develop/Enhance software application modules.
• Conducted detail Analysis and processed complex data sets using visualization (with Tableau/Power BI) and analytics tools.
• Utilizes data visualization tools to make clear and concise visual representations of data.
• Restricted data for at row level and user with the help of filters in Tableau Workbooks.
• Developing worksheets using parameters, calculated fields, groups, sets, hierarchies in Tableau.
• Developed worksheets with different styles like pie, bar, dual axis, tree map, field map etc. in Tableau.
• Published Tableau Dashboards to Tableau Server through Tableau Desktop.
• Test the data and data integrity among various sources and targets and monitor data movement, identified and fixed the bugs.
• Provide Production Support and enhancements of existing Business applications reports.
• Involved in supporting Tableau dashboards/stories for users across the organization.
• Involved in regression testing of reports after the migration of Cognos 10.2 to 11.

Environment: Cognos 11/10.2.2, Report Studio, SQL Server 2014/2016, PL/SQL Developer, PeopleSoft AP and GL, Tableau 2019 (Tableau Desktop, Tableau Server).

Confidential, Orlando, FL

Sr. BI Analyst/Lead

Responsibilities:

• Involved in administrating Cognos BI environment, Train sub-ordinate resources and develop complex Cognos reports using Report Studio.
• Dimensional data modeling using Star Schema for the various metrics related reports utilizing Framework Manager.
• Worked on performance tuning of the dispatchers to handle requests better and optimize the performance of the application.
• Involved in creating Data mapping documents from Source (Chorus Application) to Target.
• Involved in writing complex adhoc report SQL queries for Users, which required raw data and used for Data Modeling for EIM Project.
• Analysis, design, development, enhancement, testing, maintenance, documentation, lead and technical support for Cognos BI applications and Tableau.
• Involved in developing Relational Models in Framework Manager, which was required for EIM Project and modeled data models in Tableau for creating dashboards.
• Developing worksheets using parameters, calculated fields, groups, sets, hierarchies in Tableau.
• Involved in creating PowerPlay Cubes using PowerPlay Transformer for EIM Project (OLAP Cubes).
• Involved in design and development of Operational and Reporting database systems utilizing the Kimball Methodologies for Data Modeling.
• Requirement gathering coordinating with different stakeholders including the business-process manager, other design teams and developments teams for requirements analysis, preparing design documentation, project planning. Analyze to access system capabilities to meet the requirements, and also finding the gaps, and determining those gaps that need customization.
• Provide timely resolution of incidents, service calls, and work orders assigned and document repeating problems and solutions as knowledge base for the BI team in support for Cognos and Tableau.
• Develop complex reports, modifications and testing of existing models and reports in Tableau Server and Power BI Desktop.
• Developing worksheets using parameters, calculated fields, groups, sets, hierarchies in Tableau.
• Developer ad-hoc reports in Power Pivot and shared them using Power BI to the decision makers.
• Developed worksheets with different styles like pie, bar, dual axis, tree map, field map etc. in Tableau.
• Document detailed application specifications translate technical requirements into programmed application modules and develop/Enhance software application modules.
• Test the data and data integrity among various sources and targets and monitor data movement, identified and fixed the bugs.
• Worked on ad-hoc analysis and visualizations from data derived from external sources and presented key insights to business users with help of Power BI, Tableau and Cognos.
• Provide Production Support and enhancements of existing Business applications reports/databases.
• Participated in training new version of Cognos, Tableau and Power BI.
• Experienced in developing, designing Dashboard and Reports in Tableau and Power BI.

Environment: Cognos 11/10.1.2, Report Studio, Framework Manager, Cognos PowerPlay Transformer, Tableau (Tableau Desktop/Server), SQL Server 2012/2008, TFS, RTC, Power BI (Power BI Query/Desktop).

Confidential, Tallahassee/Jacksonville, FL

Sr. BI/Cognos Consultant

Responsibilities:

• Interact with the Business users to gather requirements and convert them to technical specifications.
• Created model for adhoc reporting and publish using framework manager.
• Built Models and published Packages utilizing Framework Manager.
• Created list reports, cross tab reports, chart reports, master detail reports, drill through reports and reports with lot of conditional formatting using Report Studio.
• Developed complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Created Summary and Year Cubes on different centers in PowerPlay Transformer and published PowerPlay cubes as a data source and package.
• Worked with Integration Services (SSIS) to run Jobs for data loading from Staging to Reporting DB’s.
• Involved in writing adhoc report SQL queries for Users which required raw data.
• Created reports with Pass through SQL’s in Cognos when required and requested by the business users.
• Created SSIS Packages to pull data from SQL Server and exported into Excel files and vice versa.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts using SSIS services.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Involved in the Guidewire Training for Claims, Policy and Billing center.
• Extensively worked on writing Adhoc reports i.e. reports purely based on SQL.
• Used Rally tool for tracking status of reports and updating the Rally with Defects assigned in HP QC.

Environment: Cognos 10.1.2, Cognos TM1 9.5, Cognos 8 BI (8.4) Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos PowerPlay Transformer, SQL Server 2012/2008, HP QC, SSIS, BITS.