SUMMARY:

• 11+ years of experience in IT Sector with strong analytical skills; extended expertise in Implementing, Developing/Customizing teh ETLs and Reports.
• Utilize keen analysis and insights and team approach to drive organizational improvements and implementation of best practices.
• Hands on experience in following teh SDLC methodologies like Waterfall model and Agile model.
• Designing Cognos Framework Model by implementing Parameter Maps, Securities, Determinants, Relationships, Shortcuts, Alias, Calculations, Hierarchies.
• Creating Dashboards and Portal Pages in Cognos by implementing Drill Through, Drill Down, Master - Detail, Sectioning, Parameter Maps, Macros and integrating Java script to in corporate inventive features.
• Skilled inTableau Desktop for Data visualization, Reporting and Analysis. Experienced in creating different visualization like Cross Map, Scatter Plots, Geographic Map, Gantt charts and Bar Charts, Page Trails and Density Chart.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to teh users and adding them to teh specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Experienced in writing complex SQL Queries, Stored Procedures and constructingTables, Triggers, User Functions, Views, Indexes, Data Integrity.
• Well versed with Extraction, Transformation and Loading of Data using ETL tool DataStage and Informatica.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.

TECHNICAL SKILLS:

Operating Systems: Windows XP, UNIX

BI & DW Technologies: Cognos 8.4/10.1/10.2 BI, Tableau 9x/10.1/10.2, Microsoft Power BI, SSRS 2008, SSAS 2010, SAS Via, Data Stage 8.7, Abinitio 3.2, Informatica 9.6

Frameworks: IBM Cognos Framework Manager

Tools: Cognos BI, Tableau, Power BI, SAS Via, Microsoft BI (SSRS, SSAS, SSDT, SSMS)

Databases: Oracle 9i/10g, SQL Server 2008/2010/2012, Teradata

PROFESSIONAL EXPERIENCE:

Confidential

Cognos Developer

Responsibilities:

• Participate in all sprint ceremonies
• Understand teh requirements and provide design and solutions
• Develop new Informatica mappings and workflows to load data after applying several business logics using different transformations like aggregate, lookup, router, rank, sequence generator etc.
• Update teh Parameter Files, Audit process to in corporate newly added workflows
• Apply changes in existing Cognos Framework Models
• Designing and developing dashboards in Tableau by using Marks, Action Filters, Parameters and Calculation Fields
• Building various views by using Sorting, Grouping, Hierarchy, Aggregate, Level of Details, Calculations, Customized Charts, Dual Axes and Axes Blending using Tableau Desktop
• Adding java scripts, dynamic parameter handling to Tableau reports and integrate them to Dash Insight
• Walkthrough of teh ETLs and Reports to showcase all new additions and enhancements
• Deployment of teh ETL objects and Report objects

Environment: Informatica 9.6, Cognos 10.2.1/10.2.2, Tableau 10.1/10.2, Oracle 10g

Confidential

Lead Report Analyst

Responsibilities:

• Understanding existing reporting applications, underlying data, data models, execution frequency
• Create data sources using SQL queries, Database Views and SSAS Cubes
• Designing and developing dashboards in Tableau by using Marks, Action Filters, Parameters and Calculation Fields
• Building various views by using Sorting, Grouping, Hierarchy, Aggregate, Level of Details, Calculations, Customized Charts, Dual Axes and Axes Blending using Tableau Desktop
• Adding java scripts, dynamic parameter handling to Tableau reports and integrate them to Dash Insight
• Design and develop dashboards in Power BI using SSAS Cube as a source
• Performance optimization of teh reporting applications
• Walkthrough of teh reports to showcase teh new features and enhancements added while replicating teh existing report
• Managing milestone deliveries for teh project

Environment: Cognos 10.2.1/10.2.2, Tableau 10.1/10.2, SSAS 2010, Oracle 10g, Dash Insight, Java Script

Confidential

Report Analyst

Responsibilities:

• Gathering requirements from application teams and create data model which can to be used by various projects
• Understanding of data model and data analysis for teh purpose of business intelligence
• Designing customized interactive dashboards in Tableau using Marks, Action Filters, Parameters and Calculation Fields
• Building various views by using Sorting, Grouping, Hierarchy, Aggregate, Level of Details, Calculations, Customized Charts, Dual Axes and Axes Blending using Tableau Desktop
• Implementing Data blending, Replace s, Customized Queries and Advanced Visualizations in Tableau
• Designing Cognos Framework Model by implementing Parameter Maps, Securities, Determinants, Relationships, Shortcuts, Alias, Calculations, Hierarchies
• Creating Dashboards and Portal Pages to enhance Cognos report visualization
• Implementing Drill Through, Drill Down, Master-Detail, Sectioning, Parameter Maps, Macros and integrating Java script, VB script to in corporate inventive features in Cognos reports
• Maintenance, enhancement and performance optimization of existing enterprise reporting applications
• Designing SSAS cubes as per business requirements to aid better data analytics, data forecast and data visualization
• Managing milestone deliveries for all sub projects

Environment: Cognos 10.2.1/10.2.2, Tableau 10.1/10.2, SSAS 2010, SSDT 2010, SSMS 2010, Oracle 10g, Dash Insight, Java Script

Confidential

Team Leader/Report Analyst

Responsibilities:

• Requirement Analysis, Data Profiling and Modelling for Business Intelligence
• Designing Collective Framework to serve various report requirements of different reporting areas
• Creating database objects like Materialized Views, Stored Procedures, Functions to support reporting data source
• Implementing Data extracts, Data blending, Dashboard Actions and Table Calculations to create interactive Tableau dashboards
• Creating Customized Charts, Dual Axes, Axes Blending, Set, Groups and Bins
• Implementing Parameters, Quick Filters and Context Filters to give restricted provision to users
• Creating Users, Groups, Projects, Schedules; setting up Security in Tableau Server
• Creating Release Document, Mapping Documents, High Level Design, Low Level Design Document
• Involved in Project Estimates and Preparing Project Road Map

