Post Job Free
Sign in

Sql Server Manager

Location:
Alexandria, VA, 22306
Posted:
August 28, 2013

Contact this candidate

Resume:

Professional Summary:

V Over Nine years of diverse IT experience with 4 years of leadership

experience in Quality Assurance, Testing, Data Analyst, Development

and Maintenance of various software applications in Data warehouse

environment.

V Extensively wrote SQL for Back end testing ETL related complex

business processes on UNIX batch applications and interfaces.

V Worked as Informatica Admin and Migrated the code in different

environments using Informatica Repository

V Experienced in creating source to target mapping document for ETL

development and ETL testing

V Expert in ETL tool Informatica which includes components like

PowerCenter, Designer, Workflow Manager, Workflow Monitor, Repository

Manager, Repository Server, Administration Console, PowerMart,

PowerConnect

V Highly Proficient in developing Complex Transformations, Mappings,

Mapplets, Workflow, Worklets and Scheduling Informatica Jobs

V Worked extensively with Complex Mapping using different Transformation

like SQ, Expression, Filters, Joiners, Routers, Unconnected/Connected

Lookups, Functions, Aggregators, Stored Procedures, Transaction

Control, Update Strategy

V Strong experience in designing SCD 1, SCD 2 mappings

V Highly proficient in Debugging and Performance Tuning of the ETL

process which includes tuning of Informatica mappings, session, source

and Targets

V Experienced in Extracting data from various sources like Oracle,

Teradata, SQL Server, DB2, Flat Files into the staging area

V Extensive Database Experience using Oracle 10g/9i, DB2, PL/SQL, SQL

*Plus

V Expertise in Ab initio graphs and Informatica work flow execution and

validation.

V Experience in Data Modeling by creating Logical and Physical Models

using ER-win

V Excellent understanding of the SDLC, its constituent Activities &

steps, Models & the supporting Disciplines.

V Extensive experience in all steps of STLC; performed Requirements

Analysis, Test Preparation, Test Execution, UAT, Defect Management and

Reporting.

V Thorough hands on experience with all levels of testing namely Smoke,

Sanity, Integration, Interface, Functional, Integration, End to End,

Regression, Backend and Front end testing, Load, Performance, Volume

and Compatibility testing.

V Actively participated in the user requirement gathering & JAD Sessions

that involved the Project Sponsors, Managers, BAs, development team &

test team.

V Prepared and maintained RTMs, FRMs and PR reports to ensure

comprehensive test coverage of requirements.

V Expertise in Path Analysis & Data Flow Analysis and writing test cases

from the basic, alternate, and exceptional flows of the Use cases.

V Extensive experience in both Manual and Automated testing using QTP,

WinRunner, LoadRunner, Quality Center/Test Director and Clear Quest.

V Experienced as Quality Centre/Test Director Administrator for

adding/Deleting users and projects.

V Extensive experience in tracking bugs using Bug tracking tools such

as Test Director/ Quality Centre, Remedy and Clear Quest.

V Coordinated and prioritized outstanding defects and enhancement based

on business requirements, allowing sufficient time frame to ensure

accuracy.

V Expertise in generating & analyzing management reports.

V Performed Gap Analysis through interactions with both the client and

the technical team to ensure key financial and business data is

managed and delivered in line with the business requirements.

V Scrum Alliance Certified Professional Scrum Master

V Lead testing efforts in several projects by implementing Agile

Methodology by using Scrum and Extreme Programming.

V Awarded with Certificate of Appreciation for my work from Advance Auto

Parts

V Good knowledge of Finance, Insurance, Ecommerce, Mortgage, Auto Parts,

Travelling and Media Industry and processes.

V Ability to multitask, flexible in adjusting to people, hard working

with a realistic attitude, good interpersonal skills and a team

player.

EDUCATION:

Master of Business Administration (MBA) in Finance, George Mason University

Bachelors B.S in Computer Science

Certifications:

Certified Scrum Master from Scrum Alliance, Member id: 000086754

[pic]

TECHNICAL SKILLS:

ETL TOOLS: Informatica Power center 8.6/8.1/7.1/6.2, DataStage.7.5/7.1,

