PROFILE SUMMARY:

Data Scientist / Data Analyst/ Tableau Consultant with 19+ years of experience executing data - driven solutions to increase efficiency, accuracy, and utility of internal data processing. Experienced at creating data classification and clustering models, using predictive data modeling, and analyzing data mining algorithms to deliver insights and implement action-oriented and statistical machine learning solutions to complex business problems.

PROFESSIONAL SUMMARY:

• Around 19 years of extensive experience in Business Analysis, Data Warehousing, Management and Business Analysis, Business Development
• Extensive experience with Tableau Desktop and Tableau Server in Tableau 9.x and 10.x as a Consultant
• Experienced with supervised and unsupervised machine learning algorithm such as logistic regression, random forest, KNN, SVM, linear regression, lasso regression, XGBoost, and k-means
• Experience of working on Python 3.5/2.7 (Numpy, Pandas, Matplotlib, NLTK and Scikit-learn)
• Excellent Tableau Developer with an expertise in building and publishing customized interactive reports and dashboards with customized parameters and user-filters using Tableau
• Experience in implementing data analysis with various analytic tools, such as Anaconda 4.0 Jupyter Notebook 4.X and PyCharm
• 4+ years of experience developing Tableau Data visualization reports and dashboards
• Extensive Experience ETL/ELT Designing and Implementing Data Warehouses and Data Marts in MS SQL Server, Netezza and Oracle databases using UNIX and Windows platforms.
• Extensively worked in Extraction/Transformation/Loading of the legacy data to Data warehouse using SQL Server Integration Services (SSIS) and Informatica Power Center.
• Created Complex Stored Procedures which could be used in SSIS and Informatica for re-run ability and performance.
• Responsible for creating Complex Informatica Mappings to load data from different environments to Oracle Database.
• Experience in writing Unix Shell Scripts in UNIX environment for pre-processing data and scheduling Workflows.
• Expert in applying Insert/Update Strategies using Flip Table Logics in Netezza.
• Experience in designing/developing Informatica Mappings using transformations like Connected and Unconnected Lookup, Router, Filter, Aggregator etc.
• Implemented complex business rules in Informatica by creating re-usable transformations, and robust mappings/ mapplets.
• Experience in creating Indexes for faster performance and different types of views for controlling user access for querying database.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Hands on experience in writing, testing and implementation of the SQL programs, stored procedures, Functions, Views, Packages and performance tuning of SQL queries.
• Experience on Creating detailed project outlines and application design specifications.

SKILLSS:

Languages: Python, R

Machine Learning: Logistics Regression, Naive Bayes, Decision Tree, Random Forest, KNN, Linear Regression, Lasso, Ridge, SVM, K-means

Data warehousing: Informatica Power Center, SSIS, SQL*Loader, NZ Load.

Databases: Netezza, Oracle 11g/10g/ 9i/ 8i (ODBC), MS SQL Server, DB2.

BI Tools: Tableau, Cognos, Business Objects 5.0, BIDS (SSIS, SSRS), Logi Analytics

Programming: Python, SQL, PL/SQL, UNIX Shell Scripting.

Web and Tools: TOAD, SQL*Plus, Perforce, TIDAL Scheduler, AUTOSYS, Workbench

WORK EXPERIENCE:

Confidential

Sr. Data Scientist / Tableau Consultant

Responsibilities:

• Gathered Business Requirements. Interacted with the Users, Designers and Developers, Project Manager to get a better understanding of the Business Processes. Analyzed and optimized the process.
• Worked according to the software development life cycle.
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees).
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Created Report-Models for ad-hoc reporting and analysis.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse
• Worked extensively with the ERwin Model Mart for version control
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Provide 24 x 7 problem management support to the development team.
• Document various Data Quality mapping document.
• Perform small enhancements (data cleansing/data quality).
• Trained team members with project knowledge and business processes.
• Develop enterprise Business Intelligence (BI) solutions using Tableau
• Create dashboards and reports within Tableau, developing impactful presentations and documents
• Design and implements proof of concept solutions and create advanced BI visualizations
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Administered user, user groups, and scheduled instances for reports in Tableau
• 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.

