PROFESSIONAL SUMMARY:

• Experience in Systems Development Life cycle (SDLC) performing analysis, design, and BI system implementation in agile environments.
• Experience in Data Warehouse development; Facts, dimensions tables, Indexes, Views, complex stored procedures, Triggers and Functions in SQL Server and Oracle environments.
• Experience with large - scale data warehousing and analytics projects, including Map Reduce technologies, Massively Parallel Processing (MPP) Architecture using AWS technologies - Redshift, S3, Data-pipeline and Azure, Cosmos/Scope big data technologies.
• Experience in ETL (Extract, Transform and Load) process development using SSIS (SQL Server Integration Services), AWS Data pipeline, BULK INSERTS, SQL Merge scripts and BCP.
• Experience in writing complex SQL Queries using joins, Sub Queries, CASE statements, CTEs (Common table expressions), Pivot, Ranking functions and table variables.
• Experience in Tableau, MS Power BI Dashboard Reports development. Experience in SQL Server Reporting Services (SSRS) operational Reports development with SharePoint integration.
• Experience Performing Statistical analyses and Deep Dive Data Analysis; problem root cause/opportunities, impact analysis, time series/forecasting and descriptive statistics using R, Python, and MS Excel tools; pivot tables, Lookups and charts.
• Experience in writing automation scripts for repetitive tasks, documents parsing, string and spreadsheet manipulation, web scrapping using C#, Python, PowerShell and UNIX Korn Shell scripts.
• Experience in Report performance tuning using Indexes, partitioning, Hints, Execution/Explain plans, Report caching and snapshots.

TECHNICAL SKILLS:

DBMS/Reporting: SQL Server, Oracle, MySQL, MS Access, MS Excel, SSIS, SSRS, Power BI, Tableau, OBIEE, SharePoint, AWS, Redshift, Cosmos, R and Python.

Other Skills: Visual studio, TFS, C#, Java, Azure, XML, FTP, UNIX and PowerShell.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Universal Store BI Developer

Responsibilities:

• Support project teams in the areas of metric definitions, data analysis and visualization critical to data driven project management.
• Perform SQL and C#/Cosmos/Scope big data development to extract and transform massive data for analysis.
• Automate ETL Processes. Create SSIS jobs/ SQL Server Agent to automate data loading from emerging data sources into the data warehouse. Automate big data recurring jobs/ Excel Reports automation using PowerShell Scripts.
• Perform deep dive data analysis (problems root causes /opportunities, impact analysis, cost-benefit, invest-divest, trend analysis, forecasting). Prepare written recommendations and presentations based on the findings.
• Analyze data sets using MS Excel; Pivot tables, Lookups and charts. Perform monthly statistical analysis/forecasting using R tools.
• Implement Dashboard Reports using Power BI to monitor Key business drivers; Implement Data Analysis expressions (DAX) and interactive Report Visualizations.
• Maintain operational reports in SQL Server Reporting Services (SSRS). Manage SSRS report subscriptions. Utilize SharePoint to share reports.
• Utilize Visual studio, and TFS for development and manage user requests. Perform Project documentation.

Confidential, Seattle, WA

Supply Chain Data Analyst

Responsibilities:

• Develop intelligent, insightful reporting on the key drivers of the business to enable stakeholders to manage the business.
• Retrieve and transform massive data using Oracle SQL, AWS Redshift, MySQL, Python and MS Excel into actionable intelligence. Perform deep dive data analysis on product performance. Present insights and written recommendations to key stakeholders and senior leadership.
• Design and develop MS Excel Dashboard reports to support weekly customer service metrics review.
• Create Python scripts to automate repetitive tasks; Generating and updating Excel Spreadsheets, text pattern recognition /document parsing, website scrapping utilizing Python libraries, Pandas, openpyxl, nuMPy, regular expressions and Matiplotlib visualizations.
• Design and develop Tableau Dashboards reports to monitor operational metrics in order fulfillment centers; Used data blending feature to bring together the data from Mysql and Oracle database. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Create and schedule daily ETL running queries and AWS Redshift Data Pipelines, s3 buckets to support reporting processes. Utilize Redshift Sorting keys, distribution keys, COPY, Vacuum to optimize ETL/Reporting processes.
• Utilize Oracle Indexes, partitioning, Hints, Explain plans, report caching and snapshots to enhance report performance.
• Utilize SharePoint to provide weekly reports.

Confidential, Redmond, WA

Data Analyst / BI Developer

Responsibilities:

• Work with multiple business stakeholders to identify Data warehouse and reporting solutions needs.
• Provide ad hock Data analysis support to cross functional teams utilizing MS-TSQL and MS Excel tools; Pivot tables, lookups to manipulate and summarize data.
• Create data warehouse objects including Fact tables, dimensions, Stored Procedures, Functions and Views to maintain data warehouse hosting data from multiple sources consumed by organizational Scorecard, Dashboards, automated and ad-hock reporting solutions
• Design, develop and implement ETL processes (SSIS/ SQL Merge scripts) to load data from multiple sources into the data warehouse. Schedule daily data refresh jobs using SQL Server agent.
• Design, develop and implement multi-level organizational SSRS scorecard reports for monthly business performance review. Consolidate operational reports into single operational reporting platform (SSRS). Troubleshoot SSRS Reports in production and deploy fixes.
• Create SSAS Tabular Models and Power BI Dashboard reports utilizing PowerPivot/DAX, PowerQuery, Powerview resulting into Self-Service reporting solutions.
• Utilize SharePoint to share reports, Visual Studio/ TFS (Team Foundation Server) to manage user requests and source code control.

Confidential, Seattle, WA

Systems and Technology Data Analyst

Responsibilities:

• Collect data from multiple business users in a variety of methods and perform complex data analysis through data loads and manipulation of the data under specific standards, context, and existence of project deadlines.
• Design and build SQL Server database tables based on the requirements per RDBMS normal form theories to meet the OLTP load standards set for the database tables.
• Perform ETL (Extract Transform Load) processes using SSIS, DTS. Build SSIS (SQL Server Integration Services) packages for initial and incremental data loads. Perform data loads; analyze and initiate data extracts; and clean up data.
• Write AdHoc SQL reports for daily, weekly, and yearly usage resulting in automated reporting. Perform testing on the table and data which are imported/reported to ensure data will load and reports include the correct data.
• Support project managers with advanced data analysis using MS-Excel. Manipulate and summarize data using MS Excel tools and functions; V-lookups, pivot tables and charts identifying trends and Descriptive statistics.
• Program database applications using MS-SQL performing maintenance and troubleshooting of systems and applications. Develop triggers to capture OLTP updates into history tables, write stored procedures and functions to automate reporting. Create views to control data access.
• Create and maintain complex operational reports in SSRS (SQL Server Reporting Services). Implement reports using SSRS data visualizations, interactive features and expressions. Setup SSRS Reports subscriptions in SharePoint.
• Migrate existing reports to more interactive Tableau reports. Create Tableau Desktop Reports by connecting various data sources, multiple views and associated reports.