SUMMARY:

• Extensive Experience in Business Intelligence, software design, development, testing and support
• Having 12+ years of working experience in BI using Tableau, Tibco Spotfire Professional, Tibco Spotfire Webplayer.
• Hands on experience in administering, deploying, and maintaining Models, Reports.
• Expertise in complete Life Cycle Development Process of a reporting solution that involved Gathering Business Requirements, Analyzing Business Needs, Documenting Business Information
• Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, Executive Dashboards using Tableau and Tibco Spotfire
• Utilized Best Practices and Proven Methodology in modeling data, ETL and other BI development process.
• Expert in designing Spotfire dashboards / reports with complex multiples data sources ( SQL, Excel, Flat files) relational design and optimizing applications.
• Worked on TIBCO Spotfire installation and maintenance.
• Worked on designing dashboard / reports to give them consistent and professional looks using TIBCO Spotfire Professional.
• Worked on various business modules like Banking, Sales, Procurement to analyze and create reports.
• Worked extensively on ETL process (Informatica) to help build Data Warehouse for reporting requirements.
• Strong skills using SQL queries on Oracle, DB2, and SQL Server.
• Strong experience with stored procedures and functions using PL/SQL.
• Interacted extensively with end users during requirements elicitation phase, provided training and support.
• A good team player with excellent communication skills. Enjoy challenges and have the ability to adapt to any industry and learn quickly.
• Worked with the various business teams, marketing teams to prototype and develop BI reports that enhance the users understanding of the data
• Analyze and troubleshoot data integrity issues ensuring high confidence reports
• Developed defined reports and underlying data structures on the Cognos 8 platform
• Assisted business analysts and users with testing.

TECHNICAL SKILLS:

BI Tools: TIBCO Spotfire Professional 3.3,4.0,4.5 TIBCO Spotfire Webplayer, TIBCO Spotfire enterprise player, Tableau

Operating systems: Windows 2008 server, Windows 2003 Enterprise Server, XP, 2000, UNIX, OS/390.

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

Languages: JAVA, VISUAL BASIC, COBOL, JCL, SAS

Database: SQL Server2005/2008, Oracle 9i/10g, DB2, Teradata V2, DB2, Sybase

Legacy systems: IBM Mainframe S/390,AS400

Domain: Mortgage Industry, Energy and Utilities, Retail (Supply chain), Credit card Services, Transaction banking and Media.

PROFESSIONAL EXPERIENCE:

Confidential, SaltLake City

Spotfire Consultant

Responsibilities:

• Built dashboards with customized view of data enabling row level security using personalized information links.
• Created Signoff spotfire Dashboard for Traders to write back to the Sybase Database.
• Scheduled / Cached the reports to improve the load time for users.
• Implemented caching with security enabled reports using mashups.
• Created complex dashboards using property controls, prompts, Filters, Calculated columns, Python scripting for different functionalities.
• Connecting to multiple data sources, custom data sources, and utilizing calculated columns, custom expressions, transformations (pivots/unpivot etc), bookmarks, filtering schemes
• Build analyses involving high degree of interactivity using data on demand, in - database connectivity, Action Controls and Property Controls.
• Have implemented Dashboards and Visualizations using Action controls and Script controls and have used Iron python scripting to achieve key functionalities that demands specific user interactions

Environment: and Resources: Spotfire professionals (3.3, 4.02, 4.5), Spotfire web player, Spotfire enterprise player, Sybase ASE, Javascript, HTML, Iron Python, Aquadata Studio, Oracle, windows server.

Confidential, Dallas

Spotfire Consultant

Responsibilities:

• Gathered business requirements and Developed Solution design Specification.
• Created various Complex ScoreCard Dashboard for Underwriters, Tracking the Loan reviews, Cycle time of the review.
• Worked on Spotfire Professional to create dashboards, Tableau to create worksheets / Dashboards and published them to server for end users .
• Customized data by adding prompts, Filters, Calculations, by writing complex custom Oracle SQL, Summaries and Functions.
• Created interactive Dashboards and Business Presentations by importing SAS data from UNIX server and merging it with Excel sheetsfrom SharePoint using Spotfire.
• Worked on the Migration plan to move the Tableau/ Spotfire dashboards to Acceptance/Production and guide the end users to get the necessary access through the corresponding Active Directories.
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.

Environment: and Resources: Spotfire professionals 4.02, Spotfire web player, Spotfire enterprise player, Tableau6.0, Oracle11g, TOAD, SQL, Unix, SAS, windows server.

Confidential, California

Spotfire Consultant

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Created, developed and supported reporting and Business Intelligence initiatives using Spotfire application suite.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports
• Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use
• Created Database connection and Spotfire Dashboard file (DXP) in Spotfire server
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Created interactive Dashboards and Business Presentations by importing data fromExcel sheetsusing Spotfire.
• Customized Reports by writing complex custom SQL.
• Worked on a plan to develop the process for remote systems administration and ongoing Spotfire application enhancement and maintenance
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: and Resources: Spotfire professionals 3, Spotfire web player, Spotfire enterprise player, DB2 9.5, SQL Server, TOAD, SQL, windows server.

