PROFESSIONAL SUMMARY:

• A total of about 9 years of experience in the Software & Internet industry with experiences ranging in Consulting, Development, Testing, Analysis, Design and Implementation of software applications using Confidential technologies.
• Knowledge in data analytics using R, Power BI, MS Excel, understand statistical modelling, familiar with data exploratory analysis, data modelling, data visualization using R - GGPLOT, Power BI, MS Excel.
• Knowledge in Text Analytics using R, represent word frequencies with word cloud, Sentiment Analysis.
• Experience working with relational databases primarily on SQL Server - data modeling, Database design, stored procedures and functions and performance tuning.
• Experience in design and development of data warehouse using Confidential SQL Server tools and deploying DTS packages. Experience querying OLAP cubes using Multi-dimensional Expressions (MDX).
• Experience working as SDET under BI vertical including end to end manual testing in MS SQL Server environments, performance analysis and automation tasks.
• Fair understanding of the Object-Oriented Paradigm. Well acquainted with tools like MS Visio for design and UML modeling.

EXPERTISE:

Data Analytics tools: R, Power BI, MS Excel

Programming Languages: TSQL, MDX, R, C#, VBA

Databases: SQL Server 2014/2012/2008 R2/2000, MySQL and MS Access

Other Tools: SSMS, SSIS, MS SQL Server Analysis Services, DTS, TFS, Bugzilla, SQL Profiler, Database Tuning Advisor, Octopus

WORK EXPERIENCE:

Confidential, Seattle

Data Analyst/SDET

Responsibilities:

• As SDET, was involved in testing various workflows in provisioning traffic permits from the point of application submission till permits issuance for various permit types including amendments, renewals and replacements of licenses.
• Own authoring test plans, test cases and SQL scripts for test data collection and validation.
• Involved in performing User experience testing, end to end functional testing, security testing, regression testing and data validation.
• Testing reports for various permit types, monthly invoices, payment reminders, renewal notifications and permanent permits. Report testing included data preparation in SQL, visualization, data validation and security.
• Prepare test report for bug fixes active/resolved bugs.

Confidential, Redmond

SDET/Data Analyst

Responsibilities:

• Understand data pull mechanisms of various sources (datasets) and perform end to end testing whenever there is a Confidential .
• Deploy and validate builds, functional testing, data validations and log issues encountered during testing
• Validate DB to ensure data integrity after build deployment.
• Data analysis to ensure data validity for the Confidential implementation.
• Evaluate Scope scripts to verify the data extracted from COSMOS.
• Participate in automation of some of the tools using SQL server and C#
• Participate in performance analysis of ETL jobs whenever there is a change in environments such as migration from SQL 2012 to SQL 2014 OR migration from Informatica to SSIS.

Technology: SQL Server 2014/2012, COSMOS, SSIS, C#, TFS, Octopus

Confidential, Redmond

SQL Developer/Consultant

Responsibilities:

• Prepared Tech Spec for the BE design and development.
• Developed new BE objects and re-engineered existing procedures to cater to the new requirements.
• Created SQL scheduled job for reporting to pull organization related data for business users.
• During production performance crisis, actively worked on resolving performance issues by identifying missing indexes or tuning the SQL queries.
• Was involved in several troubleshooting and fixing of issues reported by partners in production Metro DB.

Technology: MS SQL Server 2012, Replication, C#.net.

Confidential

Associate Manager

Responsibilities:

• Involved in design and development of several database related projects for various clients
• Involved in design and development a Data warehouse database from an existing OLTP system of the client.
• Developed Confidential queries for pulling data from OLAP cubes for reporting purposes.
• Developed DTS packages for automating the creation and population of the Data warehouse DB, processing the OLAP cubes and schedule the packages to run at desired interval.
• Analyzed client Databases for performance and implemented performance enhancement changes to the DB for quick data access.
• Managed the offshore development teams and coordinated with the clients for smooth project execution and delivery.
• Analyzed data for long running queries and identified necessary indexes to enhance query performance resulting in queries running within SLA.

Technology: MS SQL Server 2005/2000, MySQL, Analysis Services, Reporting services, MS Project.

Congruent, Bellevue

Programmer Analyst/Consultant

Responsibilities:

• Worked as onsite coordinator for Self Sufficiency Wage Calculator, a tool developed for Confidential .
• Planned and executed User Acceptance Testing(UAT) coordinating between the offshore team and the clients.
• Involved in implementation and training of the Wage Calculator at Confidential .
• Performed data analyses and monitoring throughout the project execution.

Technology: MS SQL Server 2000, MS Project.

Confidential, Seattle

Programmer Analyst/Consultant

Responsibilities:

• Involved in developing/unit testing queries for views and stored procedures and batch job scripts for the Reporting tool of MS Certified Partner.
• Worked on analyzing queries in reports and fine tuning them by inserting necessary indexes to tables and views to improve performance of data retrieval for various reports.

Technology: MS SQL Server 2000, ASP.

Confidential, Seattle

Programmer Analyst/Consultant

Responsibilities:

• Involved in designing data dictionary and developing/unit testing stored procedures and other backend objects for implementing functionality for the Midas programs.

Technology: MS SQL Server 2000, ASP.

Confidential

Consultant/ Module Lead

Responsibilities:

• Subject Matter Expert for various modules of the system.
• Involved in arriving at various algorithms in the system.
• Worked with team for Designing user interface for various modules of the system.
• Worked with team for developing stored procedures for handling transactions in various modules of the system.

Technology: MS SQL Server 2000, ASP.