We provide IT Staff Augmentation Services!

Bi Data Analyst/ Business Analyst Resume

NJ

SUMMARY

  • Overall 7 Years of Industry experience as a Senior Data Analyst/ Business Analytics Consultant with solid understanding of Business Requirements Gathering, Business Intelligence, Data warehousing, Data Mapping, Data Validation, Data Integrity, Master Data Management (MDM), Reporting, Data Governance, Data Stewardship and Data Modeling.
  • Experienced in data analysis, data modeling, Conceptual logical modeling and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
  • Extensive experience in conducting Market Research, Feasibility Studies, Data Analysis, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
  • Researched data issues and identify the root cause in source systems, data warehouse and data marts using various data analysis techniques, data profiling and data mining activities.
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Pro model, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
  • Expertise in Business Process Modeling, Business Process Re - design and in designing Process Architecture.
  • Experienced and professional employee with knowledge in regulatory compliance, GMP, Quality Assurance Audits, Document control, Quality Assurance/Quality Control activities in the pharmaceutical
  • Highly proficient in working with users to gather requirements, analyze them and subsequently use the Rational project and design tools to model the requirements.
  • Strong expertise in FDA regulations, GxP suites (GAMP4 & GAMP5, GDP), Computer System (CSV) & Equipment Validation, Document, LIMS and Track wise.
  • Responsible for documenting workflows and resulting business analysis into a Business Requirement Document (BRD) and obtaining sign-off from the client on the specifications for use within the Request for Proposal (RFP).
  • Performed Good Laboratory Practice (GLP) audits on research data books and conducted GLP .
  • Analyzed potential GMP issues and determined whether an event or investigation was warranted.
  • Good experience in Data Modeling with expertise in creating Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
  • Expertise in performingGAP analysis, Requirements Traceability Matrix (RTM), Data mapping and Data Modeling.
  • Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
  • Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
  • Experienced in developing accurate business process requirements for Banks, Insurance, State government projects.
  • Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
  • Good Data Warehousing concepts including Meta data and Data Marts.
  • Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
  • Extensive experience in project management best practices, processes, & methodologies including Rational Unified Process (RUP) and SDLC
  • Excellent communicator focused on customer service.
  • 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.
  • Strong background in support documentation.
  • Analysis and review of Software and Business Requirement Documents.
  • Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
  • Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.
  • Team lead skills encompassing user interviews, coordination with Tech Lead, DBA's, Developers, QA/QC Analysts during the design phase.
  • Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
  • Having application testing experience with working knowledge of automatic testing tools like Mercury Quick test Professional and Load Runner.

TECHNICAL SKILLS

Programming Languages: C, Java, SQL, UNIX Shell scripting, VBScript, JavaScript, jQuery, Windows Script Host (WSH).

ETL Tools: Ab Initio, Data Stage

Databases: Teradata, MySQL, MS Access, SQL Server,DB2,Netezza, Oracle11g, MS SQL Server 2012/2008/2005 , DB2.

Defect Tracking Tools: JIRA, HP Quality Center

Operating systems: Microsoft Windows 98/2000/NT/XP, Linux, UNIX, Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access

Teradata Utilities: BTEQ, Fast Load, Multi-Load, Tpump, Fast-Export, Query man

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop, SQL AssistantPando 8.6, Parasoft SOA 9.1, Selenium Webdriver, Toad, Telnet 3270 plus, SharePoint, Notepad++, SalesForce CRM, TOAD, AQT v8, SQL Server Management Studio, SQL Developer, SQL Assistant, QTP, FTP Pro, SOAP UI.

Test Automation Tools: HP Unified Functional Testing (UFT), QuickTest Professional (QTP). Selenium IDE, Remote Control (RC), WebDriver, Grid. SoapUI.

IT Service Management: BMC Remedy Incident, Change Management.

Software Development Methodologies: Agile, RUP, UML, Agile Modeling, SDLC model, Waterfall Model.

PROFESSIONAL EXPERIENCE

Confidential, NJ

BI Data Analyst/ Business Analyst

