SUMMARY:

• 8 years of hands - on experience in Data Mapping, Data Staging & BIMart utilizing Oracle, MS SQL Server RDBMS;
• Experience in Data Analysis, Business Intelligence Reporting using SQL Server Integration and Reporting Services;
• Experience in Database Development, Data Migration and Extract-Transfer-Load (ETL) processes Monitoring ;
• Experience in Data Sources refinement, Data Cleansing and Loading Data into Enterprise Data Warehouse;
• Solid experience in Performance Tuning, Server Configuration, Deployment and Source Control Management;
• Experience in Managing and Monitoring of SQL Server Jobs, Alerts and overall Activity on the Servers;
• Experience in Manual and Automation Testing, Bug Reporting by means of QC and QTP and TFS and Visual Studio;
• Extensive experience in Functional, Integration, Regression, Stress, Load, Security, Accessibility, 508 Compliance, Cross Browsing, Graphic User Interface (GUI) and User Acceptance Testing (UAT), Unix and Shell scripting;
• Experience in writing Automation Test Scripts, Use Cases, Test Plans, Test Scenarios using CaseComplete;
• Experience in Requirements Analysis, Documentation Review, Data Modeling using UML using MS Visio;
• Hands on experience interacting with Clients as a SMEs to perform Requirements Change Management;
• Extensive knowledge and experience in Agile and Waterfall Methodologies of Software Development Life Cycle;
• Excellent presentation, time management, communication skills to interact with technical and business audience;
• Excellent analytical abilities and proven ability to perform multiple tasks in a high-pressure environment.

TECHNICAL SKILLS:

RDBMS: MS-Access, Oracle, MS SQL Server Management Studio 2008/2012

Software Development: Visual Studio, TFS, GiTHub, Eclipse, SSIS, SSRS, Informatica

UML / Requirements Tools: CaseComplete, MS Visio

Testing Tools: Quick Test Professional, LoadRunner, JAWS

Bug Reporting: HP Quality Center, Quick Base, FogBugz

Other Tools: MS Office Suite, SharePoint, Snagit, TextPad

Operating System: Windows (XP, Vista, 7, 8, 10), UNIX, IOS

Languages: PL/ SQL, T-SQL, VB.Net, VB6, C#, Shell

S W Methodologies: Agile, SCRUM, Waterfall SDLC

PROFESSIONAL EXPERIENCE:

ETL / Database Developer

Confidential, Herndon, VA

• Analyze 110 GB Enterprise Data Warehouse to develop best practice long run Data Integration solutions with multiple Data Sources and Ingest processes;
• Create Views and Temporary Tables in the Database to clean up the data and prepare it for ETL Staging process;
• Schedule, monitor and debug ETL routine ad hock processes to update Enterprise Data Warehouse;
• Develop ETL source and target mapping design/specifications based on the business requirements and ETL standards and architecture;
• Develop & Execute SQL/stored procedures/ server scripts as needed to support ETL code and SSIS pacakges ;
• Integrated existing Data Sources into Infromatica ETL components to support Data Analytics for downstream applications;
• Implement Performance Tuning related to SQL Server 2012 version upgrade and Query Execution Plan optimization;
• Perform Exploratory Research on external existing data sources such as SalesForce, USPS, InfoUSA and others;
• Suggest new formats of the data standardization and normalizing to synchronize MIDAS Database;
• Identify issues related to data conversion in ETL processes and synchronization between MIDAS DB and SalesForce and other third party data sources and downstream applications;
• Validate data supplied by various XML Web Services against existing data in the Enterprise Data Warehouse;
• Perform Testing of the Frontend interactive application integrated to SalesForce APIs;
• Review existing ETL package in SQL Server Integration Services to optimize data load and conversion;
• Collaboratively communicate with all Stakeholders to highlight existing issues to document them into a backlog;
• Perform Functional Requirements Gathering and CR Management communicating with Marketing, Market Development and Billing Departments;
• Perform Demo of a functionalities and outcomes of the completed User Stories at the end of the sprint;
• Prioritize and optimize proposed solution at the sprint planning to refine Product and Sprint Backlogs;
• Outlined a scope of Testing, provide a Manager with LOE and report identified defect to Development Team.

