SUMMARY

• Certified Business Intelligence Professional with 8(+) years of Complete BI project life cycle experience - Analysis, design, Administration, configuration and implementation of business intelligence systems, Operational databases, Enterprise Data Warehouses (EDW) and data marts, Data Mining, Data Modeling, Transformation and Loading Methodologies, OLAP tools, Reporting tools and OLAP environments, along with strong analytical skills and application of structured methodology for reporting / BI design, specification and development.
• Over 8 years Business Intelligence experience using Tableau 7, 8.1,8.2(Tableau Desktop and Tableau Server), Cognos Series 7, Series 8 and Series 10 - Impromptu 7.1/6.6/6.x, PowerPlay, Transformer, Impromptu Web Reports (IWR), Upfront, Power Prompts, Visualizer, Cognos Query, Architect, Powerplay Enterprise Server, Cognos DecisionStream, Scripting, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Metrics Studio, Map Manager, Business Insight, Business Insight Advanced, Active Reports.
• Experience in configuration of backgrounds jobs, scheduling of the extract refresh activity, troubleshooting failed refresh activity, monitoring dashboards performance on tableau server.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms and also monitoring critical tableau parameters of tableau server.
• Used performance monitoring tool of tableau desktop to analyze the performance of data heavy dashboards and implemented the best practices to improve the end user experience
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Managed cross-functional teams through Software Development Life Cycle.
• Strong experience in Installation, Configuration, Monitoring and Management of Cognos on both UNIX and Windows platforms. Expertise in defining the multi-tiered Cognos Architecture, Performance tuning, Security infrastructure and Deployment work flows from Prod, Dev and Test environments. Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and SQL Server
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment.
• Sound Skills in Report Development, Modeling (Relational, DMR), Dash Board Report in Cognos 8/10.
• Experience in OLTP Modeling (2NF, 3NF) and OLAP Dimensional modeling (Star and SnowFlake) using ERWin (Conceptual, logical and physical data models).
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries.
• Experience in writing and optimizing SQL queries in SQL Server 2005, 2008 and 2012.
• Experience in data extraction, transforming and loading (ETL) using various tools such as SQL server integration services (SSIS).
• Experience in maintenance and administration of SSIS by creating jobs, alerts and schedule SSIS Packages.
• Knowledge of tools such as Erwin and MS Visio Professional.
• 8 years of experience using Oracle 8i/7.x, Developer 2000, DB2, PL/SQL, SQL*Plus, Win NT 4.0, Linux. Experience in Oracle PL/SQL programming (Collections: Nested tables/VARRAY, Functions, Procedures, Packages, Triggers, Indices and database objects) and Shell Scripting (C Shell, K Shell, Bourne Shell). Posses advanced MS Excel and MS Access skills.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually. Proven experience at building, training, motivating and leading professional teams, managing projects and supporting client relationships

TECHNICAL SKILLS:

BI TOOLS: Tableau (Desktop 7x to 8x, Tableau server and Tableau Online),Cognos(v10.2,v10.1,v8,ReportNet1.1/1.0x,Cognos Impromptu 7x/6x, Impromptu Web Reports (IWR), Power Play, Power Play Transformer 7x/6x, Cognos Administration, Upfront, Power Play Enterprise Server, Scheduler, Business Insight, Business Insight Advanced, Active Reports, Report Studio, Framework Manager, Cognos Mobile, Cognos for MS Office)

DATABASE: Oracle 8i/9i/10g/11g, Teradata, MS SQL Server 2005/2008/2012, DB2

DATAMODELING: ORACLE TOOLS

LANGUAGES: ETL TOOLS

OPERATING SYSTEMS: Erwin, Microsoft Visio. SQL*Plus, Toad, SQL*Loader, PL/SQL Developer. SQL, PL/SQL Programming, C,C#, Python.

Informatica, SSIS: MS Windows NT/2003/XP/ME/95/98, Windows 7, Windows 8, UNIX.

WEB: HTML, XML, and JAVASCRIPT

WEB SERVERS: IIS, Netscape Enterprise Server, IE

APPLICATION SERVERS: Apache Tomcat, Web sphere application server(WAS 6.0)

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

BI Tableau Developer/ Admin

Responsibilities:

• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams and created Technical Design Document from the functional specification documents.
• Generated visuals in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Design and deployed rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau and provided these visuals in Tableau online and Reader to Stake Holders.
• Generated context filters and used performance actions while handling huge volume of data.
• Created multiple Adhoc dashboards in Tableau in order to represent the status like strength and weakness etc. for the business users at a glance.
• Created dashboards for financial department such as accounts payable, accounts receivables, Cash management and Asset management for Finance Team.
• Developed dashboard related to Asset management department for asset category and subcategory, depreciation and asset retirement.
• Design of ETL jobs as per the technical requirement and source to target mapping.
• Extract data from source files such as Sequential files, XML files, Flat files, CSV files etc., transformed and loaded data into DataMart.
• Worked on Python scripts to convert CSV files to flat files to ingest the data for ETL.
• Extracted and Transformed data using OLE DB connection by creating various SSIS packages from different server locations and data sources.
• Involved in maintenance and administration of SSIS by creating jobs, alerts and schedule SSIS Packages.
• Created test plans and performed the Unit testing, Integration testing and System testing for the ETL jobs.
• Worked on Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle).
• Created tables, views, materialized views with indexes in SQL Server to tune the performance.
• Installed and Monitored of Tableau Server (Dev and Prod) on AWS Environment.
• Created incremental refreshes for data sources on Tableau server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created report schedules, data connections, projects, groups in Tableau server.
• Administered users, user groups, and scheduled instances for reports in Tableau.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Used Java Script API to customize the views, selects, filters, date and time.

Environment: Tableau 9.0, Tableau v8.2 (Tableau Desktop, Tableau Reader, Tableau Online and Tableau Server), Oracle12g (SQL, PL/SQL), SQL Server 2008(SSIS, SSAS, SSRS), Python 2.7.

Confidential, Pittsburgh, PA

BI Cognos Developer / Tableau Developer

Responsibilities:

• Worked on Tableau Dashboards in Tableau 8.1 and Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Developed dashboards, reports as per the requirements with appropriate guided navigation.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Created and assisted users in Tableau dashboard development.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Extensively used advanced filtering capabilities and created calculated fields for Analysis depending on the user requirements in Dashboards.
• Created contextual filter for improving the performance.
• Worked on Developing a Data mart for dealer sales connect and developed SQL views on the mart to facilitate BI reporting on the same.
• Installed and Configured Cognos 10.2.1 BI in single server Environment.
• Design and Developed the Framework Manager models using Stored procedures, Relational tables and published in to server.
• Used data blending options of tableaufor different datasources to create a consolidated view.
• Involved in Upgrading Framework Manager Models, Transformer Cubes from Cognos Version 8.4 to 10.2.1 and solved the issues in the existing model.
• Developed Interactive Active/Mobile Reports for browsing and exploring data offline.
• Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
• Extensively worked in Scheduling and Deploying (Staging to Production) Reports.
• Created reports with Optional filters and custom prompt pages (using HTML and Prompt API) in Report Studio.
• Developed summary and detailed level dashboard to enable drill down option. This features helps business to deep dive into the data whenever required.
• Upgraded Reports prompt pages with Prompt API by replacing embedded JavaScript.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Developing the Dashboard reports using MDX Functions.
• Developed Dashboard reports to display all the information related to environment using Summary reports.
• Created Complex, multipage reports using the reporting features like Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, and Drill Up
• Used Slice & Dice and Drill through techniques in Standard Reports and Business trend Reports using Multidimensional cubes.
• Involved in gathering and analyzing business requirements to migrate Reports from QlikView to IBM Cognos 10.2.1
• Designed and implemented 10.2 Dynamic Cube instead of migrating the cube using Transformer 10.2 from 8.4.
• Created and performed testing strategy and test plans for any changes/upgrade to Cognos Reports

