PROFESSIONAL SUMMARY:

Nearly 6 years of IT experience using the Software Development Life Cycle (SDLC).
Extensive experience in Business Analysis supporting various complex financial and retail projects.
Successfully completed training for “Specifying Client Requirements” from IAG.
Experience in creating and maintaining Requirement Traceability Table /Matrices for the projects.
Expertise in SOX rules, and Requirement management tools.
Knowledge on ISO (International Organization for Standardization), CMM (Capability Maturity Models) and Six Sigma Standards
Clarified client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders.
Strategized project scoping and specifications documents, to clearly communicate the project roadmap.
Expertise on COTS product integration to evaluate for end-to-end automation and feasibility analysis of several options for modernization and recommendation.
Interfaced with ISS to identify business requirements specific to a business product/process andtranslated the business application\'s needs into systems requirements.
Expert in business process engineering, system integration and software development life cycle, including analysis, design, development, testing and implementation of software applications.
Translate the business requirements into functional specifications, capture user interactions, user interface specifications (i.e. screens and windows), outputs (i.e. reports and forms), interfaces and general systems requirements; assisted by the IT Lead where appropriate.
In-depth knowledge of data modeling and mapping; and design using UML, and Visio.
Experience merging data sets with different levels of granularity to ensure output data integrity by primary keys (measuring the size of the components)
Compared received data and existed reference files and analyzed resulting datasets to review and pinpoint significant discrepancies in aggregated statistics for various dimensions (lack of consistency)
Have excellent technical leadership, analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and can work as a part of a team as well as independently
Certified SAS Base Programming for SAS ® 9 using SAS as data management and statistical analysis tool.
Background in statistical techniques such as Correlation and Regression including Multiple Regression, Logistic Regression, Multivariate Analysis, ANOVA and MANOVA, Cluster Analysis, Forecasting, Time series Analysis, Factor Analysis
Strong UNIX and Shell Scripting skills
Experience with SAS/BASE, SAS/STAT, SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ETL in Windows and UNIX environments.

TECHNICAL SKILLS:
BI Tools SAS/SQL, SAS/BASE, SAS/MACRO,
RDBMS SQL Server 7.0, MS Access, DB2 v 8.14, Rapid SQL 7.5.5
Operating Systems WIN-XP/NT, UNIX, Sun Solaris
Languages C, SQL, Rapid SQL, PL/SQL, Visual Basic and HTML
Management Tools DOORS, Test Manager
OR Tools STAT GRAPHICS, STAT EASE, JUMPIN, SAS 9.1.3, SAS 8.2
MINITAB
Data Modeling Tools Erwin, MS Visio
Others IBM Rational Clear Quest, Clear Case, MS Office 2003, CATIA, Neural works Professional II and Quality Center.

PROFESSIONAL EXPERIENCE:

Confidential,VA Apr ’09 – Present
Sr. Business Analyst/ Sr. Statistical Analyst

• Foreclosure Timeline Penalty: The objective of the project is to return the Servicers to normal state standards by the end of 2011 by taking smaller steps to ensure the Servicing firms can adjust as Freddie Mac makes adjustments as Servicer’s foreclosure timeline performance is measured on all foreclosures completed in a calendar year.
• Sybase Encryption – The transmittal password between SYBASE Client Accounts and Database Server (ASE) within Freddie Mac Internal Network has to be encrypted.
• Workout Prospector Replacement – This project is to enhance Default Management processing ability by replacing existing Default Asset Management systems (Workout Prospector 2) with a commercial off the shelf (COTS) product.
• Project Enterprise Servicing Application Retirement – PE Servicing is an application where all the destination of the loans has to be serviced. Since all the non-closed loans have been converted to mainframe (MIDAS), the application was being retired.
• Home Affordable Foreclosure Alternatives – HAFA is a part of the Making Home Affordable program and is designed to provide Servicers and borrowers the ability to use a Short Sale or Deed–in–Lieu (DIL) to avoid a foreclosure for HAMP eligible loans. The program attempts to mitigate the impact of foreclosure on borrowers and communities by encouraging the private sale of properties or the voluntary transfer of properties from borrowers to investors.
• Home Affordable Modification Program –HAMP is a Freddie Mac’s program that helps the homeowners to sustain the homeownership. As part of HAMP, a borrower who is behind mortgage payments, in the foreclosure process, or is current on payments and are about to default as a result of a recently experienced hardship, may be able to modify the loan to a lower rate.