Environment: SRUM SDLC, .NET, IIS, SQL Server 2008/2014, GitHub, TFS, SSIS, SSRS, Informatica, SalesForce, Windows 7/8.

SQL Developer / Data Analyst

Confidential, Fairfax, VA

• Worked on Solomon Accounting System Data Migration to Microsoft Dynamics;
• Built data Mapping Specification Document to reflect Data Migration changes;
• Processed various sources of data received from Sales Managers and designed reports using MS SSRS;
• Created and Backed up Database populating with corresponding data for different stages of Testing;
• Extracted, Transformed and Loaded (ETL) data creating Data Sources and Data Flow Tasks using MS SSIS;
• Performed Unit Test for of SSIS packages built for Data Migration and fix identified issues or defects;
• Developed Front End Graphic User Interface (GUI) for FRx accounting reporting software using VB.Net;
• Performed a Data Cleanup in “gold copy” of the Database logging removed data logs in SharePoint platform;
• Mapped ODBC Data Sources in SQL Server to Microsoft Dynamics, Solomon and FRx accounting software;
• Modified existing Accounts and Subaccounts according to Accounting Department Requirements;
• Coordinated Account Department Testing effort to identify any issues and get them fixed by start of UAT;
• Participated in JAD Sessions with Accounting Department representatives to facilitate Data Migration;
• Established connection between VM Horizon client and internal server to access Solomon, Microsoft Dynamics.

Environment: SRUM SDLC, .NET, IIS, SQL Server, Visual Studio, SSIS, SSRS, Chrystal Reports, Windows 8/10.

Data Analyst / ETL Test Engineer

Confidential, Washington, DC

• Performed Data Conversion and Migration from multiple source files to Excel and SQL Server DB using Conditional Splits, Derived Columns and Expressions in SQL Server Integration Services;
• Loaded and archived data for each batch execution from SQL Server DB to XML, Flat, Excel, TRC destination files concatenating corresponding batch execution date stamp string;
• Debugged ETL data from Flat, XML and Excel source files using SQL Server Integration Services and SQL Server;
• Designed Parameterized Nested Reports based in the production log using SQL Server Reporting Services;
• Designed cascaded Dynamic Statistical and Graphical Reports, Industry Reports using Report/Group Variables and represented as Pivot Tables, VLookups, Macros, Bar Charts and Gauges using SQL Server Reporting Services, Excel;
• Designed Stored Procedures to perform Validation of Data in source files and Data stored in SQL Server Database;
• Designed Views, Tables, Scalar User Defined, String Functions, Multi Statement and Inline Table Valued Functions;
• Performed System, Regression, Functional, Integration, Security, Usability, 508 Compliance, Cross Browsing, Graphic User Interface Testing;
• Implemented Web Performance and Load Testing and analyzed results using Visual Studio TFS;
• Analyzed Functional and Business requirements and wrote Test Cases for Integration and Regression Testing;
• Logged and kept track of application defects into Visual Studio TFS Test Manager and ran automation scripts;
• Created queries in Visual Studio TFS to maintain Requirements Traceability Matrix and other reports;
• Prepared and presented Master Test Plans and Test Summary Reports to the Client at Test Readiness Reviews;
• Designed SharePoint website for UAT to provide access to supplementary documentation and UAT Scripts;
• Wrote UAT Test Scripts and corresponding supporting documentation to guide UAT Testers though the process;
• Investigated and collaboratively resolved UAT issues reported by UAT Testers in SharePoint-based website;
• Proposed new Requirements and Change Requests to the Client to improve the existing application functionality;
• Acted as a Team Lead for 60 Federal and State USDA employees during two-week PHIS UAT.

Environment: Agile SDLC, .NET, IIS, SQL Server, TFS Visual Studio, SSIS, SSRS, JAWS, Windows 7, MS Office Suite.

Data Quality Engineer / Data Analyst

Confidential, Washington, DC