Responsibilities:

  • Strong experience in the Data Analysis, Data Profile, Data Quality, Data Integrity, Design, Development, Implementation and Testing of Business Intelligence applications using ETL and ELT methodology.
  • Performed data analysis on source data to be transferred into a MDM structure.
  • Performed data analysis and ran various SQL queries to critically evaluated test results.
  • Advanced ad-hoc and standard report development, including data analysis through the use of Oracle Discover, Business Objects, TOAD, Erwin, Excel, Access, SAS, SPSS, SQL, and Oracle Reports.
  • Led development and documentation of data governance policy and procedures as well as Stewardship inventory.
  • Used Microsoft Visio for Business Process Modeling and Data flow diagrams.
  • Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master Data. Used senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data warehouse processes.
  • Extensive experience with Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools (Qlikview and Tableau).
  • Developed reporting specifications by identifying business needs, prototyping sample reports and mapping data elements from reports to data models.
  • Data integration’s assessment from Bach Records according to ALOCA + guidelines.
  • Experienced in Documentation and validation of Electronic Batch Records (EBRs).
  • Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
  • Document analyses on MBR and EBR.
  • Worked for a large sized pharmaceutical company. The project includes creating a commercial pharma data warehouse platform, which acts as a single source for processing, managing, accessing and reporting all the data related to commercial requirements of the client for all of its products/franchises.
  • Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
  • Experienced in data analysis with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping and Data Modeling.
  • Debugging and Troubleshooting improper data. Validating the data provided by client and ensure Data Integrity.
  • Assisted Business users to understand data flow across different modules of the project.
  • Used Client’s current Test Cases to identify gaps in coverage and supplement the test suite with test cases that will verify and validate data points and integrations.
  • Used SAS for pre-processing data, SQL queries, and data analysis, generating reports, graphics and statistical analysis.
  • Used Microsoft Visio for Business Process Modeling and Data flow diagrams.
  • Used Tableau to track KPIs and prepared statistical reports for each product (each client) outlining marketing cost vs incoming revenue on a weekly basis.
  • Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
  • Created conversion scripts by writing SQL queries and PL/SQL procedures using TOAD or other comparable SQL development tool for Member Management.
  • Responsible for 24x7 coverage for various mainframe based Cobol applications using DB2, VSAM and IMS databases.
  • Managed a project team of internal and external resources to successfully upgrade the Nautilus LIMS for High Throughput Organic Synthesis and Purification Labs yielding new functionality and increased system performance.
  • Handle batch processing file scripts to auto update the database and backup process.
  • Defined and documented the vision and scope of the project for Data warehousing and BI Analytics.
  • Conducted meetings periodically with various stakeholders at various phases of the Manufacturing Process Flow to discuss open issues and resolve them.
  • Created validation transfer plans for four separate assays while collaborating with Marketing, R&D and Manufacturing.
  • UAT database load testing by creating and executing queries.
  • Strong understanding of various PMO techniques used in SDLC such as Rational Unified Process (RUP), Waterfall, Agile and SCRUM with hands on experience in each of them.
  • Prepared presentation slides in MS Project, which was extensively used in different JAD sessions and to track progress.
  • Implemented Rational Unified Process (RUP) and Business Process Mapping (BPM) across the organization.

Environment: Smart LAB, Track & Trace, SAP Field glass, MS office, MS Word, MS Excel, MS Visio, Windows XP Professional, RUP,, UML, PL/SQL, Business Objects, ETL, Oracle, Mainframes, COBOL, Veeva., Oracle, Tableau, XML, SOA, RUP,, UML, Rational Rose, Requisite Pro, Clear Case, Rational Clear Quest, MS Office suite, MS Visio, PL/SQL, Business Objects, ETL, Oracle, Mainframes.

Confidential, Columbia, MD

BI Data Analyst/ Business Analyst