• Responsibilities:
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Collaborated with project manager, business owners and architectural teams (for architectural guidance) to identify the standards relevant to the project.
• Met with all developers and project stakeholders to lead a kickoff meeting. Defined and introduced the project, team members\' roles, and key deliverables. Mapped out timelines, milestones, communication processes, question and answer session.
• Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues
• Estimated effort, plan and tracked delivery of the project while adhering to the standards.
• Created data mapping between DB2 and Mainframe databases.
• Developed use cases, workflow, screen mock-ups, and conversion requirements.
• Prepared business process models; used Visio to create use case diagrams.
• Determined user/business/functional requirements.
• Conducted business analysis, project assessment and feasibility determination.
• Conducted statistical and data analysis to analyze business and systems processes.
• Validated technical designs created by IT developers against functional specifications.
• Produced user manual for IDI SAS Model.
• Used ClearCase to keep different versions of the documents and ClearQuest to report bugs or defect.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.
• Participated in SOX review meetings.
• Extensively involved in conducting the System integration testing, GUI Testing Regression Testing,Backend Testing, User Acceptance Testing and End-to-end testing.
• Involved in the Backend Testing of the application by writing & executing SQL queries using Rapid-SQL.
• Assisted in coordinating and administering an issue tracking system that kept track of build status, versions, defects, code changes, and enhancements
• Environment: UNIX, Exceed, DOORS, HTML, Test Manager, Clear Case, Clear Quest, MS Access, Sybase, Visio, Excel and IBM DB2.
• Business Systems Analyst Dec ‘07 – Dec ‘08
• Confidential,Multiclass Enhancements Release 1 and 2

The scope of the project is to create Synthetic Whole Loan Structure (SWLS) for the purpose of Credit Default Swap (CDS) transactions using loans that currently collateralize Freddie Mac issued PC’s. MultiClass CDS built a functionality to perform the monthly loan servicing and disclosure, as well as the ability to administer and disclose the SWLS.
Responsibilities:
Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR).
Created test cases and test scripts.
Ensured all artifacts complied with corporate SDLC Policies and guidelines.
Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.
Responsible for requirements gathering, handing over to development team while documenting them, and delivery of intended requirements while handling the user acceptance testing.
Traced Functional requirements and functional specifications to system requirements using DOORS.
Prepared Business Rule Spreadsheets to the new tables.
Assisted the QA team in reviewing test cases, test plans and tested the final application for usability testing to verify whether all the user requirements were catered to by the application.
Facilitated User Acceptance testing (UAT) for the application as a Business User.

• Environment: UNIX, Windows, DOORS, MS Visio, HTML, and Test Manager.
• SAS Sr. Analyst July ‘07 – Oct ‘08
• Confidential,Loan Level Data Consistency Study
• The scope of the project is to perform a data comparison between the Credit Default Swap – Agency CDS variables proposed for loan level disclosure (also labeled as Investor Disclosure or ID) and the loan level variables that are being sent for Freddie Mac’s disclosure as part of the Affordable Housing Initiative. The focus of the study is to ensure that the data behavior is consistent with expectations across both systems, not to check for data accuracy.

Responsibilities:
Extracted large datasets from raw data files using Import Techniques.
Using PROC IMPORT statement to convert comma separated variables (.CSV) files into SAS data files.
Developed SAS programs using SAS/BASE, SAS/SQL and SAS/MACROS for statistical analysis and data displays.
Produced loan-level data analysis and graphs using Access/Excel/SAS from large data sources.
Used PROC FREQ, PROC TABULATE, PROC MEANS,, PROC SUMMARY, PROC CONTENTS, PROC COMPARE to analyze data.
Generated reports in Excel spreadsheets using SAS/ODS and implementing them in PowerPoint presentation for the client.
Generated large queries and sub queries using SQL.
Proposed new business solutions based upon the conclusions.
Participated in Technical meetings and review sessions
Prepared documentation for valuation of programs.