• Analyzed data architecture and populated MS SQL Server with data sets to perform Back End Testing;
• Retrieved and reported Statistical Data from MS SQL Server and represented into Excel Bar Charts and Histograms;
• Worked with Lists, Pivot Tables, VLookups and HLookups, Matrix, Charts, Maps, Calculated Fields and Parameters to generate reports using SQL Server Reporting and Integration Services;
• Analyzed Functional and Business Documentation to convert into Use Cases and Test Scenarios;
• Developed different UML Diagrams based on existing Business and Functional Documentation using MS Visio;
• Wrote Requirements and performed further Specification Documents analysis and validation;
• Participated in Requirements Change Management by interacting with the Client and Stakeholders;
• Wrote Test Scenarios and executed Test Cases using Team Foundation Server (TFS) Test Manager;
• Performed System, Regression, Configuration, End - to-end, Black Box, Accessibility and GUI Testing;
• Managed Level of Effort and processes in QA Team to control current state of the Mobile Devices Certification;
• Used Visual Studio TFS to record defects and link them to corresponding Test Cases in TFS Test Manager;
• Generated weekly Test Status Reports to present to a Test Lead and Project Manager using FogBugz;
• Participated in JAD sessions and communicated with Business and Development Team.

Environment:: Agile SDLC, .NET, IIS, SQL Server, TFS Visual Studio, SSIS, SSRS, FogBugz, Windows 7, MS Office Suite.

Data Analyst / Back End Tester

Confidential, Vienna, VA

• Validated data in MS SQL Server using stored procedures and User Defined Functions to perform Back End Testing;
• Developed Dynamic Parameterized, Cascaded and Nested reports using SQL Server Reporting Services;
• Analyzed Functional and Business Requirements to create Test Plans, Use Cases, Test Scenarios and Test Cases using CaseComplete and MS Excel;
• Analyzed Help Desk System Ticketing Data to perform annual Service Level Agreement Audit using SSSR/SSIS;
• Performed Smoke, Black box, Negative, Positive, Functional, Regression, Accessibility, Cross Browsing, Testing;
• Performed Permission, Security, Incremental Integration Testing of SharePoint-based Intranet and Extranet;
• Performed Automation Testing by means of QTP in keyword view and using VB scripting in Expert view;
• Set up an environment to perform UAT, Accessibility and Cross browser testing manually and using JAWS;
• Performed Manual Graphic User Interface testing of .NET Applications and Bug Reporting using Quick Base;
• Created Requirements Traceability Matrix (RTM) in Excel and using QuickBase to report Testing status to IT Director;
• Created various UML diagrams using Visio for Requirements and Business Processes Representation;
• Participated in JAD sessions to understand Enterprise Asset Management system business process workflow;
• Participated in stand-up meetings to effectively communicate with Developers and Business Analysts and SMEs.

Environment:: Agile SDLC, .NET, IIS, SQL Server, SharePoint, Visual Studio TFS, HP QTP, SSIS, SSRS, JAWS, CaseComplete.

Quality Assurance Engineer

Confidential, Fairfax, VA

• Created Test Plans, Test Scenarios to perform System, Regression Testing for Web and Client-based applications;
• Analyzed Oracle DMS to create Views and run Store Procedures to populate with Data front end of the application;
• Performed Graphic User Interface Testing using HP Quality Center and Accessibility (508) Tasting using JAWS;
• Performed Security, Back End Testing by validating data in Oracle DMS using SQL Injection, User Defined Functions;
• Automated scripts in Quick Test Pro (QTP) to perform Functional and Regression Testing using VB Scripting;
• Retrieved data from Oracle DMS to perform automation data-driven framework testing using Quick Test Pro;
• Performed Stress, Performance, Load, Volume Testing in LoadRunner, reported using Transaction Graphs;
• Performed Cross-browsing Testing of Web-based .Net Application using Internet Explorer, Mozilla, Chrome, Safari;
• Created and maintained Requirements Traceability Matrix using MS Excel and QuickBase;
• Attended various walkthroughs and JAD sessions to analyze Business and Functional Documentation;
• Actively interacted with Configuration Management, Development and Business teams to fix critical defects;
• Reported Testing Status directly to QA Lead and Project Manager to discuss all issues occurred during testing.

Environment:: Agile, Waterfall SDLC, Java, Apache, Oracle DMS, UNIX, HP QC, QTP, JAWS, LoadRunner, QuickBase.