Responsibilities:

  • Analyst the requirements and segregated them intohigh level and low-level Use Cases, activity diagramsusingRational Roseaccording to UML methodology thus defining the Data Process Model
  • Documented project deliverables according to Waterfall and Agile Methodologies
  • Developed & maintained strong communications and relationships with project teams and business partners Collaborated and communicated with all levels of systems to provide quality of service
  • Provided decisions and direction under tight deadlines and during issue resolution situations
  • Participated in system & user acceptance testing, data validation processes to ensure requirements were met.
  • Assessed impacts & benefits to business during problem resolution and requirements gathering
  • Served as a trusted & critical analyst to both business and systems to provide time sensitive information for making company strategic decisions
  • Provided post implementation service to business partner and end users by resolving analytical report errors or data issues.
  • Followed ITSM practices to deliver fixes and solutions to users in post production support
  • Created source to target mappings for ETL Informatica jobs to ensure requirements were met by following data from beginning to end
  • Ran SQL Queries against database and created ad hoc reports in Business Objects Webii for Business users, ad hoc requests, prototyping, & training
  • Was responsible for indexing of the tables in that data warehouse. Used senior level SQL query skills(Oracle and TSQL)in analyzing and validatingSSIS ETL databasedata ware house processes
  • Create and maintain requirements, test cases and defects inMercury Quality Center
  • Develop / Auto deploy content usingAWS (Amazon Web Services), GIT/Bit bucket, Maven, Jenkins
  • Worked onAWS Elastic Beanstalkto deploy, monitor, and scale an application
  • Create newEC2 instance in AWS, allocate volumes and giving Provisional’s usingIAM
  • Analyzing the existing reports, reporting system. Worked on exporting data usingTeradata
  • UtilizedAgile/ SCRUM and PMImethodologies to monitor steer and develop project objectives
  • Implemented transformation component ofData Stageto integrate the data and to implement the data to implement the business logic. Created Test Cases and scenarios forUnit, Regression, Data Integration as well as Back end and System testing
  • Stronginterpersonal and communication skillswithin all levels of the organization and familiarity of regulatory mandates and internal controls
  • Proposed solutions for reporting needs and developed prototypes usingSQL and Business Objectsthat address these needs. Developeddata conversion strategyfor data migration from legacy systems to Technology product modules
  • Familiarity withreporting and Business intelligence,Toad Data tools such asCrystal Reports
  • Develop and maintain sales reporting usingMS Excel queries, SQL in Teradata, and MS Access
  • Extensive experience in testing and implantingExtraction, Transformation and Loadingof data from multiple sources into Data warehouse usingConfidential
  • Performed Reverse Engineering of the legacy application using DDL scripts in ERwin, and developed Logical and Physical data models for Central Model consolidation.
  • Using Agile promoted Adaptive Planning, Evolutionary Development and delivery a time-boxedi terative approach, and encourages rapid and flexible response to change.
  • Implemented business intelligence dashboards and developed detailed and summary reports, line and pie charts, trend analysis reports and sub reports according to business requirements using tableau and SSRS.
  • Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
  • Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
  • Contributing to software process-reengineering efforts aimed at evolving current software development practices to adopt Lean/Agile and Scrum practices.
  • Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.
  • Came up with ETL mapping document for the SQL Server Integration Services (SSIS).
  • Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems.
  • Creating of the XML data model for the Express PA project for the Rules engine and providing the model in .XSD format for the services team.
  • Broad Understanding of Cognos BI tools and ability to translate user requirements into Framework Manager Models and reports.
  • Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
  • Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.

Environment: Microsoft Outlook, MS Access, MS Excel, MS Word, MS Project, MS Visio, TOAD, JAD, Teradata, Test Track, Peer, Mainframe, OLAP, ERWIN, ER Studio, Clear Quest, Clear Case, Java, DB2 Database, Python, PERL, Shell Scripting Linux, Java, UNIX SQL Server, Crystal Reports, SSIS, SSRS, Rational tools like Rational Rose and Requisite pro, Rational Clear Quest, Agile/ Scrum, Cognos BI Business Objects, Test Director

Confidential, Princeton, NJ

Data Analyst/ Business Analyst

Responsibilities:

  • Analyzed business needs of the bank and participated in project feasibility studies to define project scope in terms of business vision, mission and objectives and sketched a Requirements Management Plan (RMP) and Rapid Application Development plan (RAD) to minimize time, costs and risks.
  • Create and maintain user business stories for Agile Projects
  • Worked on GAP ANALYSIS and Root cause analysis
  • Teamed with application architect to document the process and work flow for various business scenarios.
  • Provide recommendation for requirement options.
  • Identified gaps in the reporting system and worked across organizational teams to better understand the functions and improve the accuracy of the data.
  • Improved financial status by analyzing costs, monitoring variances, identifying trends, explaining processes, and techniques recommending action to management.
  • Analyzed actual costs and preparing periodic reports comparing standard costs to actual costs.
  • Worked with operations to improve the onsite inventory count process so leadership would have more visibility and accountability in managing their inventory.
  • Developed the feature lists, functional requirements, non-functional requirements, use cases, and domain models for business domain application features, communicated with Tilling hast consultants and clients as required.
  • Co-ordinate with business partners & functional units like Actuary, Strategic resources etc.
  • Integral part of the team, assigned the task of carrying out the budget planning of the project, thus, obtaining a grasp of the financial concerns of a project.
  • Teamed with staff to document requirements as Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).
  • Detailed requirements documentation as Use Cases and UML diagrams including State Charts, Class/Object diagrams, Activity and Collaboration diagrams.
  • Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
  • Worked as an Interface between the Users and the different teams involved in the application development for the better understanding of the Business and IT Processes.
  • Followed a structured approach to organize Requirements into logical groupings of essential Business Processes, Business Rules, and Information needs that insures any Critical Requirements are not missed
  • Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
  • Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
  • Refined requirement documents iteratively to accommodate changes.
  • Worked with business and technical teams to prototype, test and maintain application in an Oracle Database.
  • Use lessons learnt and best practices from experience.

