SUMMARY:

• Having 10 plus years of experience in the field of Information Technology with expertise in Tableau BI, IBM Cognos BI, Birst BI and Cognos TM1
• Extensive exposure in various business domains such as Transportation & Logistics, Banking, Healthcare Insurance, Retail Industry and Telecommunication
• Extensively worked on Tableau desktop by creating visualizations and dashboards related to statistical, predictive, forecasting, time series and trend analysis
• Have good knowledge on Informatica, OBIEE and Power BI
• Good understanding of Data Warehouse Concepts such as star schema, snow flake schema, Facts and Dimension tables
• Experienced in working on Multiple Relational Databases such as My SQL, Oracle, MS SQL Server, IBM DB2 and Toad data point
• Very good experience on Cognos Business Intelligence series 10.2/8.4 (Report Studio, Framework Manager Query Studio, Analysis Studio), and Cognos Series 7.4 (Cognos Power Play Transformer, Cognos Access Manager, Upfront portal)
• Having valuable experience on Cognos TM1 installation, administration, cube design including ETL with Turbo Integrator and application design with strong knowledge of TM1 rules and processes
• Have very good knowledge on Cognos architecture and have performed Cognos installation and configuration on a distributed environment
• Implemented third Party Security using Access Manager and LDAP

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Linux, Solaris10

BI &ETL tools Tableau Desktop, Tableau server/Online, Birst BI, Power BI,Cognos 10.2/10.1.1/8.4 (Report Studio, Framework manger, Analysis Studio), Cognos 7.3 (Impromptu web reports, Power play administration server), Cognos 7.4 Power play Transformer, Cognos TM1 9.5.2, TM1 Architect, TM1 Perspective, Turbo Integrator,, Informatica 9.6/9.1 - PowerCenter Designer, PowerCenter Repository Manager, PowerCenter workflow Monitor, PowerCenter workflow Manager

Databases: My SQL,Oracle 9i/10g/11g, IBM DB2, Sql Server 2005, MS-Access

Web Servers: IIS, Apache, Tomcat

LDAP Servers: Active Directory, Sun One Directory

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Technology Lead

Responsibilities:

• Primarily responsible for the lead activities in the project as in managing and leading the team, Preparing and sending the weekly status reports and Effort estimation reports
• Responsible for gathering the requirements from various stakeholders, documenting them and creating the required dashboards/Reports
• Involved in building various cross database join queries mainly for pulling circuit, order management and Revenue information from XO communication databases
• Involved in development of Tableau, Cognos reports pertaining to various applications related to Provisioning, Billing, Sales, order management and XO stats
• Created various staging and look up tables using Toad data point
• Developed various adhoc reports for the migration of data from XO to Confidential
• Played a key role in the Revenue Traceability by comparing and analyzing data from XO and Confidential for the Tech upgrade and Migrated products
• Responsible for maintaining over 2000 cognos reports and Tableau Tech upgrade dashboards related to order management
• Involved in identifying and debugging Informatica issues pertaining to scheduler /workflow

Environment: Tableau Desktop, Tableau Server, Cognos 10.2, Framework Manager, Informatica power center, Toad data point, Oracle SQL Developer, Informatica 9.6/9.1 - PowerCenter Designer, PowerCenter Repository Manager, PowerCenter workflow Monitor, PowerCenter workflow Manager, Lucid chart, MS Visio

Confidential, Oakland, CA

BI & Analytics Lead

Responsibilities:

• As a BI lead responsible for complete life cycle of the project right from collecting the requirements, designing the data model, designing the ETL jobs specification document, Tableau dashboard creation, testing and training the users
• Performed the data modelling, designed and created a data mart from scratch
• Creating accounting dashboards based on Actual Vs. Budget cross various trend lines
• Implemented accounting cost & pricing project by gathering requirements, designing mockup screens and creating the data model
• Automated the accounting process by designing a Data mart which has source from 9 workbooks each having 20 sheets pertaining to various vessels
• Creating various Monthly dashboards for the Accounting team based on the Fuel consumption for every Fiscal month
• Trained the Operation and accounting users on the tableau desktop and Tableau online
• Prepared the ETL test cases and performed the user testing by handling configurations for ETL jobs in winscp and executed jobs via putty

• Created dashboards and visualizations pertaining to multiple applications such as Fuel analytics, China customer service dashboards and Terminal operations
• Implemented China customer service dashboards end to end from Designing the data model, setting up the schema, validation of the data, assisting in the ETL logic and the job workflow, Tableau dashboard development and the distribution of reports
• Developed complex dashboards showing various trends in Fuel analytics
• Created various Data driven reports in tableau server to distribute the Fuel consumption report for a voyage leg to the Ship captains and Chief engineers as soon as the vessel reaches a port
• Involved in the Brio migration reports to the Tableau Dashboards
• Played the onsite coordinator by assigning the ETL resource with tasks and briefing on the requirements for the ETL job changes

Environment: Tableau Desktop, Tableau Online, Amazon Athena, MySQL WorkbenchBirst BI, Brio Reports, ETL Talend studio, lucid chart, MS Visio

Confidential, Greater Chicago Area, IL

Tableau Analytics Developer

Responsibilities:

• Responsible for implementing effective Business dashboards & visualizations for senior management employing Tableau Software worked closely with senior business system analyst to analyze and develop complex interactive and dynamic dashboards from business intelligence requirements
• Administrate Tableau Server, data content and report distribution
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts
• Created weekly dashboard showing statistics on Planning and Demantra jobs
• Developed order history report, backlog report, shipments report from oracle order management system
• Developed reports tracking the progress on the tickets logged in the HP lifecycle management ticketing tool