SQL*Loader, Bulk Loader

Reporting Tools: Cognos, Business Objects XI, MS SQL Server Reporting

services 2005, Developer 2000(Forms

5.0, Reports 6i), Crystal Reports 10, Crystal Reports 2008.

DATA Modeling: Erwin 4.0/4.1

Operating Systems :Windows (9x, 2000NT, 2000, XP, 2003), AIX, HP UX

9000, Linux, UNIX

Languages : TSL, C/C++, Visual Basic 6, SQL, PL/SQL, Bourne Shell,

Java,

J2EE, HTML

Testing Tools : Win Runner, QTP, Load Runner

Tracking & Version : Test Director, Quality Center, Clear Quest, Remedy,

VSS, Doors, Clearcase

Databases and tools : Oracle 11G, MS SQL Server, Sybase, DB2, My SQL,

Toad

Web Tech. :HTML/DHTML, VB Script, J2EE, XML, Java Script, WML, CSS,

XSLT, ASP, JSP

Web/Appl. Server : SAP Web AS, Web Logic Application Server, Tomcat 5.0 Web

Server, Apache Web Server, Microsoft IIS Web Server

Projects Undertaken:

Allegis Group, Hanover, MD

NOV 2011 - Current

Informatica Developer / Data Analyst

Project: BI Framework

Allegis Group is the parent organization of TEK systems, Aerotek, Stephen

James, Allegis Group Services, Market Source, and Major, Lindsey & Africa

among others. Each operating company specializes in a different contract

services and solutions industry. Allegis group being a very large

organization with multiple application system across different companies

wants to capture information across the enterprise in a central database

and make better business decisions using the business intelligence from

central Enterprise Data Warehouse.

Responsibilities:

V Extensively worked in full Software development life cycle.

V Worked closely with business users on gathering the requirements and

prepared Technical Design and Mapping documents.

V Created Folders and deployment groups using Repository manager.

V Extensively worked with Designer tools like Source Analyzer, Target

designer, Mapping designer, Mapplet designer, Transformation

Developer.

V Created source and Target Definations, Reusable transformations,

mapplets and worklets.

V Created Mappings and extensively used transformations like Source

Qualifier, Filter, Update Strategy, Lookup, Expression, Router,

Joiner, Normalizer, Aggregator and Sequence Generator, Web services

Consumer.

V Developed Source to Staging and Staging to Dimension mappings.

V Developed Source to Staging and Staging to Fact mappings

V Used Workflow Manager to create sessions, worklets workflows.

V Extensively involved in tuning the mappings, sessions and the Source

Qualifier query.

V Identified performance issues in existing sources, targets and

mappings by analyzing the data flow, evaluating transformations and

tuned accordingly for better performance.

V Manage all technical aspects of the ETL mapping process with other

Sprint team members.

V Involved in Unit and Integrating testing of Informatica Sessions,

Batches and the Target Data

V Created mappings to load Slowly Changing Dimension tables based on the

amount of historical dimension data wanted to keep

V Worked with Oracle On Demand to load the data to the cloud and query

from OOD using Informatica.

V Extensively worked on WSDL requests and responses.

V Modified the WSDLs as per the Business rules.

V Involved in migration of mappings and sessions from development

repository to test and production repository.

V Designed and developed UNIX shell scripts as part of the ETL process,

automate the process of loading, pulling the data..

V Involved in production support and done knowledge transfer to team

members

V Actively involved in Daily check in meetings to discuss on the

production issues and resolved.

V Graphically represented the data flow and process flow by creating

Dataflow diagrams and Process flow diagrams

V Analyzed functional requirement and created the logical model using ER-

win.

V Converted the logical model into the physical model by identifying the

tables and columns on a granulated level using ER-win.

V Created the data flow and conceptual diagram for the business for

better understanding and identifying the stages of data.

V Filtered tables in a source system to obtain the most relevant

data/ tables in accordance with the business requirements for decision

making by upper management.

V Created source to target mapping document for the ETL development and

ETL testing team.

V Set-up functionality walk-through workshops with business analysts and

developers.

