PROFESSIONAL SUMMARY:

• Over 7.5 years of versatile working experience in BI using reporting tools such as Tibco Spotfire Professional, Tibco Spotfire Webplayer, Cognos 8.x (Report Studio, Query Studio, Framework Manager),
• Have solid understanding of Spotfire Architecture.
• Extensive hands on experience in Spotfire Professional.
• Proficient in designing multiple enterprise level Spotfire Analytical solutions.
• Strong report development skills with Spotfire (Version 4.0 - 5.5) and advanced knowledge of best practices in data visualization.
• Experience with Information Designer in Spotfire.
• Salesforce Integration with Spotfire for collabaration.
• Configuring and Managing Scheduled updates for the analysis, managing user roles,supporting deployement process in Spotfire.
• Created different types Visualization in Spotfire like Crosstab,Summary,Box Plot and others.
• Familiar with SQL and Python scripting to enhance the Spotfire visualizations.
• Experienced with reporting and data modeling tools of Cognos 8,Cognos 10.X (Frame work manager, Report Studio, Active reports).
• Provided extensive End-User and Support for Cognos Tools.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica.
• Having strong skills on Data warehouse concepts, SQL, Informatica, Teradata, Oracle.
• Customization of spotfire reports using spotfire APIs and scripts.
• Knowledge of Oracle Business Intelligence Enterprise Edition (OBIEE) from both a functional and technical perspective.
• Knowledge of Cloud computing concepts and integration with BI tools.
• In depth exposure to Finance, Logistics, and Health care business processes.
• Ability to contextualize business data to generate highly enriched dashboards with KPIs and business value reports.
• Experience in Oracle SQL and PL/SQL including Stored procedures, Stored functions, Packages.
• Extensive experience in metadata modeling using Framework Manager.
• Proficient at working as a team player with an aim of contributing towards the team's success. Involved in unit testing, systems integration testing and documented the same.
• Excellent problem solving skills with the ability to provide creative solutions.
• Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual.
• Proven Client relationship management.

TECHNICAL SKILLS:

Programming Languages: C, SQL, PL/SQL, IronPython, Java

ETL Tools: Informatica Power Center 9.1/8.5/8.1.0, Informatica B2B Exchange (Data transformationStudio)

Operating Systems: Windows 2008, 2003, Vista, Win7, XP

BI Tools: Spotfire,Cognos 8 /10/10.2.1, OBIEE 10X/11X

Databases: Oracle 10g/9i/8i, SQL Server 2005/ 2008, MS Access.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida

Senior Spotfire Developer

Responsibilities:

• Gathered requirements from functional team.
• Coordinated with offshore development team in designing, development and deployment of new business enhancement requirements.
• Coordinated with various internal/external system interface team for design/integration testing/ deployment and production issues.
• Designed and implemented of a global, enterprise class Spotfire environment.
• Performed day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting.Create information links and source the information in spotfire reports.
• Designed and development of spotfire dashboards.
• Created Iron python scripts with spotfire APIs for customizations.
• Reviewing all the ETL components like Informatica mapping, Teradata
• Configured and managed scheduled updates for spotfire analysis.
• Project Delivery aspects like UAT, Production Migration and Production Implementation.
• Prepared Test Plan and Plan System Integration testing and performed UAT test along with Business Users.
• Creating one stop shop reporting dashboard using spotfire to analyse and make decisions on product,Sales,Territory etc.

Environment: Spotfire 4.1, Oracle 10g, UNIX, IronPython, Java.Teradata.

Confidential, Wichita, Kansas

Senior Spotfire Developer

Responsibilities:

• Gathered the requirements from business team and transformed them in technical architecture and design documents.
• Involved in estimation, analysis and solution documents.
• Design and implementation of a global, enterprise class Spotfire environment.
• Performed day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting.
• Documented best practices guides as well as proper administration and configuration.
• Collaborated with business personnel to define requirements of development efforts.
• Reported progress and status of assigned tasks to the project teams and managers.
• Responsible for creating cost effective efficient Data visualizations using thrid party connector for salesforce to Spotfire integration and ensure the quality of data loaded to the system.
• Responsible in creating the Analysis Design and Building dashboards by creating the information links from oracle,salesforce to display data in reports.
• Created Information links,parameterization,defining join rules in Information designer.
• Pivoted and transformed data in spotfire professional before buiding visualizations.
• Integrated Salesforce data and feed with spotfire reports..
• Analyze and document process along with quick resolutions for typical issues in production and which were critical to the process.

Environment: Informatica 9.1, Spotfire 4.0.3, Salesforce, Oracle, UNIX, IronPython, Java

Confidential, Houston, TX

