SUMMARY

• Over 8+ years experience in the IT industry as a Senior Business Analyst/Systems Analyst/Data Analyst/Database Developer in Finance, Banking, and Healthcare industries
• Excellent experience in Data Analysis, Data modeling for transactional as well as Data Warehousing (Dimension Modeling), ETL Mapping Document and BI reporting.
• Expert in Data Quality Management techniques like Data Profiling, Data Cleansing, Data Integrity, Reference Data and Data Security, Data mining etc.
• Good experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, Fact and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Experienced in Implementing Normalization/Denormalization techniques for optimum performance in OLTP/OLAP database environments for Business Intelligence’s function.
• Excellent Knowledge in all the end-to-end activities of BA such as requirements eliciting and gathering, 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.
• Proficient in using UML in behavioral, structural and architectural modeling - in creating Use Case/user stories, State, Activity, Class and Sequence diagrams.
• Expert in various SDLC methodologies like Rational Unified Process (RUP), Agile Scrum, V-Model, Rapid Application Development (RAD).
• Ability to understand current business processes and implement efficient business process.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Skilled in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data using Informatica and SSIS.
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data integrity, SQL joins and SQL query writing.
• Having application testing experience with working knowledge of automatic testing tools like Mercury Quick test Professional and Load Runner.
• Excellent communicator focused on customer service.

TECHNICAL SKILLS

Methodologies: RUP, Agile, CMMI, OOAD, UML, Business Modeling, Process Modeling and Data Modeling

Requirements Management Tools: OptOptimal Trace Enterprise, iRise, Rational Requisite Pro

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Access, MS Project, MS Outlook, Lotus Notes, StarTeam

Process/Modeling: MS Visio, Rational Rose, Rational Requisite Pro

ClearCase Tools: ClearQuest

Quality Management: HIPAA, CMMI, CMM, Six Sigma, TQM

Languages: C/C++, Java, SQL, PL/SQL, HTML, XML, PERL Scripts

Database: MS Access, SQL Server 2000/2005/2008/2012 , Oracle 9i & 10g, DB2.

Web Testing: Microsoft Visual Studio Test Edition, Fiddler, Trace Plus Web Detective

Defect Tracking Tools: Rational Clear Quest, Quality center, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Mahwah, NJ

Business Analyst/Data Analyst

Responsibilities:

• Liaised with lead business users (PK Analyst, QC Coordinator/QC Reviewer) and developed system process flows and User Requirements Specifications through surveys and interviews based on the supply chain process of the company.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Finalized and documented the Business Requirement for the application with various key stakeholders.
• Involvement administration process of fund of hedge funds and fund of fund for AIS with a focus on accounting and web reporting.
• Analyzed and created the process flow diagrams for the Fund of Hedge Funds, Accounting and Trade Execution business groups.
• Conducted the Data Analysis and identified the Data quality issues using Data profiling methodologies.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Prepared the Dimension models and validated the models with the business requirements
• Prepared Data Cleansing methodologies by relating them to DQ issues.
• Prepared the ETL mapping specifications to load the data in to staging area, and from staging area to the Data marts.
• Provided data modeling support for numerous strategic application development project
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications.
• Identified IS strategy to be followed and related IS strategy to Business strategy and communicated the same through written and oral communication to the top management and Systems Analyst and Designer.
• Analyze the system data mapping requirements of the HIPAA 834-standard layout to Confidential proprietary layout. Assessed risks, costs and potential benefits of alternative business process.
• Followed the UML based methods using Microsoft Visio to create Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams.
• Developed strategies with Quality Assurance group to implement Test Cases in Quality Center for stress testing and UAT (User Acceptance Testing).
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro and managed the concurrence of the parties involved with respect to the evaluation criterion.
• Created Informatics maps to load data from Sequential files, Flat Files and MS Access.
• Used informatics to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Prepared Data Volume estimates.

Environment: Rational Suite Tools, SDLC (RUP), MS Word, MS-Visio, MS-Project, Mercury Win runner, Mercury Load Runner, informatics 8.6 Windows NT 4.0,iRise, SQL Server 2008/2012, PL/SQL, DOS and UNIX Sequential Files, MS Access

Confidential, Jersey City, NJ

Business Analyst( Data Analysis, ETL, BI Reporting)

Responsibilities:

