SUMMARY

• 8 + years of experience in IT industry with a strong background in Analysis, Design and Development in teh field of Database and implementation of Business Intelligence applications.
• 6+ Years of Experience with teh BI tools - Tibco Spotfire Professional, Web player, and Tableau and Business Objects.
• Experience in creating Complex Spotfire Dashboards and Reports Using Tibco Spotfire Professional.
• Experienced in business scoping, design, development, and performance and data analysis.
• Enterprise level experience in using statistical analytic tools like SAS Enterprise, R, Minitab and IBM SPSS in all aspects of project development lifecycle ranging from requirements gathering, data extraction, data management methods, statistical analysis and data reporting.
• Developed cross tables, Bar charts, Tree maps, line charts, scatter plots, combination charts, box plots and complex dashboards involving Property Controls and Custom Expressions.
• Created Complex Information Links to pull teh data from Oracle 10g/11g and SAS datasets.
• Expert in Writing SQL Queries on Oracle and SQL server and DB2.
• Created various Reports using Tableau and involved in Performance tuning.
• Knowledge in Relational and Dimensional Modeling.
• Used data on demand to custom reports, well versed in using different data sources, components and schemas
• Extensively worked on Relational Databases like Oracle 11g/10g and SQL server DB2 and database access tool TOAD.
• Developed and prepared new and enhancement of existing Business Objects applications.
• Converted multiple reports from Excel, Tableau and SAS and BO to Spotfire.
• Experienced in developing complex column changing report using stored procedures
• Strong domain knowledge in Banking and Financial, Manufacturing and Utilities, and clinical and pharmaceutical research.
• Knowledge on ETL tools like SAS DI Studio and Informatica.
• Good Programming Experience in COBOL, DB2 and JCL.
• Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent Interpersonal and Communication Skills.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.

TECHNICAL SKILLS

Operating Systems: MS Windows XP/Vista, MS 2003 server, UNIX

Language: SQL, SAS, IronPython, R, C, C++, Java, JavaScript, HTML and XML

Spotfire: Spotfire professional 6.5 and below, Spotfire server 7.0 and below, Spotfire web player

Statistical Tools: SAS(Base, Macro and SQL), SAS/Stat, SAS/ETL, SAS /Graph, SAS/OLAP Server, IBM SPSS 20, Rstudio and Minitab

Business Intelligence: SAS enterprise 9.3, SAS Enterprise Guide 4.5, OLAP Cube, SAS Web Report Studio 4.4, Visual Studio, SAS Data Integration Studio, and Informatica.

Databases: MySQL, Oracle 9i/11g, SQL Server 2005/2008 R2, MS-Access, Star and Snowflake Data warehousing schemas with (RDBMS, OLTP, OLAP).

Other Technologies: Visio, MS Office (Word, Excel, PowerPoint, Project, and Outlook).

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Lead SAS/Spotfire Data Analyst

Responsibilities:

• Responsible for Requirements Gathering, Data Analysis, Documentation, Report Creation and Testing.
• Created Data Sources by using Information Designer to connect various data marts with Oracle/Oracle Data Direct, SQL Server/SQL Server Data Direct and SharePoint lists.
• Performed Data Validation, Data Cleaning and Data manipulation and combining using procedures like ProcFreq, Proc Means, Proc Sort and Proc Univariate in SAS Enterprise.
• Used SAS/Macros to create and optimize teh programs to decrease scripting redundancy.
• Designed and developed complex dashboards in Spotfire using calculated columns, custom functions and property controls with data obtained from SAS datasets, Excel, flat files and other DBMS files.
• Created Cross Tab Reports, Summary tables, line charts and bar charts.
• Applied data table properties, property controls, filtering schemes, joins and custom functions to get formulated data from information links.
• Employed TERR (TIBCO Enterprise Runtime for R) for scripting statistical analytic queries for selecting teh appropriate predictive analytic model.
• Conducted statistical modeling for both continuous and categorical data, including linear regression, nonlinear regression, ANCOVA, GLM model, repeated measure, nonparametric regression and Survival analysis using SAS STAT and TERR.
• Identifying data from teh back end database tables and queried teh same for reports creation.
• Designed and developed Scorecards for Servicers to identify teh better performing groups.
• Build various Spotfire reports by using Spotfire professional and published them on to teh Spotfire server.
• Installed and configured various Spotfire server components.
• Auto scheduled teh Spotfire reports.
• Trained users in Spotfire on Report usage.
• Created complex SQL Queries and Information links embedded in SAS and native RDBMS environments like Oracle 11g and SQL Server.

Environment: Spotfire professional 5.x and 6.5, Spotfire web player, Iron Python, Oracle11g, SQL Server 2008, TOAD and SQL, PL/SQL, SAS enterprise 9.3, SAS Enterprise Guide 4.5, SAS (Base, Macros, SQL), SAS/Graph, SAS/Access, SAS/ETL, SAS/Stat, SAS/BI and TERR.