V Reviewed the mapping documents for STAR Schemas and Conformed

Dimensions to create complex Informatica ETLs, SQL Views, Procedures,

Tables and Synonyms for the test framework

V Thoroughly conducted data analysis and gap analysis between source

systems for EDW model.

V Designed and developed the Test Suite in the HP Quality Center

V Worked as Informatica Admin and added new users and provide them

different rights as per there role needs.

V Created deployment groups in Informatica Repository and copied

objects.

V Migrated Informatica code using Informatica Repository from DEV to

TEST and from TEST to PROD.

V Created new sessions and events using Informatica Workflow Manager.

V Co-ordinate with Oracle and SQL server DBA's to create DB links to

test the data coming from different source databases.

Environment:

Oracle 11G, SQL Server 2008, DB2, Unix, ER-win, Mercury Quality center

10.0, Door, BO Info View, Pl/SQL, Toad 10.6, SQL server management

studio, Informatica 8.6.1, Informatica 9.0, Business Object Informatica

Power Center 8.6.1, Oracle 10g/11g,DB2, Sybase, Rapid Sql server, Erwin,

Windows XP, UNIX.

Amtrak, Washington, DC

NOV 2010 - NOV 2011

Informatica Developer

Project: EDW & CSPMI

Amtrak being a very large organization with multiple application system

wants to capture information across the enterprise in a central database

and make better business decisions using the business intelligence from

central Enterprise Data Warehouse.

Responsibilities:

V Extensively used Informatica Power Center 8.6.1 to create and

manipulate source definitions, target definitions, mappings, Mapplets,

transformations, re-usable transformations, etc.

V Involved in design and development of complex ETL mappings and stored

procedures in an optimized manner.

V Implemented partitioning and bulk loads for loading large volume of

data.

V Involved in loading the data from Source Tables to ODS (Operational

Data Store) Tables using Transformation and Cleansing Logic using

Informatica.

V Based on the requirements, used various transformation like Source

Qualifier, Normalizer, Expression, Filter, Router, Update strategy,

Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations

in the mapping.

V Developed Informatica SCD Type-I, Type-II mappings.

V Created Stored Procedures in PL/SQL with Oracle in order to create,

update several tables like Order processing Information table and

train scheduling tables.

V Used the Debugger to run Debug sessions setting Breakpoints across

instances to verify the accuracy of data.

V Used PMCMD command to start, stop and ping server from UNIX and

created UNIX SHELL scripts to automate the process.

V Created UNIX Shell scripts and called as pre session and post session

commands.

V Developed workflow tasks like reusable Email, Event wait, Timer,

Command, Decision.

V Creating Test cases and detailed documentation for Unit Test, System,

Integration Test to check the data quality.

V Executed workflows in Informatica to migrate the data from source to

target

V Monitored workflows in Informatica and send out success/failure email

notification to entire team for daily, weekly and monthly loads for

different subject areas.

V Updated schedules and added business users for various reports in

production using BO info view.

V Monitored BI reports in production every morning and sent out

success/failure email notification to business.

V Worked with developers in De-bugging the issues for workflows

failures by analyzing the data and logs.

V Performed smoke testing, functional testing, Back end Testing, Front

end Testing, Integration testing, End to End testing, regression

testing, positive and negative testing

V Worked with Business Intelligence team to coordinate integration

between BO universe and EDW

Environment:

Informatica PowerCenter 8.6.1/8.1.1, Oracle 11g, TOAD for Oracle 9.7,

SQL server 2008, Flat Files, PL/SQL, ERwin, Windows 2000, UNIX

Advance Auto Parts, Roanoke, VA

Feb 2009 - Nov 2010

System Test Lead/Data Analyst

Project: APAL Point Of Sale/Second Source/Web Applications

Advance Auto Parts, Inc. is the second largest auto parts; Roanoke,

Virginia-based Company operates more than 3,400 stores located in 38

states, Puerto Rico, and the Virgin Islands. Further, it is a partner in

PartsAmerica.com, an online auto parts retailing venture. The project

involved enhancement in Point of sale application, web projects in

Implementation factory and second source project in APAL team.