Environment: Tableau Server v7/8, Tableau Desktop v7/8,Cognos 10.2.1,Cognos 8.4(Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced Cognos Transformer 8.3/8.4/10, Cognos Transformer 7.4, Cognos Mobile,Cognos for MS Office,Oracle11g (SQL, PL/SQL)

Confidential, Secaucus, NJ

Cognos Developer/Tableau Developer

Responsibilities:

• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Extensively used SQL scripts for data mapping and querying.
• Designed and developed a business intelligence dashboard using Tableau reporting solutions, allowing executive management to various trends in data related to Merchants and Merchant products.
• Extensively worked in Scheduling and Deploying (Staging to Production) Reports.
• Designed and developed a business intelligence dashboard using Tableau reporting solutions, allowing executive management to various trends in data related to Merchants and Merchant products.
• Developed and published reports and dashboards using Tableau Desktop/server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Configured tableau server for subscriptions enabling business to receive dashboards periodically.
• Collected data on various process measurements and formatted into graphs using Tableau software.
• Developed Dashboard reports to display all the information related to environment using Summary reports.
• Redistributed tableau server processes (based on tableau’s recommended configuration) in a distributed environment to improve server’s performance.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Worked collaboratively with a team of Teradata developers to build ETL process needed for reporting.
• Configured SAML on tableau server.
• Executed and tested required queries and reports before publishing.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.
• Converted Cognos based reports into tableau reports.
• Provided 24/7 production support for Tableau users.
• Participated in report concept, design, mock-up, testing, and post-production development meetings.
• Worked with BI Specialists and BI Analysts for implementation of Cognos to internal departments.
• Deployed and monitored the report schedules.
• Developed Dashboards, Customized reports and scorecards based on business requirements and UI specifications.
• Developed Active reports, Dashboards and complex reports for Cognos Mobile and Tablets.
• Designed ad Developed standard report, complex reporting and Ad-hoc reporting for Business Users.
• Involved in integration of Cognos application to Share point interface and resolved integration issues.

Environment: Cognos 10.1(Report Studio, Query Studio, Business Sight Advanced, Framework Manager), Informatica 9.1, Oracle, TOAD, SQL, Share Point, Agile-Scrum, DataStage, Tableau 8.1, UNIX, SQL Server, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential, Scranton, PA

Sr. Cognos Developer / Lead

Responsibilities:

• Assisting the client, through analysis of their existing system, challenges, and business needs. Documented the reporting requirements and interacted with Business users and collected business information and their requirements for developing the project.
• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document
• Install Multi-server Dispatcher Cognos installations for Dev/QA/Pseudo Prod/Prod Environments. Crete/Maintain Cognos User classes and groups with Windows Role Based Structure and user account provisioning
• Developed Active Reports target on I pads and Mobiles.
• Built an reports for Blackberry, Apple using IBM Business Intelligence.
• Developed sophisticated interactive dashboards by using Business Insight Advanced.
• Developed Cognos reports, dashboards, metrics, analysis using Cognos Mobile.
• Built Framework Manager Models (Relational, DMR) for Standard Reporting and connecting to the Enterprise Data warehouse (EDW).
• Also built Framework Manager Models for Ad hoc Reports and building Dashboards.
• Involved in ETL process by requesting the ETL team for custom calculation columns and complex logics to be implemented at the database level, in order to improve the performance of the report, while fetch and load data to Various Target Tables
• Created star schema groupings in Framework Manager Models to meet the reporting requirements, Created Import View, Business View and Star schema grouping Dimensional Views in Framework Manager.
• Implemented Complex row level security apart from the data level, object level security in the Frame work manager, using the sessions parameters and security tables.
• Designed and developed numerous list, crosstab, multi-query, multi-page reports utilizing the master-detail relationship, conditional blocks, conditional formatting, unions, etc.
• Extensively worked on Powerplay Transformer for Data Modeling of the Rx data, building Multidimensional Cubes. Created numerous power play reports and analysis studio reports using the multidimensional power play cube. Experienced with trouble shooting and optimizing cube performance
• Upgraded Framework Manager Models, Transformer Cubes and reports from Cognos Version 8.4 to 10.
• Install/setup Cognos 10.1 software. Upgraded the Cognos 8.x reports. Troubleshoot upgrade problems/fix issues. Created and managed agents using Event studio, which monitors the data and performs the task when an event occur
• Administered the Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups
• Customized Cognos Connection with appropriate reports and security measures.
• Created Executive Dashboards, using Business Insight and Business Insight advanced.
• Created and managed agents using Event studio, which monitors the sales one data and performs the task when an event occur.
• Design & development of multiple reports using various templates likelist reports, cross-tab reports and chart reports.
• Trained power users to use Business Insight, Business Insight Advanced and Query Studio for Ad-Hoc reporting. Trained professional authors to write complex reports using Report Studio.
• Acted as the primary contact for cognos support issues from users. Actively interacted and resolved the issues with IBM support team on various congos bugs and defects.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Administering the Servers - Installation, configuration, roles, Privileges and Performance Tuning of the Servers.
• Developed Custom Portal Tabs and Custom User Interfaces for Reports based on UAT Feedback. Created, refreshed and supported Cognos Transformer OLAP models and Power Play cubes.
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Coordinating with Development Team tasks & Deliverables and working on high priority issues.

Environment: Cognos 10.1,Cognos 8.3/8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced Cognos Transformer 8.3/8.4/10, Cognos Transformer 7.4, Cognos Mobile, Cognos for MS Office, Oracle10g (SQL, PL/SQL), Teradata.

Confidential, Jersey City, NJ

Cognos Admin / Senior Cognos Developer

Responsibilities:

• Understand user requirements and Data Model defined and developed by the business analysts and data architects in Erwin Data Modeler to understand the underlying relationships between the tables.
• Installed and configured Sun One LDAP directory server, IIS server and migrated all the security from the old to the new servers. Migrated Cognos 7 Upfront, IWR reports, PPES, Cubes, automation scripts and all the scheduled jobs over to the new data center. Migrated all Cognos 8.4 related content including Cognos Content Store and data source connections.
• Installation of various Cognos tools in distributed environment (Development, Test and Production).
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Single sign on Security with LDAP and Group level security in Cognos Connection Portal.
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers, reporting of enterprise data warehouse (EDW).Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.
• Lead and implemented the migration of impromptu reports and cubes from Cognos series 7 to Cognos8.2.Developed the few model and packages from scratch based on the existing catalog and migrated 100+ reports into reportnet, using report studio, based on the existing impromptu report
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Developed Cognos Portal integration & Cognosportal design.
• Reviewed the Cognos Framework Manager model developed in development environment by other team members. Upgraded reports from 8.2 to 8.4.
• Migrated reports from Cognos EP Series 7 (7.3 and 7.4) to Cognos 8 BI (8.2 and 8.4).
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.

Environment: Cognos 8.2,Reportnet1.1 MR2, Cognos Series 7 (Cognos Power Play 7.3, Cognos Transformer7.3, PPES, Access manager, Impromptu Administrator, IWR), (Impcat2xml, Migratetoc8, Deploytoc8), Informatica 8.6, Oracle 9i/10g,SQL Server 2000/2005, windows 2000, UNIX 5.0.

Confidential, Warren, NJ

Cognos Developer

Responsibilities:

• Installed Cognos ReportNet and Framework Manager in an interim environment as a proof of concept.
• Migrating reports from Cognos EP Series 7 (Impromptu reports and catalogues) to Cognos ReoportNet. Complete understanding of key & important milestones associated with migration to Cognos Series 7 and Reportnet.
• Imported Meta Data from Multiple Sources like Oracle 8i, Flat files in to Framework Manger.
• Created different projects in Framework manager for data coming from Modules like General ledger to create different types of reports like current assets, fixed assets, liabilities, revenue and expenses.
• Created Business Views and added business values, specific to reporting requirements
• Created, modified and Published Framework Manager Packages on ReportNet Server
• Implemented security using Framework Manager on Package Level, Object Level, Data Access Level For Groups, Roles and Specific Users.
• Generated Ad-hoc Reports, Standard Reports Using Query Studio and Report Studio
• Created Reports of different formats like HTML, PDF, EXCEL and Delimited Text.
• Created Parameters, Prompt Pages using various Prompt types (Value Prompts, Text Box Prompt, Date Prompt, Select & Search Prompt, Interval Prompt on the reports).
• Created Lists, Groups and Cross-tab reports with drag and drop functionality.
• Created standard Calculation on Query Item and applied various Filters to Data like Tabular, Group Filters on Query items and formatted the Reports.
• Created Drill-through connection to link 2 Reports, Book Marks and Conditional Block Lists.
• Modified Power Cubes by adding new Dimensions, Levels and Measures.
• Provided End user Support & training to the ReportNet users on Report Studio and Query Studio.
• Exposure on Installation of Cognos, Upgrade and configuring on different environments.

Environment: Cognos ReportNet1.1, Framework Manager, Query Studio, Report Studio, PowerPlay Transformer, PowerPlay Enterprise Server (PPES), Impromptu 7.1, Transformer 7.1, PowerPlay 7.1, PowerPlay Enterprise Server 7.1, Access Manager Oracle 8i, Toad, MS-Excel, Windows.

Confidential

Jr. SQL Developer

Responsibilities:

• Used SQL* LOADER to load data into table space.
• Connected to Remote Data Bases using Data Links and pulled required data.
• Designed and developed front-end application using CGI/C ++ programming. Insert, update and deletion were done using these forms.
• Handled Complex queries with TRANSLATE & DECODE.
• Granting access to different users for the system
• Modifying the profiles of different users
• Development and report generation.
• Involved in writing different stored procedures, triggers in PL/SQL as per functionality

Environment: Oracle 7x, PL/SQL, SQL*PLUS, SQL*LOADER, SQL Scripts, Developer 2000, Windows.