SUMMARY

• 7+ years of professional experience as a Data Modeler/Data Analyst in Finance domain.
• Extensive experience in analysing and requirements gathering and writing system functional specifications.
• Extensive risk management experience conducting fraud and risk investigations for financial institutions and payment processing organizations
• Good understanding knowledge of Commercial Lending, Commercial Loan, Risk analysis,
• Strong experience in RUP Business modeling process.
• Took part in capacity planning discussions for Teradata hardware.
• Experienced with data mapping using SAS for collecting the data, cleansing it and maintaining it in company’s data warehouse and generating reports.
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Comprehensive knowledge of the Student Loan industry and Commercial Lending.
• Work with semantic extraction team, by providing them by costumed ontologies as inputs for a semantic extraction tool.
• Experience in designing and developing reports using Microsoft Reporting Services (MSRS), Crystal Reports, MS Access, and Data View web part
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data and other SAS application for data updates, data cleansing, and reporting
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store Procedures.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Extensively worked on store procedures for new system changes and troubleshoot the existing store procedures to work more efficiently.
• Proficiency in data analysis and Reverse Engineering for previously developed data models, mappings and reports.
• Designed flow diagrams which explain the process flow of Semantic development.
• Involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance.
• Strong business analysis skills and a sound understanding of the Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP) methodology.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills.

TECHNICAL SKILLS

• Rational Rose Enterprise Suite
• Rational Requisite Pro
• MS Visio
• Test Director
• Test Manager
• Rational Clear Quest
• PVCS Tracker
• MS Office
• MS Project
• MS Publisher
• MSRS
• Rational Robot
• Performance Studio
• Mercury Win Runner
• Load Runner
• Korn Shell Script
• C/C++
• Java 2
• Teradata
• SQL
• PL/SQL
• VB
• Shell Script
• Html
• Crystal Reports
• Micro strategy
• Visual Basic
• Access
• Excel
• MS - SQL Server
• Oracle
• Sybase
• SQL* Plus
• UNIX (Solaris/Linux)
• MS-DOS
• Windows 95/ 98/ 00/NT/XP
• MS FrontPage
• Dream weaver

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Data Modeler

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Complete study of the in-house requirements for the data warehouse.
• Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analysed.
• Developed and provided formal training and presentations/lectures to all DWH users ensuring an understanding of the dimensional model, metadata, and effective usage.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Create and Maintain Teradata Databases, Users, Tables, Views and Macros
• Execution of PL/SQL on oracle table in order to view successful transaction of data.
• Built reports and report models using SSRS to enable end user report builder usage.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Worked with heterogeneous sources from various channels like Oracle DBMS, SQL Server, flat files, and web logs.
• Used SAS for pre-processing data, SQL queries, and data analysis, generating reports, graphics and statistical analysis.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• In this project all the existing Crystal Reports are converted to MSRS reports.
• Designed and developed a Semantic Web tool to utilize the intuitive use of Usability Patterns.
• Created various reports such as ad-hoc reports, drill-down, drill-through, and parameterized reports using Reporting Services (SSRS) for internal teams.
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment
• Used XML for building and parsing of Application Configuration file.
• Facilitated and led JAD sessions aimed at functional requirement walk throughs for all the impacting projects and updated the documents based on recommendations (if any).
• Designed flow diagrams which explain the process flow of Semantic development.
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• 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.
• Reviewed test results and coordinated with testing and development team to correct the issues.
• Developed timelines for project delivery, and managed projects/resources

Environment: Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, SAS, VBScript, C#. MSRS, Teradata, DOORS, C++, NET, ASP.NET, Business Objects, TestDirector, LoadRunner

Confidential

Data Modeler

Responsibilities:

• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
• Designed both the Logical and Physical data model using Erwin by analyzing OLTP and creating OLAP.
• Identify business rules for data migration and Perform data administration through data models and metadata.
• Designed and developed project document templates based on SDLC methodology.
• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
• Gathered and validated requirements, resulting in detailed business rules, functional requirements and process design.
• Involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance
• Also involved in the design and development of wholesale management system
• Build a layer of multi-tier upper ontologies which consists of small, modular, and self contained core ontologies to promote re-use and provide semantic interoperability across different domains.
• Worked in mainframe environment and used SQL to query various reporting databases
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Worked on data modelling and produced data mapping and data definition documentation
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Responsible for physical/logical data modeling; metadata documentation; user documentation; and production specs.
• Conducted evaluation of bank’s data governance structure and identified gaps in structure, data and systems.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• DefinedData Model Requirements to meet Reporting, Analysis & specific Business Objects needs.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.
• Creation of the data mart from existing Operational data Store and other sources.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Created SAS programs that are used for data validation, statistical report generation and program validation and automated the Edit Check programs using Macros.
• Developed and Tested SAS programs needed to import external data from raw data files.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Assisted in development of training materials for new technology and process improvements

Environment: Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .NET, Oracle, Crystal reports, RUP, UML, Visual Basic, SQL, MSRS, DB2, UDB, Cognos, Mainframe, Win Runner

Confidential

Data Analyst/Data Modeler

Responsibilities:

• Designed, developed and tested data mart prototype (SQL 2005), ETL process (SSIS) and OLAP cube (SSAS) for Computer Maintenance Management System (CMMS)
• Created DTS and SSIS Packages to vendors in which records were loaded Daily, also to other data resources such as Excel, Access, flat file, and XML in order to Create and maintain a centralized data warehouse.
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Developed project plans and managed project scope.
• Validated and maintained the enterprise-wide logicaldatamodel forDataStaging Area, DWH and DSS.
• Excellent in Teradata Data warehousing environment.
• Used conceptual data modeling as an analysis bridge between use cases and UML design and implementation models.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis Created source table definitions in the DataStage Repository by studying the data sources.
• Implemented Excel pivot tables for extraction of informative data from these databases using SAS excel plug-ins.
• Create technical design documentation for the data models, data flow control process, metadata management.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Designed and built Datamarts by using Star Schema’s. Created Logical and Physical Data models using ER Studio extensively.
• Incorporated the Informatica Velocity approach for Mapping design, development and Data Governance
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Develop, build and manage Reporting Services (SSRS) reports using both SSAS cube and relational database sources including distribution of reports using subscription services
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Defining thesemanticlayer according the Federal reports
• Preparation of deliverable; business process design and workflow, business requirement documents, detailed syetem functional and non functional specification.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Conducted benchmarking activities to identify best practices.

Environment: Mainframes, COBOL, JCL, Db2, Visual Basic, Oracle, Teradata, UNIX, Rose, MS office, Cognos, MS Word, MS Excel, MS Visio, SAS, LoadRunner, WinRunner

Confidential

Data Modeler/ Data Analyst

Responsibilities:

• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Developed data cleansing and data auditing procedures to clean external data and provide audit logs of rejected data.
• Created dynamic data cleansing modules to identify duplicate student data using rules from a rules table in the database.
• Performed process design, requirements gathering, defined the demand forecasting unit, tuned demand planning statistical models, application flow definition and application setup
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Followed solely RUP methodologies during the course of the project.
• Designed and implemented Teradata physical, access, andsemanticdatabase layers for use in new TeradataDataWarehouse
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Write and execute positive and negative test cases to ensure the data originating from the data warehouse (Oracle dB) is accurate through to the SQL dB in the applications.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Coded the Korn Shell Scripts for pushing and pulling data to and from the Server, Merging the files and placing it in the server etc.
• Using UNIX console commands to check database has been connected the other functionalities.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• As part of a team provided assistance with monthly data extractions and imports utilizing Microsoft Access, SQL and Microsoft Excel.
• Developed small applications with Teradata at the backend.
• Involved in design, development and implementation of a semantic web solution.
• Created source table definitions in the DataStage Repository by studying the data sources.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel
• Created source table definitions in the DataStage Repository by studying the data sources by importing the data from Mainframe.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs.
• Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, Sybase, MS Office, Teradata, Mainframe, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential

Data Analyst

Responsibilities:

• Created and scheduled Sessions based on demand, run on time and run only once using Informatica Server Manager.
• Participated inJoint Application Design/Development (JAD)sessions and involved in discussions with clients/users to determine the dimensions, hierarchies and levels, basic measures, derived measures and key metrics for relational / multidimensional data model for the system, understanding reporting requirements, designing star schema data model.
• Prepared architecture for the DW environmentand developed data modelfor the reporting and analytics solutions based on the existing OLTP system.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Coordinated activities with project manager and various other teams using MS Project.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.
• Involved in generation and execution of SQL queries.

Environment: Microsoft Office Suite, MS Visio, Java, C, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, Mercury TestDirector, Mercury LoadRunner