SUMMARY:

• Over 10 years’ experience as Sr. Data Business Analyst with extensive and diversified experience in the Construction Projects, Finance and telecom Information Technology sectors. Strong knowledge of Secondary Market related to mortgages, Construction Projects. Particularly effective at project planning and management, requirements gathering, preparation of functional design specifications, use cases, application development, creating databases, replicating, job agent, testing and user group training. Experienced in business process reengineering, data modeling, technical writing, financial reporting, Ad Hoc Reports, project documentation and information systems support. Strong organizational, leadership and interpersonal skills with the ability to motivate and empower staff.Result oriented IT professional with more than 10 years of professional experience in Information Technology including Data Business Analysis, System Analysis, and design and implementation phases.
• Excellent working experience with Confidential, Confidential, Chevy Chase, Nextel.
• Involved in all stages of Software Development Life Cycle (SDLC). Experienced with building applications based on RUP (Rational Unified Process).
• Extensive functional experience with different industry as well as automating technical capability.
• Participated in SQL database migration and Modified the ETL script to SSIS package.
• Involved in development of SSIS packages as part of ETL process migration. SQL Server Administration skills including backup recovery, database maintenance, user authorizations, Database creation, Tables, indexes. Expertise in the performance of the database by optimizing SQL statements, SQL Tuning.
• Designed, developed, documented and deployed Different reports and data analysis applications using Microsoft SQL Server 2005 Reporting services (SSRS).
• Hands on experience with SQL data replication set up, maintenance and troubleshooting issues.
• Strong understanding of Data Warehouse architecture, concepts and methodologies
• Extensive experience in Data Warehousing environments including DB2, Oracle, SQL Server on UNIX and Windows. Highly skilled in SQL
• Prepared data reconciliation strategies and monitored technical data quality. Modified several processes to automate data reconciliation and generation of exception reports in Data Warehouse environment.
• Developed test cases and scripts for System Test, User Acceptance Test, Volume Test; Conducted walkthroughs to obtain sign - off from business users.
• Involved in several projects related to data accountability, trace ability, and attestation as required by Sarbanes-Oxley Act.
• Highly skilled in strategic planning, problem solving, Black Box, Integration, System, Performance, Stress, Load, Regression, Manual, Automation Testing.
• Involved in Writing, Executing and Maintaining Test Plans, Test Procedures, Test Cases and Test Metrics in every release and in all phases of SDLC.
• Exposed to Business Objects 6.x. Coordinated with Business Objects teams while creating and designing Business Objects Universes and Reports.
• Extensively automated manual scripts by using Mercury Interactive Automation tools such as Win Runner, Quick Test Pro and Test Director.
• Expertise in Functional GUI Testing by Using Win Runner and Defect Tracking by using Test Director.
• A self-starter and highly motivated individual with excellent interpersonal and relationship building skills. Adept at handling multiple concurrent priorities and projects.

TECHNICAL SKILLS:

Languages: VB, Java, C, SQL and HTML

Database: MS Access(2003,2005,2007), Oracle 11g, DB2 SQL 2005,2008 R2, 2012(stored Packages& procedures, Functions, Database triggers, Index)

Operating Systems: UNIX, Windows NT XP/ 2000/2003/2007/2008/2012

Tools: and Technologies: MS Office, MS Access, MS Project and PowerPoint, Business Objects and Informatica, Erwin, SQL developer,Rational Clear case, Clear Quest

Web-based: HTML, DHTML, JavaScript, FrontPage, Photoshop, CGI, and ASP.NetT esting T ools: W in Runner, Load Runner, Test Director

Version Control: CVS, Rational Clear Quest, Rational Clear Case

Other Tools: TOAD, SQL Navigator, ER Win, PVCS and CVS

Microsoft Product: Visual Studio /SSRS/SSIS/SSMS 2005, 2008,2010

PROFESSIONAL EXPERIENCE:

Sr. DBA Analyst

Confidential

Environment: SQL, Windows, ASP. Net

Responsibilities:

