PROFESSIONAL SUMMARY:

• 7+ years of experience as a Business/Data Analyst 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 Modelling.
• Sound experience in all phases of Software Development Life Cycle - analysis, design, development, testing, implementation and maintenance of applications.
• Strong experience in data analysis, data modelling, conceptual logical modelling and physical database design for Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Proficient in Data Governance, Data Lifecycle, Data Quality Improvement, Master Data Management, and Metadata Management.
• Experience working with Data governance team to evaluate test results for fulfilment of all data requirements
• 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.
• Experience in researching data issues and identifying the root cause in source systems, data warehouse and data marts using various data analysis techniques, data profiling and data mining activities.
• Good experience in 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).
• Excellent understanding for Data Modelling concepts with good knowledge of Star Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modelling.
• Skilled in statistical analysis, quantitative analysis, predictive modelling and forecasting, hypothesis testing, data mining, data cleaning, data quality assessment data integration and validation, data modelling, ETL, data visualization.
• Proficient in MySQL (RDBMS, SQL server, PL SQL), Python (NumPy, Pandas, Scikit-Learn), R programming (ddply, ggplot2, Random Forest), Core Java, Web scrapping, A/B Testing, Google analytics, web analytics, marketing analytics.
• Expertise in transforming business requirements into analytical models, design algorithms, develop reporting solutions that scales across massive volume of structured and unstructured data.
• Expertise in gathering requirement from different users and requirement analysis and documentation in desire format.
• Strong ability to analyse data in legacy applications to determine data migration/integration complexity, to identify data gaps against new requirements or conflicts across multiple legacy applications.
• Extensive knowledge in creating various UML diagram like Use case diagram, Activity Diagram and Sequence Diagram.
• Strong experience in understanding Stored Procedures, Stored Functions, Database Triggers, OLAP, OLTP and specific data extraction using PL/SQL.
• Expertise in to documenting business case, specification and other technical detail for application.
• Good working knowledge of data processing fundamentals including entity relationship diagrams, database models, structured application design and IT infrastructure networking and hardware.
• Experience in facilitating requirement discussion with business owners and technical developers, gathered, documented and managed requirements using Rational Requisite Pro.
• Ability to work independently as well as effectively in team environment with excellent relation making skill with different technical and non-technical users.
• Experience in performing multi-function management and business analysis for various projects.
• Experience in leading data analytics projects from requirement stage, scope analysis, developing models, deployment and support.
• Experienced in analysing Business Requirements Documents (BRD), Functional Requirement Documents (FRD), Test Strategy and Test data preparation, coordinating User Acceptance Testing (UAT), preparing Manuals and Business Users.
• Expertise in Advanced MS-Excel (Gsuite, sheets), PowerPoint, Spreadsheets (Pivot Table & Pivot Charts, Macros, VLOOKUP), Jupyter/iPython Notebook, Version Control Software (GitHub, Bugzilla, Jira).
• Expertise in data visualization, developing Dashboards, Charts, Graphs and reports using Tableau.
• Excellent interpersonal, decision-making, communication and presentation skills and involved in high interaction with variety of audiences (PMs, technical specialists, developers, architects, SMEs).
• Experienced in working with business users as a primary liaison between the business users and the development team.

TECHNICAL SKILLS:

Languages: Python, R, Core Java, SQL, PL/SQL

Python Libraries: NumPy, Pandas, Scikit-Learn

R: ddply, ggplot2, Random Forest

MSOffice Package: Microsoft Office (Windows, Word, Excel, PowerPoint, Visio, Project).

BI Tools: Tableau

IDEs: Jupyter, iPython, Notebook

Version Control: GitHub

Defect Tracking: Bugzilla, Jira

Database: Oracle, MySQL (RDBMS, SQL Server, PL SQL)

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Designed and developed project document templates based on SDLC methodology.
• Worked in an AGILE delivery model involving multiple scrum teams and daily stand-up meetings.
• Performed requirement gathering and analysis by actively soliciting, analysing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
• Worked on Data Analysis, Data Profile, Data Quality, Data Integrity, Design, Development, Implementation and Testing of Business Intelligence applications using ETL and ELT methodology.
• Extracted data from multiple data source, wrote Python (scrapy package, selenium) scripts to scrape data and images from ecommerce websites (web scraping).
• Used Python packages (Pandas, NumPy, Scikit learn) for feature engineering and machine learning models.
• Performed Data Profiling, Data pipelining, and Data Mining, validating and analysing data (Exploratory analysis / Statistical analysis) and generated reports.
• Performed Statistical analysis, Data analysis, anomaly/Outlier detection using R programming.
• Developed Tableau dashboards and reports to show the analysis insights.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL Server.
• Performed in depth data analysis identifying data issues in legacy system and worked with business to develop resolutions to those issues.
• Performed data analysis and ran various SQL queries to critically evaluated test results.
• Used Data Integrator to load data from various sources such as MS Access, MS Excel, CSV files to MS SQL Server.
• Used SQL, Python, Excel, and other tools to create reports and develop practical solutions to challenges for operations, engineering, and sales
• Used Microsoft Visio for Business Process Modelling and Data flow diagrams.
• Transformed existing standalone reporting into a coherent and extensible reporting workflow (ETL).
• Set up foundational dashboards for executives to easily grasp trends and drill down to desired details.
• Achieved up to 90%-line reduction in existing core scripting while improving readability and accuracy.
• Automated the quarterly business review process to improve reliability and allow team leads more time to analyse trends instead of creating reports.
• Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
• Prepared reports and presentations for weekly management meeting to update senior management on project deliverables, progress and timelines.

