SUMMARY

• Excelled in business process engineering in SDLC methods like - Water fall, Agile Scrum, in all phases analysis, design, development, testing, deployment of software.
• Defined KPIs, and Created KPI dashboards and generated insights to drive data driven decision making
• Worked as a bridge between nontechnical stakeholders and technical developers to attain project objective
• Detail oriented, Logical, confident, have worked at code level to resolve issues
• Passed Teradata queryman test with 97% and payment industry ethics & rules with 100% at Confidential
• Experience analyzing database architecture, data modeling, data mining in Teradata, Hadoop, Oracle
• Performed in usability studies, target audience definition and research
• Implemented A/B and multivariate test using Adobe/custom tools and analyzed data using site catalyst, backend SQL and provided insights to facilitate strategic business decisions
• Good command on personalization and web/Mobile analytics tools- Adobe site catalyst, Target, Google Analytics, Optimizely, created segment, pathing, conversion funnel reports
• International implementation experience, have remote teaming ability
• Created information architecture, wireframes, using user-centric design techniques
• Developed complex UML diagrams, data flow and process flow diagrams with Visio
• Adept at time and budget estimation, tracking & control; option analysis (Financial, Technical, HR etc)
• Accurately designed and executed change management workflows
• Excellent communication, client relationship, problem-solving, documentation, and interpersonal skills; spontaneous learner, out of box thinker
• Analyzed risk assessment reporting, Facilitated evaluation and mitigation of onsite and online risks
• Excellent at achieving earned value targets, optimizing critical path and completing tight time bound projects successfully meeting quality targets, Used MS projects/project server for planning
• Experience in Multi Tier applications in 24x7 Client Server environment using technologies like PHP, JAVA, J2EE, SOAP, RESTFUL WEB SERVICES, XSD, XML JSON
• Wrote and reviewed Test Plans, Test Scripts, used automated testing tools
• Carried out Acceptance testing, end to end Integration testing, regression testing, UAT

TECHNICAL SKILLS

Languages: C, PHP, SQL, .Net, XHTML, XML, Java Script, JAVA, AJAX,CSS, LAMP, PL-SQL

RDBMS/Big data tools: Teradata, Hadoop, Hive, Impala, Hue, Platfora, Scoop, Oracle 9i, Oracle 10g,Oracle 11g, NDM, MS Access, My SQL

Technical management Tools: Autosys, Informatica, TOAD, Teradata SQL assistant, Fast load, Multi load, BTEQ, Tpump, Tableau, Pivot tables, Micro strategy, Rally, Confluence, Share Point, MS Projects, MS office, Visio, ALM Quality Center, JIRA, QTP, Load Runner, Eclipse,, PHP doc, PHP Unit, SDL world server, Demandware Studio, Bazaar version control, SVN, Drools Guvnor

OS: Windows XP, Windows Vista, Win 2003, Win 2008, Linux

Web Analytics: Adobe Site catalyst, Adobe target, PXP, Optimizely, Google Analytics

Project Method: SDLC- Waterfall, Agile Scrum, RUP

Data Warehouse: Star Schema, Snowflake schema, OLTP, OLAP, Data Mart, fact Table, Dimension Table, Logical and Physical Data Model, Data Warehouse Architecture, ETL Process, stored procedures, triggers, Data governance, data management, data quality management

PROFESSIONAL EXPERIENCE

Confidential, San Bruno, CA

Sr. Business Operations analyst

Responsibilities:

• I analyzed data across both server side and client side tools available through various internal and 3rd party platforms like Adobe Site Catalyst, Discover, Workspace, ThoughtSpot, to generate insights and help business decision making for Hardlines department at Confidential Ecommerce.
• Improved Peak ( Nov-Dec ) revenue collection by providing key insights about homepage product merchandising web analytics and search keyword analysis on daily basis and helped meet and beat planned KPIs.
• Worked with Omniture Implementation team to remove bugs and improve tagging in order to get better accuracy in data.

Environment: SQL, Adobe Analytics, Hadoop, Hive, Hue, Jira, Teradata, HQL, ThoughtSpot

Confidential, Milpitas, CA

Web Analytics Consultant

Responsibilities:

• Reviewed Adobe analytics implementation and tracking enhancement requirements. Reported defects in configuration and instrumentation of EVAR/Prop/Events/Products etc. variables to correct reports.
• Analyzed Historic web click stream data for Desktop, Mobile, Tablet, Kiosk channels to define benchmark
• Worked with Product managers to define KPIs and reporting requirements and based on that reviewed current custom tracking
• Performed site testing to analyze pain points, improve tracking and functionality, created wireframes
• Brain stormed A/B testing ideas, implementation plan and KPIs
• Suggested persistent bar and left nav UI improvement to improve log in and sign ups
• Created dashboards using Adobe Analytics for KPI monitoring on Visits, Visitors, Checkout/cart/order Conversion, GMV, orders, UPT, AOV, Exit rate, Add to cart, cart abandonment, checkout/payment error rate, Referrer performance
• Performed UAT testing and post production testing of Custom tracking and reporting
• Analyzed backend data in Hadoop and Teradata systems to create reports on Offers redemption using SQL/ Hive Query. Ran referrer performance report in Google Analytics
• Analyzed tender type and customer loyalty during peak and off peak
• Analyzed shipping offers across competition and suggested A/B testing idea to improve GMV during peak

