SUMMARY

• Solutions - driven Business Data analyst wif overall 7 years of experience in consulting businesses and analysing their business data. Previous experience in working wif different domains like Aviation, Healthcare & pharma.
• Strong experience in Business and Data Analysis, Testing, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
• Knowledge in Hadoop Core Components (HDFS, MapReduce) and Hadoop Ecosystem (Sqoop, Hive, Pig).
• Knowledge in Business Intelligence tools like Tableau, SSRS, Web focus, Business Objects, Cognos and OBIEE.
• Worked and extracted, migrated data from various database sources like Oracle, SQL Server, MYSQL and Teradata.
• Works in an Agile environment and continuously reviews the business needs, refines priorities, outlines milestones and deliverables, and identifies opportunities and risks.
• Ability to write complex SQL. /Hive queries to analyse in Spark environment using Scala by creating data frames to read the Structured and Unstructured data.
• Works wif cross-functional teams and various stakeholders, including analytics, engineering, and reporting.
• Experienced wif ETL process management, Data modelling, Data Wrangling and Data warehouse architecture.
• Expertise in Data Reporting, Ad-hoc Reporting, Graphs, Scales, PivotTables and OLAP reporting.
• Provide complex business analysis using SQL and make recommendations to business team that resolve around business/process issues.
• Build, operate, monitor, and troubleshoot Hadoop infrastructure.
• A relational database to store and manage data
• Able to create Test strategies &Test Plans for applications that are moderate to complex.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) wif expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings.
• Agile Delivery Frameworks, Strong on Agile, Dealing wif Stakeholders, Preparing communication wif stakeholders
• Proven ability to work simultaneously on multiple projects as a team player and as an individual contributor wif a strong adaptability to new technologies.
• Excellent analytical, verbal, and written communication skills.

TECHNICAL SKILLS

RDBMS/DBMS: Oracle, MYSQL, Pl/SQL, SQL Server, Teradata & Big data

Visual Modelling Tools: Rational Rose, MS Visio, SnagIt, Erwin, ER Studio, Miro

Text Editors: Ultra-Edit, Text Pad

ETL Tools: Informatica Power Mart v6.1/5.0 & Power Centre v6.1/5.0

Reporting Tools: Congo’s, Crystal Reports, Oracle OBIEE, SAP BI

Requirement Management Tool: QC, ALM, Jira Conference, Rally, Gemini

Office Tools: MS Excel, MS Access, MS Word, MS Power Point, MS Visio

Operating Systems: Windows NT, UNIX, Linux

Version Control: VSS, SharePoint, SVN

Other Tools: MS Project, FileZilla

Soft Skills: Leadership, teamwork, analytical, attention to detail and problem-solving skills.

PROFESSIONAL EXPERIENCE

Confidential, FL

Business Data Analyst

Responsibilities:

• Interacting wif business users to analyse the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting, and rolling out the deliverables.
• Works wif cross-functional teams and various stakeholders, including analytics, engineering, and reporting.
• Designed the business requirement collection approach based on the project scope, Created Business Analysis using agile methodology.
• Conducted interviews wif key business users to collect requirement and business process information.
• Created project plans, style sheets and templates to analyse and estimate feasibility, cost, time, and general guidelines for project team.
• Facilitated JAD (Joint application development) sessions wif business users and development teams to drive out detailed business requirements.
• Performed extensive data analysis using MS Excel and gap analysis.
• Stored and modified requirements in MS - Word. Documented business requirements wif wireframes and mock-ups to explain in detail the business implications and impacts.
• Managed SharePoint Designer workflow creation.
• Involved in Requirement Elicitation and maintaining requirements from Inception through Construction phase. Analysed and prioritized user and business requirements as system requirements that must be included while developing the software. Conducted Business Analysis and Data Analysis.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Worked wif ETL team to create source to target mappings and performed validation for source to target mappings.
• Agile Delivery Frameworks, Strong on Agile, Dealing wif Stakeholders, Preparing communication wif stakeholders
• Involved in data model reviews wif internal data architect, business analysts, and business users wifin depth explanation of the data model to make sure it is in line wif business requirements.
• Participated in JAD session wif business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Assisted the project managers wif the development of project schedules.
• Involved in documentation during various phases of development life cycle.
• Performed UAT on business requirements, technical specifications, and product knowledge.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture for AWS redshift.

Environment: Windows server 2007, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, Office-2007, MS Excel, Kanban.

Confidential, NJ

Business Data Analyst

Responsibilities:

