SUMMARY:

• Around 9 years of IT experience in Data analytics with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of decision support systems in the Healthcare (Medicare/Medicaid), Railroad, Insurance, Utilities, Aerospace/ Defense and Public Sectors.
• 5+ years of data visualization experience using Tableau and Python .
• 5+ years of experience doing data analysis and data mining using python using libraries like pandas, scikit, matplotlib, numpy etc.
• Hands on experience on Tableau Desktop versions 7/8.2,9.2, Tableau Reader and Tableau Server.
• Hands on experience with data integration at on premise, oracle cloud, and AWS.
• Infrastructure assessment of hardware and software for health cluster.
• ETL Processing Using AWS Data Pipeline and Amazon Elastic MapReduce.
• ETL workflow pushing webserver logs to an Amazon S3 bucket, cleans and filters the data using Pig scripts, and then generates analytical reports from this data using Hive scripts. 
• Data integration with cloud using Amazon Redshift, Amazon RDS for MySQL
• Hue within EMR to perform SQL - style queries quickly on top of Apache Hive.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
• Communicate effectively with colleagues and business users.
• Data modeling experience using Erwin.
• Experience with relational databases such as Oracle8i/9i/10g/11g, Netezza, Teradata and unstructured data sources (XML, COBOL and flat files)
• Extensive logical and physical design of OLAP and OLTP databases
• Strong experience designing Star Schema and Snowflakes Schema in relational database design.
• Business process modeling using SWOT analysis and Project management methods like UMI, RAD, RID Gantt Charts, IDFF etc.
• Predictive Modeling, Predictive analytics using Python or R Experience
• Designing a RESTful web services and web API using python.
• Data Profiling and Data cleansing experience.
• Experience of production support and making sure loads are done in an efficient manner
• Experience in SQL, PL/SQL packages, functions, stored procedures and materialized views to implement business logic in oracle database.
• Developed test cases for business and user requirements to perform System/Integration/User Acceptance testing .
• Prepared Code Migration requests using automated code migration tool.

TECHNICAL SKILLS:

BI Tools : Tableau Desktop 7.0, 8.2, 9.2.3, Tableau Server, OBIEE11g, Pentaho, Informatica Power Center 9.x/8.x/7.1/6.2/5.1, MDM, IDQ, Cloud

Data Modeling : Erwin Data Modeler r7.3/4.x (ERD), MS Visio 2000

Databases : Oracle 8i/9i/10g MS SQL Server 2000/2005, MS Access, Teradata, Netezza

Job Schedulers : Tidal, Control M

Languages : Python, Javascript, R, SQL, Oracle PL/SQL, Korn Shell Scripting (KSH)

Version Control : MS Visual Source Safe (VSS), IBM Rational ClearCase

Others : Microsoft Office 2010 (Excel, PowerPoint), WINSCP, PUTTY.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Analytics Consultant

Responsibilities:

