Data Analyst Resume

SUMMARY:

5+ years of overall IT experience, as a Data Analyst and Software Test Engineer
Hands - on experience in Microsoft SQL Server Database
Hands-on experience with U-SQL scripts (Scope scripts) to perform ELT operations in Azure Data Lake(Advanced version of COSMOS)
Good knowledge on ETL packages using Microsoft SQL Server Integration Service (SSIS).
Good experience in developing and maintaining reports in PowerBI Desktop tool.
Good experience in Pivot Table Development and Management in Excel
Good knowledge in different Azure Storage services
Skilled in building excellent rapport with clients and team members. Able to see the big picture, delegate effectively and motivate team members to achieve on-time project completion.
Initiated cross-training with other departments to improve work flow and streamline project completion
Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives
Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC), QA methodologies.
Extensively used test automation tools like Selenium for functional and regression testing
Experience in Manual Testing like preparing Test plans, Test cases and automated tests
Experience in preparation of data driven automated tests
Proficient with testing tools such as Visual Studio Team System, HP Quality Center, Team Foundation Server, Jira, Fiddler.
Strong analytical and debugging skills.
An enthusiastic and project-oriented team player with good communication skills.

TECHNICAL SKILLS:

Programming: C#, SQL, VB Script, U-SQL, Scope

Web Technologies: HTML 5, JavaScript

Databases/Technologies: SQL Server 2012, SSIS(2012)

Development Tools: Visual Studio 2008/2012, TFS 2012

Platforms: Windows 7, Windows Server 2008/2012

Testing Tools/API: Bug Tracking Tools

Visual Studio Unit Test Framework Selenium: Bugzilla and Bug Tracker, Jira

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

Extracted data using scope queries in COSMOS
Developed reports and delegated tasks to team members
Integrated Custom Visuals based on business requirements using Power BI desktop.
Developed complex calculated measures using Data Analysis Expression language (DAX).
Embedded Power BI reports on Stargate portal and also managed access of reports and data for individual users using Roles.
Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
Used advanced Microsoft Excel to create a pivot table, VLOOKUP and other Excel functions
Developed a deep understanding of the business objectives of internal and external stakeholders; evangelized the product vision and built trust by maintaining an accurate and achievable roadmap.

Confidential

Data Analyst

Responsibilities:

Understanding the Requirements and Specifications
Developed and maintained new data ingestion processes with Azure Data Factory
Implemented data aggregation and business logic in Azure Data Lake
Developed reports in PowerBI Desktop tool
Participation in design and daily stand-up meetings.

Technologies: C#, Azure data Lake, U-SQL, PowerBI

Confidential

Software Tester

Responsibilities:

Analyzed System Requirement Specification (SRS) document and Business Requirement Document.
Developed test plans, test cases based on functional specifications and design documents.
Maintained requirements and created Traceability between Requirements and Test Cases.
Validated the data by using SQL queries extensively
Involved on testing the new functionality based on test cases and used TFS for bug tracking.
Communicated the bug status and test case coverage status on a daily basis.

Technologies: C#, ASP.NET, SQL, Visual Studio, TFS, Windows Server 2012

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship