SUMMARY:

• Over Seven years of extensive experience in the field of Business/Data Analysis, working with the technical staff to implement management and staff's business requirements into the software application in Healthcare and Finance.
• Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross - platform environment.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Expert in developing and managing MS access and SQL server data base for data entry, storage and generation of reports to facilitate management decision making processes.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from Operational Data Store to Enterprise Data Warehouse
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Discovery, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Good understanding and hands on experience with web technologies like HTML, XPATH, XML, JavaScript, AJAX, SOAP, WSDL.
• Sound Knowledge of data architecture concepts, data warehouse and datamarts.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in broad range of technologies including business process tools such as MS Project, MS Visio, Technical Assessment Tools, Data Warehousing and ETL Process.
• 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 with data migration (ETL development), document data manipulation processes and scripts
• Extensively worked with WINTEL, a computer running Windows on an Intel processor, created RAID volumes to improve overall performance.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Developed extensive SQL queries using Query Manager against oracle database for data verification and backend testing .
• Expertise in Procurement and Management Services
• Excellent skills in Project and Performance Management to support Strategic Planning, Goal Setting, Strengthen Accountability, Enhance Decision Making, and Improve Customer Service.
• Experience in implementing Microsoft Office SharePoint 2007.

TECHNICAL SKILLS:

Programming Languages: C#, Python, RData Base MS SQL, MySQL, Power BI

Reporting Tools: Crystal Reports 8.0

Operating Systems: MS-DOS, Windows95/98/NT/2000/XP, Apple McIntosh, Linux

Software: MS Office Suite (Word, Excel, Access, PowerPoint & Outlook), MS Publisher, MS Visio, MS Project, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes

Visualization Tools: Tableau, Weka, D3. Jason

Processes/Technologies: Rational Unified Process (RUP), Waterfall, UML & Microsoft Office SharePoint 2007

Big data: Hadoop, Map Reduce

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Sr. Business Data Analyst

Responsibilities:

• Maintaining the data of the other data (metadata) in-order to give the business a single point reference to the product development process flow.
• Performed forward engineering in Erwin tool to generate schemas and implement them in DB.
• Developed a Conceptual model using Erwin r9.7 based on business requirements.
• Performed reverse engineering SQL DB to get physical data models.
• Designed the Data Marts using Ralph Kimball's dimensional data modelling technique
• Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the source data.
• Involved in documentation of Data Mapping and ETL specifications of data warehouse Designing and developing conceptual models using MYSQL, work bench and Erwin designing tool as per the user requirements and demonstrated to the business how their database design look like.
• Document the complete process flow to describe the program development, logic, testing and implementation, application integration and coding
• For good efficiency and better performance tuned several SQL Queries.
• Developed various Qlikview Data Models by extracting and using the Data from various sources files, DB2 Database, Excel, Flat Files.
• Created DDL scripts for implementing Data Modeling changes.
• Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
• Responsible for creating business scenarios and use cases, Gathering and documenting all business requirements required for development and process in the industry.
• Performing product development process in agile sprint methodology and even involved in project management to deliver the sprints with deadlines.
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to in corporate the new calculations.

Environment: Erwin 9.5, MY SQL, Workbench, MS Excel, MS Visio, Oracle11g, SQL developer, Jira, GitHubcrystal reports 9.

Confidential Park, NC

Business Data Analyst

Responsibilities:

• Worked with the client organization and business users to understand the requirements for all the 3 phases of the ABBI project and providing the requirements to the development team.
• Used the requirement attributes (priority, effort, and risk) as the basis for negotiating the inclusion of the requirement, to manage the scope of the system efficiently. Created scheduled batch jobs using PL/SQL for downloading data into temporary tables to generate the data required for some of the reports.
• Defined the calculations based on the reporting needs and the source data available
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using ERWin. Identify customer Marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW)
• Generated detailed reports for documenting the database structure using TOAD.
• Assisted the project manager in preparing the project schedules, milestone tracking, resource allocation using MS project. Developed data cleansing and data auditing procedures to clean external data and provide audit logs of rejected data.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Followed Agile (XP) Methodology for the release.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Helped business SME's to identify data abnormities, identify root causes and conduct data profiling of critical data elements by using SAS/SQL to code complex logic of data derivation from source systems.
• Performed data analysis, feed analysis on the staging and data warehouse using complex queries and reporting tools.
• Involved in performing data mapping (source to target) for report attributes identified during requirements elicitation.
• 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.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Understand the as Is system and develop the to Be system concept and also prepare the System Process Maps.

Environment: Rational Rose and Requisite Pro, MS Visio, MS Project, UML, XML, Windows XP, NT/2000, HTML, Vignette Content Management Tool, J2EE (JSP1.2), SAS ODS, XML, XSL, XSLT, HTML, Oracle 9i.

Confidential

Business Data Analyst

Responsibilities:

• Used the guidelines and artifacts of the RUP (Rational Unified Process) to release multiple iterations of the deliverable over the span of the project lifecycle, propounded early development and base lining of a robust executable architecture.
• Participated in the identification, definition and documentation of impending work flows for the purpose of migrating to a superior version of party information system.
• Facilitated JAD (Joint Application Development) sessions to identify business rules and requirements and then document them in a format that can be reviewed and understood by both business people and technical people.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Analyzed existing data to identify critical data elements, perform source to target data mapping, elicit data requirements and converted them into BRD and SRS.
• Performed extensive data modeling to different between the OLTP and Data warehouse data model.
• Used SQL*Loaders to load bulk data from various Flat Files used SQL for DDL commands utilized SQL to create Risks signals and Extract large subsets of data.
• Handled the development of Business Requirement Documents (BRD) resulting from JAD sessions.
• Wrote clear, concise detailed System Requirements Specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance. Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Used Rational Clear Case and Clear Quest as Configuration Management and Change control tools.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.

Environment: RUP, UML process, MS-Office suit, Windows NT/2000/Vista, crystal reports, Business objects, dot NET, Delphi (Borland Suit), Mainframe.

Confidential

Data Analyst

Responsibilities:

• Performed requirement gathering and analysis by actively soliciting, analyzing customer requirements and prepared the requirement specification document for the application.
• Involved in gathering reporting requirement from the business users, Involved in building data warehouse application.
• Developed information cycle diagram, data flow diagrams, in MS Viso.
• Interpreted data from primary and secondary sources using statistical techniques.
• Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.
• Used advanced Excel functions and VLOOKUP to generate spreadsheets and pivot tables.