• Python programming for data manipulation and visualization using javascript and python libraries.
• Dashboard/report development and preparing models(correlation/regression, supervised and unsupervised learning models.
• Data mining, Statistical modeling, Predictive Modeling for leasing decisions.
• Clustering & Segmentation analysis for customers.
• Implemented Time series analysis, forecasting & multivariate methods for sales department.
• Designing a RESTful web API using python.
• Advanced data visualization using javascript, python and tableau.

Confidential, New York state

Data Engineer

Responsibilities:

• Gathering Requirements with high level end users, from clinic, agency to director of nutrition.
• Data mining using Python applying bayesian methods for classification of vendors.
• K means clustering for participants and vendors.
• Doing extensive data analysis, designing analytical application for data mining and reporting for BSI (Bureau of special investigations), Vendor management, Clinic, Nutrition, Caseload Management, Quality Assurance, Food Management, EBT (Electronic Benefit Issuance, Fiscal/Financial Management.
• Generating multivariate predictive models using python & R.
• Connecting to Hive and Impala running on Amazon EMR via the ODBC driver for Amazon EMR.
• Using Tableau to Visualize the Data from Impala.
• Data integration with cloud using Amazon Redshift, Amazon RDS for MySQL
• Hue within EMR to perform SQL-style queries quickly on top of Apache Hive.
• Hadoop data analysis with Tableau server 10.0.
• Preparing High level and low level technical specifications, doing extensive data analysis and business analysis using several reporting application.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Large reduction of time-stamped data in transitional database using seasonal decomposition, time series analysis .
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• Created drill down and drill up in worksheets in tableau.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Involved in license management SLA's with Tableau support.
• Prepared proof of concept for best practices in Tableau deployment.
• Developing a Dashboards and preparing ad-hoc Reporting.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI’s.
• Business process modeling using SWOT analysis and Project management methods like UMI, RAD, RID Gantt Charts, IDFF etc for WIC
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau Desktop 9.2.3, Tableau Server, Windows vista/7, Python 3, Scikit, d3.js, pandas, numpy

Confidential, Omaha, NE

Sr. Data Engineer

Responsibilities:

• Creating and validating bayesian models.
• Statistical modeling, Predictive   Modeling, social network analysis   & Data visualization for executives.
• Sensitivity analysis & running monte carlo modeling and performing statistical   inference, Statistical analysis using fuzzy data.  
• Conducted exploratory analysis identified relevant classifiers.
• Applying NLP,  Pattern recognition, classification, clustering, regression/fitting, using python 2.
• Bayesian model diagnostics & selection, Markov chain monte carlo.
• Implemented Time   series analysis, forecasting & multivariate methods .
• Confidence interval, Linear regression, Logistic regression, model selection, non linear regression, hypothesis testing.
• Knowledge of scrum agile methodology of software development.
• Responsible for conceptualizing semantic, logical and physical layer for supporting user requirement.
• Developed analytical application improved the performance of standard and adhoc reports from 20-30 min to less than 3 sec. for custom and less than 6 sec for adhoc reports.
• Created dashboards for analyzing POS data using Tableau 8.0.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
• Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Scheduled extract refresh for weekly and monthly reports.
• Experience in design and development of Tableau visualization solutions.
• Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Working on generating various dashboards in Tableau server using various sources such as SAP HANA/SQL Server/Teradata/Oracle.
• Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Created drill down and drill up in worksheets in tableau.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Involved in license management SLA's with Tableau support.
• Prepared proof of concept for best practices in Tableau deployment.
• Developing a Dashboards and preparing ad-hoc Reporting.
• Worked on workbook Permissions, Ownerships and User filters.
• Business process modeling using SWOT analysis and Project management methods like UMI, RAD, RID Gantt Charts, IDFF etc.

Environment: Windows vista/7, PL/SQL developer, Netezza, Erwin, Agile/Scrum development methodology, Teradata SQL assistant, ODI, Tableau 8.1, Tableau Server

Confidential, Costa Mesa CA

Data Engineer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Experience in Marks, Publisher and Security concepts.
• Experience with creating Worksheets and Dashboard.
• Experience with Tableau for Data Acquisition and data visualizations.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created the Test Evaluation and Summary Reports.
• Experience in BI interactive Dashboard.
• Experience of Client-Interaction on onsite/Offshore.
• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on EMPI databases and generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Embedded Tableau views in to SharePoint
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding.
• Business process modeling using SWOT analysis and Project management methods like UMI, RAD, RID Gantt Charts, IDFF etc.

Environment: Windows vista/7, SQL navigator, Toad, Fixed width flat file, Mainframe COBOL files, Tableau 7.0.6, Tableau Server

Confidential, Los Angeles, CA

Tableau Consultant

Responsibilities:

• Captured the business requirements , worked on gap analysis, and prepared the gap analysis document.
• Interacted with business users for gathering requirements for BASV Projects Dashboards.
• Prepared Use cases and look and feel documents and got reviewed with end users.
• Generated Tableau dashboards for e-bills and paper bills comparison.
• Generated tableau dashboards with quick filters and sets for project codes connecting to Oracle Database.
• Generated adhoc Tableau reports on demand for providers.
• Generated Tableau reports with Trend lines.
• Generated Tableau Dashboards with Oracle Essbase multidimensional database.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Performed incremental extracts for OLAP database.
• Created actual sales and target sales view with Trend lines, table calculations to see the difference between each quarter.Designed and developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Involved in Migration, UAT, Go-Live, and Production Support
• Demonstrated ability to produce Executive Level Tableau Dashboard visualization for Senior Management
• Tableau SME with strong expertise in Tableau visualization / Reporting on complex projects

Environment: Windows vista/7, SQL Server Management Studio, Toad, DB2, Fixed width flat file, ODI, Tableau 7.0.2, Tableau Server

Confidential, San Diego, CA

Tableau Developer

Responsibilities:

• Interacted with Business Analysts and Users in gathering and analyzing and designing the Business Reports Requirements.
• Worked as Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, participated in the Design Team and user requirement gathering meetings.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Generated Tableau combination charts using Tableau visualization software.

Environment: Windows vista/7, Oracle, Toad, Tableau 6.0.4, Tableau Server

Confidential, Santa Ana, CA

Business Intelligence Consultant

Responsibilities:

• Conduct a gap analysis between Current and Future Service and Application model options and identify required changes to processes and technology and successfully implement the organizational redesign.
• Conducted Dimensional Modeling Analysis for each ORDM subject area
• Delivered: (Migration Project Cognos to OBIEE) Prototype of dashboard and Reports. Delivered Dashboards like Inventory, Spend Analysis, Manufacturing Planning, Supplier Dashboards, Material Deflation and Productivity, High cost vs. low cost country reports.
• Used inline Lookup within the transformation language script (tgp) in DT studio and using an external table (XML), and dynamically using variables of type code: lookup Table
• Used mapper, serialiser, parser for parsing COBOL files (EBCDIC)  
• Used Powercenter unstructured data trasnformation to automate realtime transformation of unstructured data.
• Conducted Use Case analysis for each functional area based on requirements and business cases.
• Was responsible for Data Modeling of events and filings subject area using Erwin .
• Loading XML files to oracle using Informatica, handling variable length XML files using Informatica.
• Have led the team for Stress testing and optimization .
• Experience processing multiple XML files using Informatica .
• Coordinated the release management and migration support for PAT.
• Business requirement gathering by conducting several iterative Joint Application Design ( JAD ) sessions and interviews with the business user community and business analysts for the new CCMS application.
• Developed dashboards with grids, charts, KPIs, filters and drill down.   Used query as web option to build visualizations based on the reports built in Business Objects.
• Exported visualization contents to various file formats (PDF, PPT, HTML and Flash).
• Involved in troubleshooting the visualizations for various problems faced during data connectivity.
• Actively involved in designing, developing, creating complex and simple mappings, Mapplets using Informatica source, warehouse and loading the data .
• Scheduled the workflows using Informatica scheduler and enhanced the data mart as per business specifications.
• Used XML Parsers and Generators to handle inbound and outbound XMLs in Informatica.
• Installing Informatica Power center 9.0/8.x/7.x/6.x on windows/ Linux environment.
• Developed ETL Design Documents and managed the Business rules and data validation .
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Worked with transformations such as expression, filter, router, update, union, lookup, rank, connected stored procedures, aggregator, and sequence generator, Sorter, joiner transformation.
• Managed development and production environments using Power Center, MS SQL Server . Monitored the load jobs, error log files for regular load and interacting with end users.
• Checked the accuracy of data loaded into Teradata.
• Tuned Teradata SQL queries (explain plans, collect statistics, primary and secondary indexes) for better performance.
• Maintained both development and production environments since a long time using Power Center, Oracle (PL/SQL). Monitoring the load jobs, checking the error log files for regular load and interacting with users were my primary focus areas
• Use ClearCase for version control across common source code used by developers
• Deploy all the code that has to be migrated to QA/Production environment
• Coordinate with System Testing and UAT team to analyze and resolve opened defects.
• highly visual analytical dashboards using Tableau.
• ability to produce Executive Level Tableau Dashboard visualization for Senior Management

Environment: Windows vista/7, MS SQL Server 2008, Erwin, XML, OBIEE 10.1.3.4

Confidential, Fort Worth ,TX

OBIEE Developer

Responsibilities:

• Coordinated in the client installations and integration of OBIEE 10.1.3.3, DAC and Informatica 7.1.2
• Implemented conditional formatting using OBI Publisher.
• Involved in RPD Development , Oracle BI Administration, Oracle BI Answers and dashboards.
• Actively Participated in Team meetings and discussions to propose the solutions to the problems.
• Involved in setting up LDAP security and Data level, Object level and user level security.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges.
• Created the Custom Dashboard for the custom reports and aligned the reports within the dashboard according to client requirement.
• Worked in multi user environment in OBIEE.
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers .
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Configured DAC - Data warehouse Application console for running of ETL jobs
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web / Oracle BI Presentation Services.
• Performance tuned report queries by using indexes, parallel hints and optimized the queries generated in answers.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• ability to produce Executive Level Tableau Dashboard visualization for Senior Management

Environment: OBIEE 10.1.3.4, Teradata, WINSCP, PUTTY, ERWIN, XML

Confidential, Ontario, CA

Reporting technical consultant

Responsibilities:

• OBIEE reports development (using List, Crosstab, Funnel, Chart, Alerting, Conditional Formatting).
• Designed and conducted unit tests of new or changed RPD objects and ETL mappings Interacted with business units to understand their needs and design appropriate RPD objects.
• Developed and maintained corporate data model, documented various data sources.
• Worked in conjunction with users for developing dashboards.
• Developed complex OBIEE reports, building RPD, designing aggregate tables, reports and dashboards. Did performance tuning for Informatica mappings and RPD object.
• Business requirement gathering by studying the current enterprise model
• Interview Subject Matter Experts and IT team and develop foundational understanding of current system architecture
• Develop high-level estimate using Microsoft Project Plan, schedule, resource plan and risk analysis
• Develop a full lifecycle proof of concept to further explore selected technology option
• Supplement financial analysis by comparing performance over time across key value drivers using Value Analytics
• Actively involved in designing, developing, creating mappings, mapplets using Informatica source, warehouse and loading the data.
• Scheduled the workflows using Informatica scheduler and enhanced the data mart as per business specifications.
• Developed ETL Design Documents and managed the Business rules and data validation.
• Worked as Informatica Administrator.
• Hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man).
• Checked the accuracy of data loaded into Teradata.
• Tuned Teradata SQL queries (explain plans, collect statistics, primary and secondary indexes) for better performance.
• Working with ETL leads to formulate ETL approach and appropriately uses Teradata Tools and Utilities.
• Analyzed the Fulfillment requests (FR) and Change request (CR) as per requests from HPPM.
• As per Fulfillment requests (FR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Performed Upgrading Informatica Power center Version 7.x to Informatica Power center 8.X.
• Ensures proper configuration of the Power Center Domain components.
• Experience in nodes, Repository services and Integration services.
• Ensures proper application of the licensing files.
• Create, backup, restore for Informatica Repositories.

Environment: TOAD, Oracle9i, MS SQL Server, Teradata and sql, Oracle, OBIEE 10.1.3.4, Control M

Confidential, Madison, WI

Datawarehouse Consultant

Responsibilities:

• Collaborated with Business contacts & Business Analysts in the analysis and preparation of OBI data requirements
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
• Performed migration and merging of RPD’s in OBIEE .
• Created Drill down Hierarchies and implemented Business Logics for Facts .
• Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
• Creating dimensions, aggregations and keys using admin tool. Customizing Physical Layer, BMM Layer and Presentation Layer using OBI Administration tool.                                                                        
• Developed Global prompts, Filters, Customized Reports and Dashboards using OBI presentation services.
• Creating Users and Groups and managing the object level and data level security .
• Creating MUD - Multi User Development and assigning project based on BMM layers or Catalog Level (Subject area level)
• Managing the intelligent dashboards by using dashboard, page and report level security.
• Creation of views like Pivot table , Column Selector, Compound layout .
• Involved in fine-tuning the reports by working extensively on the Caching Strategy .
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Provided test data QA team to validate front end application and also involved in unit testing .
• Extensively used Oracle Delivers and iBots so as to provide alerts.

Environment: Oracle10.1.3.1, Informatica Power Center 7.x, Linux, Windows XP