• Environment: UNIX, Base SAS v9, Exceed, SAS/MACRO, SAS/GRAPH, SAS/STAT, MS Access and Excel, and SQL server.

Confidential,MA
Sr. Business Systems Analyst Jan ‘07- June ‘07
IRI is the world’s leading providers of enterprise market information solutions and services, empowering its clients to grow their business profitably in a complex marketplace. Thus project was to analyze retail market information. The project involved migrating data from SQL Server to application environment, transforming the required tables and flat files into SAS datasets and formation of SAS analysis datasets and reports, performing complex data manipulation using multiple files in SAS data steps and to produce reports employing various SAS procedures.
Responsibilities:
Involved in Requirement Scoping and identifying high priority requirement for implementation.
Facilitated review meetings to ensure that the project was implemented within the specifications of the contract.
Validated technical designs created by IT developers against functional specifications
Prioritized issues and allocated development and QA resources to ensure timely and quality deliverables.
Created SAS datasets using PROC DATASETS, PROC IMPORT, PROC SQL, IMPORT WIZARD, etc.
Integrated SAS datasets into Excel using Direct Data Exchange.
Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS for statistical analysis and data displays
Generated reports to communicate key findings and articulate strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN, PROC GPLOT, and PROC GCHART
Documented purpose and methods used in each SAS program

• Environment: UNIX, XP, Base SAS v9, KEDIT, DOORS, MS Visio, SAS Enterprise Guide, SAS/MACRO, SAS/GRAPH, SAS/STAT, MS Excel, SQL server and Visual Basic.

Confidential,New York, NY

• Sr. Business Systems Analyst Sept 05-Dec 06

The project was running an IBM DB2 platform with a data warehouse that included DB2 client files, agent files and adviser files as well as an IBM CIIS platform from which the data flowed. These data sources fed software applications including those from SAS. In turn, results from SAS flow into enterprise data, customer and agent files and the data warehouse, which primarily included product and financial data. Those data sources feed individual data marts, which provide the necessary customization.
Responsibilities:
Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.
Served as a link between the business user and members of the technical support team.
Implemented documentation and training management for installation of SharePoint.
Working with Project Manager, Business Owners and Architectural teams (for architectural guidance) to identify the standards relevant to the project.
Used PROC SQL to extract data from different relational database management (DB2, and SQL Server) systems using SAS.
Validated data and created a HTML report using different procedures such as PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORT and SAS ODS facility.
Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
Matched merging using merge statement with (in=) option, which was extensively used to find exceptions of loan numbers from different tables.
PROC COMPARE was used to compare data sets and corresponding fields from SAS data sets.
Analyzed data using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA, Cluster Analysis, Forecasting, Time series Analysis, Factor Analysis.

• Environment: UNIX, XP, DOORS, MS Visio, Clear Quest, Base SAS v9, KEDIT, SAS Enterprise Guide, SAS/MACRO, SAS/GRAPH, SAS/STAT, MS Excel, DB2

Confidential,Kansas City,

The project included data management, manipulation, statistical analysis and reporting. The project accomplished successful development and deployment of business/statistical models and communication of those findings to internal customers.
Responsibilities:
Extensively interacted with business users for requirements gathering, analysis and documentation
Used Base SAS to develop SAS extracts for transformation and loading of data
Developed reusable code using SAS MACROS to direct the program to look for the table names in a driver program
Generated SAS/Graphs for top management.
Used SET, UPDATE and MERGE statements for creating, updating and merging various SAS datasets
Used PROC SUMMARY and PROC REPORT to document the results and presented them using MS PowerPoint
Created new or modify SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
Extracted raw data from the warehouse and created SAS data sets that were required for the project analysis using SAS/ACCESS and SAS/CONNECT.

• Environment:SAS 8.0, SAS/BASE, SAS/MACRO, MS-Excel, PL/SQL, and UNIX

EDUCATION:

Masters of Science in Mechanical Engineering
Bachelor of Science in Mechanical Engineering