Environment: Informatica with IDQ, R/R studio, Python, Tableau Desktop Tableau Server, UML, Agile, Oracle, PL/SQL, Visio2003, Visual Basic, MS Office Suite, QTP, Windows NT and UNIX.

Confidential

Sr. Data Analyst / Tableau Consultant

Responsibilities:

• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
• Conducted JAD sessions to gather requirements, performed Use Case and work flow analysis, outlined business rules, and developed domain object models
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database
• Created a conceptual design based on the interaction with the functional and technical team.
• Analyzed the existing data model and incorporated new additions for the advancement data into the data model identifying the cardinality of the new tables to the existing tables and ensure proper referential integrity of the system
• Analyzed, created and formatted the Reports as per Business Requirements.
• Analyzed and created various Ad-hoc Reports for users based on User Requirements.
• Created both list and drill down reports identifying the data hierarchy
• Performed report validation writing SQL queries using TOAD on an Oracle database.
• Created process documents, reporting specs and templates, material and slideshow presentations for the application development teams and managements
• Analysis of the data identifying source of data and data mappings of BHC.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Create dashboards and reports within Tableau, developing impactful presentations and documents
• Design and implements proof of concept solutions and create advanced BI visualizations

Environment: Oracle 10g, Windows, Tableau Desktop, Tableau Server MS Visio, MS Project, Informatica

Confidential, California

Sr. Data Analyst

Responsibilities:

• Work with users to identify the most appropriate source of record and profile the data required for sales and service.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the business/transformation rules applied for sales and service data.
• Define the list codes and code conversions between the source systems and the data mart.
• Worked with internal architects and, assisting in the development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Responsible for defining the key identifiers for each mapping/interface
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Involved in configuration management in the process of creating and maintaining an up-to-date record of all the components of the development efforts in coding and designing schemas
• Developed the financing reporting requirements by analyzing the existing business objects reports
• Interact with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Responsible in maintaining the Enterprise Metadata Library with any changes or updates

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects Scheduler, WIN CVS and SSRS

Confidential

Data Analyst & Project Manager ( SQL/SSIS/SSRS )

Responsibilities:

• Involved in the full systems life cycle and responsible for designing, developing, testing, implementing and supporting applications software that is delivered on time, in line with business objectives.
• Extensively work in NETEZZA and SQL SERVER databases in UNIX as well as Windows Platforms.
• Worked extensively in migrating the data from ORACLE to NETEZZA platform using INFORMATICA and Oracle to SQL Server using SSIS.
• Used reverse engineering to convert the old legacy system to Netezza platform and designed completely reusable ETL reconcilable framework.
• Gather the business requirement by interacting with business users and convert the functional aspects into technical specifications
• Developed SQL codes using Flip Table Logic to properly perform the INSERT and UPDATE in EDS tables.
• Performed Code review and testing for the code developed by offshore and coordinated in Release meetings and making the release manual for production deployment.
• Used WINCVS to maintain versions of all SQL and Unix scripts and leveraged it to migrate the Codes to QA environment.
• Involved in important role in Media sales project for the reverse engineering of PACING revenue project -This project involves migration using Informatica to Netezza platform.

Environment: MS SQL SERVER, SSIS, Netezza Database, Informatica Power Center 9.0 and 8.6, MS SQL Server, SSIS, Oracle, TOAD, Putty, WINSCP, UNIX, TIDAL Scheduler, WIN CVS

Confidential

Business Manager - Business Development/ Trainer

Responsibilities:

• Use research and questioning techniques to gain in-depth knowledge about clients in the following areas: business strategy, goals, priorities, and issues; needs and expectations of the service provider; industry, market, operations and competition in all regions; business cycle; organisational life cycle.
• Improve profitability through pricing, alternate revenue generation opportunities and introduction of low cost servicing platforms
• Drive client revenue through sales and implementation of value added tools Pitch preparation - exceeding client expectations and competitor's offering.
• Employ tactics to collect competitor data.