Environment: Python, R, Pandas, NumPy, Scikit-Learn, SQL, MS SQL Server, MS Word, MS Excel, MS Visio, MS Access, Tableau, Agile

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Performed GAP Analysis and worked closely with the clients and stakeholders to develop a detailed understanding of the new requirements and features
• Organized JAD sessions with various projects stakeholders to elicit requirements, identify and resolve open issues
• Worked alongside with cross functional teams in order to establish comprehensive business and functional requirements and then translating those requirements into software design specifications using various notations of UML for designing and documenting the detailed business and functional requirements
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns as per department requirements
• Attended stakeholders meetings to document changes and implemented procedures to test changes Identified Use Cases from the requirements and created Use Case Diagrams, Activity Diagrams and Sequence Diagrams, based on UML Methodology using Rational Rose and MS Visio
• Worked closely with the QA Team to review and enhance the Test Plan and Test Cases
• Performed data analysis, created data mapping and data interface documents and kept the documents updated with changes in requirements and functional specifications.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality.
• 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 integrity and data dictionary and data analysis.
• Resolved data integrity and quality exercises to reconcile data from Master Data Management (MDM).
• Worked with the ETL data warehouse and BI teams while developing data marts, data models and while reporting and data mapping & validation and wrote SQL queries, prepared dashboards and performed data analysis.
• Utilized SAS procedures and other SAS applications for data updates, data cleansing and reporting.
• Wrote SQL queries to update the database and extract the data for analysis.

Environment: Python, R, Pandas, NumPy, Scikit-Learn, SQL, MS SQL Server, MS Word, MS Excel, Tableau, Agile

Confidential

Business Analyst

Responsibilities:

• Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Conducted GAP analysis so as to analyse the variance between the system capabilities and business requirements.
• Responsible for analysis and functional specifications of “As-Is” and “To-Be” business model to conduct GAP analysis in comparison to the proposed system to enhance the functionality of the application.
• Gathered business requirements through interviews, surveys and observing from account managers and conducted controlled brain-storming sessions with project focus groups and documented them in the Business requirement Document.
• Planned and defined system requirements to Use Cases, Use Case Scenarios and Use Case Narratives using the UML methodologies.
• Created Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.
• Provided inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Worked on customer data related issues and worked on project resolution in collaboration with development teams
• Participated on cross-functional project teams to identify critical requirements from a reporting perspective.
• Acquired data from multiple sources and prepared data for further analysis.
• Involved in discussions with business partners to identify questions for data analysis and experiments.
• Generated Tableau dashboards for sales with forecast and lines.
• Worked on data issues with migration from development to testing.
• Worked with business managers/leaders, reviewed business and system requirements.
• Responsible for managing the process, technology changes and implementing agile methodology.

Environment: Python, R, Pandas, NumPy, Scikit-Learn, SQL, MS SQL Server, MS Visio, Tableau, SDLC, Agile

Confidential

Data Analyst

Responsibilities:

• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Defined the functional requirement documents for each source to target interface.
• Performed Data Profiling and Data Quality.
• Performed data analysis for the existing data warehouse and changed the internal schema for performance.
• Involved in defining the Source To business rules, Target data mappings, data definitions.
• Used SQL queries to pull the data from disparate systems and Data warehouse in different environments.
• Performed periodic data integrity reviews to facilitate and monitor status for data clean-up to ensure consistent and reliable data flows.
• Ensured data files are produced in accordance with approved business logic rules.
• Created statistical models using distributed and standalone models to build various diagnostics, predictive and prescriptive solution.
• Improved processes and accuracy with advanced Excel tools including Pivot Tables, index, and VLOOKUP’s.
• Created additional data validation reports to help ensure accurate data and identify possible data issues.
• Gathered analytical data to develop functional requirements using data modelling and ETL tools.
• Generated on data profiling and data validation for accuracy of the data between the Datawarehouse and source systems.

Environment: Python, SQL Server, ETL, MS Office Suite - Excel (Pivot, VLOOKUP), DB2, R, Visio