Responsibilities:

V Managed and lead team of 6 test members.

V Created and presented the overall Test Strategy and Test Process for

POS, Second Source and web project to the team and higher management.

V Held daily status meetings with team and provided metrics to senior

management

V Analyzed system requirements, Business Requirements and generated

Requirements Traceability Matrices, test plans, test scripts

accordingly.

V Provided LOE for test planning and execution

V Organized requirements review sessions with business users and

requirements analysts to bring new members up to speed for Systems

Testing and Held business knowledge transfer from system analysts to

system test team.

V Assigned work among the team members

V Worked very closely with business analysts and developers in the

projects.

V Designed system test plans for client server based applications and

web based applications

V Organized and supervised formal reviews of technical specifications,

design documents and test plans

V Wrote and executed system test cases for web and client server

applications under test using Quality Center.

V Wrote intuitive test cases and scenarios for functional, usability,

browser compatibility, data, and regression testing in Quality Center

V Experienced as customizing HP Quality Center tool and creating report

V Provided Quality Center training to users as needed

V Worked as an administrator for adding/deleting users and project in

Quality Center tool

V Performed smoke testing, functional testing, Back end Testing, Front

end Testing, Integration testing, End to End testing, regression

testing, positive and negative testing

V Completed data analysis on the Oracle sever to fetch data for testing

V Wrote complex SQL statements to retrieve data for data scenarios

V Validated the complex business process ETL for external partner client

interfaces by writing SQL query for extracted data.

V Executed Informatica work flow from UNIX.

V Executed UNIX batch job and verified success by checking various

application logs.

V Written SQL queries for checking the Data Transactions and Database

Integrity in Oracle and SQL Server. Also developed SQL scripts to run

complex data integrity test cases and to extract data from the tables.

V Worked with developers in De-bugging the failure issues by analyzing

the data and logs

V Performed functional, GUI, and Security testing using the different

checkpoints in the automated WinRunner

V Worked on multiple projects and lead the testing efforts of those

projects at the same time

V Participated in UAT testing with business users

V Executed multiple builds for UAT users as communicated the results

V Developed test cases and test scripts using Winrunner for

Functionality, Security and Regression Testing. Configured, developed,

tested and supported the networks.

V Carried out extensive testing with the WinRunner, testing tool with

different test cases, which reflects the various real time business

situations.

V Communicated with the developers and business users for test issues

and escalated when required

V Tested report generated from Cognos BI Layer

V Used SQL Server Management and Rapid SQL to query database

V Involved in Extensive testing of various situations along with the

implementation team, resolved the issues and problems.

V Participated in daily defect review meetings and provided testing

progress status.

V Retested all new and existing defects and communicated the results

with the users

V Used Quality Center as defect tracking tool

Environment:

Clarion, Oracle 10G, SQL Server 2005, DB2, Unix, Dot Net 2.0, Csharp, VB

Dotnet, Java, J2EE, Mercury Quality center 10.0, Door, Clear case, Win

runner, Pl/Sql, Sql server management studio, rapid SQL, Informatica,

Business Objects

Carlson Wagonlit Travels, Plymouth, MN

Sept 2008 - Feb 2009

QA Test Lead

Project: CWT Document Bank

Carlson Wagonlit Travels is United States second biggest traveling company

which is dedicated to helping companies of all sizes, as well as government

institutions and non-governmental organizations, optimize their travel

program and provide best-in-class service and assistance to travelers. The

project involved enhancing the web based application called CWT Document

Bank in different sprints and converting the entire data of CWT Document

Bank from one database to other database which has information of all

unused documents.

Responsibilities:

V Managed and led Team of 5 test members

V Assigned task among the team members

V Used Agile Methodology method for testing like scrum and Extreme

Programming

V Prepared and presented plan for need of requirement based System

Testing based on project complexity and also since current testing

suite was just integration testing.

V Created over all System Test Strategy detailing Test Methodology for

CWT Document Bank

V Tested Data Conversion and complex ETL from SQL server to Oracle

database by creating comprehensive SQL statements

V Executed conversion and ETL shell scripts from UNIX

