MEENAKSHI SUNDARAM RAMASWAMY

SUMMARY:

Over ** years of Microsoft professional experience involving design, development, Implementation and Testing in the areas like MS-SQL Server, Oracle,Visual C#, Active Server Pages, .Net 4.5,EDM tools(Markit), DevOps(CHEF),Performance Testing, Has worked on Business Analysis, Data Analysis and Mining and Business Intelligence,

TECHNICAL SKILLS:

Hardware: PC-64, Windows Mobile, iPod, iPad, Windows tablet, Android

OS/Platforms: MS Windows 10, Windows 7, UNIX, Linux,Windows server 2012,Windows 8.1

Languages: Visual C# 2015, Java 8,Java 7, .Net 4.5, QTP, QC

RDBMS: MS SQL Server 2014, 2012, 2005, Oracle 8.0,Mongodb(Nosql)

Analysis/Design: Relational Database Design, Structured System Analysis and Design

Code Analysis: FxCop and StyleCop, LeakDiag, UMDH

EDM: Markit,BigData

DevOps: CHEF

Performance Tools: Load Runner, VSTS

Scripting: Powershell, VBScript,Java script

UI Automation: Selenium, Coded UI

API: REST,SOAP

Test Framework: NUnit,MSTest,JUnit

Source Control: SVN,GIT

Bug Tracking: JIRA, TFS

BI:SSIS,ETL,Markit, SSRS,OLTP,OLAP

Cloud:Azure

PROFESSIONAL EXPERIENCE:

Senior Automation Engineer -Russell Investments, WA (Nov 2013 – Present)

Worked as senior automation engineer end to end for enterprise data warehouse project. Markit EDM is an Enterprise Data Management (EDM) system. It is used to perform most functions around data quality and mastering, specializing in financial and investment data and supports processing vast amount of financial or investment data and producing end user reports for making investment decisions.

Wrote Markit EDM Solutions for loading data from Bloomberg files, State Street, and BBH files using Business requirements document and implementing Matcher and Mastering logic as per business requirements.

Has automated and tested the working for Matrix Reports, List Reports, Chart Reports and Drill down reports in Markit EDM BI tool.

Has automated testing of SSIS packages in sql server.

Has strong understanding of database and proficient in writing sql queries.

Create complex sql views for loading the final output from Markit EDM.

Wrote UI automation framework for selenium from scratch to support Chrome and IE browsers for Markit Project, added support for page factory to load page dynamically when controls updated in the page. I was responsible for UI automation for my project and used the framework to accomplish this efficiently. The number of pages that was automated for UI testing is 5 web pages with average of testing 10 controls on each pages.

Worked as Senior Developer and implemented source control and build setup for version 1 deployments, implemented the daily build process successfully and defined source code structure feature wise and version control management across dev/test/prod using SVN and powershell scripting.

Worked on test automation for loading files in automated fashion to edm system and producing daily reports.

Worked on sql performance and responsible for query/stored proc tuning and optimizations.

Worked on Big data analysis for comparing the existing pace system with new Markit system and identified defect patterns and repeating issues and helped the team identify/fix root cause of issues.

Wrote automation tools in ..Net/C# in the current project for loading Bloomberg data files on daily basis.

Wrote SQL automation using xml loader for transformation of data files and load in to central system on daily basis.

.Net Technical Lead -Nordstrom Inc, WA (Nov. 2011 – Nov. 2013)

Worked as a Technical Lead in Nordstrom Shop/Secure web site development projects. Wrote automation tools in Visual studio team suite and QTP.

Proto-typed and wrote white paper on test driven development at Nordstrom which was adopted at the team level and successfully introduced for Rollout.

Converted C# applications to java applications and getting it up and running.

Has done automation for verifying SSIS reports.

Was involved in backend performance testing and load balancing for production systems.

Over the past 2 years involved in the automation and management of following projects at Nordstrom:

Test management for Web Cap Project Nov. 2011 to April 2012

Webcap is a project for customizing “your account” page in Nordstrom web site with features related to customer marketing preferences that runs across 5 downstream systems. Managed team of 5 testers with onshore/offshore model, this project involves data migration from flat files to oracle databases. Following are some of executed tasks:-

Allocated daily tasks for offshore testers.

Did mobile apps testing for Nordstrom mobile app.

Investigate/unblock on issues as needed and work prioritization.

Did data driven testing for account, address and credit cards migration from oracle to mdm database.

Wrote sql queries for verifying data migration

Schedule management and status reporting to stake holders.

Supported prod rollout on night shift and successful rollout

Test management for SQL 2012 upgrade April 2012 to Nov. 2012

Nordstrom databases were upgraded from sql 2005 to sql 2012, the system had 150 sql jobs and dts/ssis packages that needs to migrated and tested for functionality. Managed team of 4 testers with onshore/offshore model Following are some of executed tasks:-

Allocated daily tasks for offshore testers

Test Env and jobs setup and debugging runtime issues on sql jobs/dts packages.

Investigate/unblock issues as needed and work prioritization.

Planned and executed data driven testing for dts packages.

Wrote sql queries for verifying data being processed correctly by sql jobs.

Schedule management and status reporting to stake holders.

Tested High availability feature of sql 2012 or Always on.

Supported prod rollout on midnight and successfully migrated.

Test management for Nordstrom Apply and Buy Dec. 2012 to June 2013

Apply and Buy is new nordstrom.com website feature that involves applying for instant credit cards from shopping bag page and checkout pages and have the ability to use the cards immediately to buy upon approvals. Managed team of 4 testers with onshore/offshore model, Following are some of executed tasks:-