• Requirement gathering and Business Impact Analysis.
• Written the BRD diagram to ensure high level design is accepted by client.
• Created the dimension models and the created the physical data models.
• Written the specifications for the Data mapping and complex ETL transformation specs.
• End-to-end ETL development of the new source providers to integrate the data in the existing Data Warehouse using SSIS
• Involved in end user training and support for new source providers.
• Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Designing ETL flow, batch job creation, responsible for identifying and monitoring data warehouse usage across several applications.
• Automated Batch Jobs to Load the Consolidated Data warehouse at scheduled times to run on a daily, weekly and monthly basis in Job Scheduling Console.
• Designed and developed informatics Mappings to load data from Source systems.
• Create and update Business Requirement Documents and Functional Requirement Documents.
• Acted as a liaison between the business units and the technology teams. Lead JAD sessions and act as the lead facilitator for various projects from start to finish through the SDLC.
• Participate in Code Reviews, System Testing and UAT followed by production verification, post production testing and support.
• Conduct BRD walk thru session with the entire finance team, business, testers and developers after the completion of the BRD. Organize meetings with the SMEs of the dependent systems. Conduct weekly issue meetings with customers.
• Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams.
• Developed test cases and test scripts for system and UAT testing.
• Extensively used Quality Center for Test Management needs.

Environment: SQL Server 2008/2008R, T-SQL, XML, XSD, Perl Script, Start Team, Maestro Microsoft SSIS

Confidential, Atlanta, GA

Business Analyst/Systems Analyst

Responsibilities:

• Identified the Data Source and defining them to build the Data Source Views for easy access.
• Reverse engineered the Databases and analyzed the source data
• Extensively used DOORS to document, review and analyze the requirements.
• Studied the Gap analysis for the proposed reports with the existing Data, for the feasibility of reports.
• Written specs for the additional data captures
• Designed the dimension models for the data marts and validated against the reports.
• Written the complex data mapping transformations for the cubes
• Served as a liaison between business team and the project team by assisting the Business in identifying, understanding, and documenting their business needs.
• Gathered business requirements for the concerned enhancements in the administration process by conducting meetings, interviews, and JAD sessions with stakeholders.
• Extensively used agile methodology’s best practices during the SDLC.
• Elicited requirements from users through user stories incorporated these user stories as requirements in the Sprint Backlog and further expanded them into tasks for each sprint.
• Provided the detailed inputs to the Scrum Master about the tasks completed and assisted in the creation of the Sprint Burn Down Chart
• Moderated everyday scrum meetings along with the other senior business analysts to improve the efficiency and productivity of each sprint
• Developed user test cases and validates test results during user acceptance testing (UAT).
• Used various SQL commands like create, delete, update, left joins, right joins and full joins to update the database and retrieve data for analysis.
• Provide ad-hoc data to internal and external requests from the business users.

Environment: DB2, Microsoft Visio 2007/2010, Rational RequisitePro, Microsoft Excel (pivot tables,v lookup), Microsoft word, Microsoft Access, Micro strategy, Power Point, SharePoint, Agile Methodology

Confidential, Hershey, PA

Business Analyst

Responsibilities:

• Analysis for making system compliant with HIPAA. Involved in making the Medicare patient profiles being compliant with the HIPAA regulations. Management of patient profile transfer (PPT) reports created by data team by verifying the associated data.
• Assisted in walkthroughs/sessions (JRDs/JADs) with business Owner /stakeholders/ SMEs as well as design/development teams to gather system requirements. Worked with business area SMEs/analysts to develop and finalize test plans/scripts/use cases.
• Analysis of key business requirements and assisted in the development of Business Requirement (BRS), Functional Requirement (FRS), and System Requirement Specification (SRS).
• Experience with Epic Resolute Professional and Hospital Billing system experience.
• Experience in a highly regulated environment (healthcare, financial, SOX, HIPPA etc)
• Hands on experience with Mercury Quality Center.
• Member of the patient information reporting project team for analyzing and designing responsible for analyzing and designing a system that would improve reporting of patient data especially with relation to Medicare population.

Environment: EDI ANSI X12/HIPAA, UML, MS Access, MS Office, MS Visio, SQL Server 2005 and Rational Ste.

Confidential, Manhattan, NY

MS SQL Server Developer

Responsibilities:

• Provided database development support to development team.
• Produced ad-hoc queries and developed reports to support business needs.
• Performed unit testing of developed solutions.
• Reviewed existing stored procedures, supported application developers by providing expertise on tuning and performance of their SQL queries.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Involved in Job scheduling and alerts on recurring basis minimize the impact to online users.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• In-Depth working knowledge of ODBC.
• Created many complex Stored Procedures / Functions and used them in Crystal Reports directly to generate reports on the fly and hosted on the web for the users.
• Worked with end users to define, implement, and maintain their reporting requirements.

Environment: SQL Server 7, SQL Server 2005, T-SQL, Win NT v4, Win 2000, Win 2003, Crystal Report 8.5

Confidential

MS SQL Server Developer

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management, implementation of version control with Visual Source Safe.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Supported front-end development team to resolve SQL related issues in Active Server Pages during server migration.

Environment: SQL Server 2000, T-SQL, ER-Win v4.0, Windows 2000, Crystal Report.