SUMMARY:

• Over 7+ years of IT experience in the field of Data Analysis, Business analysis, ETL Development, Data Modeling and Project Management
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management
• Experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes 
• Extensive experience in enterprise data modeling and analytics (SSRS, SSAS, SSIS, ETL, MDM, Entity Data Models and data warehousing) incorporating transaction oriented business/service level data processes and metadata collection techniques to enhance informatics strategies
• Experience in Data Transformation, Data Loading and Performance Tuning
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Expertise in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS), and Informatica. 
• Knowledge in Business Intelligence (BI) tools like Business Objects, Tableau, Qlikview.
• Extensive exposure to project development models like Agile, Waterfall, TDD and XP
• Extensive experience in eliciting requirements using Interviews, Requirement workshops, JAD and RAC
• Experience writing analytical SQL queries to perform data analysis, data validation and quality check
• Proven track record in troubleshooting on Technical areas of Database Architecture, Design, and Optimizing ETL jobs and addressing production issues with respect to performance tuning and enhancement
• Experience in Master Data Management, Meta Data, Informatica Business Glossary & Data Quality, Data Governance, Reference Data Management
• Extensive knowledge in Informatica Data Quality, Informatica Data Director, Power Center tools.
• Strong expertise in ETL, Data warehousing, Operations Data Store (ODS) concepts, data marts and OLAP technologies.
• Experience in gathering requirements and making BRD, FSD, and SRS documents
• Exposure to data analysis using MS Excel and SAS

TECHNICAL SKILLS:

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9 

ETL Tools: Microsoft DTS/SSIS and InformaticaIDQ, IDE, IDD

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML, XML, VB.NET 

Database Tools: Microsoft SQL Server 2012/2008R2, Teradata, Oracle 11g/10g/9i, and MS Access 

Visualization Tools: Tableau, Qlikview, SAP Business Objects

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server

Operating Systems: Microsoft Windows 8.1 / 7 / Vista / 7, UNIX, DOS

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr Business Data Analyst

Responsibilities:

• Work with Requirements Analysts and Subject Matter Experts to identify, understand and document business needs for the data flow.
• Work closely with various financial and mortgage business teams in gathering the business requirements.
• Work with the Project Management in the creation of project estimates.
• Analysis of the data identifying source of data and data mappings of HCFG.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Developed different data visualizations using Tableau and presented to the client
• Interact with the SME’s to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Enforce standards to ensure that the data elements and attributes are properly named,
• Work with the business and the ETL developers in the analysis and resolution of data related problem tickets.
• Support development teams creating applications against supported databases.
• Provide 24 x 7 problem management support to the development team.
• Document various Data Quality mapping document, audit and security compliance adherence.
• Perform small enhancements (SOR element additions, data cleansing/data quality).
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR’s residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.

Environment: Mainframes, COBOL, MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, Microsoft SQL Server 2012, SQL Manager, Erwin 8.0, Visio, Informatica, Business Objects XI, Teradata SQL Assistant, ER Studio 9.1.0, Linux

Confidential, McLean

Sr Data Analyst

Responsibilities:

• Worked closely with the Risk Compliance and Strategy teams to develop processes and procedures that monitored Branch Operations and captured exceptions in critical processes such as manual Non-Sufficient Funds/Over Draft (NSF/OD) pay decisions, Funds Availability,  General Ledger Accounting etc
• Designed and rolled out a complex algorithm to validate manual NSF/OD pay decisions made by Branch Associates
• Performed UAT for Retail Banking Data migration from a Dimension Data Warehouse to an Enterprise wide 3NF model Data Warehouse
• Created Complex Teradata scripts to generate ad-hoc reports that supported and monitored Day to Day Branch Operations as well as Sales and Services
• Automated and scheduled recurring reporting processes using UNIX shell scripting and Teradata utilities such as MLOAD, BTEQ and Fast Load
• Created a Branch Operations specific data-mart as part of a Business Objects Universe which replaced the existing system of reporting that was based on exporting data sets from Teradata to Excel spreadsheets
• Migrated three critical reporting systems to Business Objects and Web Intelligence on a Teradata platform
• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Create and maintain data model/architecture standards, including master data management (MDM)
• Set up definitions and process for test phases including Product test, integration test, system test and User Acceptance Test (UAT).
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Created the test cases for all the Use Cases using EA tool.
• Created test scripts for all the test cases in PL/SQL.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP
•  Extremely involved into data clean up and deletion teams in data cleansing phase of the implementation project. 
• Involved in Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams

Environment: RUP, UML, UAT, SDLC, Rational Rose, Ascential DataStage 7.5, Rational Test Manager, XML Spy, Data Stage, Teradata, VBA, Rational Requisite Pro, Rational Clear Case, Clear Quest, Rational Rose, UNIX, Oracle 11g, PL/SQL, DOS and UNIX Sequential Files, Mercury TestDirector Agile, Waterfall, MS Access, CSV Files, XML File,

Confidential, Chicago, IL

Sr Business / Data Analyst

Responsibilities:

• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
• Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits (including Medicare).
• Involved in requirement gathering and testing of consumer web portal for the enrollment of Medicare members.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Involved in creating test cases for EDI 837 Claims (I & P) Transactions.
• Involved in development phase meetings for business analysis and requirements gathering for the Common Claim Layout (CCL).
• Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Transform disjointed data from several different sources including Business Objects, Spreadsheets, Remedy and other management tools.
• Led development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for MDM projects.
• Facilitated joint application development (JAD) sessions, one on one interview and meetings with business users and subject matter experts (SMEs).
• Created flexible forms and reports using SQL and VBA to read, update and append records to the Oracle tables.
• Organized and led JAD/JAR sessions and interviews with the various stakeholders in the organization
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Managed Scope and change throughout the SDLC process of the product.
• Designed tables, forms, queries, and reports using VBA, SQL, Crystal reports, Excel and other tools.
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Create and maintain data model/architecture standards, including master data management (MDM)
• Set up definitions and process for test phases including Product test, integration test, system test and User Acceptance Test (UAT).
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Created the test cases for all the Use Cases using EA tool.
• Created test scripts for all the test cases in PL/SQL.

Environment: RUP, UML, UAT, SDLC, Rational Rose, Ascential DataStage 7.5, SSIS, Rational Test Manager, XML Spy, Data Stage, VBA, Rational Requisite Pro, Rational Clear Case, Clear Quest, Rational Rose, UNIX, Oracle 11g, PL/SQL, DOS and UNIX Sequential Files, Mercury TestDirector Agile, Waterfall, MS Access, CSV Files, XML File

Confidential, Chicago, IL

Sr Business Data Analyst

Responsibilities

• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis. 
• Analyzed the business requirements by dividing them into subject areas and understood the dataflow within the organization 
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable 
• Created and maintained Metadata, including table, column definitions 
• 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. 
• Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement. 
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information 
• Helped the BI, ETL Developers, Project Manager and end users in understanding the Data Model, data flow and the expected output for each model created 
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation 
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository 
• Extensively used Erwin as the main tool for modeling along with Visio 
• Developed the logical data models and physical data models that confine existing condition/potential status data fundamentals and data flows using ER-Studio 
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata. 
• Extensively used SQL for performance tuning. 
• Developed and executed queries in SQL for reporting using SQL Manager 
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models. 
• Assisted developers, ETL, BI team and end users to understand the data model. 

Environment: Teradata, Microsoft SQL Server, SQL Manager, Erwin, Visio, Informatica, Business Objects, Teradata SQL Assistant, ER Studio, Linux

Confidential

Business Analyst

Responsibilities

• Perform mapping, gap analysis and requirement gathering and testing process of the organization to understand business drivers and prioritized requirements
• Proposed full SDLC lifecycle for legacy mindset to new highly dynamic and scalable system.
• Identify and document business rules, dependencies, assumptions, risks, supportability, performance and training needs.
• Experience developing and manages all appropriate project management documents, including project plan, resource estimates, project budget, project schedule, team roster and assignments, issue management, risk management, change control, and periodic status reports.
• Involved in keeping project details up to date in MS Project and making sure that we meet targets as per time allocated in Project Plan.
• Helped analyze test plans, including definition of testing requirements; testing criteria, test scripts, user acceptance conditions and end-to end test requirements.
• Written SQL queries to retrieve data from SQL server 2000 data base
• Prepare Maintenance documents for defects and enhancements for monthly releases.
• Make recommendations for “buy vs. build” decision.
• Understanding of various aspects of Insurance business like documentation of NB (New Business), policy administration, Sales and Marketing, Accounting, Actuarial, Underwriting, Claims, Products Pricing, Quality, Risk Analysis, AML guidelines, KYC Norms, SOX Rules etc.
• Technical Environment: MS-Visio, Word, Excel, Project, Power Point, Traceability Matrix, SQL, SQL Server, Clear Quest, Cognos, Swim Lanes

Confidential

Business Analyst

Responsibilities

• Understanding the process flow of the conceptual design
• Delegation of work to the other team members
• Interpretation of the results
• Implementing the Six Sigma standards
• Co-ordination with design team
• Interacted with the business users and gathered requirements for the business definition.
• Created Functional Requirements Document (FRDs), Functional Specifications Document (FSDs) and Traceability Matrices for application development.
• Involved in the stack sessions, and met with all stake holders to understand, articulate, and document the requirements.
• Worked on projects which used RUP and Waterfall methodologies.
• Facilitated JAD sessions with the management, developers and analysts from all the dependant systems/applications and business users to refine functional requirements and to perform the Impact Analysis.
• Created mock up diagrams using MS VISIO and provided the screenshots replicating the changes to the User Interface (UI) as per the requirements.
• Created spreadsheets using MS EXCEL in data gathering stages for requirements mapping.
• Proposal of new designs to the client
• BOM lines release for Manufacturing
• Integration with the DFSS tools and data retrieval
• Tools to reduce the cycle time of design process and improving efficiency of the design system.
• Log the best practices and Lessons learnt in the Intranet.
• Co-ordination with the client at On-site at all stages
• Applying Six Sigma to reduce the process lead times.

Environment: VB, SQL, MS Excel, RUP, FRD’s, UI, MS VISIO, Waterfall, Minitab, GE DFSS