Environment: SQL, Adobe Analytics, Hadoop, Hive, Hue, Jira, Teradata, HQL, Google Analytics

Confidential, San Jose, CA

IT Analyst

Responsibilities:

• Led reporting track for CMC project. Worked closely with Scrum trainers to bring D - state project to B+ state to improve project ROI.
• Mapped data from disparate sources using primary- foreign key relationships to create reporting schema
• Analyzed the data reporting requirements, wrote HQL and analyze marketing data schema from Hadoop and create ETL plan for data extraction from Oracle Eloqua to Hadoop
• Understood Oracle Eloqua out of box reports and helped business users with automated reports.
• Analyzed Confidential marketing data in Oracle 11g using Toad
• Created Business Requirements Document, Technical Design Document Logical and Physical Data Model and upload in Confluence.
• Presented analysis outcome in Scrum demo meetings to larger team

Environment: SQL, Oracle 11g, Hadoop, Hive, Hue, Oracle Eloqua, Blue Kai, Confluence, Rally, Tableau, Toad

Confidential, San Jose, CA

Web analytics experiment Manager/ Data Analyst

Responsibilities:

• Managed 250+ A/B tests, Multivariate tests, Ramp for 10+ consumer product teams globally in all countries where Confidential has presence.
• Partnered with product/program managers, tech leads to improve hypothesis, placement, experiment design. Participated in usability testing and reviewed results.
• Led process improvement for quality experimentation to improve usage companywide and get lift in Primary and Secondary KPIs like sign up, activation, conversion, reactivation
• Created and maintained self-help tutorials and trained different teams on experimentation process
• Proposed change management workflow as part of process improvement plan
• Followed Agile Scrum method. Created and updated agile user stories and tasks in Rally.
• Worked closely with PXP engineering team, product teams to ensure flawless integration implementation, instrumentation, and data collection tracking of KPIs, eg. Click through, conversion
• Provided end to end support for implementation and modification of test, segmentation, web traffic throttling and ramping, analysis of result
• Documented KPIs and analysis plan for experiments.
• Fired SQL queries to retrieve data and conduct analysis.
• Calculated P value, statistical significance. Performed cohort, funnel analysis.
• Analyzed the results using Adobe site catalyst and FPTI backend data on Teradata
• Partnered in resolving issues while rolling out new features and products on computer and mobile devices through experimentation platform
• Provided experimentation tool enhancement, personalization requirements; filed defects of experimentation tool and tracked resolution
• Published experimentation dashboard on tableau server. Maintained weekly report
• Completed Confidential compliance, Anti Money Laundering, information security trainings with 100%
• Completed agile basics for Scrum training from Rally Agile University

Environment: SQL, Teradata, Confluence, Jira, Rally, PXP, Adobe site catalyst, MS office, Tableau

Confidential, San Francisco, CA

Sr. Risk Data Analyst

Responsibilities:

• Completed Security Risk Assessor training with 100% marks to get required system accesses
• Completed Anti Money Laundering, Bank Secrecy Act and OFAC regulations training with 85% Worked closely with Operations Risk managers, Information security officers and risk consultants to understand the security requirements and risk reporting requirements
• Collected requirements for risk reporting from higher ups for code review, FFIEC, Site review, disaster recovery and other types of risks
• Understood existing data structures and find out root cause of issues in reporting
• Recommended new data design to improve security risk reporting
• Partnered with higher management to reengineer processes to manage, high risk rating TVMs.

Environment: SQL, Visio, Oracle11g, TOAD, MS Excel, Sharepoint, SPARC

Confidential, San Jose, CA

Business Systems Analyst

Responsibilities:

• Analyzed business requirement and created/updated agile user stories and tasks in rally and updated research work on confluence. Presented research work in meetings.
• Analyzed high level info in epics and provided detailed research work to create executable user stories.
• Participated in daily scrum meetings, Retro, sprint backlog and release planning meeting and work closely with business, scrum master, product owners, ETL developers, and data modelers.
• Participated in Scrum of scrum meeting and update status of current sprint and plan the future sprints
• Analyzed Enterprise data schemas and dataload processes in Confidential and Confidential credit systems
• Understand and document data definitions
• Ran SQL query using TOAD, SQL developer and Teradata SQL assistant on Oracle 11G database and Teradata 14 database on test and production environments to pull and analyze data and find entity relationship to provide ETL plan and create reports using Excel/ Micro Strategy.
• Analyze and update status of web analytics instrumentation for the new platform in Omniture/FPTI
• Developed useful Visio diagrams to explain complex technical processes and architecture
• Performed data integrity checks, participated in end to end testing, raised and tracked defects in Jira

Environment: Agile Scrum, SQL, Visio, Oracle11g, TOAD, Informatica, Teradata14, Confluence, Rally, Jira

Confidential, San Francisco, CA

Data Analyst/Business System Analyst

