Experienced Business/Systems Analyst with emphasis on analysis, configuration, design and management of database development processes. I have also experience in developing and implementing business process, ETL solutionsandsystem solutions for the real estate industry and other businesses. I possess strong working knowledge in developing project guidelines to support all phases of Software Development Life Cycle (SDLC) for web-based applications and Client Server applications. Dynamic and Assertive team player with strongcommitment and excellent communication skills.

Professional Expertise

• Good knowledge of understanding the Business Process, Business Rules and Scope of Projects
• Developing process that extracts transforms and repackages data to suit specific client needs.
• Experience in designing and implementing Test Cases, Plans, and Scenarios to conduct Functional Testing using various Rational Testing Tools
• Utilized technical programming to provide executive management the development and implementation of interactive business tools, and strategic analysis, vital for use in mission-critical decision-making.
• Exceptional ability to build and maintain client relationships

Technical Skills

Databases

SQL Server 20008/2005/2000, MS Access, IBM DB2

Rational Tools

RequisitePro, ClearCase, and ClearQuest

Data Warehousing Tools

Business Objects, Informatica, COGNOS, Pentaho

Scripting Languages

VB Script, JavaScript, Visual C#

Operating Systems

Windows 7, XP/ 2000, UNIX

Microsoft Tools

MS Office

Experience

Confidential, Rancho Cordova,CA
Business Analyst Integration Nov 2010 to May 2011
Confidential is a leading provider of business information, analytics and outsourcing services. They have a vase repository of data, an advanced set of analytical models and a have the opportunity to drive innovation and cultivate insights and build unique solutions for clients.

Roles and Responsibilities

• Worked with different data providers in identification and creation of relevant datasets

• In-depth manipulation of large datasets and samples
• Performed data modeling, relational design including data normalization
• Involved in creating ETL processes that updated the production databases periodically, so accurate analysis can be performed by the management
• Involved in data analysis, synthesizing relevant data and presenting recommendations to senior management
• Performed data quality checks periodically on the production database and ensured data accuracy
• Formulated documents and tactical actionable requirements for product development
• Extensive research in identifying a Business Intelligence tool that was critical for analytical purposes and product development

Confidential, Sacramento, CA Oct 2008 to Nov 2010

Programmer/Test Analyst, CCSAS-CSE (California Child Support Automation System, Enforcement Project)
CCSAS-CSE is a single statewide Child Support system capable of providing high quality cost-effective services to California’s demographically diverse and mobile population. CCSAS utilizes an expansive set of software and hardware tools to meet federal requirements for statewide child support enforcement (CSE) systems.

Roles and Responsibilities

• Worked independently in functional testing of the functionalities Interstate and IV-A. Both functionalities were independent systems interfacing with the CSE system.
• In-depth analysis, planning and execution of tests for Change Requests(CR) and Design Change Requests (DCR) of the existing system
• Worked extensively with Secure File Transfer Protocol using WinSCP and execution of Batch Jobs using Tivoli Job Scheduling Console and PuTTy
• Extensive analysis of production data using SQL queries to formulate test scenarios and identify defects
• Created Automated Test Scripts for various functionalities using Quick Test Professional 9.0
• Completed Thorough Manual Regression of functionalities - Interstate and IV-A for every planned and emergency release
• Resolved Production Support Tickets by reproducing the errors and determining if they are genuine, in which case defects were opened and passed on to the developers with all the needed information enabling a quick turnaround or as in most cases, by educating the client about the proper use of the Software.
• Interacted with the client on a day-to-day basis

Confidential, Irvine, CA May 2007 to Sep 2008
Systems Analyst / Developer 
Confidential developed a Collaborative Real Estate Platform (CRP), and their client base includes Century 21 Realtors. CRP encompasses all business aspects (business-to-business, business-to-consumer commerce and collaboration). This platform is adapted to the following sectors of the market: real estate, mortgage, escrow, title, and brokers back office.

Roles and Responsibilities

• Involved in the development and Maintenance of Web pages using HTML and ASP.NET.
• Analysis and Transformation of raw data from the Multiple Listing Service database/ source to meaningful and desired format.
• Create and Maintain large databases
• Create reports in SQL Server 2000 to aid management decision-making process
• Perform User Acceptance Testing for new client sites
• Data Mining to ensure the accuracy of data displayed on the client’s websites
• Provide technical support for day-to-day issues as well as Customer Training Sessions
• Testing and release of IRESS - Integrated Real Estate Software Solutions - a collaborative platform for Real Estate companies, to enable visitors to their website to search for properties listed with various Multiple Listing Services (MLS).

Confidential June 2001-Apr 2003
Program Analyst
Confidential Cybertech Ltd was a start-up which revolutionized the use of computers and Information Technology for small businesses. A wide client base spread over a small geographical area enabled amazing success within the first few years of incorporation.

Roles and Responsibilities

• Extensive Requirement Analysis of Projects at Client’s end.
• System/ Project Design preparation
• Creation of Web pages using HTML and JavaScript
• Database Modeling and creating databases

Confidential 
Dec 2000- June 2001

Intern – Systems Analysis
Academic Training with hands-on-experience in the Project that involved design of a Mail Client for SRA’s Web Based E-Mails.

EDUCATION

Certificate Course in SQL and Data Warehousing and Business Reporting-(Business Objects, Informatica and COGNOS)
Masters In Computer Applications
Graduated In Commerce and Business Studies