SUMMARY:

• 7+years of IT experience with expertise in Business Analysis/Data Modeling/Data Analysis in Finance Industry.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Comprehensive knowledge of and solid experience in Derivatives including Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives.
• Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP).
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2000.
• Extensive experience in Sybase Database Servers, developing and maintaining automated software used to monitor the database
• Experienced in conducting requirement analysis, use case design, designing test plans and developed database schemas based on the logical models.
• Knowledge of Mortgage Products, Pricing, Loan origination, Risk compliance and Document Management Systems
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
• Extensive experience in configuring data mapping between different Databases.
• Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
• Extensive experience in conducting Joint Application Development (JAD) sessions.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Participation in the Credit Risk Analysis like Estimation of PD, LGD and EAD
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose
• Worked extensively on user requirements gathering, gap analysis, and development of functional speculations for critical mission accomplishing projects.
• Proficient in Functionality Testing, Black Box Testing, System Testing, Integration Testing, and Regression Testing.
• Excellent experience in Manual Testing and Automation Testing using Mercury Interactive Tools.
• Proficient in Unit Test Plans (UTP), Integrated Test Plans (ITP) Extensive experience in User Acceptance Testing (UAT).
• Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow - Flake schema
• Proficient in programming languages like C, C++, Java and .NET TECHNOLOGIES
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.

TECHNICAL SKILLS:

• ERWIN
• ETL: Ascential DataStage (7.x 6.x 5.x)
• Star-Schema Modeling
• Snowflake Modeling
• FACT and dimension tables
• Erwin 4.0
• Business Objects
• Micro strategy
• Erwin 4.x
• C/C++
• Java SE 1.4
• TURBO PASCAL 7.0
• VB.Net
• HTML
• COBOL
• SQL Server
• SOA
• SAP SD
• MySQL
• Oracle 8i
• Visio
• Sybase ASA (6 - 9).ASP/ASP.net
• PHP
• Microprocessors 8085 & 8086
• Unix
• MVS
• MS Windows/95/98/NT/2000/XP
• MS DOS
• MS Office 2000
• Mercury Test Director
• QuickTestPro
• WinRunner
• Load Runner

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr. Business Analyst

Responsibilities:

• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Involved depth understanding of Credit Risk management for the application
• Conducted User Interviews and Work Shops to gather accurate Business Requirements
• Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs.
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Developed BRD documents for Securitized Inventory (CMO, ABS, MBS, and ABCP). BRD targeted new Basel Compliance requirements.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Collected information and requirements about different Entities and attributes from FDS.
• Completed GAP analysis in detail on all entities in CCL for a source system.
• Prepared questionnaire based on the System Analysis Performed for all entities.
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
• Analyzed system performance and initiated process improvement measures for mainframe and Web-based applications.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
• Configured the Data mapping between Oracle and SQL Server 2005.
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Provided data modeling support for numerous strategic application development projects.
• Prepared Use cases and activity diagrams for a source system using Enterprise Architecture (EA) tool.
• Created the test cases for all the Use Cases using EA tool.
• Created test scripts for all the test cases in PL/SQL.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager, Parallel Extender) Debugger, Autosys 4.1, WinCVS 1.3,Microstrategy, Enterprise Architect 4.5, Sybase, Visio, Toad 8.0, Erwin, HTML, Windows NT 4.0,UNIX, Oracle 8i, PL/SQL, Java, DOS and UNIX Sequential Files, MS Access, CSV Files, XML File

Confidential, Minneapolis, MN

Sr. Business/QA Analyst

Responsibilities:

• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Strong usage of Subject Matter expertise in Fixed Income, Equities, Equity Swaps, Equity Finance, Stocks Trading Cycle, Portfolio Analysis, Asset management, Bonds and Bond Trading Cycle, Bond Pricing, Derivatives (Options-Including Vanilla and Exotic and Futures/Forwards), Credit Derivatives, Interest Derivatives, Alternative investment, Portfolio Management, Sales and Marketing
• Responsible for creating and reviewing business requirement documentation, functional specifications, project schedules and test plans
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
• Enhancing supporting documentation (policies, frameworks, standards, methodologies, and modeling documents) to demonstrate compliance with the Basel II Accord.
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Conducted JAD sessions for communicating with Stakeholders and Project directors
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing using Mercury Test Director
• Enabled Proper selection of the hash table design parameters for faster table look-up.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Generated XML documents using the XML Output Stage.
• Troubleshot the designed jobs using the DataStage Debugger.
• Created jobs sequences.
• Created job schedules to automate the ETL process.
• Enhanced the job properties for performance tuning.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager, Parallel Extender) Debugger, DataStage BASIC language Expressions, SAP SD, SQL Server, Windows NT 4.0, Visio, Sybase, UNIX, Java, Oracle 8i, PL/SQL, Confidential DB2, Dbase3, Erwin, MS Access, XML Files, MVS, IMS.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery using Rational Rose requisite pro - RUP
• Reverse Engineered the existing ODS in to Erwin.
• Conducted meetings for the Data Modeling and Analysis.
• Enforced naming standards.
• Created the logical models and generated the physical models in the databases using Erwin.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL on this data.
• Tested Performance & Accuracy related queries under SQL Server.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Analyzed the given source Dimensions and target Fact table structures to develop Surrogate Key tables referencing required dimensions.
• Created Hash tables referencing the Surrogate Key tables for quicker and more efficient lookup to Dimensions.
• Developed various jobs using ODBC, Hashed file, Aggregator, Sequential file, Transformer stages.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Imported and exported Repositories across DataStage projects.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Trouble-shooted jobs using DataStage Debugger.
• Worked on performance tuning and enhancement of DataStage job transformations.
• Summed key performance indicators using Aggregator stages as an aid to Decision Support Systems.
• Used DataStage Director run time engine to schedule and execute developed jobs and job sequences, and use Log events to monitor job progress and performance.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Environment: Ascential DataStage 6.0(Manager, Director), Visio, Confidential DB2/UDB Universal Database Oracle 8/9i, MS SQL Server 7.0, HTML, XML, UNIX, HTML, Windows NT, Sybase.

Confidential, PA

Business Analyst/Data Analyst

Responsibilities:

• Identified and validated high potential business opportunities for stakeholders.
• Used Rational Unified Process (RUP) for streamlining the team’s development activities.
• Gathered business Requirements, analyze data/workflows. Defined the scope and progressed from problem Statement to well-documented Designs.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created standard test case template according to the company requirements and standards.
• Worked with business analysts to deliver business use cases according to the project requirements.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Generations of Surrogate ID are for the dimensions in the fact table for indexed and faster access of data.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time.)
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Maintained on-going technical assistance and provided help desk support to customer’s mainframe systems software that included problem determination and resolution.
• Implemented local containers to simplify the job design.
• Implemented shared containers to use in multiple jobs, which have same business logic.
• Involved in writing Job Automation process i.e. writing shell scripts using Korn shell, as scheduled daily, weekly, monthly, and sending these jobs to clients email-ids.
• Involved in DBA tasks such as table creation and maintenance, create indexes, optimize queries, and grant privileges.
• Involved in creation of Database Tables, Global Temporary Tables, Cluster Tables, Partition Tables, and Index-by Tables using storage parameters.
• Wrote many Stored procedures, Stored functions, Packages and used in many Forms and Reports.
• Created indexes on tables and Optimizing Stored procedure queries.
• Involved in interaction with the End Users and implemented reviews of the application.

Environment: Data Stage 5.2, Oracle 8i, Windows NT, SQL Server, Visio, MS- excel, CSV files, UNIX, Sybase.

Confidential, Phoenix, AZ

Business Analyst

Responsibilities:

• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Created surrogate key tables to map the required dimensions.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Troubleshot the designed jobs using the DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Created jobs sequences.
• Created job schedules to automate the ETL process.
• Enhanced the job properties for performance tuning.
• Prepared the documentation of Data Acquisition and Interface System Design.

Environment: Ascential DataStage 6.1/5.1,Metastage (Enterprise Metadata directory), (Designer, Director, Manager, Parallel Extender) Debugger, DataStage BASIC language Expressions, Windows NT 4.0,UNIX, Oracle 8i, PL/SQL, Confidential DB2, Dbase3, DOS and UNIX Sequential Files, MS Access, .csv Files, XML Files, Sybase.