Anagha Deo

acvpcl@r.postjobfree.com

Cell: 425-***-****

SUMMARY

Years of experience for planning and implementation of Business/data analysis. Intermediate skills for SQL and Report generation. Passionate about Business/Data analysis. Worked with various validation tools and also expert in Excel and SQL. Used Power BI to create reports. Designed and developed data validation plans, automated validation processes. Generated BRDs and functional documents. Proficient in Microsoft office (Word, Excel (Pivot Tables), Visio and PowerPoint.) Understanding of Software Development Life Cycle and excellent communication and interpersonal skills. Worked with statistical tools like R and SAS. Worked on SharePoint applications and Agile environment. Created the data quality and test documents for the management team.

SKILLS : Hadoop, Hive, SQL server 2014/2012/2008/2005, Power BI, Informatica, SSIS, SSRS, T-SQL, Oracle 10g, Oracle 9i (OCA Certificate), C#,Oracle 8i, ETL, SQL*Plus, Crystal reports, PL/SQL, C/C++, DB/2, REXX, Perl, MS Office, Pro*c, Office 2013, Office 2010, SharePoint, SAS, R, XML, XSL

Tools/Platforms: Windows 8, Windows7 Vista/ XP/ NT/ 2000, Linex, UNIX, AIX, IBM PS/2, AIX, OS/2,

WORK EXPERIENCE

Sr. Business Analyst/ Hadoop Data Analyst, T-Mobile Bellevue, WA 10/15-07/16

These are my current responsibilities. Get the source information and details from business and co-ordinate with developers and document the requirement details also clarify the details and Functional Specs. I am currently working on project which is migrating data from SCOPs BI (Supply Chain) to Hadoop. I Generate reports and based on business requirements and planning based on which down stream programs/projects involved. Generate and maintain Sprint documents like which objects are involved for each Sprint and gather details for each of those objects for developers. Use hive commands for data analysis once objects are deployed. Create pivot charts and excel sheets for various reports like sprint planning and deployment process. Co-ordinate with Business to verify requirement and deployed objects and document it. Co-ordinate between business team and developers to get smooth ride from requirement to deployment for each Sprint. Document each and every detail for future reference.

Sr. Data Analyst/Reports Developer, Microsoft, Redmond, WA 06/15-10/15

Worked in Windows Azure team. Used SQL queries and Power BI and Excel pivots to create Reports China Azure team. Created Excel charts. Co-ordinated with data scientist and Business to understand what is needed and what can be done and did data analysis to create the reports. Used SQL server to generate automated reports and create datasets.

Sr. Data/Business Analyst/Reports Developer, Expedia, Bellevue, WA 04/13-05/15

I fulfilled following responsibilities when I was at Expedia. Created BRDs and Daily, Monthly Reports using hotel, flight and car trip data. Created documents for the new and old processes. Understanding business requirements and co-ordinate with source team (business) and developers to clarify details to create business documents for email marketing campaigns. Used SQL and ETL tools to load data also created ETL reports using reporting tools. Generated cooked up data for test environment. Perform data analysis and generated daily, monthly and weekly reports for campaigns. Created reports using SSRS for Trends, monitoring email counts and graphical representation of ETM reports. Used SQL queries and BI testing for campaigns. Developed test data management plans and strategies for test data lifecycle management, analysis, validation. Also worked on B2C and B2B testing and Analysis. Documents. Developed data validation plans and automated validation processes when necessary.

Sr. Analyst Microsoft, Redmond, WA 98029- 05/10-03/2013

I was leading couple of projects like Field dashboard and BRE audits. I used ETL tools to load data, used SharePoint for the scorecards of ROB (Rhythm of Business) and Share Dashboard. CSCDM was responsible for developing KPIs/Metrics for ROB (Rhythm of Business) and other business groups like STB (Servers and Tools Business) and SLT (Senior Leader Team) and MYR (Mid-Year report) with of customized formats and design. I did data analysis and wrote store procedures for the automating processes and audits on the various servers. I used MDX queries for validating the KPI, created BRE Rules for MSRAs. (MS Sales Report Analytics). Used SQL and TSQL, Informatica, Oracle, Excel Pivot tables, MDXs as and when necessary. Built automation to streamline the data pull from SQL into Excel. Created SQL scripts to run data exports. Created Visio documents for the processes. Created ad-hoc semi-automated audit queries. Following will give you a little idea about my overall job description Understand and document BRD, following instructions and documenting results and report testing and steps in between. For Data validation used various data validation tools, excel and SQL. Designed and developed data validation plans and automated validation processes when necessary. Following project plan and executing it. Create documents for the management team and create functional specs.

Support Analyst, Microsoft, Bellevue, WA 09/08-03/10

Responsible for creation and maintenance of daily reports that allow visibility to various business groups and effective business decisions. Created Operational Reporting Tool using SSRS which created the UI reports from a batch process to pull data (SSIS) from xCAT, HR (Oracle data using Informatica) and various Sales systems. Created stored procedures in SQL Server and .rdl files for all the SSRS reports. I was responsible for handling multiple reports managing deadlines and regular cadence of report outs. Worked on fiscal year rollover for HR process. Handled BWB file (Business Work Bench) and compensation rules for HR data rollover. Created various procedure and modified existing to enhance the rollover process. Oversight the HR process to assure correct data will be available during HR rollover. Summarize and solve HR system issues and bugs using SQL 2008. Analyzed historical data to identify opportunities for efficiency gains within supply chain. Worked continuously to improve the processes and/or reports. Worked with in house data validation tool, SQL, Excel for data analysis and validation.

Analyst/ Real Network, Seattle, WA 02/08- 08/08

Worked in Media Application Programs team. Worked on the list pull for music data and games data. Generated and automated Crystal reports using version X for music and games data. Created/modified various complex queries to get the required results. Managed and developed overall program plan, identified key projects and deliverables and assigned required resources. Used Bugzilla for bugs handling and CVS for code handling. Worked with the clients for projects requirement and management. Used SQL server, Oracle 10G, Toad, UNIX, AIX and used various reporting tools as and when required. Worked on data validation created data validation plans and automated validation processes.

Analyst/ Reports Developer, WAMU, Seattle, WA 11/06- 11-/07

Worked in CMRG Data Team on CMRG RODS database. Worked on new model analysis and implementation analysis for various data issues and modeling. Developed and executed Data pulls for modeling team. Used ETL tools and code for Daily Demands payoffs and Daily Payoffs. Used Fidelity data source for Demands data which was necessary for monthly retention and reporting group. For Analysis and development, I particularly used Fidelity, SQL server, Oracle 10G, Toad, UNIX, Linux, and Crystal reports 8 reporting tool. CMRG uses XML, HTML for prepayment models and oracle database.

Data Analyst/ ETL, Cingular wireless, Bothell, WA 08/05- 10/06

Worked on LNP project using Informatica ETL and Oracle and SQL server.

Data Manager/Analyst, Dendrite (Analytika), RTP, NC 07/01-08/05

Detail will be available if needed

EDUCATION

Oracle 9i OCA certification

MS Computer Science, Pune, India

BS Computer Science, University of Poona,

C/C++ Course from Technical College

Java and OOA and OOD course from NCSU.

Contact this candidate