• Conducted one-on-one sessions wif business users to gather data warehouse requirements.
• Analyse database requirements in detail wif the project stakeholders by conducting Joint Requirements Development sessions and create Technical design documents.
• Developed normalized Logical and Physical database models to design Hadoop, Bigdata/RDBMS database applications.
• Works in an Agile environment and continuously reviews the business needs, refines priorities, outlines milestones and deliverables, and identifies opportunities and risks.
• Analysed DB discrepancies and synchronized the Staging, Development, UAT and Production DB environments wif data models.
• Reviewed and revised data models for soundness of data structures and adherence to client standards.
• Created Master data Customer - Vendor model using ERWIN.
• Worked wif Database Administrators, Hadoop administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated, and documented detailed business rules and Use Cases based on requirements analysis.
• Write software to interact wif HDFS and MapReduce.
• Assess requirements and evaluate existing solutions.
• Build, operate, monitor, and troubleshoot Hadoop infrastructure.
• Hive: Perform analysis of vast data stores and uncover insights. Create scalable and high-performance web services for data tracking
• A relational database to store and manage data
• An extraction, loading, and transformation (ELT) solution for preparing the data for analysis
• Statistical analysis, reporting, and data mining capabilities
• Developed the logical data models and physical data models that capture current state/future state data elements and data flows using ERWIN.
• Developed a Conceptual model using Erwin based on requirements analysis.
• 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.
• Involved in creating Source to Target Mapping document for the OLTP system.
• Reverse Engineered DB2 databases and tan forward engineered them to Teradata using ERWIN.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
• Responsible for migrating the data and data models from SQL server environment to Oracle 10g environment.
• Worked closely wif the ETL SSIS Developers to explain the complex Data Transformation using Logic.
• Extensively worked on the naming standards which incorporated the enterprise data modelling.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Worked closely wif the ETL SSIS Developers to explain the complex Data Transformation using Logic.
• Able to analyses the Test scenarios based on the Use cases.
• Run the Hive SQL queries to validate the Business requirements based on the architectural data flow design.
• Write the SQL and Spark Scala scripts to create the Tables in Hive Data base from the Source systems.
• Apply the performance tuning strategy for improving the query performance on Hive and SQL /Teradata queries.
• Worked in Agile Methodology wif planned Sprints.
• Participated in the PI planning sessions.
• Created the design architecture diagrams for both Realtime streaming and the Batch streaming

Environment: Windows server 2007, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, JIRA, Big Data -Hive /HBase, Aws - EMR, S3, Clusters, Atana, Redshift.

Confidential

Business Data Analyst / Quality Analyst

Responsibilities:

• Liaised wif business and functional owners during project scoping and planning to identify the high-level requirements and product test requirements for the project.
• Documented the functional requirements and created the various other process flow diagrams and artifacts.
• Designed and developed test plans and test cases.
• Performed Risk Analysis of the requirements to identify the project critical success factors and prioritize functional requirement.
• Defined specifications like use case documentation, activity diagram, and business process flow using Microsoft Visio.
• Participated in Joint Application Development (JAD) sessions for requirements gathering.
• Created Required Data Elements (RDE) to define the business rules for source to target mapping.
• Created Requirements Traceability Matrix (RTM) and tracked solution validation to requirements matrix.
• Performed gap analysis of business rules, business and system process flows, user administration, and requirements. Worked wif the functional owners to bridge the gaps.
• Lead calls wif the SMEs and business to finalize complex Business logics and Transformation rules.
• Coordinated and managed the execution of User Acceptance Testing.
• Involved in creation of OALP, Data analysis, Data processing - Extracting data from different sources, Cleansing and transferring data, Distribution of data, Mappings Creation, Debugging, Optimization, slowly changing dimensions, Comparison of mappings, Designing the data mart.
• Involved in the data profiling activities for the column assessment and natural key study.
• Performed complex data analysis in support of ad-hoc, standard, and project related requests.
• Identified and resolved data related issues.
• Ensured Quality standards to meet the Data Quality SLAs.
• Performed Data Mining to analyse the patterns of the data sets.
• Provided support to the development and was a part of testing teams during the lifecycle of the project.
• Perform functional; regression testing; support UAT; Pre-Go Live & Go-Live testing.
• Review and provide feedback on test cases created by team members.
• Responsible for framework modelling, report writing (relational and multidimensional) and creating dashboard components.
• Analysed emerging business trends, production patterns and forecasting demand using BI Reports.
• Involved in updating the existing Universe and Model when the reports require changes.

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), Selenium (Testing), MS Excel, Windows XP, Crystal Reports.