Confidential, New York

Cognos Consultant

Responsibilities:

• Analysed Business requirements and using the existed excel Reports developed cognos Report Specification.
• Published reports and cubes on Cognos Connection and gave required security privileges to end users
• Customized the Cognos portal, edited the system.xml and the default.css files to have a better user interface.
• Created models in Framework Manager and cubes in Transformer using various data sources.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models
• Solved issues in existing model and created, published packages using Framework Manager.
• Created calculations and filters in the Framework Manager model.
• Modified existing model in Transformer, created Cubes as per requirement and improved cube build time.
• Created appropriate dimensions, manual levels and cube groups in the Transformer model.
• Used Analysis Studio for analyzing the sales trend by ranking the performance of Area and its associated Branches
• Created Drill through and Master Detail reports using Report Studio for sales analysis and summary reports for current year and previous year.
• Created complex Dashboard Reports like Trend Over Time Reports, Variance Reports and Forecast Reports
• Developed Reports such as Trend analysis, and Inventory reports using Report Studio.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Employed Customized cascading prompts, drill-through, HTML Script and sub-reports.
• Created Executive Dashboards, complex reports using Report Studio
• Developed Reports in query studio to meet the adhoc reporting requirements and later trained the users on how to develop their own reports
• Dashboards incorporated list reports and charts and also provided Dynamic drill through.
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports
• Worked extensively with ETL team to analyze and build data warehouse for reporting requirement.
• Created stored procedures query subjects in framework manager and resolved related issues.
• Created fresh catalogs using Impromptu 7.4, which were optimized for improved performance
• Migrated required Impromptu catalogs and reports in batches to Cognos 8 for the current project.
• Created project documentation for the complete project life cycle.
• Trained and supported the end users. Hands on training to generate reports in Analysis Studio.

Environment: and Resources: Cognos 8.3/8.4 (Framework Manager, Report Studio, Query Studio, PowerPlay Transformer, Analysis Studio), Cognos 7.4 (Impromptu, IWR, PPES, Transformer), Access Manager, Oracle 10g, Microsoft SQL server 2005, Excel, Access, Informatica PowerCenter, Windows 2003 Server, UNIX, ERwin, Toad

Confidential, Chicago

Cognos Consultant

Responsibilities:

• Installation and configuration of the ReportNet environment.
• Implementing Cognos access manager and third party securities with Cognos ReportNet.
• Administer the Server environment and troubleshooting based on user requests.
• Communicated with the business users to comprehend the requirements.
• Worked with the HR Department for building multi dimensional models and reports.
• Involved in migration of catalogs from Impromptu to ReportNet using Migration Utility.
• Updated Impromptu Catalog by adding tables and creating new joins.
• Data retrieval, Multidimensional analysis, Power Play structure. Reporter Operations such as Sum and Average, intersection, Exception Highlighting, Sorting, Ranking etc.
• Designed multidimensional cubes using Transformer.
• Setup of Alternate Drill Down paths and Convergence levels.
• Created user class views, dimension views and cube groups to cater various business needs.
• Designed models using Framework Manager and deployed packages to the ReportNet Servers.
• Created standard and Ad hoc reports using Cognos Report studio and Query Studio.
• Created various catalogs and reports in Impromptu.
• Developed portable customized reports in Power Play.
• Used Analysis Studio to develop Sales Rep performance by ranking the top performers.
• Developed templates, standard reports, Master Detail Reports, and burst reports using Report Studio and Query Studio.
• Developed complex reports to cater the client’s requirements using Report Studio.

Environment: and Resources: Cognos 8.0, Cognos ReportNet 1.1 Mr2 (Framework Manager, Report Studio, Analysis Studio and Query Studio), Cognos Power Play 7.2, Cognos Transformer 7.2, Metadata Migration Utility(migratetocrn), Power Play Enterprise Server 7, UNIX, Maestro, Windows 2003

Confidential

Lead Developer

Responsibilities:

• Coding scripts in Group-1 to format the address given by the customers.
• Analyzing the JCL s on mainframe and get the required information for coding the CL s on AS/400
• Coding and testing the CL s on AS/400
• Involved in self & peer code reviews.

Environment: and Resources: AS/400 - COBOL/400, CL and third party package GROUP-1

Confidential, Baltimore

Team Member

Responsibilities:

• Involved in data mapping for the files in CMS(Customer Management system) between the two versions of Vision Plus.
• Design and Develop batch programs to read the files with Version 2.1 and porting into files for the version 2.5
• Create VSAM files using IDCAMS Utilities.
• Write SAS programs to statistically check the data in VSAM files created by both the versions

Environment: and Resources: IBM - MAINFRAMES - VISIONPLUS 2.5, COBOL, JCL, SAS, EZTRIEVE, FILEAID and VSAM