Environment: Tableau 10.1, Oracle 10g, Dash Insight

Confidential

Onsite Coordinator, ETL Developer

Responsibilities:

• Discussion with application teams to understand existing applications
• Coordinate with offshore to halp in understanding applications and procedures to accomplish milestones
• Developing new ETLs to implement generic solution across several applications
• Developing various ETL graphs for extracting, cleansing, transforming, integrating and loading data into Data Warehouse
• Creating audit tables and loading teh rejected records into teh relevant tables and send to teh users for re-submission
• Implementing Slowly Changing Dimension - Type 2 (SCD - Type 2) for preserving history of teh required dimensions.
• Adding fixes in existing applications to stabilize teh production environment
• Handling production abends
• Updating schedules and Maestro jobs to deploy and schedule newly created applications

Environment: Abinitio 3.2, Teradata, Maestro Job Scheduling, UNIX

Confidential

Senior Reporting Consultant

Responsibilities:

• Requirement gathering, Data Profiling, Data Modeling
• Creating mock-up reports and arranging demos to approve requirements
• Design of Data Stage parallel, sequence, audit, generic jobs
• Using DataStage Designer for developing various jobs to extract, cleanse, transform, integrate and to load data into Data Warehouse
• Using Datastage Director to schedule teh jobs, monitoring schedules and validating their components
• Implementing different stages like Change Data Capture, Lookup, XML, Saleas Force, Transform, Aggregate to achieve DW dimension and fact load
• Designing common Framework for all reporting requirements
• Creating Dashboard and Detail Reports by arranging different objects; implementing dynamic data change functionality; providing feasibility to view reports in different format; sending report copy to email; serving different views of one report
• Ad-hoc report creation using Business Insight and Business Insight Advanced
• Conducting user and providing User Manual
• Project Deployment and milestone approval
• Creating Business Requirement Documents, Project Sign Off presentations

Environment: Oracle 10g, SQL Server 2005, UNIX, Cognos 8.4/10.1/ 10.2, Data Stage 8.7

Confidential

System Analyst

Responsibilities:

• Requirement Analysis
• Data analysis and building Data Extracts
• Designing customized interactive dashboards in Tableau using Marks, Action Filters, Parameters, Calculation Fields
• Building various Views, Sorting, Grouping, Hierarchy, Aggregate, Set, Groups and Bins
• Implementing Customized Charts, Dual Axes, Axes Blending, Data Blending, Replace s, Customized Queries and Advanced Visualizations
• Installation, Configuration and Administration of Tableau platform by creating managing sites, projects, groups and users at teh server
• Creating Report Design Documents, Report Mapping Documents and User Guides

Environment: Tableau 9x, SQL Server 2012

Confidential

Team Leader, ETL/Report Developer

Responsibilities:

• Involved in End to end implementation - From requirement gathering to Design, Build, Unit Test and System Integration Testing.
• Requirement Analysis and Proviso DB analysis
• Played secondary role in Data Modeling
• Development of DataStage jobs to extract, cleanse, transform, integrate and to load data into Data Warehouse
• Implementing Slowly Changing Dimension - Type 2, generic logic, sequence jobs in Data Stage
• Creating interactive Dashboards by implementing Aggregates, Hierarchies, Formatting, Sorting, Grouping, Filters, Quick Filters, Calculated Measures, Set, Groups, Bins, Dual Axes, Axes Blending
• Implementing Data Blending, Replace s, Customized Queries and Advanced Visualizations to provide forecasting and various trend reports
• Creating sites, projects, groups and users at server and applying securities at different levels
• Creating Weekly Status Report, effort estimation for fixed price project

Environment: Tableau 9x, Oracle 9i, SQL Server 2012R2, DataStage 8.7

Confidential

System Analyst

Responsibilities:

• Requirement Analysis
• Development and testing of processes and programs necessary to extract teh data from operational databases and tan transform and load it into Data warehouse
• Development of various stage, dimension, fact, sequence jobs
• Designing Framework Model by creating data source, database layer, presentation layer to in corporate all sources and to make them available for reporting
• Development of Summary and Detail reports using List, Charts, Crosstabs, Blocks, Variables, Prompt Pages, Hyperlinks, Master-Detail, Drill Through functionalities
• Deployment of multiple report using Cognos Job

Environment: Cognos 8.4/10.1, Oracle 9i, SQL Server 2012, DataStage 8.7

Confidential

Programmer Analyst

Responsibilities:

• Detail analysis of user requirements and mapping with teh existing operational systems
• Creating database objects like table, views, stored procedures, functions
• Development of various stage, dimension, fact and sequence jobs
• Development of Summary and Detail reports
• Ad-Hoc Report Development using Cognos Report Studio
• Dashboard and Detail report development with drill through, drill down, drill up and prompt page features
• Report performance optimization

Environment: Cognos 8.4, 10.1, SQL Server 2012, DataStage 8.7

Confidential

Developer

Responsibilities:

• Requirement Analysis
• Development/Customization of Dashboard and Detail reports in SSRS
• Report standardization, performance optimization
• Creating database objects like stored procedures to use as a re-usable component for prompts
• Creating multiple schedules of teh reports based on requirements
• Creating complex SQL queries and database objects like table, stored procedures, function
• Interaction with client to gather teh requirements and to report teh project status
• Creating Informatica workflows, mapping, parameter files to load data from staging area to data mart
• Scheduling and monitoring Informatica Workflows

Environment: SQL Server 2008, Oracle 10g, SSRS 2008, Informatica 9.6