SUMMARY

• Close to 5 years of IT experience as Business Analyst and Data Analyst with strong Microsoft SQL SERVER Development skills in OLTP and OLAP with Production, Development and Testing in Clustered and Stand alone Server Environment.
• Extensive experience in defining system requirements, writing use cases and functional specifications, documenting business requirements and potential solutions, modeling current and future state process flows, and creating system documentation.
• Experience in creating UML (Unified Modeling Language) diagrams such as activity, use case and sequence diagrams.
• Excellent oral and written communication skills with ability to communicate with all levels of management and team members. Possess exemplary technical writing, presentation, listening, time management, JAD session facilitation, interpersonal, organizational, interpretation, problem escalation, leadership, decision making, motivational, issues management, and influencing skills.
• Expert in writing/Creating Generic Stored Procedures, Functions, Database Triggers, tables, indexes, views, sequences using SQL and PL/SQL.
• Extensive experience and knowledge in Oracle Forms and Reports, SQL Developer, PL/SQL Developer and tools.
• Excellent working and conceptual knowledge of Oracle SQL, PL/SQL, Oracle Forms 6i /9i, Oracle Reports 6i / 9i.
• Extensively worked on SSIS for transferring data from Heterogeneous Database (OLE DB, Excel, Flatfile,Tables ) to create Data Marts.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Extensive experience in producing documents like Business Requirements Documents (BRD), Functional Requirement Specifications (FRS), Software Requirement Specifications (SRS), Creating Request for Proposals (RFP), creating Requirements Traceability Matrix (RTM).
• Also worked with SSRS reporting concepts using report wizard.
• Experience in developing and imparting pre and post implementation training, conducting GAP Analysis, User Acceptance Testing (UAT), SWOT Analysis, Cost Benefit Analysis and ROI analysis.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in - depth of T-SQL.
• Actively involved in management of Change Control Requests.
• Excellent Team Player with focus on delivering projects within scope, time and costs while following department standards, methodologies and guidelines.
• Highly motivated, self-starter with excellent communication, presentation and interpersonal skills, can perform well both independently and with a team, always willing to work in challenging and cross-platform environments.

TECHNICAL SKILLS

Databases: MS SQL Server /2000, SQL Server Integration Services 2005 (SSIS), Data Transformation Services (DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), SQL Server 2005 Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Operating System: Windows XP/2003/2000/.

Programming Languages: C, C++, HTML, PL /SQL.

Application: Requisite Pro, Enterprise Architect, Oracle 9i/10g Forms and Reports

Office Tools: PowerPoint, Excel, Word, MS Office

Concepts: Object Oriented Programming (OOPS),Database Management System (DBMS)

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis

Business Analyst

Responsibilities:

• Performed Stakeholder Analysis and conducted interviews, worked with the SME’s (Subject Matter Experts) to identify the key players for project success and participated in Stakeholder Management to communicate effectively with them.
• Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system.
• Provided implementation assessment for Rational RequisitePro, Rational Rose, Unified Modeling Language (UML) and Rational Unified Process (RUP).
• Facilitated Joint Application Development (JAD) Sessions for communicating and managing expectations with Commerce bank whose customers were going to be the final users of the product.
• Created Process Work Flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Specification Document (FSD).
• Created and managed project templates, Use Case Project templates, requirement types and traceability relationships in Rational RequisitePro.
• Created Use Cases using UML and managed the entire functional requirements life cycle using Rational Unified Process and Rational Rose.
• Responsible for creating business flow diagrams and charts for E-commerce using MS Visio.
• Developed Test cases and Use Cases and conducted User Acceptance Testing (UAT), Functional System Testing, Integration testing and resolving the various issues.
• Created and modified SQL scripts for creating various schema objects - tables, views, synonyms, integrity constraints, indexes and views in the database.
• Designing PL/SQL block modules for classified groups of SQL queries
• Involved in the implementation of logical and physical database schema changes.
• Developed Stored Procedures, Views, Triggers and Complex Queries.
• Designed and scripted tables, set table relationships, keys and indexes.
• Maintained data integrity by performing validation checks.
• Database Administrator, Database Programming.
• Administered SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Also worked on SSRS reporting tools to build reports using Report Wizard.
• Rebuilt indexes at regular intervals for better performance
• Involved in trouble shooting and fine-tuning of databases for better performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered databases from backup in disasters
• Maintained database consistency with DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Administered SQL Server configuration settings.
• Performed installations & performance tuning, manage user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• Designed & developed data models and performed forward and reverse engineering using data modeling tools like ERWIN.

