Data Analyst Resume

SUMMARY:

Professional experience of 4years in Information Systems, Business Intelligence, Data Warehousing & Analytics
Hands on experience of developing visualizations, ad hoc reports and dashboards for strategic planning & decision making
Knowledge of SOX, PCI, Dimensional Modeling, Performance Tuning, A/B Testing, Marketing Funnel, ISO 27002

TECHNICAL SKILLS

BI Tools: SAP Business Objects XI R3, BI 4.0, WebI, SAP BO CMC, SAP BEx Analyzer, OBIEE, MS Power BI, SSRS, SSIS

Databases: Oracle 10g, SAP HANA, MS Access

Programming: SQL

Data Visualization Tools: Tableau, SAP BO Xcelsius 2008

Management Tools: MS - Office Suite, HP SM7, JIRA, Visio

Security Framework/Compliance Standards: SOX, Payment Card Industry (PCI v3.1), HIPAA, ISO 27002, NIST

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

Providing data analytics service to MS Audit Group (Financial Investigating Unit, Internal Audit & Enterprise Risk Org)
Developed SSRS and PowerBI reports using SQL server management studio and built SSIS packages by gathering requirements
Developed a POC for High Risk Deals projects by merging/manipulating data from multiple sources using SSIS, SQL Server
Developed a NIST Risk Assessment compliance dashboard for Executives which gives an overview of risks across MSFT services

Business Analyst

Confidential, Redmond, WA

Responsibilities:

Liaised wif MSIT and Infosys India team to assist Microsoft in the divestiture of their Confidential feature phone business
Planned and led the execution of migrating 4000+ employees from Confidential domain to Microsoft Domain
Managed the transition of 4000+ employees from Confidential domain to Microsoft domain wifin a strict deadline
Maintained tracking and reporting of key operational metrics to track the overall migration progress

Data Analyst

Confidential, Issaquah, WA

Responsibilities:

Worked wif clients to understand the current state of Payment Card Industry (PCIv3.1), SOX, HIPAA controls in Costco
Developed HIPAA controls for Costco Global, Costco Travel and metadata for PCI, SOX & HIPAA
Used ISO 27002 as the anchor framework & mapped PCIv3.1, SOX, HIPAA & PIPEDA controls to ISO27002 sub-controls
Rationalized the controls and made it compatible for an import to Archer
Drove key analyses on marketing funnel metrics to improve overall performance of different business channels & divisions
Planned and conducted A/B tests to understand customer behavior and preferences

Confidential

Business Intelligence Analyst

Responsibilities:

Collaborated wif business stakeholders and technology teams to define requirements and implement analytic solutions
Analyzed financial/employee/student data to create OBIEE reports & dashboards providing insights to university departments
Customized dashboards and reports in OBIEE wif different analytic views to support and execute change requests
Leveraged google analytics to analyze & developed reports on website metric trends of University of Arizona

Confidential

Data Analyst-SAP BO

Responsibilities:

Collaborated wif team to analyze business needs and deduce key metrics; supported BI reporting enhancements
Liaised wif business users to gather requirements and designed Business Objects reports and dashboards
Developed functional and technical documents for newly built BO reports and updated the documents for any change
Remodeled existing (BOXI R3) WebI reports in BI4.0; added features: cascading prompts & hyperlinked reports
Fixed 100+ bugs reported in WebI; used import wizard tool to move 100+ reports from dev to prod environment
Acted as a liaison for change approver board; led meetings for status reporting on bug fixes, enhancements and new developments
Scheduled 50+ WebI, crystal reports monthly; tuned WebI reports - data extraction speed improved by 5-7mins
Assisted Shell staff quarterly via 200+ bug fixes, 100+ Ad hoc reporting solutions focused on root cause; saved revenue loss of $1M+
Developed a prototype in Tableau by merging data from different sources to understand the travel booking pattern of Shell resources