OBJECTIVE

• Seeking a position of Tibco Spotfire Developer in Business Intelligence domain where me can use my strong technical, quantitative, analytical skills and abilities in impacting teh success and growth of company.

SUMMARY

• Having 8 years of IT experience in analysis, design, and development and testing of client - server using.
• Having 6+ years of experience in Business Intelligence development and big data analytics, data mining, data integration
• TIBCO Spotfire, Oracle and SQL server in Health care, Biopharmaceuticals, Agriculture-Biotech, Chemical Process Engg, and Oil & Gas.
• Comprehensive knowledge and experience in installation and configuration of Spotfire including implementations, report building and administration in large and complex data environments.
• Experience in full life cycle of business systems including system analysis, design, development, deployment and reporting; specializing in Web based Application, Client/Server Architecture, Object Oriented Technology, data mining and Business Intelligence.
• Experience in Designing and developing teh information links, data source, calculated columns, joins (inner, free), filtering, pipeline pilot connectors etc in TIBCO Spotfire.
• Experience in Creating dashboards and visualization by using teh key concepts filtering scheme, markings, custom insert columns and custom expressions, details on demand, property controls, Text Areas, Summary tables, Bar Charts, Pie Charts, scatter plots, heat maps etc in Spotfire.
• Experience working in Tibco HAWK, Oracle 10g/11g, OracleBI11g(OBIEE11g),TIBCO Business Studio, IronPython, shell scripting, pilot script(Accelrys), ODBC,OLEP, JDBC, xml handling, flat file processing, Windows XP, Linux.
• Experience in creating and integrating statistical scripts, R code and functions into applications, including TIBCO Spotfire
• Strong knowledge of Data warehousing concepts, including Star schema, Snowflake schema & Dimensional Modeling.
• Strong experience in writing SQL and PL/SQL programs (TOAD, SQL Tools 1.6), stored procedures for teh custom functions in Spotfire 4.0,4.5,5.0.5.5,6.0.
• Experienced in writing database queries using SQL for data extraction, creating packages using PL/SQL, jobs, triggers etc
• Expert in designing Spotfire dashbords /reports wif complex multiples data sources (SQL, Excel, Flat files, composite) relational design and optimizing applications.
• Knowledge of python scripting and spotfire APIs.
• Experience in full life-cycle development management (business requirements, functional requirements, use cases, design, development, testing, implementation, support and documentation).
• Expertise in Spotfire Report migrations from lower environment to upper environments through automation services designed and implemented folder structure.
• Ability to work independently and manage business expectations wif a delivery-focused approach to work; ability to build and maintain strong working relationships wif team and management.
• Strong analytical, problem-solving and communication skills, wif particular emphasis on clear, detailed business requirements and functional specifications, as well as reports for management
• Ability to understand, analyze and design business processes and workflows wif teh objective of providing recommendations for teh best use of technology for improvement.
• Managed in-house product development, client interactions and technical negotiations for project undertakings.
• Excellent communication and Inter personnel skills. Exceptional ability to learn and master new technologies and to deliver outputs in short deadlines.
• Entire development was done using Agile methodology under Scrum.
• Strong understanding of proprietary in-house BioInformatic tools of healthcare domain under GMP, GLP, ISO standards.
• Solid understanding and hands on experience on various chemical processes, including fermentation, flash separators, distillation, chromatographic separations (Ion-exchange, affinity, hydrophobic, HPLC, UPLC etc), heat transfer, mass transfer, thermodynamics

TECHNICAL SKILLS

• SQL
• HTML
• CSS
• Python
• Spotfire
• OBIEE11g
• SAP Business ObjectsSDLC
• Datawarehousing
• ER modeling
• PerlIronPython
• MS Visio
• Composite softwareAutomation
• IBM RUP
• Bioinformatics toolsFMEA Studies
• Document Project scope
• Buss. Requirement GatheringCrystal Reports
• Cognos
• Technology TransferWaterfall
• Agile Methodology
• Scrum

PROFESSIONAL EXPERIENCE

Confidential, MO

Business Intelligence Developer & Data Scientist

Responsibilities:

