SUMMARY

• About 8 years of IT Experience in the full life cycle Requirement Gathering, development, and implementation in Cognos BI environments, SQL Server and Netezza.
• Experience in Cognos10 BI (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight, Advanced Business Insight, Cognos Connection, Cognos workspace and active reports) with expertise in Metadata Modeling - Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.
• Extensively worked with Cognos Tools such as Cognos 8 Suite (8.1/8.2/8.3/8.4 ), Query Studio, Report Studio, Event Studio, for both development and Ad-hoc reports and Analysis Tools such as Cognos Transformer & Power Play, Analysis Studio, and Server Installation & Maintenance.
• Extensively worked with Cognos 7.x Suite (Impromptu, Impromptu catalogs, Impromptu Web Reports-IWR, Power Play Transformer and Power Play Windows/Web, upfront)
• Experience in Report Development, Modeling (Relational, DMR), Dash Board Report in Cognos 8.x and Cognos 10.1
• Used Best Practices for dimensional and relational data modeling using Framework Manager.
• Performed Query optimization and improved report performance through use of index, aggregate tables and drill-thru functionalities.
• Experience in building and maintaining Powercubes in Transformer using relational, DMR and OLAP packages as data sources
• Developed various Complex reports using Cognos 8, Report Net, Power Play and Impromptu
• Expertise in writing T-SQL Queries using joins, Sub queries and Cursors in MS SQL Server 12/14
• Extensive hands-on experience with MS SQL Server 12/14 with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services of and SQL Server Integration Services.
• Excellent understanding of T-SQL (DDL and DML), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server 12/14
• Worked on projects using Agile/SCRUM methodology.
• Hands on experience with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, user-defined functions, views, indexes, user profiles, relational database models.
• Exposure to reporting using Tableau 9.X/8.X/7.X/ as a developer and Analyst.
• Experience in creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Deep understanding of SDLC Methodologies like Waterfall, Agile/Scrum.
• Strong knowledge and Experience in using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling for designing Data warehouse /Data marts
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Experience inTrouble Shooting, Performance tuning of reportsand resolving complex issues.
• Experience in interacting with various business stakeholders and able to gather the business specifications and translate into business data for effective decision making.
• Expert understanding of Star Schema & Snowflake Schema, Fact & Dimension Tables
• Understanding, flexible, and adept at working in high paced environments, adapting quickly to different business organization’s needs.

TECHNICAL SKILLS

BI Tools: Cognos, Tableau(Desktop/Server/Mobile/Public), Business Objects

Databases: Oracle 8i/9i, SQL Server7.0 & 2000, Teradata, MS SQL Server, DB2, SQL/PLSQL, MySQL, IBM DB2,Amazon RedShift, Hadoop

Languages: UML, C, C++, HTML, Java, Oracle ETL, SQL, PL/SQL, .NET, VB, CSS, Java Script, Shell Scripting.

ETL Tools: Informatica, SSIS, Datastage

Application Packages: MS Visio, MS Project, MS Access, MS Office Suite, RDBMS: Oracle 11g

PROFESSIONAL EXPERIENCE

Confidential, NJ

Business Intelligence Analyst(Data Analyst)

Responsibilities:

• Analyze, author, test and Automate reports (In SQL, NETEZZA, Oracle and Cognos 10 and 11). Update, distribute and schedule recurring reports. Run, test, distribute and make enhancements to existing production reports.
• Completed complex SQL queries for analyzing purposes and created multiple stored procedures, views and UDFs to implement the business needs.
• Creating/ Running/ Maintaining reports in Oracle RDBMS
• Created multiple pivot tables using SQL query and stored them into views for future reporting needs.
• Consult with Internal business Clients on their Data needs and suggest specific reports and time periods (weekly, monthly etc.)
• Transfer business needs into detailed business requirements and develop formalized test plans for reports.
• Identify data problems and discrepancies; work with IT personnel and other departments to correct any data problems that are found.
• Work with other team members, business users and IT staff members to determine needs for additional enhancements to existing Underwriting Reports, which will allow business users to more effectively use the underwriting data to support their needs.
• Collaborate with team members and Manager on complex analytical and underwriting projects/activities.
• Assist in preparation of training documentation and facilitation of training in field of expertise.
• Represent my team in meetings for Cognos 11 initiative as a Cognos specialist to make sure that Cognos 11 is setup properly to satisfy the needs of all stake holders.
• Conduct sessions for team members on any lessons learned and assist them with technical issues in SQL, Netezza and Excel
• Attending Agile meetings as required to clarify requirements as a Subject Matter Expert

