SUMMARY

• In depth knowledge of the Software Development Life Cycle (SDLC) using various methodologies like Agile (SCRUM) and Waterfall Methodology.
• Experience providing Technical support to Confidential Azure Customers as a consultant
• Experience working with customers to troubleshoot issues on Confidential Azure
• 8+ years of experience in IT
• 5+ years of hands - on experience in business consulting and application development, with excellent skills in client interfacing, requirement gathering, user support, quality assurance, problem solving, and documentation.
• 3+ years of experience working as a business analyst with responsibilities ranging from customer requirement gathering using agile methodology, project coordinator, data modeling to Quality assurance and scrum master.
• 2 years of experience working as a full stack developer
• 5 years of experience in SQL
• 4 years of experience in Excel, pivot table, VLOOKUP’s, Dashboard,
• 3 years of experience in sprint planning and functional documentation
• 1 years of experience in power BI, DAX, PLX script & dashboard.
• 3 years of experience in functional, visual, manual testing and QA. completed 6 months course in Data Science (Python,TSQL,Azure Machine Learning Studio,PowerBI,Kafka)
• Have In-Depth knowledge of SDLC: Waterfall, Agile.
• Experiences of leading and interacting with business teams, programmers and technical staff at all levels.
• Strong knowledge of Project management skills such as time estimation, task identification, risk analysis and scope management and resource management.
• Ability to act as a liaison with different stakeholders of the project as well as with quality assurance team, technical writing team, testers.
• Experience in business systems analysis with excellent skills in client interfacing, requirement gathering, user support, quality assurance, problem solving, and documentation.
• Experience in creating and maintaining the Requirements definition documents that included Business requirements and Functional requirements
• Strong knowledge of Project management skills such as time estimation, task identification, risk analysis and scope management and resource management
• Involved in training of end users. Documented training manuals for new Product Release.
• Defining Test Cases, analyzing bugs, interaction with team members in fixing errors, Unit testing and User Acceptance Testing (UAT)
• Expertise in Problem solving and Bug Tracking Reports using Bug tracking Tools.
• Motivated self-starter, good team member with exceptional team building, leadership, and interpersonal skills to resolve issues. Possess good facilitating skills.

TECHNICAL SKILLS

Software Development Life Cycles (SDLC): Waterfall Model, Agile Scrum

Operating Systems: Windows & Linux

Databases: Oracle 8i/9i/10i, MS Access, MS SQL, SQL, MS Excel (Macros, Pivot tables, Look up)

Technical: C#, ASP.NET, SQL, CSS, iQuest

Modelling/Documenting Tools: MS Office, SharePoint, MS Project, MS PowerPoint, MS Visio

Quality Management: IBM Rational Tools (RQM, RTC & RTM), HP QC, Mercury QC & HP-ALM.

Other Technologies: Salesforce CRM, Oracle EBS & Apps, JAVA, Web Services, Tableau, ETL (Informatica/Power BI), DAX.

PROFESSIONAL EXPERIENCE

Confidential - Bellevue WA

Technical support Analyst

Responsibilities:

• Provided technical support to Azure customers by resolving escalated, complex technical customer issues on the Azure Platform
• Responsible for delivering Azure Technical Support against CPE (Customer-premises equipment)
• Collaborated on customer issues with Confidential product groups and operations
• Experienced in communicating clearly and professionally with customers.
• Work with cross teams to resolve the issue.
• Create reports in dashboard (power BI)
• Analyzed, interpreted and explained technical errors and solutions to end users.

Confidential - Bothell WA

Data Analyst

Responsibilities:

• Presented findings and data to team to improve strategies and operations
• Manage the planning and development of design and procedures for metrics reports
• Proposed solutions to improve system efficiencies and reduce total expenses
• Document Requirement Specification Document and stories meeting the Definition of Ready. created dashboard using PLX script and generate reports. verify large set of data and from excel and f1 engine ( Confidential engine )
• Address all the issues raised during the meetings and follow up with the corresponding people using Bugnizer tickets until the open item/issue is addressed/closed.
• Communicate with Business Owner/Product Owner about the gaps and fill in the gaps by conducting meetings and document solutions/comments inferred from the meetings.
• Assist/support the Development Team in refining user stories, backlog, and their quest to do everything possible to fulfill customer’s needs and exceed expectations.
• Proactively monitor and improve the process/system/policies to make the best effort to document all the missing gaps. Removing impediments by finding the right people.
• Performed gap analysis in Higher Level of the process and for a small part of a huge project and create reports
• Facilitate discussions, decision making, and conflict resolution.
• Support/educate Product Owner, especially with respect to refining/grooming and manage the product backlog.
• Support and educate the Development Team, especially with respect to self-organization, agile engineering, agile testing and incremental and iterative software development.
• Provide higher management, like my Program Managers/Director/CIO in Boise, with up to date information be sending out various reports about the status of the project on epic level.
• Make sure the weekly deliverables are on track as expected and if not, making sure the higher management is aware of the deliverables not being achieved as expected. Performed the role of a Business Analyst by driving requirement analysis, gathering sessions with the Business users, SMEs, Sponsors and other Stakeholders to analyze the detailed level process flow and elicit detailed level requirements in the form of deliverables which include Business Requirements Documents, Functional Specifications and Technical Design Documents, for the most part.
• Worked with Project manager on scheduling completion and approval of validation deliverables.
• Worked with various business units to gather business requirements by process of leading JAD sessions.
• Work closely with Business Owners and Stakeholders to outline Business Requirements
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT).
• Did support for test preparation of the integration (unit test; SIT; Regression Testing; performance test) in collaboration with the Testing Team managing customer expectations.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and insured that critical requirement are not missed.
• Analyze the restriction for each event.
• Performed quality assurance, system integration and user acceptance testing facilitating on-time, on budget and acclaimed "go-live" of enterprise implementations.

Confidential

Technical Business Analyst

Responsibilities:

• Worked with Acer to refine requirements for the application
• Created business and functional requirements for the dev team
• Facilitate sprint planning, daily scrums, stakeholder meetings, and software demonstrations.
• Developed test plan and created sign-off requirements for the dev team
• Development and testing based on Agile methodology.
• Export all user details in excel.
• Create dashboard and pivot tables in excel for client.
• Direct and lead development team from project initiation through the delivery of final product.
• Performed user acceptance testing
• Provided training to client on how to use the application
• Weekly reporting to client and technical support.
• Testing backend with scripts.
• Dashboards: Created visually impactful dashboards in Excel for data reporting by using pivot tables and VLOOKUP.
• Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
• Used advanced Confidential Excel to create pivot tables, used VLOOKUP, and other Excel functions
• Prepare documentation

Confidential

Developer, C#, ASP.NET, SQL

Responsibilities:

• Developed web pages using C# and ASP.NET.
• Export and import reports via excel.
• Create dashboard and pivot table in excel for export result.
• Create VLOOKUP's in excel.
• Export survey results in excel.
• Created SQL stored procedures and scripts
• Improved performance of the website by 40%
• Provided on-call support for the website

Confidential

Web Developer - Team Lead

Responsibilities:

• Designed and developed custom user controls for the website
• Implemented business logic validation and error handling.
• Provided on-call support
• Create dashboard and pivot table in excel for survey output.
• Import user details via excel.
• Export survey results in excel