• Analyzed existing complex systems to understand and document data elements, relationships, data flows, dependencies and related interfaces
• Using strong technical business/domain knowledge and handling of Big Data analytics to develop and deliver multiple business analytics visualizations using Tibco Spotfire, SAP Business Objects, Crystal Reports
• Extracted data from various sources Excel files, Pipeline Pilot, MS Access, Oracle and other database to built various dynamic dashboards using composite virtual platform and relational database (RDBMS, Oracle PL/SQL) using information links, pilot connector tools
• Direct experience in database development (Oracle), data analysis, data integration and visualization techniques, data mining & querying, pipeline management In charge of infrastructure support for Implementing Spotfire.
• Entire developments were performed using Agile Development Methodology on Scrum.
• Demonstrated strong understanding of databases and SQL experience(PL/SQL)
• Demonstrated ability to expand customer’s use of a BI product by recommending new capabilities and innovative tool offerings
• Document process flow diagram (MS Visio), handle scope of projects, define used cases for multiple scientific projects
• Setup of spotfire webplay and professional client servers.
• Developed complex s+ scripting, designing complex algorithms & data functions for computational analytics using spotfire terr. Used SAS & MatLab scripts for computational analytics through spotfire spss.
• Attained hands-on experience in Data Warehouse, Business Intelligence implementations and development using Oracle and Composite software data integration & virtualization
• Established track record of working collaboratively wif multiple teams, Scientists, Business Systems management and business leaders to review requests, analyze requirements, establish priorities and set direction, aligning wif overall company and department objectives.
• Troubleshooting operations, interacting wif Business user to gather requirements at global level in multiple countries in North America, Latin America, Asia-Pacific, Africa.
• Through understanding and strong working knowledge of OBIEE11g BI tool as well.
• Generation of scientific data in support of product performance evaluation
• Experimental design and reporting wifin amultidisciplinary research and development team
• Management of global transgenic DNA & bacterial archiving at Confidential VQC (Vector quality control) using multiple laboratory software’s and analytical tools.

Environment: Spotfire 4.0-6.0, SOAP UI, accelrys Pipeline Pilot Client 9.1, Oracle10g/11g, SQL, PL/SQL, TOAD 11.5, sql tools 1.6,DB visualize, FlySpeed, Visio, SQL SERVER, Composite virtualization, OBIEE11g, JDBC, ODBC,OLEP, Python, IronPython, Weblogic8.1.5, Business Objects 6.x/5.1.2, Windows NT/2003,XP,7, Unix. Multiple in-house and other Bioinformatics & Computational Biology tools; MEGA, CitrixLIMS, Pollux, monarch, CLC-BIO, vector NTI,DNA star, Apollo: Cloning Manager, Registration Manager, Advancement & Analysis, Analysis Set-Up Manager, Trial Planning tool, Experiment Manager, .

Confidential

BI Developer

Responsibilities:

• Dimension free data exploration
• Writing SQL queries for retrieving data for analysis
• Built map view of wells using spotfire 5.0
• Dynamic field size distribution analysis
• Building production profile using spark chart in conjunction wif scatter plot for selected wells.
• Involved in requirement gathering and high level system design meetings
• Prepared teh detailed technical design documents for teh interfaces
• Used Soap UI for testing teh Web services.
• Conducting Knowledge Transition sessions wifin teh team and grooming new associates in teh project.
• Having daily calls wif offshore and coordinated wif offshore team to manage teh deliverables.
• Used Microsoft Team Foundation Server for teh purpose of version Control and source code maintenance needs.

Environment: SQL SERVER 2008R2, Environment: TIBCO Business Works, TIBCO Administrator, TIBCO spotfire, TIBCO EMS Server, TIBCO Hawk, ClearCase, HP Quality Center, UNIX. Designed and developed SSAS cube & SSRS reports

Confidential 

BI Developer

Responsibilities:

• Engaged in Data Analysis and process research planning for commercialization of biopharmaceuticals.
• Developed Business Intelligence reports wif Spotfire and Crystal Reports to allow management to measure performance at strategic and operational levels for biotherapeutics (PTH, GM-CSF, EPO, Peptidase, Interleukins, Interferon) in R&D, pre-clinical & clinical trials.
• Retrieve data and access data quality from various databases using PL/SQL and develop business user readable reports using various reporting tools like Spotfire, Crystal Reports halping in business & research decision making process
• Gathering functional & non-functional requirements by interacting wif different scientific and business users
• Engaged in data mining for research planning for commercialization of biopharmaceuticals
• Provided inputs to CMC sections of regulatory filings including IND, NDA, and BLA submissions.
• Write programming scripts for automation and smooth running Multi fermentor controlling system, Bio Command, Liquid handling systems, Fast performance Liquid Chromatographic Systems, DNA sequencers, automated colony pickers and many other commonly used scientific systems in bio therapeutics/biopharmaceuticals
• Develop process flow maps and procedures using multiple database management tools and other bioinformatics software’s
• Handled upstream processing & downstream processing process development and operations
• FMEA (Failure Mode Effect Analysis) studies to access process robustness
• Technology transfer & process flow optimization for biopharmaceuticals
• Used OBIEE administration tool for customizing and modifying teh Physical Layer, Business Model and Mapping (Aggregates, Dimensions and Time), Presentation Layer of teh repository (.rpd).
• Developed sample reports for proof of concept inOBIEE10g
• Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, and Alias and Extension tables.
• Develop many reports using different Views (Pivot table, Chart and Column selector), Interactive Dashboards wif drill-down capabilities, tabular using dashboard and page prompts.

Environment: Crystal Reports 4.6, Visual Studio/Visual Basic 6.0, MS access, Visio, OBIEE7.8, OBIEE 10g