Environment: SQL Server 2005 Enterprise Edition, SQL server 2008, T-SQL, PL/SQL, Windows XP, Erwin, SSIS, SSRS

Confidential - Wilmington, DE

Business Analyst

Responsibilities:

• Interacted with business owners to identify business system needs, evaluated solutions or business problems and proposed alternate methods to increase efficiency
• Analyzed and documented information system requirements and the corresponding impact on business processes
• Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS)
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project
• Responsible for maintaining the minutes of all the requirement gathering sessions
• Installed and configured MS SQL Server and Clients.
• Involved in Database design, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Created and Managed schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity
• Performed Data migration (import & export BCP) from Text to SQL Server. Data transfer using BCP and DTS
• Managed Disk space, memory and User connections
• Generated Script files of the databases whenever changes were made to stored procedures or views.
• Excellent knowledge in Import / Export using DTS and BCP utility.
• Performed query tuning and reduced response time.
• Performed query plans and enforced indexing in each and every query
• Designed DTS packages to refresh data on Development and QA/Staging
• Wrote dynamic stored procedures to create Database Roles and grant permission to roles and adding logins to specified roles
• Designed new schema for data partition and creating Partition views for better performance.
• Implemented Performance Tuning, Analysis, tuning and optimization of SQL Server Applications using performance monitor.
• Assisted the SQL Developers in query tuning and optimization.
• Created updatable partitioned views.
• Created Stored Procedures and triggers to perform automated rules and updation of related tables.

Environment: MS SQL server 2000, 2005, Windows XP, Enterprise manager, Query Analyzer, SQL profiler.

Confidential, NJ

Business / Data Analyst (SQL)

Responsibilities:

• Performed GAP Analysis to define gaps between AS-IS and TO-BE processes.
• Acted as a facilitator in JAD sessions to analyze and prioritize competing business needs.
• Determined traceability and dependability between the requirements
• Assured that all RUP artifacts are in compliance with corporate SDLC policies and guidelines.
• Used Rational Rose model the process using the UML to create Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, MS Visio Wireframes and Sequence Diagrams.
• Created BRD, Vision and scope and Functional Spec.
• Develop the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and product knowledge.
• Database Administrator, Database Programming. Rebuilt indexes at regular intervals for better performance.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Involved in trouble shooting and fine-tuning of databases for better performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Maintained database consistency with DBCC at regular intervals.
• Used DTS packages to move logins and jobs from one server to another server.
• Coding which involved development of stored procedures, functions, triggers and packages.
• Administered SQL Server configuration settings.
• Monitored SQL server performance using profiler to find performance and deadlocks.
• Responsible for Maximum performance and uptime in production environment.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Performed daily tasks including backup and restore etc by using SQL Server 2005 tools like SQL.
• Performed installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• Designed & developed data models and performed forward and reverse engineering using data modeling tools like ERWIN.

Environment: Windows XP, MS SQL Server 2000, MS Access, Erwin, Enterprise manager, Query Analyzer.

Confidential

Data Analyst (SQL)

Responsibilities:

• Developed the inbound and outbound file interface with various subsystem
• Menu driven programs for various subcomponents of time card and payroll Management system
• Various MIS reports to track
• Time sheet tracking by cost center / work center / Project, etc
• Expense report tracking by cost center / work center /project, etc
• Vacation management reports and process
• Used SQL programming for stored procedures and queries to interact with SQL server.
• Manage database performance, capacity, replication, backup and security.
• Created SQL scripts for creating various schema objects - tables, views, synonyms, integrity constraints, indexes and views in the database.
• Designed and created databases, tables, views, store procedures and triggers.

Environment: SQL Server 2005 Enterprise Edition, Windows XP.