Environment: Tableau Desktop, Tableau Server, Oracle 11g, HP Lifecycle management ticketing tool, MS Excel, MS Access

Confidential, Atlanta, Georgia

Onsite Coordinator

Responsibilities:

• Actively involved in access procurement, pre-analysis, requirement gathering, Analysis, Development and Testing stages of the project
• Handled both Tableau and Cognos development activities for one of the application which deals with Anti Money Laundering
• Created AML dashboards using the Tableau Desktop
• Distributed dashboards across various users using Tableau Server and set the necessary user groups permissions
• Prepared TDD, Field mapping and system appreciation documents for various enhancement reports
• Prepared analysis documents and workflow documents for reports based on stored procedures and involved in fixes/tweaks for the adhoc based reports
• Designed the Framework manager model by converting the stored procedure based model to regular model query subjects
• Played key role in requirement gathering from the users and designed the requirement based documents
• Played the role of onsite coordinator by assigning offshore with the necessary action items

Environment: Tableau Desktop, Cognos 10.1, Framework manager, Report Studio, Query Studio, Oracle PL/SQL, Analysis Studio

Confidential

Technology Analyst

Responsibilities:

• Involved in creating Cognos reports and dashboards for the Credit Risk application based on technical specifications collected from the business analyst
• Developed a Cognos daily dashboard, Monthly dashboard for Citi credit Risk users to track the tickets and alerts that has been generated for the credit limit usage
• Experience on Cognos Framework Manager Model by creating packages and publishing them in Cognos connection
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query reports, Burst Reports against database
• Developed Relational Model as well as Dimensional Model (DMR) with use of hierarchies for advanced functions
• Performed Cognos administration activities across various lines of business (LOB) such as Citi cards, Citi Real estate, CBNA, Collections, Consumer Business group(CBG)
• Having good experience on Portal Administration in Cognos Connection
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Responsible for managing content in Cognos administration by creating Data sources, bursting reports and emailing them to the distribution list or individual recipients
• Handled the assigned Service requests raised in the Remedy Ticketing tool
• Monitor and manage scheduled jobs to assure that stakeholders receive analytics to drive their business

Environment: Cognos 10.1.1 Suite, Report Studio, Analysis Studio, Query Studio, Event studio, IIS 6.0, Oracle 11g, Remedy Ticketing tool

Confidential

Sr. Cognos Developer/Admin

Responsibilities:

• Involved in the installation and configuration of Cognos 8.4
• Security validation of user access/Data source access through Cognos Access Manager
• Involved in Requirement gathering from Business Users
• Analyzed the requirements provided by the clients and Developed specification documents for reports as per client requirements
• Implemented data level security, object level security and package level security using the Frame work manager and Access manager
• Designed & developed list, crosstab and drill through reports for departments like claims, billing, and members/subscribers
• Created DMR model with Dimension and Hierarchies for providing drill downs & ups in Analysis Studio
• Worked on Analysis Studio to develop multi-dimensional reports and applied context filters for better analysis
• Resolved issues resulting from User Acceptance Testing (UAT)
• Developed reports with Prompt pages with HTML items, Multiple Report Pages with Page Breaks and Conditional Variables
• Created Burst Reports and Multilingual Reports based on groups of users & Preferences for our various partners
• Performing the server administration activities by managing, monitoring and tuning the dispatchers and services
• Bursting reports and emailing them to the recipients
• Extensively worked on Analysis Studio to develop multi-dimensional reporting

Environment: Cognos 8.4, Report Studio, Query Studio, Event Studio, Analysis studio, Oracle 10g, TOAD, UNIX

Confidential

Cognos Admin/Developer

Responsibilities:

• Performed Cognos Installation and configuration on a distributed environment
• Involved in setting up the LDAP security for adding users, groups
• Extensive experience on Cognos8 with respect to Deployment, Content Administration, Users and User Class Creation and Scheduling of Reports
• Administered by setting up the Cognos security settings at package, report level using the Cognos connection administration portal with restricted features depending on the class of user
• Involved in Requirement gathering from Business Users. Built models using Framework Manager based on the user requirements
• Created Simple and Complex Reports using Report Studio with multiple Charts and Reports on one page
• Requirements extensively used Conditional Blocks to hide/display the report contents (list, cross tab, charts) based on user selection in the prompt
• Introduced Highlight exceptions and graphics, and drill-down reports to expedite analysis
• Have performed unit testing for the reports using oracle database as backend
• Bursting Reports Using Report Studio and emailing them to the recipients
• Created dashboards for a managerial overview with drill up and drill down capabilities
• Created models in Transformer, built cubes and published cubes to Power Play server

Environment: Cognos 8.4, Framework Manager, Report Studio, Query Studio, Oracle 10g

Confidential

Cognos Administrator

Responsibilities:

• Handling the Cognos services in IWR, PPES servers in Development, Testing and production environment
• Performing backup, upgrades, set up security, roles and users, and troubleshoot by understanding the various log messages
• Cooperating with Infra and Application teams for any Planned and unplanned outages or Zone restart activity and Interacting with different departments within the organization regarding new deployments
• Monitoring systems capacity and performance, plan and execute disaster recovery procedures
• Provided L2/L3 support for Cognos
• Identifying, escalate and document production impact issues for the environment to confirmed delivery for client and business notification
• Responsible for the weekly/monthly maintenance activities
• Security validation of user access/Data source access through Access Manager

Environment: Cognos PPES 7.3, Cognos PPTS 7.4, IWR 7.3, IIS 5.1, Access Manager, Solaris 10, Remedy Ticketing