SUMMARY

• Over Seven years of professional experience as a Systems 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
• Proven success as a business analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
• Strong experience in RUP Business modeling process.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, Perl 5.0, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
• 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
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Highly effective management and organizational skills with ability to prioritize.
• 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
• Rational Robot
• Performance Studio
• Mercury Win Runner
• Load Runner
• Informatica
• Business objects
• Erwin
• Korn Shell Script
• 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, NY

Sr. Systems Analyst

Responsibilities:

• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• 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.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Worked on data modelling and produced data mapping and data definition documentation
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process’ and revenue streams aimed towards problem solving.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.
• 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.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Develop direct mail and email marketing initiatives using Unica Affinium Campaign and SQL.
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• 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, SWOT analysis, Cognos, Win Runner

Confidential, New York

Data Warehouse Systems Analyst

Responsibilities:

• Addressed all aspects of credit card business.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Gathered requirements from JAD/JAR sections with developers and business clients.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Developed project plans and managed project scope.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• 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.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Provided key input in working with users in defining project and system requirements.
• Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.
• Managed the database using SQL and Unicas Affinium Campaign to execute queries against large data sets in an Oracle environment to generate lead lists for new and recurring marketing campaigns based on the documented business requirements.
• Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Developed business requirement specification documents as well as high-level project plan.
• 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, Las Vegas, NV

Systems Analyst

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Involved in Risk Assessment for each project.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Created functional requirement documents for the impacting projects that were agreed upon to be implemented in the current release.
• 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.
• Designed and developed Project document templates based on SDLC methodology
• Execution of PL/SQL on oracle table in order to view successful transaction of data.
• Generated data cubes for analysis purposes using excel functionality and created several reports in Cognos report studio.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Worked with heterogeneous sources from various channels like Oracle DBMS, SQL Server, flat files, and web logs.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Performed White Box testing by using Expediter tool and updated some of the PROCs, JCLs and SAS programs in the Test region. Submitted batch JCLs in order to create output datasets for verification.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
• 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.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Worked with developers to execute functional testing and user acceptance tests for UNIX, NT based data replication products as well as application replication products.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• 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#. Cognos, Teradata, DOORS, C++, NET, ASP.NET, Business Objects, TestDirector, LoadRunner

Confidential, Princeton, NJ

Business Systems Analyst

Responsibilities:

• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• 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.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• 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
• Helped with Data Mapping between the data mart and the Source Systems.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Managed Scope and change throughout the SDLC process of the product.
• Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
• 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.
• Suggested measures and recommendations to improve the current application performance.

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

Confidential, NC

Systems Analyst

Responsibilities:

• Reviewed and analyzed the business environment and identified process improvements.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• 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.
• Created and scheduled Sessions based on demand, run on time and run only once using Informatica Server Manager.
• 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.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• 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