SUMMARY

• Extensive experience of more than 7+ years in IT industry, including business analysis, database management, data analysis, management reporting, pivot tables, macros, linking & embedding, advance filters & formulas, queries, and implementing policies and procedures.
• Organizational and systems professional with proven ability to manage teams and projects, create business processes, and leverage technology to improve productivity and reduce costs.
• Processed, entered data updated and revised data spreadsheets and databases, identified, analyzed relational databases content to ensure efficient and timely production of reports.
• Wrote advance coding in SQL and Access for data extraction and database automation.
• Working expertise in Software Development Life cycle (SDLC), Six Sigma, Project Life cycle, Business Process Modeling (BPM), Software Development Methodologies including Rational Unified Process (RUP), Waterfall, and Agile.
• Actively used Joint Requirement Planning (JRP), Joint Application Development (JAD) and Rapid Application Development (RAD) sessions with Business users, SME’s and Stake holders alike in gathering requirements, collating and analyzing them to identify the real business need.
• Extensive knowledge and working experience in converting business requirements into UML diagrams using Rational Rose and MS Visio and also managing and tracking those requirements.
• Experience in process modeling using Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams.
• 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).
• 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.
• Extensive experience on Excel, Word, PowerPoint, MS Project, MS Visio.
• Developed complex queries in Access to produce, automate and analyze critical data and reports.
• Developed in - house modules in VB and Access for office automation.
• Extensive experience and knowledge in Oracle Forms and Reports, SQL Developer, PL/SQL Developer and tools.
• Provided support to marketing department on CRM proposal software Assist and preparation of new proposal and presentation for clients with 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, and Flatfile, Tables) to create Data Marts, using all the major Data Flow Transformations (Aggregate, character map, condition split, data conversion, derived column, Data Conversion, Lookup, Fuzzy lookup, Merge, Merge Join command)
• Also worked with SSRS reporting concepts using report wizard.
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors, Temp tables and Dynamic SQL queries.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Stored Procedures etc for finding out long running queries.
• Auditing of database for users transaction, login and database action and removing orphan users.
• 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

Application Software: MS Word, MS Excel, MS PowerPoint, MS Outlook Publisher, CrystalReport, Adobe Acrobat, RequistePro, Enterprise Architect

Languages: Visual Basic, HTML, UML

Databases: MS Access, SQL, Oracle, Dataease, SSIS, SSRS, Data Transformation Services (DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS)Operating Systems: Windows 2007, 2003, XP, 2000, NT

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

PROFESSIONAL EXPERIENCE

Confidential, Skokie, IL

Sr. 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.
• Independently manage project scope, risks and manage project meetings as needed to drive projects to completion.
• Also worked with SSRS reporting concepts using report wizard.
• Extensively worked on SSIS for transferring data from Heterogeneous Database (OLE DB, Excel, Flat file Tables) to create Data Marts.
• Responsible for interacting with the developers to explain the proposed changes and understand the system requirements to handle these changes.
• Coordinated with the test team to check the weekly status and report the same to the project manager.
• Formulated comprehensive test plan based on requirements and develop test scenarios based on use cases.
• Performed regression, functional testing, stress testing, performance testing, user interface testing, User Acceptance and system testing.
• Database Administrator, Database Programming.
• 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.
• 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.
• Developed working instructions for Customer Support to reference when troubleshooting issues on their devices.
• Created coding in Access to verify and analyze critical data and reports.
• Created new procedures for process improvement.

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

Confidential, Chicago, IL

Sr. Business/Database Analyst

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 using Rational RequisitePro.
• Assured that all RUP artifacts are in compliance with corporate SDLC policies and guidelines.
• Used EA to create Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, and Sequence Diagrams.
• Created BRD, Vision, scope, wire frames 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.
• Liaison with customer’s business unit managers, stakeholders and functional subject matter experts (SME). Created project charter, scope and schedule.
• Performed change management system during change requirement.
• Developed, enhanced and maintained of all in-house software packages.
• Involved in Database design, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database.
• Also worked on SSRS reporting tools to build reports using Report Wizard.
• Created and Managed schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity
• Performed Data migration 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.
• 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.
• Provided support to marketing department on CRM proposal software Assist and preparation of new proposal and presentation for clients.
• Assisted project manager with scope of work, proposal, man-hours and change order preparation.
• Provided system support to employees including installation and up gradation of software.
• Coordinate with Managers and Engineers to meet the Submittal Schedule.
• Designed an Excel template to calculate costs accurately based on Client’s requirements.
• Execute teamwork on various platforms to achieve a desired result.
• Work on web-based project management application - ProjectTalk.
• Work on CDOT Construction Management website application.
• Developed the following software packages in visual basic for office automation:

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

Confidential, West Des Moines, IA

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.
• Interacted extensively with the developers to make sure that they understood the user requirements and to make sure that the system developed met those requirements.
• Created Process Work Flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Specification Document (FSD).
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Also worked with SSRS reporting concepts using report wizard.
• Involved in trouble shooting and fine-tuning of databases for better performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• 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.
• 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.
• Designed & developed data models and performed forward and reverse engineering using data modeling tools like ERWIN.

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Developed and supported applications in Visual Basic and Developer/2000.
• Project planning, monitoring, developing and implementing of software packages and subsequent maintenance/support for the company and its clients.
• Involved in designing database, developed the menu system for the project by using menu module of forms.
• Used ADO technology to access and manipulate data.
• Created Module File to centralized all the procedures and functions.
• Used Menu Editor to create the menu system of the project.
• Involved in testing and implementing the software.
• Implemented the application and provided support thereafter.

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