SUMMARY:

• Having more than Seven plus years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various phases of SDLC.
• Expertise in creating Triggers, Exceptional Expertise in TIBCO Spotfire installation and upgrading existing version.
• Worked extensively on Spotfire Professional and created various visualization.
• Worked as Spotfire Lead, responsible for gathering requirements, developing POC, analysis, design, development and production.
• Responsible for converting business requirements to spotfire reports.
• Designed and developed complex spotfire reports integrated with stored procedures, custom SQL’s, automated reports.
• Experienced in business scoping, design, development, performance and data analysis.
• Created multiple integrated dashboards with web integration and share point integration.
• Experienced in exclusive design of reports, with Cross tables, Bar Charts, Combination charts, scatter plots and Pie charts.
• Used data on demand to custom reports, well versed in using different data sources, components and schemas.
• Experienced in developing complex column changing report using stored procedures.
• Administered projects with multiple scheduling reports, automation services, schema changes and report integration.
• Expert in creating complex Reports that include Cross tab, Drilldown, complex formulae, parameters, Sub Reports, On - Demand Sub Reports.
• Expertise in Cognos 8 BI Suite ( Framework Manager, Cognos connection, Report Studio, Analysis Studio, Metric studio, Event Studio and Query studio)
• Extensive experience in Multiple Relational Databases including SQL SERVER, ORACLE, TERADATA and DB2.
• Deploying Models and reports from Staging to Production and administering users/groups/roles.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.
• Excellent Team coordinating Skills with the Development Team and Deliverable dates.

TECHNICAL SKILLS:

BI Tools: Spotfire professional (3x, 4x,5x,6x), Spotfire Web Player, Cognos 8.4.1 Suite (Framework Manager, Cognos connection, Report Studio, and Query studio)

Operating Systems: Windows 2012 server, Windows 2008 Enterprise Server, XP, 2000, UNIX

Databases: SQL Server, Oracle, DB2, Teradata V2.Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Tibco Spotfire Developer

Responsibilities:

• Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system. Study and understand the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules
• Results-focused approach with regards to design and development of Spotfire software applications to support reporting and Business Intelligence initiatives
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support
• Integrated information from several data sources, Excel, Oracle, SQL Servers
• Installed and configure Spotfire Server
• Created server-based Spotfire workbooks(DXP) dashboards and applications from scratch based on clients needs
• Developed bar charts, pie charts, dash boards and cross tables.
• Integrated stored procedures with spotfire to create a unique selection of columns for report.
• Created custom reports on ad-hoc basis bi-weekly and monthly.
• Designed complex reports with data on demand, details on demand options.
• Developed information links with multiple data tables using information designer.
• Integrated multiple data tables from dimensional model data mart.
• Integrated share point files data into spotfire reports used to create custom reports.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Spotfire.
• Used Import wizard to transport Dashboards, Assisted end user’s in generation of Live Office reports.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Spotfire professianl 4.5& 5.0, 6.0, Spotfire web player, MS Office, SQL Server 2008, Oracle, TOAD, SQL, Tomcat/Apache, windows server 2008

Confidential, DE

Spotfire Developer

Responsibilities:

• Worked as a BI analyst/Spotfire BI Developer.
• Created functional specification documents, based on the technical specification documents for dashboard and reports.
• Modified existing Cognos canned reports and created customized auditing reports to keep track of report run times and volume of data churned by report/user.
• Created Spotfire report file (DXP) and Database connection in Spotfire server,
• Worked on Spotfire Professional to create worksheet , dashboards and published them to Spotfire server for end user use
• Worked with end users to explain Spotfire workbooks, creating ad-hoc reports
• Trained developers on Spotfire Professional and Spotfire web player in terms of best developing and design practices
• Coordinated an employee training program for various Spotfire applications and basic troubleshooting principles
• Created dynamic and cascading prompts using Business views.
• Designed systems design specification and publisher process documents.
• Worked on a plan to develop the process for remote systems administration and ongoing Spotfire application enhancement and maintenance.
• 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.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Used Cognos RTM SDK to call Report Studio reports from Java programs.
• Worked on TOAD and BTEQ for Oracle and Teradata database systems for creation of adhoc queries and for improving various performance issues

Environment: Spotfire Professional 4.5, Cognos 8.4.1 BI (Framework Manager , Report Studio, Query Studio, Analysis Studio) Oracle, SQL, MS Office (Word 2007, Excel 2007, Visio 2007)

Confidential, FL

Cognos Developer

Responsibilities:

• Involved in the entire project life cycle from evaluation, installation and development of end user reports.
• Created Joins and Relationships in Framework Manager depending on reporting needs and verified them to minimize Cross Joins and data redundancy.
• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Created database layer and business layer, defining appropriate relationship between query subjects.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database
• Created Transformer models and built power cubes using PowerPlay Transformer and published onto Cognos Server, created reports using cubes in Report Studio and Analysis Studio
• Extensively used Filters, Prompts, Drill-through, and Conditional Formatting, Summaries, Grouping and Sorting features of Report Studio to generate efficient and user-friendly reports.
• Used Conditional Blocks and Conditional Formatting for creating complex reports.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection in ReportNet.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports( MOLAP - ROLAP)
• Used Cascading prompts, Filters, Calculations to create efficient reports in Report Studio and Analysis Studio.
• Extensive training for end-users to generate reports using Analysis Studio and Query Studio. Sessions on best practices involved in modeling and reporting.

Environment: Cognos 8.4 (Framework Manager, Report Studio, Analysis Studio, Query Studio), Cognos Series 7 Impromptu (IWR and Upfront), , SQL Server 2000

Confidential, Houston, TX

Report Developer

Responsibilities:

• Created packages using multiple data sources in Framework Manager.
• Created the packages defining the business rules and calculations with folders to store conditions, calculations and prompts.
• Worked on the Framework Manager to create metadata model and solved ambiguous relationships.
• Created ad-hoc reports in Query Studio and standard reports in Report Studio.
• Prepared User documentation to train users and functionality of each report.
• Developed List, crosstab, drill through, master-detail using Report Studio and Query studio, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports.
• Scheduled reports, maintained public and individual folders, distribution lists, users, groups and roles using Cognos connection in Report Net.
• Created complex reports using multiple tabular models and tabular sets in Report Studio.
• Installed ReportNet Migration Tool and migrated Impromptu catalogs using impcat2xml command.
• Developed complex reports using impromptu with drill through capabilities, summarization, grouping and filtering.
• Accessed data from data marts using Cognos Impromptu & Cognos PowerPlay
• Created cubes using Cognos PowerPlay Transformer
• Extensively used scheduler for periodical upgrade.

Environment: Cognos ReportNet 1.1, Cognos EP Series 7.3 (Impromptu, Upfront, IWR, Transformer, Powerplay), Oracle 9i, SQL Server, Windows XP.

Confidential

Programmer/Analyst

Responsibilities:

• Created Power Play cubes using Transformer (PowerPlay).
• Reporter Operations such as Sum and Average.
• Exception Highlighting, Sorting, Ranking etc.
• Changing filters, layers and measures.
• Created Multi-Dimensional reports using PowerPlay.
• Created Business Mix reports and Top ten reports.
• Designed and developed multi dimensional cubes.
• Customized data by adding calculations, summaries and functions.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Generated reports using Cognos Impromptu tools querying database.
• Created Filters, Conditions and Prompts in Catalog.
• Developed Impromptu Web Reports (IWR) and published them into Upfront.

Environment: Oracle8, SQL, PL/SQL Macromedia Dreamweaver, Windows NT 4.0