Analyst

YAMUNA A. KUMAR

804-***-**** (C)

************@*****.***

(US Citizen)

I have a strong desire to learn and explore new concepts. I have good communication and interpersonal skills and will take up assignments with enthusiasm. I am a good team player and have worked well with different teams at multiple customer sites.

Summary

Programming/development:

Experience in design, development, and implementation of business solutions

• Experience in all phases of Software Development Life Cycle.

• Designed, developed, tested, Excel macros using VBA for reports and transferred data using DTS package.

• More than 5 years of experience in SQL server 2000 and 2005.

o Database backup/restore. Performance tuning and optimization.

o SSIS – Developed SSIS packages for data transformation from legacy claims processing system to SQL Server 2005 for various billing and reporting needs from Business users.

o SSAS- Created Cubes from fact / dimension tables.

o SSRS- Adhoc reports using Report Server. Model report.

o Extracted millions of records from databases and cleansed, transformed, integrated and loaded data into data warehouse using SSIS package. Mapped them in tables for other applications.

o Imported data from various source files of types CSV, TXT, SQL, Access, and Excel.

o Used SQL runtime engine to schedule nightly process. Ran server jobs, monitored schedule and validated its components.

o Extensive exposure to ETL tools like SQL Server Integration Services (SSIS), DTS and Data Stage.

o Experience with Transact SQL - Tables, Views, Triggers, Indexes, and Cursors.

o Implemented SQL stored procedures and functions for other developers.

• Excellent interpersonal and customer relational Skills. Proven communication skills.

• Capable of working as an individual and also as a part of team.

Systems / Integration testing:

Quality Assurance Life cycle testing including

• Preparing Test cases/scripts, and Requirements,

• Debugging/Executing Tests,

• Analyzing & documenting test results and coordinating sign-off of all production changes.

Proficient in:

DBMS: SQL Server 2000 SQL Server 2005, MS Access, Oracle 8i

ETL Tools: SSIS, DTS.

Systems: Visual Basic, SQL 2000 and 2005,

Excel / VB programming

Applications: Asset management, Connect IT, Share Point

Web Technologies: HTML, Dream Viewer.

Testing Tools: Win Runner, Quick Test Professional, Load Runner, Test Director, Silk

Defect Tracking Tools: Clear Quest.

Tools: Microsoft Excel, Word, Power Point. Crystal Reports.

Experience

Company: Advanous / Enterbridge. Glen Allen .VA

Duration: Feb 2009 to present

Title: Data Integration / Analysis Specialist

Primary responsibility for delivering fully automated SSIS data integration and ETL processes in SQL Server 2005. Familiar with data warehouse architecture, SSIS and data transformation services including staging and transformation,

This position includes

• Consolidating, enhancing and overseeing the operations of in-house client adaption processes used to populate a SSAS analytic solution.

• Supporting data analysis services through traditional ROLAP, cube and operational data store environments and creating SSRS reports for business use.

• Communicating directly with business team analysts and providing automation for existing processes and implementing new data discovery and analysis services at the request of the business team.

• Setting up QA environment for performance and functional testing including backup and restore as necessary.

• Data mapping.

Tools/technologies: MS SQL server 2005, Red Get, File zill, Visual Studio, CSV(Source code), and JIRA.

Company: SunTrust Bank. Richmond .VA

Duration: Aug 2008 to Dec 2008

Title: SQL Data Analyst

Developed and supported the reporting needs of the SunTrust Consumer Lending Operations Group and SunTrust Mortgage companywide for the War on Losses Project.

A high degree of creativity and latitude was required for this position.

Key responsibilities included.

• Accurately identifying, extracting, and analyzing large volumes of data.

• Extracting data from databases and cleansing, transforming, and integrating it.

• Creating stored procedures for reporting/processing data.

• Executing manual processes and automating where feasible.

• Working with business units to coordinate data scope and format requirements.

• Documenting existing processes.

• Providing production support for bug fixes and enhancements

• Defining, in written form, data and reporting requirements for new projects obtained from business and technical leads

• Developing and testing Excel macros using VBA for reports and transferring data using DTS package.

• Collaborating with various levels of staff (including senior management) on numerous reporting initiatives.

Tools/technologies: MS SQL server 2000, Visual Basic 6.0, and Excel

Company: Northrop Grumman. Richmond .VA

Duration: May 2007 to July 2008

Title: Data Analyst

Created and updated operational tables and procedures. Created reports (SSRS), including all related stored procedures. Analyzed data constraints and maps, wrote scripts to convert legacy data and table, structure to SQL Server.