Environment: Tools: MS Excel, Rational Requisite Pro, Microsoft Visio, Mega tool, Sharepoint. RAD 8.5, RSA 8.5, MS Project 2007, Rational Enterprise Suite (Rose, Clear Case, Clear Quest), RUP, Visual Basic, SQL, Oracle, Unix, Windows XP, Dream Weaver, Adobe Photoshop, Windows Forms, Web Forms, Load Runner, Win Runner, DOORS, Project Management.

Confidential

BI Business Analyst

Responsibilities:

  • Responsible formanaging the process, technology changesand implementing agile methodology
  • Worked closely with the financial reporting team to help with the analysis of financial statements.
  • Developed an inventory dashboard by regions and provided monthly updates for inventory turns including trends of cost.
  • Used Excel Sheets, flat files to generatetableau ad-hoc reports
  • GeneratedTableaudashboards for sales with forecast and reference lines
  • Worked with business managers/leaders; reviewed business and system requirements
  • Utilization ofPower BI functions and Pivot Tablesto further analyze in given complex data
  • Understanding theFunctional Design Specsand preparing the Technical design
  • Involved in designing and developingHigh level and Low-level designs
  • Worked Extensively onTableau tools-Repository Manager, Designer and Server Manager
  • Involved in Extraction, Transformation and Loading(ETL)Process
  • Tuned the mappings to increase itsefficiency and performance
  • DevelopingUnit Test Plansthoroughly covering all the business scenarios
  • Worked on enhancement activities related toGL accounts
  • Involved inunit testing, systems testing, integrated testing and user acceptance testing
  • Configure the applications usingMicrosoft Office Suite (Word, Excel, Outlook, PowerPoint, Project, Visio) to meet a client requirement.

Environment: Oracle, XML, SQL, SAS, R, SPSS, SSRS Metadata Hub, Confidential Data Quality tool and sharepoint.

Confidential

Business Analyst

Responsibilities:

  • Elicited business requirements for the project usinginterviews, document analysis, surveys, site visits, use case scenarios.
  • Documented Functional requirements & business requirements to createAS-IS and TO-BE business process models.
  • ConductedJoint Application Development (JAD) sessionswithSubject Matter Experts (SMEs).
  • Understood theBusiness process flowfor better reporting and analysis.
  • Responsible for preparation ofBusiness Requirement Document (BRD),Functional Requirement Document (FRD)andSystem Requirement Specification (SRS).
  • UsedVisioto create processflow diagramsformanagement and logical mappingof different aspects of the process.
  • DevisedUML diagrams (Use Cases, Activity, Sequence and Class Diagrams)to capture the dynamic behavior of different applications.
  • PreparedRequirement Traceability Matrixand interacted with QA team to ensure quality of software.
  • UsedSQL queriesto extract data for report generation andMinus queriesto narrow down data to only key components.
  • RecordedData Mapping documentsof variousHTMLfields toXMLtags and further onto tables stored in database, after coordinating with the team, business users & other analysts.
  • Worked on development of data warehouse, Data Lake and ETL systems using relational and non-relational tools like SQL, No SQL.
  • Participated in all phases of data mining; data collection, data cleaning, developing models, validation, visualization and performed Gap Analysis.
  • Data Manipulation and Aggregation from different source using Nexus, Toad, Business Objects, PowerBI and SmartView.
  • Implemented Agile Methodology for building an internal application.
  • Maintenance in the testing team for System testing/ Integration/ UAT.
  • Involved in preparation & design of technical documents like Bus Matrix Document, PPDM Model, and LDM & PDM.
  • Understanding the client business problems and analyzing the data by using appropriate Statistical models to generate insights.

Environment: Erwin, SDLC Waterfall, MS project, MS office (Word, Excel, PowerPoint), MS Visio, HTML, CSS, SAS, and SQL

Hire Now