CORE TECHNOLOGIES & COMPETENCIES:

• Spotfire / Python / R / MATLAB / JavaScript (Big data, Data Visualization & Data Science platform
• Extending the spotfire platform using Ironpython, R, S+, Spotfire SDK and JavaScript.
• Building complex advanced visualizations all available chart types and custom JavaScript or ironpython charts.
• Proficient with advanced custom expressions.
• Scripting OVER, Statistical, Spatial, Ranking, Math, Logic, Binning, Conversion, Date & Time, Text and Property functions.
• Creating and registering custom data functions in R and/or S - Plus. Running SAS and MATLAB scripts through Spotfire.
• Embedding spotfire reports in web portals, websites and SharePoint.
• Data visualization best practices, interactive dashboards and guided analytics.
• Advanced geomapping configuration with multilayer integration.
• Building elements, joins, procedures & infolinks in info model layer.
• Library administration, Information Designer and Administration Manager Proficiency.
• Managing licenses, setting up and configuring spotfire users (5000+).
• Deploying cluster of spotfire servers including web player server, load-balancing servers, automation services server, statistical services server and spotfire servers.
• Upgrading, patching, monitoring, ldap integration, installations and all other administration duties.
• Configuring Spotfire Application Data Services for multiple environments (Composite) including Netezza, Teradata, MS PDW, Oracle and other big data sources.
• Scheduled updates and automation services xml jobs.
• Server monitoring using geneous, splunk and creating alerts for exceptions.
• Spotfire infrastructure design and platform configuration for clusters, high availability of web player servers.
• Configuring spotfire information model by designing and developing back end stored procedures & complex queries for spotfire server information links.
• Exceptions reporting and analytics for applications.
• Bookmarks and analysis snapshots for guided analysis style reports.
• Deploying web server based dashboards in Spotfire 4.x, Spotfire 5.x., Spotfire 6.x and Spotfire 7.x
• Spotfire center of excellence standards domain knowledge.
• Training Analysts, knowledge base, and documentation.
• Tableau/ R / JavaScript / AWS Cloud Integration (Big Data, Data visualization
• Connecting with data; using the Tableau interface to effectively create powerful visualizations.
• Create calculations including string manipulation, advanced arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Build advanced chart types and visualizations: bar in bar charts - bullet graphs, box and whisker plots - pareto charts, build complex calculations to manipulate data, using statistical techniques to analyze data, using parameters and input controls to give users control over certain values, implement advanced geographic mapping techniques and using custom images and geocoding to build spatial visualizations of non-geographic data, combine data sources by joining multiple tables and using data blending, make visualizations perform as well as possible by using the data engine, extracts, and using connection methods correctly, build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices, implement efficiency tips and tricks.
• Using statistical techniques to describe data.
• Using groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations.
• Using Measure Name and Measure Value fields to create visualizations with multiple measures and dimensions.
• Tableau Administrator: Windows Server monitoring of Tableau Servers (externally), and internally using Tableau Administrative view workbook.
• Tableau directory service integration using Active Directory.
• Full utilization of TABCMD and TABADMIN to do server-side auditing and administration of groups, users, sites, server status through batch scripting or simple DOS prompt commands.
• Implementing end-to-end workbook, database, trusted security strategies by leveraging ISMEMBEROF, FULLNAME, etc. so as to achieve the desired level of security required by end-users.
• Implementing user or core-based licensing strategies.
• Design and deployment of high availability, failover, and distributed Tableau configurations across multiple domains.
• SAML implementation with reverse proxy.
• Tableau JOLT for stress testing.
• Configuration of Tableau VIZQL, Background, and Data Engine processes to adjust for performance across distributed configurations.
• Using F5 load-balancing for very active Tableau servers.
• Dashboard performance recording and tuning. DirectX and browser compatibility in improving user desktop performance.
• Full utilization of Tableau in-built Postgres database server to monitor user, browser, and server activity
• Data Wrangling / Machine Learning / Big Data
• Using python scripts to read & move flat files, web scraping using APIs to extract data in JSON & XML.
• Cleaning, rescaling and munging data using R, SAS & python; dimensionality reduction & normalization.
• Building models for machine learning algorithms by using several techniques to solve business problems. This would include: K-nearest neighbor, Naïve Bayes, Simple Linear Regression, Multiple Regression, Logistic Regression, Decision Trees & Neural Networks for supervised learning algorithms.
• Utilizing clustering algorithms for unsupervised learning models.
• Refactoring map reduce code in python and java to optimize query performance.
• Using enhanced techniques to reduce overfitting or underfitting including; Random forest.
• Leveraging natural language processing, recommender systems & network analysis to build custom data products and solve complex business problems.
• Utilizing NumPy, pandas, scikit-learn and other python and R libraries to build data products and decision engines.
• Using statistical and probability techniques, linear algebra, gradient descent, hypothesis and inference to build models for machine learning algorithms.
• Consolidating structured and unstructured data from disparate data sources to build POC data products and eventually deploy or integrate solution with other applications in production systems.
• Configuring hash tables and map reduce application for efficient load balancing.
• Design, architecture & development of analytic solutions to solve business problems.
• Implement these solutions and train analysts, developers to use the analytic tools and / or data products.
• Exploring data sets to generate patterns using time series models, cross-correlations with time lags, signal processing & filtering techniques, spectral analysis and correlograms.
• Configuring HIVE on HDFS, Horton works, Impala for big data analytics.
• Using scala scripts to optimize real time data analytics using apache spark and storm.
• Build data products extract data from IoT devices and do complex event processing for decision engines, predictive models and live streaming dashboard for monitoring.
• Rapid prototyping of products & solutions after analyzing business problem and going through iterations and simulations of possible solutions; thinking outside the box and challenging status quo techniques for problem solving.
• Critical thinking & domain knowledge in several industries including: Banking, Finance, Telecommunications, Oil & Gas, Pharmaceuticals, Healthcare technology, Supply chain & logistics, Marketing, Consulting, Professional Services and Information Technology.
• Deploying single instance and active cluster of CIS server environment.
• Proficiency creating models and developing views in CIS using CIS studio.
• Configuring CIS monitor and administering shared resources for CIS environment.
• Development and provisioning of data services (web services) in CIS environment.
• Scheduling cache and automated jobs, data cleansing and transformations.
• Administration and integration of shared resources, versioning and authentication integration.
• Configuring and provisioning of several CIS adapters for integration of disparate data sources in CIS.
• Upgrading, patching, and administering deployments using deployment manager.
• Deploying and configuring deployment files, environment variables, unit testing and version control.
• Implementing high availability (HA) in client APIs, replicating query tables.
• Design event flow input and output streams.
• Implementing aggregate functions, embedded adapters.
• Testing and debugging packages.
• Development of modules, interfaces, dynamic variables, containers and parameters.
• Maintaining Java & Python functions and client APIs.
• Interpreting business rules and domain knowledge for better design of event flow solutions.
• Monitoring and administering streambase server cluster environment.
• Designing HDD (High level Design Document) for Integration.
• Development of BW Process Templates for reusability of BW Process logic.
• Used Java utility codes from the BW Processes by calling them across the templates.
• Implementation of AE and RV messages in Multicast Request/Reply, Point-to-Point Request Reply, Publish/Subscribe messaging.
• Involved in Unit and Integration testing, bug fixing, acceptance testing.
• Deployment in services in Distributed Queue and Fault Tolerance modes.
• Configuration of TIBCO Substation DPL (Dynamic Program Link) and Triggers.
• Configuration of JMS Queues on Weblogic 7.2 Administrator.

SUMMARY:

DATA MINING & ANALYTICS, BUSINESS INTELLIGENCE & DATA VISUALISATION, BIG DATA (9years)

Tools: Hortonworks (Hadoop), Apache Spark, Python, R, SAS Base & Enterprise, SSAS, Enterprise Miner, AWS, Spotfire, Tableau, Qlikview, Orange, SSRS, SPSS, Matlab, Mathematica, Maple, PerformancePoint, Excel, Salesforce, Google Analytics

• Exploratory Data Analysis—used dynamic visualization, advanced statistical techniques and core data mining capabilities to quickly identify relationships and opportunities for outreach.
• Model Development and Deployment—Streamline data mining processes to create highly accurate descriptive and predictive analytic models based on large volumes of data.
• Algorithms for Data Mining, Machine Learning, Credit Analytics and Risk Analytics—Decision Trees, Neural Networks, Clustering Algorithms, Linear and Logistic Regression Analysis.
• Design, build and implement dashboards (KPI’s, Metrics) for critical & strategic management decisions and operations for C-Level Execs, SVPs, VPs, Directors & managers of different lines of business.

ETL, DATA WAREHOUSING & DATA MARTS, EDI & FTP (9years)

Tools: Teradata, ODW, SSAS, Informatica, ODI, SSIS, Excel, CloverETL, TalenD, SQL Server, Adeptia, Pentaho

• Building, implementing & documenting ETL packages, transformations, sessions, workflows & data mappings, change data capture, slowly changing dimensions & XML.

DATA MODELING & DATABASE DESIGN, CUBE DEVELOPMENT (OLAP) & DIMENSIONAL MODELING (9years)

Tools: Toad Data Modeler, Erwin, SQL Profiler, SSAS, Microstrategy, Visio, Excel, Spotfire, Tableau, Visio, ER Data Architect

• Building & implementing data marts, data cubes (OLAP), schemas, & logical data models.

UAT, ERP, APPLICATION SUPPORT, ENHANCEMENTS & REQUIREMENTS GATHERING, SYSTEMS ANALYSIS & DESIGN, SDLC & SCRUM (9years)

Tools: Visio, Excel, SharePoint, Word, InfoPath, Project, Oracle PeopleSoft, Web based applications, PowerPoint, Project, MS Dynamics, SAP

• Building workflows & process documentation, business process modeling, lean six sigma QA, user acceptance testing, documenting business requirements, business process reengineering, technical support, project management & implementation, expert systems & best practices research.
• Document sprints & programming unit tasks for AGILE software application development (SCRUM).
• Installing, configuring, maintaining, developing & implementing SAP, Microsoft Dynamics, and Oracle PeopleSoft.

SCHEDULED & AD HOC REPORTING (9years)

Tools: SQL Server, DB2, Oracle 10,11g, Toad Data Point, SQL Server 2005/2008/2008R2/2012, SSAS, SharePoint, Crystal Reports, SSRS, EDI Server, FTP, Teradata, Excel, Access, Spotfire, SAP Business Objects, Microstrategy, Tableau, SAS, Qlikview, Toad

• Generate, QA and validate reports daily, weekly, monthly & quarterly.
• Develop & implement automated scheduled reports.
• Write complex sql queries, stored procedures and user defined functions for adhoc & scheduled reports.

SOFTWARE & WEB DEVELOPMENT, DATABASE DEVELOPMENT (6years)

Tools: SQL Server, Eclipse, SpringSTS, Google Web Toolkit, Oracle 10g, 11g, Microsoft Visual Studio

• SQL development
• Java, C#, DOT NET programming for web based applications.
• J-Unit testing.

Desktops, Systems, Virtualization and Network Support

Tools: VMware ESX, VSphere, Windows Server 2008, Windows XP to Windows 8 Troubleshooting, Active Directory, Microsoft Exchange & Microsoft Office 2003 - 2013.

• Configuring LAN/WAN technologies, VLANs, DHCP, DNS, VPN, Routing, Switching and RAS.

TECHNICAL EXPOSURE:

Numerical Analysis, Text Mining and Modeling of Mathematical, Financial and Physical Systems

• Proficiency in Python, R, SAS, MATLAB, machine learning, text mining, predictive modeling,
• Analysis of Variance, Linear Regression, Hypothesis Testing, Interpolation, Linear Programming, Monte Carlo Methods, Markov Chains, Black Scholes, VaR, Martingale & Quant finance models.

Data Modeling, Data Mining, Business Intelligence & Analytics, ETL, Data warehousing & Reporting

• Extract, Transform and Load (ETL) Tools such as CloverETL, SQL Server Integration Services, TalenD, Adeptia, Oracle Data Integrator, Pentaho & Informatica.
• Designing logical data models & schemas.
• Proficient in Creating reports & visualization with Tableau, Spotfire, Microstrategy & Qlikview.
• Designing, implementing and administering OLAP cubes for data warehouses and data marts.

Experience with Database Management Systems& Enterprise Resource Planning Systems

• Proficient in SQL Server 2005/2008/2008 R2/2012, DB2, Oracle 10g, 11g, Teradata and MySQL.
• Relational Database Design:ER Data Architect, DBDesigner 4, CA ERWin Data Modeler R7, MySQL Workbench, Toad Data Modeler 3.3, UML, Toad Data Point.
• Proficiency with SAP, Oracle Applications, Oracle PeopleSoft and Microsoft Dynamics.

Software and Programming Language Proficiency

• Object-Oriented: Java, Microsoft Visual Studio C#, and PHP.
• Object-based, procedural and event-driven: Visual Basic, VBA, Python, IronPython, C and C++.
• Database query languages: T-SQL, PL/SQL, DMX, MDX.
• Software Development life cycle, Test Driven Development, Dependencies & SCRUM.
• Technology Stack: Hibernate, J2EE, Maven, SpringSTS, Eclipse, and JPA.

Web applications: Microsoft ASP.NET 4.0 Framework, Google Web Toolkit and PHP.

• Proficiency with HTML, CSS, JavaScript, XML, flash, HTTPS, web certificates and TLS.
• Web Services: Web Services Descriptive Language (WSDL), Service Oriented Architecture (SOA), Remote Procedure Call (RPC), REST and SOAP.
• Web Content Management Systems: Microsoft SharePoint, Joomla, WordPress, Moodle, & Web Servers: Apache, Microsoft IIS7.

PROFESSIONAL EXPERIENCE:

Principal Business Intelligence / Analytics Consultant

• Design & implement end-to-end analytics & big data solutions using Spotfire, Tableau and NoSql technologies.
• Antares Capital: Deployed Azure machine learning models on data residing in hadoop cluster. Designed, architected and implemented spotfire environment and developed operational insights dashboards for go live. Migrated reports from Power BI to spotfire from different lines of business. Setting up infolinks and data connections to disparate data sources including Hive, Sql Server, Redshift, Teradata and other external data sources.
• McKesson: Implemented contract and provider analytics dashboard project using spotfire. This data product included a series of spotfire dashboards tracking contract and provider metrics, KPI’s, regression analysis with contract coverage, clinical studies, SLA’s, drug manifestations, etc.
• Monsanto: Designed and developed a global supply chain perfect order data product and other finance, marketing dashboards using spotfire. Redesigned and configured spotfire server and web player server clustered High-Availability platform to accommodate a 1000+ user base across North America, South America, Europe, and Asia & Africa. This included a hybrid architecture scaling up and scaling out with cloud integration. 
• Redesigned and developed a global supply chain dashboard and guided analytics operational intelligence tool using spotfire. 
• Designed a reporting new data model from data-warehouse (Teradata), other big data sources (structured & unstructured) and data virtualization layer (Info model-spotfire) to feed the spotfire reports and dashboards with optimum performance.
• Refactoring and development of reports and dashboards using spotfire and extending the platform for extra and custom capabilities with iron-python, JavaScript and R. 
• Setting up and configuring automation services for data refreshes and migrations to different spotfire server environment.
• Training of developers and analysts, knowledge base documentation, setting up a spotfire BI standards center of excellence with best practices use cases well documented. 
• Collaborated with data science team to integrate machine learning algorithms and predictive analytics data products within the spotfire platform.
• Planned out and executed spotfire patch and upgrade for 7.0 & 7.5
• ConocoPhillips: Designed and developed operations real-time dashboards for production engineering support, finance, water disposal, production optimization and consolidated data products using spotfire for business unit.
• USDA: Designed and developed predictive analytics data product using tableau for managing business loans to small business, farmers, etc. Product included weather data, census data, loan status data, etc.
• Frontier Communications: Redesigned and architected spotfire platform integrating it with AS400 systems via data virtualization platform.
• Bank of America: Integrating SAS & R into Spotfire & Tableau to build dashboards and analytic products for different lines of business. Also worked with offshore administration teams maintaining spotfire and tableau server environments. Pioneer member of team that established ETL and BI center of excellence. Transitioned to data science team building machine-learning algorithms, text mining and other data products to support different LOB’s and enable bank to meet SLA’s with client agreements.

Sr Business Intelligence / Enterprise Analytics Consultant

• Design & implement Business Intelligence platform for Sales Engineering, QA and Marketing departments. SME, Training Analysts & developing C-level Exec dashboards.

Sr Business Intelligence / Enterprise Analytics Consultant

• Design & implement Business Intelligence platform for supply chain, inbound logistics, finance & EPMO departments. SME, Training Analysts & developing C-level Exec dashboards.

Sr Business Intelligence Consultant

• Design & implement Business Intelligence platform & data warehouse for different lines of business. Spotfire & Tableau SME, Operational & Portfolio Reporting & Analytics.

Sr Business Intelligence Consultant

• Design & implement Business Intelligence platform & decision engine. Spotfire SME, Reporting & Analytics, Quant modeling, Data Mining, Portfolio optimization & Application production support.

Sr Business / Data Consultant

• Leveraging & Utilizing Business Intelligence tools to deliver Value Added Analysis, Executive dashboards, Scheduled & Adhoc reporting & Data Mining Outreach for Leads. Analytics & BI(SAP, Tableau, Toad Data Point, Toad Intelligence Central, Qlikview, Spotfire, Cognos, Business Objects, Tableau, SSAS, SSRS,SAS, SQL management Studio, Excel & SharePoint). ETL processing using Teradata, Informatica & SSIS.

Sr Consultant / Software Developer

• Complete design and implementation of software applications (web & databases) using SpringSTS, Google Web Toolkit. Developed ETL processes using SSIS, SSAS including client data imports & auditing. Oracle & SQL Server 2008 development, database modeling, schema optimization, stored procedures, user-defined functions & query optimization. Tableau & Spotfire dashboard design, implementation and maintenance.

Sr. Business/ Data Consultant

• Collaborated with accounting, finance and IT department to ensure efficient billing enterprise resource planning system, all billing functions and financial reports at national headquarters.(SSAS,SSRS,SSIS)

Business Systems Analyst / SQL Developer /C#, Java .NET Developer

• SQL scripting & tuning, stored procedures, reporting, systems design, analysis & implementation, enterprise data management, requirements gathering, technical & operational support using Microsoft technology stack, SAP & Oracle ERP. Application design and development.

Database / Application Developer II

Confidential

• Designed, developed & implemented ERP system. Requirements gathering & business process modeling for enhancements to ERP system. Logical database design for applications & maintenance of Ops prod DB.