Allocated daily tasks for offshore testers

Wrote Test strategy doc and reviewed with client due to the complexity of the project involving credit systems and xml gateway systems.

Investigate/unblock issues as needed and work prioritization.

Planned and executed data driven testing for credit cards (visa, debit, retail)

Automated API testing for REST APIs.

Drove selenium UI automation for browser compat testing due to repeatability of the test scenarios

Wrote sql queries for data verification in downstream systems

Schedule management and status reporting to stake holders

Supported prod rollout on midnight and successful rollout.

Test management for NordStrom Rack DTC July 2013 to Nov. 2013

Nordstrom Rack DTC is a MPOS(Mobile point of sales) application that

only allow Pilot Rack stores to create a Direct to customer transaction from Mobile Device. Managed team of 5 testers in onshore/offshore model

Following are some of executed tasks:-

Allocated daily tasks for offshore testers.

Did mobile point of sales app testing used in Nordstrom stores.

Drove test case creation and test case review, feed backs incorporated

Investigate/unblock issues as needed and work prioritization.

Planned and executed data driven testing for mobile point of sales app.

Wrote sql queries for data verification in downstream systems

Schedule management and status reporting to stake holders

.Net/C#/SQL Developer-Microsoft Corporation, WA (Oct. 2001 – Oct. 2011)

Worked as a Software Design Engineer in Test II in Microsoft Windows Live ID, Over the past few years involved in the testing/development of following projects :-

Testing of Webstore Product (Duration Oct. 2001 to Oct. 2002)

Webstore is a database infrastructure that can meet the performance needs of demanding online users, ensure that the data is available when needed, and grow to support increasing transaction loads and storage requirements. Webstore has been created by Windows Live Platform Services to provide:

Scalability through data partitioning techniques that spread the data and workload over many servers

Availability by maintaining copies of the data which support failovers with potentially no impact on application read or write capabilities

Manageability through tools and interfaces supporting subsystem monitoring, transparent rolling upgrades, centralized job control, and autonomous self-healing

The combination of partition-based scalability, replica-based availability, and powerful management tools provide Webstore customers with a compelling database option when designing their application architecture.

Wrote Test Spec/Test cases and tested the Webstore product for repartitioning, functionality, performance, scalability identified functionality/performance/stability/reliability bugs to improve the quality of the product.

Has done regression testing of the product between multiple releases.

Wrote automation cases using scripting to verify data across multiple partitions.

Was involved in perf testing OLTP and OLAP cubes using distributed stress run and performance testing for optimizations.

Testing of Rolling upgrade (Duration Nov. 2002 to Dec. 2003)

A rolling upgrade offers multiple benefits and should be considered as an alternative of choice for any mission-critical system that requires high availability.

Benefits of Rolling Upgrade :

Minimize downtime. Rolling upgrades minimize downtime associated with software or hardware upgrades.

Minimize risk. Rolling upgrades minimize the risk of losing the service in case the upgrade fails. When an upgrade of one node fails, the other node can still provide the service, giving the system administrator the choice to repair or replace a failed node without incurring any additional downtime.

Increase flexibility. The nearly negligible system downtime caused by a rolling upgrade means that administrators could decide to perform a rolling upgrade during a working day instead of performing it late at night or on weekends.

Wrote Test Spec/Test cases to test the rolling upgrade functionality/Performance wrote and maintained test automation for the same.

Testing of Hotmail Migration (Duration Dec. 2003 to Jan. 2004)

Primary goal of this project is to migrate all the credentials and profile data from the hotmail store to one unified Passport BE. The primary objective of this testing effort is to ensure that none of our partners or customers using the service are affected due to this data migration and also ensure that the transition from authentication against hotmail BE to Passport BE happens without any outage in the service. Wrote Functionality/Performance Test Plan for the migration and tested the migration End to End and supported ops with real time migration of the run, identified/debugged issues during migration on Prod.

Performance Testing of Live ID FE/BE/Client (Duration Feb. 2004 to Oct. 2008)

Windows Live ID is a huge service with 1000 servers which consists of 250 backend servers and around 500-600 FE servers.

Worked on Developing Backend Stress harness using c# which makes accessor calls to the backend.

Worked on writing FE stress automation harness using C#/Visual studio Team Suite

Wrote Performance Test Plan for FE and BE/Client and Ran performance test pass for releases between this 3 year period.

Identified/Investigated Memory leaks and system stability issues during the performance test pass.

Perf Automated API testing for SOAP APIs using VSTS

Functionality Scenario Owner (Duration Oct. 2008 to Oct. 2011)

Wrote functionality/E2E scenario test plan/cases for the new live id features releases in Waves for windows liveid.

Did API functionality testing, wrote automation cases in .Net.

Was responsible for E2E testing and working with Partners and identifying/fixing issues on the beta site.

Was responsible for rolling the feature on prod and providing support to ops for smooth rollout.

Did security/fault injection/fuzz testing for the usability scenarios by partners and attackers to ensure feature quality.

Automated API testing using C#/.Net Framework.

EDUCATION

Bachelor of Computer Science, Madras University

Masters in Computer Science from Kuvempu University, Karnataka.

Master of Business Administration, Alagappa University

Graduate at NIIT, Madras

Microsoft Certified Solution Developer in SQL 2012 and Visual Studio .Net

PERSONAL INFORMATION

Cell Number: 425-***-****

Email Address: acz6pe@r.postjobfree.com

Contact this candidate