V Reviewed business Requirement, detail and high level development

design documents

V Attended Requirement review meeting with product owner, scrum master

and business users

V Attended Daily Morning scrum meetings with Scrum master and Product

Owner to discuss testing efforts, accomplishments and obstacles

V Designed metrics reporting template to track progress of teams and

reported weekly status to higher management and Scrum master

V Used Rally to burn task hours for each and every sprint

V Created Test plan for each and every sprint

V Used Quality Center to write Test Cases, Test Scenarios and enter

Defects

V Wrote automation test scripts and executed them in Mercury QTP

V Automated the test scripts for Regression testing and performed

backend testing by creating database check points using QTP

V Enhanced the test scripts through Check Points and Parameterization.

V Converted entire data of two tables from SQL server database to Oracle

database

V Completed data analysis on the Oracle sever to fetch data for testing

V Wrote complex SQL statements to retrieve data for data scenarios

V Worked with data team to manufacture complex data conditions that does

not exist in production.

V Used Toad and Rapid SQL to query data from database

V Held daily status meetings with my team and provided metrics to senior

management.

V Participated in daily defect review meetings and provided testing

progress status.

V Managed daily issues of test execution and functional defects with

respect to requirements or code deployment

Environment:

Java, J2EE (AJAX, DOJO, STRUTS, EJb, JDBC and XML), Sql Server, PL/SQL,

XML SPY, Rapid SQL, Unix, Linux, Oracle 9i,10G and Toad, Quality Center

10.0, QTP, Rally

Discovery Communications, Silver Spring, MD

Nov 2007 - Sept 2008

Sr. QA Analyst

Project: AMS

Discovery Communications is the number-one nonfiction media company

reaching more than 1.5 billion cumulative subscribers in over 170

countries. The project involved conversion of data from the HD Simulcast

Data Grid to the new data structures in AMS. After the conversion, all HD

data will be tracked in Core and Specials area of AMS and the HD Data Grid

will be made read-only.

Responsibilities:

V Managed and lead team of 10 test members.

V Held daily status meetings with team and provided metrics to senior

management.

V Participated in daily defect review meetings and provided testing

progress status.

V Managed daily issues with test planning regarding requirements or code

deployment

V Provided LOE for test planning and execution

V Assigned work among the team members

V Coordinated with CM to get latest builds and deployments

V Analyzed and reviewed business requirements

V Organized meetings to discuss requirement issues with manager and

business counter parts.

V Drafted test cases, test scenarios for 54 requirements on an

aggressive hard deadline.

V Reviewed test artifacts with business users and production manager.

V Reviewed conversion reports that identify the fallout of bad data

after conversion.

V Wrote complex SQL in TOAD to verify the converted data from HD

Simulcast to AMS.

V Lead the execution effort of the conversion batch processing in UNIX

V Wrote shell scripts to analyze logs.

V Performed smoke testing, functional testing, Back end Testing, Front

end Testing regression testing, Integration testing, End to End

testing, positive and negative testing

V Coordinated with developers during on and off hours during conversion

failures.

V Worked with developers in De-bugging the failure issues by analyzing

the data and logs

V Opened defects in Remedy bug tracking tool.

V Coordinated and communicated with developers to provide all necessary

info in the defect.

V Setup emergency meetings with all parties during build failures and

escalated the issue to higher management

V Manually cleaned the data by updating the bad attributes data in the

database using SQL.

V Identified the bad data by de-bugging the failures causing the

conversion to fail by querying the database using SQL in TOAD.

V Documented all data issues and communicating to users to clean the

production data.

V Executed reports to get list of data warnings that will convert but

won't cause conversion failure.

V Validated the error reports by executing expected result queries.

V Performed Backend Testing for data Integrity

V Verified the converted data to AMS by querying all tables for updated

decoders for all networks, HD Subs and billing system affiliates.

V Participated in UAT conversion testing with business users

V Executed weekly builds for UAT conversion in UNIX

V Provided reports and data to UAT team for review

V Sent weekly reports on progress of data cleanup during conversion

V Absorbed new requirement changes from UAT after every execution cycle.

V Created RTMs to map use cases with test cases and made sure that test

