sudhama edupuganti

*** **** ******** ** **, Apt 71

Vienna, va 22180

abldok@r.postjobfree.com 571-***-****

PROFESSIONAL SUMMARY:

. Over four years of IT experience using the Software Development Life

Cycle (SDLC).

. Experience of Business Analyst supporting Mortgage Backed Securities.

. Successfully completed training for "Specifying Client Requirements".

. Certified SAS Base Programming for SAS 9 with over one year of

experience using SAS as data management and statistical analysis tool.

. Expertise with MS Access and MS Excel.

. 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.

. Interfaced with ISS to identify business requirements specific to a

business product/process and translated 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.

. Knowledge to import several large datasets with varying format, into

SAS using INPUT statements and appropriate file level options.

. 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)

. Experience in creating and maintaining Requirement Traceability Table

/Matrices for the projects

. 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

. Exposure to SOX rules, and Requirement management tools.

. 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,

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.

PROFESSIONAL EXPERIENCE:

Freddie Mac, Mc Lean, VA Apr '09

- Present

Sr. Business Analyst/Sr. Statistical Analyst

Freddie Mac is a stockholder-owned corporation chartered by Congress

in 1970 to keep money flowing to mortgage lenders in support of

homeownership and rental housing. They link homeowners and renters to

the world's capital markets. It is a unique mortgage finance system

that makes homeownership a reality for more of America's families.

Project worked at Freddie are below:

* Project Enterprise Servicing 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 migrated to MIDAS, PES

application was being retired.

* Home Affordable Modification Program - Key role in HAMP is 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.

. 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. Created vision,

scope, and use case documents; business process models, use case

diagrams and activity diagrams

. 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.

. Coordinated work plans between project manager and client using MS

Project.

. Produced user manual for IDI SAS Model.

. Ensured all artifacts complied with corporate SDLC Policies and

guidelines.

. Participated in SOX review meetings.

. Conducted UAT.

. 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, Base SAS v9, Exceed, DOORS, HTML, Test Manager, Clear

Case, Clear Quest, MS Access, Sybase, Visio, Excel and IBM DB2.

* Business Analyst / Systems Analyst

Dec '07 - Oct '08

Credit Default Swap - 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.

. Worked with the Test Lead to create test conditions based on test

cases and functional specifications.

Environment: UNIX, Windows, DOORS, MS Visio, HTML, and Test Manager.

* SAS Sr. Analyst/ Programmer

July '07 - Oct '08

Credit Default Swap - 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.

National Aviation Research Institute, Wichita, KS Jan '06

- Mar '07

Statistical Analyst

Responsibilities:

. Worked on specimens from Boeing, Raytheon, Cessna, Adam Aircraft,

Liberty Aerospace, Sprit, Sirkosky, GKN Aerospace

. Performed checks for damages like cracks, fiber misalignment, de-

lamination, hole quality, alignment in the specimens

. Documented readings using APPLIED STATS software

. Generated reports in Excel spreadsheets using SAS/ODS and implementing

them in PowerPoint presentation for the client.

. Produced loan-level data analysis and graphs using Access/Excel/SAS

from large data sources.

Environment: Base SAS v9, SAS/STAT, APPLIED STATS, MS Access and Excel,

and SQL server.

Intern

Bharat Heavy Electricals Limited, India

Dec '03 - May '04

. Programmed and developed a CNC parametric program for a 9-Frame gas

turbine, low-pressure blades for steam turbine blades and plumber

block.

. Produced loan-level data analysis and graphs using Access/Excel from

data sources.

EDUCATION:

Masters of Science in Mechanical Engineering: GPA:

3.5 / 4

Wichita State University, Wichita, Kansas

Bachelor of Science in Mechanical Engineering; GPA:

3.6 / 4

Jawarhalal Nehru Technological University, India

Contact this candidate