• Manage all database objects like triggers, stored procedures, user security and other DDL functions.
• Use DML to retrieve data for generating custom reports which involves complex joins and nested queries. This involves new reports as well as modifying existing reports that run on the SQL Server Reporting Services
• Run data validity checks on the database and update the records based on the inputs provided by the user. Investigated, determined, and tested the extraction, transformation, and data load (ETL) logic and processes
• Work with developers to reproduce the errors and resolve software anomalies. Managed all aspects of the physical databases including schema, DDL, Users, Security etc.
• Perform analysis on client data and gain a specific understanding on all related Wealth Management data and its use throughout the application.
• Sync development/test database with production data using SQL Server Data transformation services.
• Sox Compliance: Tested multiple applications using different tools to meet the compliance. Identified the risk and updated to meet the standards as per Sarbanes Oxley.
• Responsible for gathering analyzing, designing and documenting data requirements for few databases. Meeting with business users to extract the requirements, responsible for turning business requirements and client specification into detailed functional design strategies, documents, and process flow diagram.
• Manage database security. Creating and assigning appropriate roles and privileges to users depending on the user activity. Troubleshoot and monitor database integrity and performance.
• Excellent communication and interaction with business clients, CFM consulting support team and upper management.
• Involved in monitoring, Performance Tuning, Database Backup and Recovery of databases which are exported to MS Access using Business Intelligence tools.
• Responsible to monitor, copying data in MS access version for MS access users’ performance tuning and database backup and recovery activities from SQL. Restoring and Maintain test and Development databases from the back up of production databases.
• Developing Dataflow Diagrams (DFD), ER Diagrams, ER mapping, and normalization and used all the appropriate CASE tools in the process. .

Confidential, Washington, DC

Sr. Business Analyst/QA Analyst Restatement Record Retention

Responsibilities:

• As a Business Analyst QA closely worked with Project Managers to Design, Support and maintain Restatement Retention Records. I deeply involved in creating the Status/ Test reports (MS Excel) for different projects, attending the managers meetings and preparing the meeting minutes. I also create required Meeting Minutes Doc with all the actions items and issues and posted them on the Share Point.
• Project duties included multiple task project assignments, scheduling and tracking; Facilitating meetings with all levels of the business community for requirements gathering, project development, design considerations, impact and risk analysis, and quality control of client acceptance testing.
• Extensively involved in Procedures and design policies for restatement record retention. I stayed in sync with corporate Record Management Plans.
• Deeply involved in Data and Document mapping and finding right evidence using Share Point portfolio for Restatement work streams using questionnaire checklist.
• Closely worked with other teams to provide different work streams closeout compliance and status and also provide all the artifacts as required for the Sox Compliance.
• Planned and performed several Sarbanes Oxley section 404 reviews on major organizations. Identified risks and key financial controls, tested the effectiveness of management assertions on these key financial controls.
• Working with Sarbanes - Oxley implementation team and internal auditors to test and validate the effectiveness of internal controls.
• Communicated client strengths and weaknesses to the operations audit team and teaming with them to plan an effective and efficient integrated audit approach.
• Implement, direct and monitor auditing policies, procedures and standards, with the goal of minimizing business risks, improving internal controls and business processes.
• Performing Access Control and Data Base Modification testing on various platforms
• Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements. Interacted with developers to report data related bugs and re-tested the fixed issues
• I also did manual testing and conducted User acceptance testing for some application.

Confidential

Sr.Business Analyst Home Equity / Mortgage Modules

Responsibilities:

• As a Lead Business Analyst, worked closely with Application Developers, Data Architects, and Technical Architects to identify and resolve complex business and technical issues related to Home Equity / Mortgage and Personal/Auto Loan modules. Provided a communication bridge to ensure constant flow of communication among the entire team.
• Responsible for gathering, analyzing, designing, and documenting data requirements for HELOC Data Marts. Facilitated meetings with business users to extract requirements. Responsible for turning business requirements and client specifications into detailed functional design strategies, documents, and process flow diagrams using RUP and Use Case Modeling.
• Investigated, determined, and tested the extraction, transformation, and data load (ETL) logic and processes. Modeled the data for optimized performance and ensured all HEL standards are strictly adhered. Responsible for monitoring and controlling the data quality.
• Reconciled data transfers between source and target systems. Assisted in automating the monitoring of Data Quality and creation of checkpoints and exception reporting procedures.
• Developed test cases for system testing; Created and verified User Acceptance Test data; Conducted walkthroughs to obtain sign-off from business users.
• Responsible for designing, creating, and maintaining various RUP artifacts such as Project Charter, Metadata Repository, Acceptance Plan, Roadmap, MS Project Plan, Test Plan, Functional Specifications, Status Assessment, etc.
• Prepared and communicated status reports and issues. Prepared release notes and ensured compliance of change control and customer notification policies and procedures for approval and risk mitigation.
• Prepared and communicated status reports and issues. Prepared release notes and ensured compliance of change control and customer notification policies and procedures for approval and risk mitigation. Involved in writing test plan.
• Created data driven tests to validate the same scenario with different test data using data pools.
• Developed Batch scripts for automated testing.
• Performed Web testing to ensure compatibility of the application on IE and Netscape.
• Used Clear Case for reducing start-up timeframes, Tracking changes, and managing dependencies between products.
• Ran SQL queries to check the database and update as per the inputs provided by the user.
• Worked with developers to reproduce errors and resolve software anomalies.
• Worked closely with the user during User Acceptance Testing and discussed possible responsibilities to particular issues.