cases were written for all functional requirements

V Updated and maintained RTM to make sure that all requirements changes

were captured

V Posted documents on IBM Lotus Quick Place, a work space designed for

team collaboration

Environment:

J2EE (AJAX, DOJO, STRUTS, EJB, JSP, JSTL, JDBC and XML), Oracle PL/SQL,

XML SPY, Remedy, JavaScript,Unix, Linux, Oracle 9i,10G and Toad, IBM

Lotus Notes, IBM Quickplace

Chevy Chase Bank, Gaithersburg, MD

Nov 2005 - Oct 2007 Sr. QA Tester

Project: Advanced Billing System

Responsibilities:

Involved in all stages of Software Development Life Cycle from

requirements gathering to post-production.

V Participated in weekly assessment meetings with BAs, SMEs, and

developers and coordinated between business analysts, development

team, and testing team.

V Analyzed system requirements, Business Requirements and generated

Traceability Matrices, test plans, test scripts accordingly.

V Performed path analysis, and developed and executed test cases, and

test scenarios.

V Performed Sanity Testing and Smoke Testing before a full fledge

testing is implemented for the application.

V Involved with UAT batch execution and analyzed UAT results to support

their schedule

V Reviewed UAT defects and traced back to functional test scenarios.

V Provided daily status on the UAT progress to all the stake holders

V Developed automation test scripts for functional & regression testing

using QTP.

V Analyzed and reviewed system/business requirements and test cases in

Doors.

V Enhanced the QTP scripts by implementing VBScript functions and

inserted Checkpoints to check for Text, table, XML, and images, and

Synchronization points to capture upload time.

V Handled known exceptions in the test scripts using QTP Recovery

Scenario Manager.

V Used Smart Identification to distinguish Objects that are difficult to

identify by using default identification mechanism.

V Performed Data-Driven testing, Text Output values by using Global and

Local spreadsheets in QTP for testing multiple data.

V Used Load Runner for conducting Performance, Stress and Load tests.

Generated the test scripts, and parameterized and correlated the

scripts to run for multiple users.

V Executed baseline tests to verify the scripts and pinpoint the

bottlenecks at various application layers.

V Monitored the system resources of all the servers while executing the

tests.

V Written SQL queries for checking the Data Transactions and Database

Integrity in Oracle. Also developed SQL scripts to run complex data

integrity test cases and to extract data from the tables.

V Logged defects using Mercury Quality Center, Remedy, Clear Quest.

V Actively participated in DRB meetings to resolve the defects in

efficient and timely manner.

Environment:

QTP, Load Runner, Quality Center, Remedy, Java, J2EE, JavaScript, Oracle

9i, MS Office, VB Script, Windows XP, Unix., SQL, Ms-Access, Windows 2000

Client: WELLS FARGO, Mc Lean, VA Aug 2003 - Oct 2005

Sr. QA Analyst

Project: Wells Fargo Deal Decision Project

Responsibilities:

V Reviewed User requirements specifications and prepared detailed Test

Plan and Test Cases.

V Tested application on Windows2000 and UNIX environments.

V Wrote test script for manual test and then transferred it for

automated test.

V Performed manual testing for the entire application and reported the

defects to the developer.

V Responsible for the set up, support and coordination during IST, PRE-

UAT, and UAT phase

V Coordinated with project team members to gather, define, and document

UAT test scripts, scenarios and conditions

V Wrote shell scripts.

V Performed Backend Testing for Data Integrity

V Performed Functional testing and System testing using WinRunner.

V Wrote test scripts for Positive testing, Negative Testing, Boundary

Testing and Security Testing.

V Utilized Load Runner for performance, volume and load testing of the

application.

V Conducted regression testing on each new build.

V Developed the schema for bug tracking and reporting using Test

Director and Remedy.

V Participated in weekly meeting and reviewed the bugs.

V Coordinated with the users and development team.

Environment:

Windows2000, Test Director, Remedy, C++, UNIX, Java (jdk 1.2.2), Websphere,

WinRunner 7.6, Rational Administrator, LoadRunner 8.0



Contact this candidate