Vaibhav Lila Jayan

646-***-****

add5i7@r.postjobfree.com

Summary:

Professional, results-driven, SAS, Alteryx Certified Business Intelligence Consultant offering over 8 years of work experience with various Fortune 500 companies. Worked in all phases of SDLCs and various Data environments such as Microsoft SQL Server/Oracle. Consummate in SQL, ETL, Datawarehousing, Tableau, Informatica, Alteryx, Project Management, and MS Office Suite across different functional domains such as Banking, Healthcare, Accounting and Treasury.

Education:

Master of Science (MS)

Management Information Systems (MIS).

University of South Florida,

College of Business, Tampa, Florida

GPA 3.86/4.0 [May 2014]

Bachelor of Engineering (B.Tech)

Electronics & Communication

University of Kerala,

India

[Aug 2008]

Skills:

SQL, SQL Server Management Studio, SSIS, Tableau, Alteryx, Informatica Power Center Databases - SQL Server 2008,2012,2014 MS Office Word, Excel (Advanced Excel- Pivot, PowerPivot, Macros) Access (Advanced – Pass- through queries, linked tables, Reporting) Programming - T-SQL, PL SQL Project Management- SCRUM - JIRA Confluence Networking TCP/IP OS - Windows /Mac/Unix/Linux. Professional Experience:

Senior Associate/Senior

Consultant

ADVANCED RISK COMPLIANCE

ANALYTICS

PricewaterhouseCoopers

(San Francisco, USA)

[Dec,2017 – Current]

Conceptualized and built tech-enabled solutions leveraging industry and technical expertise including SQL, Alteryx, Tableau and other BI tools to identify risks in a highly agile environment.

Enhanced internal audit functions to further align to company strategy and risk using advanced data tools.

Increased value and reduced costs of compliance-related activities across different domains and industries, applying the concepts of Enterprise Risk Management to help companies identify, assess, mitigate and proactively consider emerging risks.

Curated, Architect, Designed and built Ideas from inception to automation as part of Robotics Process Automation, Center of Excellence team at PwC.

Consultant/Product Engineer

DELOITTE CONSULTING

INNOVATION

Deloitte Consulting LLP

(New York, USA)

[Jan, 2015 – Nov, 2017]

Designed the technical integration and validation of client data sources needed to power a cloud based analytic product.

Architect ETL logic aligning to the requirements and data received from the client.

Resolution of complex issues in both backend and frontend using strong working knowledge on data analysis and hands-on experience with relational database management systems and SQL (i.e. Microsoft SQL Server)

Accomplished automation of client data transfers using various scripting languages and BI tools.

Designed workload automation using softwares such as (Active Batch)

Exploratory data Analysis of healthcare data (e.g., EDI, bills, claims) – processing of EDIs e.t.c. to provide valuable insights of client data.

Data Analyst/Performance

Metrics Analyst

DATA SCIENCE & PERFROMANCE

IMPROVEMENT

Lakeland Regional Medical Center

[Sep, 2014 – Jan, 2015]

Exploratory data analysis across the enterprise and presenting information and key insights that supports the organizations strategies using advanced technical tools (Tableau, SQL Server, and Crystal Reports) and expertise.

Built reports hospital-wide statistics required to support LRMC/Decision Support Service measurements.

Device and design dashboards (Tableau, Excel, Crystal reports) helping in accomplishing organization’s goals.

Prepares external regulatory reports to include AHCA filings and the annual AHA Survey.

Work across all IT teams and maintain a purview of standards and documentation of all Data Science solutions.

Analyze and propose modern solutions to replace legacy systems and data, such as individually created and widely dispersed databases and spreadsheets, to better align with LRMC enterprise information standards and strategies for single source of data, and integration.

Collaborate with and across all departments to translate business needs for information and knowledge into long term data science solutions that add value to the organization. Document and build consensus for the proposed designs and solutions.

Clinical decision support and evidence-based protocols, reducing the likelihood of medication errors, and rapidly restore access to data in the case of a disaster or outage. Graduate Research

Assistant

University of South Florida [Jan, 2013 – May, 2014]

Assist Ms. Barbara Warner, Program Coordinator & Instructor, Master of Science in Information Systems

Teach, Assist, Mentor over 700 undergrad students in learning new IT technologies

Extensive work in MS Office - Access, Excel, Word and HTML and SharePoint projects. Systems Engineer (ETL)

Tata Consultancy Services (TCS) [Nov, 2008 – April, 2011] THE ROYAL BANK OF SCOTLAND; ETL TEAM

Development and deployment of ETL workflows.

Automated many processes, devising workflows, reducing time consumption by 20%(Partial Postings check).

Led SAP System Migration: Gathered Requirements from the customer. Design and Deployment of Workflows.

Configured UNIX system files for the new SAP system. Designed the test plan and led the end-to-end testing.

Conducted well-received presentations/seminars on numerous topics such as DBMS, SQL, BI tools. ABN AMRO BANK; Operations Planning and Control Team

Worked in MAINFRAME platform –Devised solutions when workflows failed, scheduled jobs and processes.

Coordinated 4 different teams for solving complex issues. CORPORATE TRAINING: Object Oriented Methodology in Programming, Dr Scheme, Mainframes, JCL, SQL Working in teams, Professional Etiquettes, -Successfully completed the training and exit tests. Internships

Business Analyst /BI

Consulting

Finametrics [Jan, 2013 – May, 2013]

Researched and evaluated currently available BI tools, analytical DBs to leverage newer version of the tool.

Designed a well-received design plan including deployment models porting the application to an optimized technology stack that caters to an expanded functional scope and platform independence.

Proposed appropriate ETL tool, Technology Stack and Visualization tools, which will make the product platform independent. (Independent of Wall Street Systems (Oracle-RelDB), and thereby increase client base). Certifications:

Certification from Alteryx (Designer Core: Version 2019)

Certification from SAS in Analytics and Business Intelligence (Specialization: Data mining and Predictive analytics).

Graduate Coursework: Data Mining; Statistical DM; ERP & BPM(SAP); Data Warehousing; Adv DBMS; Adv Systems Analysis/Design; Distributed Information System; Project Management; Operation & SupplyChain; Healthcare IS

Brainbench TCS: DB2 Administration Level 2, SQL (ANSI) (Level 2), COBOL I (Level2).

Instructor–Led trainings (TCS) Business Communication Skills; Concur to Conquer; Effective Presentation

Boot camps (USF): SharePoint, BI tools – SAS, and Databases. Microsoft Office Specialist (Top Scorer)

Integrated Project Management System (iPMS / WebiPMS) JCL – Basics-Mainframe Competency Dev Program. Statistics, Finance and Accounting (Universal Class), SIX Sigma; NIIT Certified Java Programmer, HTML Activities/Extra-curricular/volunteer work/ interests:

Director of Operations(former) MIS Society at USF http://www.missociety.org/about-us/

ACG Cup 2014 – Represented USF at the National Business Case Presentation Competition.

Professional Photography - Covered events for various organizations in the Bay area https://www.studiovlj.com/

Plays Tabla (a percussion instrument). Performed in many music concerts.

Athletics – Short distance runner (100m,200m), Relay

Makes pencil sketches and paintings. YMCA Prize Winner. Calligrapher.

SQL Saturday – Active participant. TCS –Maitree: Member, BSS: Active Member

Contact this candidate