Confidential, Mason, OH

Lead SAS/Spotfire Developer

Responsibilities:

• Created various complex Cross tables, Bar Charts, Line Charts, Tree map, Scatter plots, Combination charts and Box plots
• 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.
• Created Information Links By using Information Designer to pull teh data from Oracle Database and SAS data sets required to create teh reports.
• Created SAS dataset from tables in Database using SAS/Access and Retrieved teh Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Utilized SAS for statistical analysis on existing customer's data, and database segmentation using Proc Means, Freq, Summary and Tabulate.
• Created new macros and implemented them in SAS programs to produce teh reports.
• Wrote SAS & SQL code for querying data from large datasets and extracted data from Oracle and MySQL DB.
• Designed complex reports with data on demand, details on demand options.
• Converted Various Excel, Tableau and BO Reports to Spotfire.
• Developed information links with multiple data tables using information designer.
• Integrated multiple data tables from dimensional model data mart.
• Conducting Unit testing of teh reports developed in Spotfire Professional.
• Responsible for teh migrating teh reports from Development to Acceptance / Production Server.
• Integrated share point files data into Spotfire reports used to create custom reports.
• Migrated reports across three environments SIT, ACPT and Prod.
• Automated schema name changes using automation services builder.
• Gathered business requirements and developed them into Spotfire reports.
• Handled scrum meetings and prepared weekly status reports.

Environment: Spotfire 4.0, Spotfire 5.0.1, Excel 2010, Iron Python, Humming Bird and SAS UNIX, MySQL, SAS enterprise 9.3, SAS Enterprise Guide 4.5, SAS (Base, Macros, SQL), SAS/Graph, SAS/Access, SAS/ETL, SAS/Stat, SAS/BI, SAS/ODS, Tableau 8.2 and BO.

Confidential, Milwaukee, WI

Sr. SAS/Spotfire Developer

Responsibilities:

• Designed and developed complex dashboards using calculated columns, custom functions, property controls.
• Gathering teh requirements, Analysis, creating teh documentation, Report creation and testing.
• Created Data Sources by using Information Designer to connect various data marts with Oracle/Oracle Data Direct, SQL Server/SQL Server Data Direct, SAS/Share functions.
• Created Cross Tab Reports, Pie charts.
• Created various reports in TibcoSpotfire and Tableau from ODS.
• Applied data table properties,property controls, filters, joins and custom functions to get formulated data from information links.
• Developed KPI Reports and published them on teh Tableau Server and maintained security.
• Identifying data from teh back end database tables and queried teh same for reports creation.
• Created complex SQL Queries and Information links.
• Auto Scheduled teh Spotfire reports
• Retrieved teh data from flat files received from teh vendors and converted to SAS data sets using SAS/STAT procedures.
• Performed data management operations using various data steps and procedures in SAS rendering teh data usable for reporting.
• Created and used Macros statements for optimizing code and performance tuning.
• Used SAS/ODS to generate reports on HTML web format as well as in RTF and PDF.
• Created reports using analysis output and exported them to teh web server to enable teh customers to have access through Internet.

Environment: TibcoSpotfire professional 4.0 and 5.0, Spotfire web player, Oracle10g, SQL Server 2008, TOAD, SQL, Tableau 8.2, SAS (Base, Macros, SQL), SAS/Graph, SAS/Access, SAS/ETL, SAS/Stat, SAS/ODS and SAS/BI.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Worked on creation of data sets for Phase me, II & III clinical studies.
• Performed relevant statistical analysis of surveys and economic data captured during Clinical Trials.
• Worked with different clinical trials data like Demographics, Adverse Event (AE),Serious Adverse Event (SAE), Laboratory and Physical Examination.
• Worked with numerous SAS data steps and PROC procedures during task handling
• Generated Tables, Listings and Graphs using various procedures like Proc SQL, ProcFREQ, Proc Report, Proc Tabulate PROC UNIVARIATE, Data null, ProcPlot, and ProcGplot
• Performed Data Validation and Data Cleaning on Clinical data using procedures like ProcFreq, Proc Means, Proc Sort and Proc Univariate.
• Used SAS Macros extensively in teh creation of new programs as well as modification of existing programs to improve ease and consistency of results.
• Scripted SQL Queries to check data for different conditions like duplicate values and missing values in native and SAS embedded environments.
• Created and implemented statistical analysis plans and specification documents.
• Integrated with Clinical, Regulatory and Data Management colleagues to coordinate collection and reporting of clinical studies.
• Developed permanent SAS formats, templates and libraries.
• Prepared list of efficacious data for statistical analysis.
• Accessed External Excel and Access files, Stored and Retrieved SAS datasets and handled moving them through multiple platforms.
• Generated graphs using SAS/GRAPH.

Environment: SAS (Base, Macro and SQL), SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, SAS/AF, ORACLE 8, MS SQL Server.