Environment: SQL Server, SSIS, SSRS, MS Access, Cognos 10.x, Cognos 11.x, Informatica, MS Office, Tableau, Tableau Server, Netezza, Oracle, Adobe Analytics.

Confidential, GA

Cognos Developer

Responsibilities:

• Created multiple Frameworks with multiple sources, assed the requirements; proposed and built a snowflake schema framework manager model to suit the needs of the project.
• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Combined data from different data sources of varying granularity using Determinants
• Created reports with Lists, Cross Tabs and Charts with drill down, Dynamic sorting, Hidden Prompts, Drill downs, Drill Throughs and report with tabs.
• Worked with the team to create and check the Visio data models
• Created date prompts, value prompts including cascading and multisource prompts to dynamically determine the filters based on initial user selection.
• Created extensive documentation of the metadata model including Hierarchy map of the model, list of dimensions to reports and lists of calculations and determinants used.
• Understanding the frontend usage and backend database of Guidewire to be able to verify the data within the Local Operational Data Store.
• Creating Frameworks from the Local ODS on all three centers to serve as a reporting platform which satisfy any ad-hoc reporting requirements select business users might have.
• Creating complex reports off of the Frameworks with features such as Dynamic sorting, Hidden Prompts, Drill downs, Drill Throughs and report with tabs.
• Incorporating existing SQL extracts into framework/frameworks (using source Query subjects) and create a report on top to replace extracts with user friendly and better formatted reports.
• Created series of SQL stored procedures to be used in the backend of a c# application which was used by the account managers to generate and send out the “Broker Statements” to the various brokers of XLCatlin products
• Created reports across the business spectrum including Finance (Accounts Receivable Aging), Underwriting(Written Premium report for all policies in a given period) and Claims (Report showing the Policies and claims against them)
• Responsible for the technical testing of the FM models and reports.

Environment: Cognos 10.1.2, Cognos 10.2.2(Framework Manager, Report Studio, Cognos Workspace and Workspace Advanced), (SQL server management studio 2008 and 2012, Business Objects,Sybase), Cognos, Visio, JIRA.

Confidential - Farmington Hills, MI

Cognos Developer

Responsibilities:

• Gathered the reporting issues from the users and analyzed user requirements.
• Involved in migrating metadata and reports from Cognos 7.4 to Cognos 8.2 using utilities.
• Assessed the scope for migration and used different approaches of Lift & Shift, Compress & Optimize wherever necessary for migrating cubes and catalogs.
• Created multiple data source connections for importing different data sources into Framework Manager.
• Created multiple paged, multiple-query reports using multiple prompts for showing selective data on user input.
• Designed relational and DMR models in Framework Manager and published packages to Cognos.
• Implemented data security, object security and package security in Framework Manager.
• Worked on compression of similar reports to reduce the number of reports and also to eliminate the unused reports.
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Created multi-query and ad hoc reports in the report studio and query studio and developed many complex reports for financial analysis.
• Used detail, summary and context filters for making the reports more specific.
• Used conditional formatting, conditional styles and Style variables to render reports for different user needs.
• Created calculated columns to measure the Gross Profit, Net Profit, and Burden in terms of Revenue.
• Created a toggle report that swaps a report layout as list or chart.
• Developed monthly Product Sales Trend, Transactions History and Backlog reports filtered by regions in Analysis Studio.
• Created Sales analysis and summary reports for current year and previous year using Analysis Studio
• Scheduled reports in the Cognos Connection portal to use off-peak hours effectively.

Environment: Cognos 8.2(Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos Connection, Transformer, Cognos 7.4 (Impromptu, PPES, Upfront, IWR), Access Manager, MS SQL Server 2005, migratetoc8, deploytoc8

Confidential

Analyst

Responsibilities:

• Translated the business requirement by interacting with the Business Analyst and developed Technical Specification and Test Case documents.
• Analyze functional and business requirements, managed onsite offshore coordination.
• Implemented quick solutions for different report designs and development issues.
• Created the database views for reports based on the report requirements
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects, Joins, Prompts, Filters, Calculations and Fact Table in Framework Manager and publish them toCognos8.4 server
• Involved in setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Implemented security for Data access, Object level access and Package access.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed Models based on the dimensions, levels and measures required for the analysis.
• Executed scripts to refresh the cubes on a daily and weekly basis.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.

Environment: Cognos 8.4 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio), Cognos Data Manager, Power Play Transformer, SQL Server2005, IBM HTTP Server, Informatica, Windows XP