Responsibilities:

• Analyzed data schema and dataload process
• Documented and presented Business and functional Requirement documents
• Owned end to end project responsibility individually and led them to success
• Developed very useful Visio diagrams to explain complex technical processes and architecture to make it easy to visualize the profitability application
• Cleaned the officer dimension using SQL query analysis to meet the requirements of reporting system.
• Executed enhancement requests for UI, added new products by creating projects, got approval on business requirement managed dev- test and deploy cycle and change requests for them
• Created Test plan, test scripts for Integration testing and UAT, Updated test results on SharePoint
• Led End users and partners for down stream testing
• Ran automated test scripts using QTP and manual scripts in TOAD on Oracle 11G database
• Raised and tracked defects in HP application life cycle management system ( ALM)
• Conducted and participated in meetings with tech team to discuss and resolve issues
• Participated in project planning, prioritization and scheduling
• Maintained version control of test plan and test scripts, shared it on SharePoint for team reference
• Simultaneously worked on multiple projects with challenging deadlines with zero defects.

Environment: Waterfall, SQL, Visio, Oracle 10g, Oracle11g, TOAD, SharePoint, HP ALM, QTP, NDM, Teradata

Confidential, Worcester, MA

Responsibilities:

• Analyzed the existing data warehouse and ETL systems. Interacted with client to understand GAPs
• Documented Reporting metrics requirements to be implemented through Business objects
• Partner with data modelers to MAP current data schema with the future EDW
• Participated in meetings with data modelers, provided inputs on GAPs and issues with Mapping
• Maintained version control of data dictionary and shared it on SharePoint for team reference
• Conducted interview sessions with Business to understand new requirements and entity relationships to create new fields in the EDW and decide SCDs ( slowly changing dimensions) data maintenance

Environment: Agile, SQL,MS SQL server, MS Access, Oracle, EMPI,HIE, TOAD, SharePoint, Citrix

Confidential, Raleigh, NC

Data Analyst

• Understood Business need for data analysis and data models in Teradata warehouse,
• Communicated with development team, data mirroring teams, business managers for understanding processes, business rules, architecture and business impact
• Understood data schema of various complex databases and enterprise tables for the given project
• Extracted data using SQL query as required and created highly accurate multidimensional cube reports and charts. Published reports on Share point site.
• Analyzed reports and created presentations with business insight and suggested process improvement based on analysis to help achieve business goals.
• Conducted meetings with global teams in Singapore, India, Europe and US including data architect, Product managers, directors, DBAs, to understand reporting requirements, metrics and BI insight questions
• Conducted meetings with Programmers, reporting analysts to review Use case documents, data flow diagrams to check data integrity
• Checked data integrity, naming conventions in data warehouse, updated issue logs
• Worked with offshore team to automate reports using micro strategy, Tableau, Excel and SAS
• Reviewed automation queries and conducted issue triages with offshore team to prioritize and fix automation quality issues.
• Analyzed production data, Omniture Site catalyst data, tea leaf and opinion labs data
• Participated in User experience research, interviewed end consumers to analyze business problems
• Partnered with Global Product Management teams in US, Europe and Singapore to resolve ad hoc analytical issues instantaneously.

Environment: JAVA, JSP, Teradata, Teradata SQL Assistant, Oracle 11g, JavaScript, XML, web services, SOAP, Tableau, Micro Strategy, SAS Adobe Site catalyst, teamsite, Tea leaf, Business Objects, MS-VisioProject: Confidential B to B ecommerce web portal development

Confidential, Mountain View, CA

Data Analyst/Business System Analyst

Responsibilities:

• Reviewed BRD and created agile user stories, test scenarios and test scripts
• Prepared GUI mock up & wireframes for the developers as per business requirement.
• Reviewed SRS, design docs, test scenarios & test scripts and suggested changes.
• Participated in meetings, maintained issue logs and resolved issues with offshore team
• Understood content publishing requirement of internet marketing team for product promotions and catalog management, deployed content in UAT, preview and production environments using teamsite CMS as defined in commerce manager catalog management system
• Analyzed reporting requirements for Omniture, Tleaf and Business objects for web analytics
• Developed and published UAT scripts for international teams, gave demo for UAT
• Performed end to end testing of B2B Estore for SMB, redirector (affiliates), CSR tool, E-fulfillment through message labs for 2.0 release for 12 countries including US, Australia, UK, Canada, Singapore
• Tested database (Oracle 9.6) table updates for transactions on CSR/ estore using SQL queries
• Participated in UAT planning meetings, logged data and environment requirements and developed issue resolution work flow with weekly or on demand builds for testing
• Discussed and prioritized blocking issues in Issue triages to resolve them
• Logged and tracked issues in JIRA as per defined change management process work flow
• Analyzed Order Management system, data and process dependencies for upstream and downstream application data flow (from frontend landing pages to middleware and fulfillment centers)
• Interacted with SMEs, architect, QA lead, offshore and onsite project managers, dev lead
• Reviewed business rules using Drools Guvnor.
• Partnered in cut over planning and execution to deploy the application to prod.
• Performed final content and functional testing in preview and production