Key responsibilities included.

 Enhancing and maintaining the Chargeback (Billing and Invoicing) system - creation of jobs using Data Stage Designer to validate schedule run and monitor the Data Stage jobs.

 Using SQL runtime engine to schedule nightly process running the server jobs, monitoring schedules and validating its components.

 Extracting millions of records from Asset management data and cleansing, transforming, integrating and loading data into data warehouse using SSIS package. Also, mapping them in tables for Invoicing and Billing.



Supporting data analysis services through traditional ROLAP, cube and operational data store environments and creating SSRS reports for business use.

 Performing technical analysis of complete systems and preparing comprehensive system level evaluations.

 Configuration Management, Performance Reporting, Resource Unit Repository, internal invoicing, and external invoicing, and interface with the ERP

 Working on Service Catalog, setting up products for catalog and change data for VITA Requirements.

 Development work on HP Open View service catalog

Tools/technologies: MS SQLSERVER 2005, SSRS,SSAS,SSIA, Visual Studio 2005, Crystal Reports, Altiris for pulling data, Asset management.

Company: Pembroke Occupational health, Inc. Richmond .VA

Duration: Sep 2006 to May 2007

Title: QA Analyst

Responsible for all aspects of Quality Assurance, including testing, bug fixes, change requests for web/database applications and other QA processes.

Key responsibilities included

 SSRS- Adhoc reports using Report Server. Model report.

 Analyzing portions of complex software applications and writing test cases which will expose defects,

 Testing reports for accurate data based on an understanding of the software application and baseline data, etc,

 Writing effective defect reports for developers to understand and reproduce, minimizing the need for further clarifications,

 Following up regularly on outstanding issues,

 Assisting in the planning and execution of full integration/system tests, developing test criteria working with developers, project managers and other specialists.

 Designing and executing tests to verify the accuracy of data migration between software systems.

 Creating different types of SQL queries/reports to test application performance.

Tools: MS SQLSERVER 2000 & 2005, Visual Studio 2005, RoboSource,

and DevTrack

Company: American General Life Insurance. Houston, TX

Duration: Jun 2005 to Jun 2006

Title: Testing Consultant

Responsible for manual functional and Integration testing. Worked on DOS and VB/Windows with VB front-end and Microsoft Access back-end. Wrote test cases, test plans, identified defects, tested and prepared other testing documentation.

Company: Capital One. Richmond, VA

Duration: March 2005 to Jun 2005

Designation: Recovery Specialist (Contractor)

o Researched bad cardholder accounts’ case history, identified credit-worthiness, collected/prepared all necessary regulatory documentation and had them processed by external collection agencies.

o Processed collection agencies’ returns/transactions and handled cardholders’ accounts data.

Company: Buxton Software Solution LTD. India

Duration: June 2004 to April 2005

Title: Testing Engineer

Life cycle testing including writing Test Requirements, Test Cases, Test Scripts, Executing Tests and Analyzing & Documenting Test Results.

Tools used: MS SQL SERVER 2000 &2005, Visual Studio 2005, RoboSource, and DevTrack

Company: SunTrust Bank

Duration: Oct 2000 – Jun 2004

Title: Teller Coordinator

Recieved Highest Sales Person of the month

• Managed 4 Tellers

• Coached trainees.

• Prepared for quarterly and yearly evaluations.

• Processed cash for branches and tellers.

• Did cross-selling of accounts, mortgage, credit cards, ATM cards, Merchant and Bank products.

• Handled all office supplies for the location

Company: F & M national Bank (BB & T)

Duration: Apr 1996 – mar 1998

Title: Teller

• Cash Handling, book keeping, and general accounting.

• Cross-selling accounts, mortgage, credit cards, ATM cards, merchant and bank products.

Education

Strayer University:

1 Pursuing BS IT/ Homeland / Security (2010)

2 System Modeling, Unix shell programming, Microsoft Access, Advanced Access, Oracle, Oracle Database, Oracle 9i, Visual Basic programming, C++ Certificate curses

J Sergeant Reynolds Community College 2008

1 Associate Degree in Information Technology with Computer Programming major.

J Sergeant Reynolds Community College 2004

2 Diploma in Computer Programming.

3 Completed Unix shell programming, Microsoft Access, Advanced Access, Oracle, Oracle Database, Oracle 9i, Visual Basic programming, C++ Certificate courses

Certifications

Microsoft Certified Technology Specialist (MCTIP)

Microsoft Certified IT Professional (MCITP)

Microsoft Certified IT Professional: Database Developer–

SQL Server 2005 and MCP ID # 6713374

Contact this candidate