Data Information

Ashish Sankaranarayanan

469-***-**** in.linkedin.com/in/AshishSNarayanan ac1lf8@r.postjobfree.com

SUMMARY

A graduate professional with concentration in Business Intelligence and Data Analytics and 3+ years of experience in data analysis, business analysis, client interaction, process documentation, project planning, product lifecycle management and ITIL.

EDUCATION

Master of Science in Information Technology & Management GPA: 3.3

University of Texas at Dallas, Texas Dec 2016

Bachelor of Engineering in Electrical and Electronics GPA: 3.8

Visveshvarya Technological University, India May 2011

WORK EXPERIENCE

Security Consultant, Agile3 Solutions- an IBM Company, San Francisco, California March 2017 – Present

Reviewed client data handling and controls including policy, organization, personnel, asset classification and control, physical security, access control, computer management, business continuity, system development and maintenance, and compliance

Performed an information risk analysis that assessed the impact of identified threats and vulnerabilities to clients' business objectives and requirements as they relate to client data

Generated report encompassing FFIEC handbook sections as appropriate, along with ISO 27002, PCI, and HIPAA requirements

I additionally deployed IBM's Guardium agents to help ensure the security, privacy and integrity of information in our data centers. These data security modules support IBM's vast heterogeneous environments including databases, data warehouses, file shares and Hadoop-based systems for custom and packaged applications on all our operating platforms

Exported data (session, failed logins, user access for all Financial Applications that are monitored by STAPs) via Guardium csv reports

Prepared detailed requirements, scope documents and process flowcharts for the development and implementation of Guardium processes

Create/refine Guardium operating guidelines, policies and procedures pertaining to PCI /SOX requirements

Developed and maintained operating guidelines and procedures in support of policies, standards and guidelines (PCI DSS, SOX, corporate, etc)

Performed vendor Risk Assessment for vendor's various service offerings

Security Consultant, Agile3 Solutions- an IBM Company, San Francisco, California July 2016 – December 2016

Developed rules for policy creation in IBM Content Classification tool and Symantec Data Loss Prevention.

Used extrusion policies to examine data leaving the database for specific value patterns such as credit card numbers

Created Decision Plans for Health Insurance Portability and Accountability Act(HIPAA), Protected health information(PHI), Payment Card Industry Data(PCI) and Personally Identifiable Information(PII)

Determined entitlements to sensitive enterprise data to determine risks such as dormant data or dormant entitlements

Deployed the Decision Plans using File Activity Monitor(FAM) agent on multiple IBM Guardium Servers.

Tested the correctness of the implemented policies and exception policies based on definable thresholds on test data

Created a centralized normalized repository of audit data for enterprise compliance, reporting and forensics

Automated sensitive data discovery and classification for risk analysis across enterprise data sources

Improved data security leveraging analytics to detect unusual data access patterns

Aggregated and normalized audit data throughout enterprise for compliance reporting, correlation and forensics without requiring native database audit functions

Data Analyst Intern (Salesforce), Mindata, Dallas, Texas Jan 2016 – June 2016

Identified Process Improvement areas and designed various high level design documentation and process models

Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions

Analyzed statistical reports on data using Tableau and presented documentation output to stakeholders.

Managed daily administration work and supported CASES’ Salesforce database including managing multiple user setup, profiles and roles, customization of objects, fields, record types, page layouts and validations

Created and managed complex workflow rules, data validation, triggers, customized reports and dashboards in Salesforce

Developed a database, designed forms and reports for a dental lab using MS Access in turn automating their billing process

Systems Engineer/Analyst, Hewlett Packard, Bangalore, Karnataka, India Sep 2011 –July 2014

Filtered and “cleaned” data, and reviewed computer reports, and performance indicators to locate and correct code problems

Used VB Scripting, App V4.5/5 and App Sense 8 extensively to modify and deploy software applications

Operations performed by software bundle management systems in cloud computing and client virtualization environments

Created user response dashboard for User Acceptance Testing (UAT) to confirm application deliverable meets business requirements and Service Level Agreements (SLAs) which saved 10% costs and penalties

Lead and assisted the offshore deployment team of 2 resources and mentored new joins on in-house tools and applications.

Automated iterating tasks using Macros in MS Excel which reduced manual effort and increased overall productivity

Conducted change impact analysis and feasibility analysis by collecting, analyzing and summarizing information

ACADEMIC PROJECTS

Wi-Fi based Tracking System: Devised a system to immediately alert the Search and Rescue team

One stop Restaurant-Reservation Management: Created and maintained a database application using MS Access & SQL

Business Intelligence/Analytics: Designed & implemented prediction model to predict accident severity & strategies

Sales Analysis using SAP NetWeaver Business Warehouse: Provide scalable and robust Business Intelligence solution

SKILL SET

Programming: VB Scripts, C, C++, Java, Python

BI Tools: R, SAS Enterprise Miner, SAP NetWeaver BW, BEx Analyzer, IBM Guardium, Symantec DLP

Reporting Tools: Tableau, Crystal Reports, MS Excel, Pivot tables, Salesforce, IBM Content Classification

SDLC Methodologies: Agile, RAD, Waterfall, Scrum, Spiral

Knowledge of: Hadoop, Hive, Pig, Hbase, Spark, VMware, MS Office, Oracle, SQL Server

CERTIFICATIONS

Salesforce Platform Developer I (Cert. Num. - 10431170)

Salesforce Administrator (Cert. Num. - 10408128)

Configuring Window 8 Certification (Microsoft Certified Professional)

SAS Inst. /UT Dallas Graduate Certificate in Business Intelligence and Data Mining

Contact this candidate