Cognos Developer

Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Created User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Developed and Published Packages in Framework Manager, Connecting and testing the Data Source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and fact tables.
• Developed FM Model against Star, Snowflake and Fact Constellation Data Models.
• Created metadata models, Joins, filters and calculations in packages, organized Folders according to the Business view and published the packages using Framework Manager onto Cognos Connection and created the store procedure.
• CreatedLists, Grouped Crosstab, andReportswith calculated fields and Conditional Formatting, Conditional Page layout, Sections, page Breaks, sorting, summaries, grouping, Drill Down, Drill Up).
• Applied grouping and associated the data with group functionality, Performed aggregate functions on calculations inreportstudio.
• Design templates in using Informatica 8 Pushdown feature for faster data movements with in Teradata.
• Developed prompts withreportpick listand generated the current information by applying proper filter condition.
• Created Models using Power Play Transformer using various data sources.
• Creating the Cubes based on the requirements and creating the drill through reports for the cubes and provided to the end users.
• Modifying the existing report based upon the changes requested by the users.
• Scheduled to triggerreports based on an event using Event Studio.
• Developed Ad-hoc reports using Query studio.
• Developed OLAP multi-dimensional cubes using Power Play Transformer and imported them into Framework Manager, created packages and published cube data to open in Report Studio and Analysis Studio for Reporting and Analysis.
• Updated Stored procedures, Database views as per user requirements.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Environment: Cognos 8.4 (Report Studio, Query Studio, Framework Manager, Event Studio and Power Play Transformer), Windows NT, Oracle 9i, Toad, PL/SQL, MS Access.

Confidential, North Chicago, IL

Cognos Developer

Responsibilities:

• Single point of contact for all the reporting needs for Regulatory and Clinical areas.
• Work with global teams, coordinates tasks and deliver them on time.
• Requirements Gathering, Technical Analysis, Design, Development & Maintenance of multiple Cognos reports.
• Upgrade reports from older version to newer versions.
• Upgrade Composite Information Server to IBM Virtual View Manager.
• Demonstrating new features of Cognos 10.
• Responsible for the delivery of 5 developers.
• Provide Documentation of various activities and coordinating with Validation/QA teams to get the required approvals.
• Development and review of the Cognos reports using Framework Manager, Report Studio, Query Studio.
• Preparation of Requirements Specifications Documents and Design Issues Template as a part of Knowledge Transfer.
• Creation of In memory Spotfire visualizations to provide more interactive reports.
• Migration of Spotfire reports from 3.3 version to 4.0
• Work Orders handling related to new reports using CR Tracking in Eroom.
• Provide resolution to Business Users for their queries/issues/concerns related to Cognos Reports raised as tickets in Remedy.
• Review of Delivery to ensure adherence to standards and Perform Enhanced Quality Assurance to modules within the project.
• Source Code control using MKS Integrity Client.
• Document Approvals using Packet Tracker (PTA) tool.
• Provide UAT and after release support.
• Coordinate with client onsite and manage the development and delivery of reports & documents from offshore team.

Environment: Cognos 8.1 (Report Studio, Query Studio, Framework Manager and Power Play Transformer), Windows NT, Oracle 9i, Toad, PL/SQL, MS Access.

Confidential, Frisco, TX

Cognos Developer

Responsibilities:

• Created Impromptu Catalog by adding tables and data files, & creating new joins.
• Created Prompts, Calculations, Conditions & Filters and creating New Jobs using Impromptu Administrator.
• Created Models by using various data sources in Power Play Transformer.
• Created User Classes and Users in Access manager and provided the user credentials.
• Created extremely big OLAP cubes.
• Used Power Play Enterprise Server to publish the cubes and Impromptu reports to the Upfront.
• Build Transformer models using Cognos 7 series.
• Create catalogs and reports in Cognos Impromptu, design the cubes using Power play Transformer and build & testing of power play cubes.
• Publish reports on Cognos Upfront and create users, user classes, user groups and grant permissions using Access Manager Administration
• Develop new Unix Scripts for enhancement to existing system using detailed design documents.
• Migrated the Impromptu catalogs from Cognos 7.3 to Cognos 8.
• Create simple list, grouped list, cross tab, grouped cross tab reports by using report studio
• Create simple, complex reports using Cognos Report Studio
• Create reports using report studio with multiple charts and reports
• Create relational, OLAP models in Framework Manager and publish the packages
• Involved in creating the IQD.
• Designed the transformer model by identifying the dimension, hierarchy and the measures.
• Implemented Drill through from Analysis Studio to Report Studio.
• Prepared the following business/technical writing of requirements, design, templates, development standards documents and detailed design documents.
• Prepare Quality Documents and also give project induction and knowledge transition to new joiners.
• Involved in performance tuning of Cognos reports by tuning the SQL.

Environment: Cognos 7 (Impromptu, Transformer, PPES Administrator, Impromptu Web Report Administrator), Cognos 8.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio), Oracle 9i

Confidential

Cognos Developer

Responsibilities:

• Worked on multiple projects and developed simple, medium and complex Cognos reports.
• Interact with business analysts assisting with business requirements.
• Create model, Relationships, namespaces, query subjects, filters and calculated fields in Framework Manager.
• Create data sources in Cognos portal and publish packages to be accessed by Report Studio and Query Studio.
• Generate various List Reports, Cross-tab Reports, Chart Reports, Master Detail Reports and Drill -Through Reports.
• Create Composite Views and Jobs in Composite Information Server.
• Deploy contents from the development environment to validation and production environments.
• Provide source system screens and reports outputs as part of unit testing.
• Write SQL queries to validate the data.
• Work on the quality standards and provide required documentation to the validation and QA teams.
• Create jobs and scheduled reports using schedule management tool to run daily/weekly and monthly basis and sending reports and report links to users trough email.
• Work as a single point of contact for Cognos and resolve various issues with the help of Cognos support.
• Work on Cognos Security Administration and provide necessary support to the users.