SUMMARY:

• Highly qualified IT Data analyst and automation lead with significant experience in data analysis, modeling and building reports.
• Motivated, energetic, and passionate about the most current technological developments.
• Served on several small to large scale projects from Confidential partner portal to Enterprise software licensing Operations group, delivering automation in operationalizing data configurations and quality.
• Experienced collaborating with various vendor teams analyzing problems, developing and implementing effective solutions using Agile methodology. Flexible, with an aptitude for streamlining current processes for greater efficiency and thrives in fast - paced environments.
• Outstanding 8+ year track record of successful experience as Data analyst and 3+ years in TSQL/PL SQL using Relational Database Management system(RDBMS)
• Experience working with relational database design, data modeling OLTP, OLAP, KPIs and Dashboards
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Proficient in Confidential SQL BI (SSIS/SSRS/SSAS) and have working experience building and deploying of reporting visualization using Power BI and Power Pivot.
• Three-year specific background As Lead Analyst in Confidential Volume Licensing Operations Group
• Certified Professional in T-SQL, Power BI, Statistics analysis with R and Data Science Essentials.
• Effectively made use of Table Functions, Indexes, Table Partitioning, constraints, Index, Views, Query Re-Write and Transportable table spaces.
• Experienced in .NET C#, VB.NET development using Visual studio/VSTS and Agile planning.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects

AREAS OF EXPERTISE:

• Stakeholder Management
• Solution Analysis
• Teamwork/Collaboration
• Document Management
• System Analysis
• SQL development
• Client Relationships
• Confidential Applications
• Business Intelligence
• Client Relationships
• Excellent Communication
• Agile Planning

TECHNICAL SKILLS:

Tools: SQL Server, MSBI (SSIS, SSRS), Power BI, Visual Studio, MS Excel, R Studio, Confidential Azure Machine Learning Studio, MS Power Point.

Databases: SQL Server 2012/2016, Oracle (SQL, PL/SQL, Stored Procedures, Triggers).

Methodologies: Agile, Business and Data Modeling.

Languages: C#, T-SQL, PL SQL, R, HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, Issaquah

PM/Lead System Analyst

Responsibilities:

• Served as the Lead Data and reporting analyst for the vendor( Confidential ) automation team in Confidential Volume licensing Operations group.
• Delivered 85+ high-impacting sprint requirements through Agile model facilitating business requirement gathering, Sprint Planning and Reviews, defining the user stories, prioritizing and communicating the status to the stakeholders.
• Saved around 260+ hours of manual effort in every launch cycle for Data verification, configuration and reporting across different groups enabling faster time to market for critical product launches.
• Designed Azure product launch SSRS data Reports for the Confidential SWE team to monitor Quotation tool performance loads
• Structured approach to report Operational and Functional metrics using Power BI and SSRS reports
• Generated compliance and Audit framework using C# and Power BI reporting on SharePoint data, which led to timely Track of risks/issues, and current state of work to business partners and leadership team.

Confidential, Redmond

Data/System Analyst

Responsibilities:

• Worked as system analyst for quotation tools in volume licensing group worth $25B+ in vendor capacity.
• Delivered critical product launches by studying the existing process and workflows, talking to various stakeholder’s, gathering requirements and documentation of the artifacts.
• Led planning and delivery of monthly product launch configurations, getting it prioritized, facilitating UAT and status communication to Stakeholders
• Ensured data quality of launches by automating Data Audits which alerted several data issue instances saved approximately 150+ hours of incident management resolution.
• Trained data analysis beginners to improve overall efficiency of team

Confidential

Database/BI Developer

Responsibilities:

• Worked as Database developer to resolve several high-priority CPE issues; was involved in requirements analysis, functional spec preparation and solution documents for change requests on Partner learning analytics application data modeling and data warehouse.
• Enhanced .NET cookie decryption for partner authentication and regression dashboard tool using C#.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and SSRS reporting.
• Created automation test suite using MTM saving approximately 35 hours of testing for every release cycle.

Confidential

Database/BI Developer

Responsibilities:

• Developed key features, such as SQL Database Archiving and Replication, using SSIS for database performance and disaster recovery
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008.
• Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.
• Assisted the deployment team to troubleshoot the deployment issues on production servers, and avoided extended downtime for the production go live.