Experience

Audible Magic

• United States
• Information Services
• 1 - 100 Employee

• Business Analyst / Data Analyst

  • Jul 2021 - Present

  Roles and Responsibilities: • Acquired data from primary or secondary data sources to maintain database systems. • Interpreted data and analyzed the results using statistical techniques to provide ongoing reports on the effects of different strategies and observed the trends. • Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment. • Used Informatica Designer to create, load, update mappings using different transformations to move Data Marts in Data Warehouse. • Filtered the data by reviewing reports and performance indicators to correct any code problems and check the efficiency of the data collection processes in place. • Created Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database. • Used Data Integrators to club data from different kinds of sources. • Performed incremental aggregation to load incremental data into aggregate tables. • Performed data profiling on datasets with millions of rows on Teradata environment, validating key gen elements, ensuring correctness of codes and identifiers, and recommending mapping changes. • Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent. • Performed data analysis and data profiling using SQL and Informatica Data Explorer on sources systems including Oracle and Teradata. • Engineered a modern data pipeline to collect, organize, process data, and maintain quality of reference data in Cosmos streams and Azure Data Factory. • Worked extensively in documenting the Source to Target Mapping documents with data transformation logic. • Worked with the Metrics reporting team to enhance and refine the metrics and KPIs reported to senior management and external regulatory agencies. Show less



City of Chicago

• Government Administration
• 700 & Above Employee

• Data Analyst

  • Jan 2020 - Jul 2021

  Roles and Responsibilities: • Involved in requirement gathering, technical design, development, testing and implementation of BI Analytics needs. • Gather Business Requirements from the Subject Matter Experts (SMEs) and document the requirements in the BRD. • Translated high-level business requirements into functional specifications for developers by creating documentation comprising of functional design requirements, test plans and screen level design specifications. • Involved in creating SSIS packages with various transformations like Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion. • Developed T-QL queries for implementing Stored Procedures, Functions, Indexes and Views for different tasks. • Designed standardized DataMart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports. • Performed Risk Analysis of the requirements to identify the project critical success factors and prioritize functional requirement. • Performed T-SQL query optimization and tuning tasks to enhance performance in daily data processes of large external and internal data files and data tables. • Developed KPI reports and dashboards on Power BI for Reliability reviews, monthly experience review meetings, modern support web page and assist app on console. • Conducted data analysis using interactive Excel features. • Implemented table partitioning to maintain performance levels to speed up loading & archiving. • Setup storage and data analysis tools in AWS cloud computing infrastructure. • Writing queries to pull the data required to verify the Metrics calculations from back end. Show less



Times Internet

• India
• Technology, Information and Internet
• 700 & Above Employee

• Senior Business Analyst

  • Nov 2015 - Jul 2019

  Roles and Responsibilities: • Facilitated effective project meetings, including requirements gathering, issue tracking, status reports, and executive communications. • Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests. • 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. • Responsible for making screen designs, Use Cases, ER-diagrams using ERWIN. • Used Informatica Workflow Manager to create sessions, workflows to run the logic embedded in the Mappings. • Involved in GAP analysis of source systems and target systems. • Designed ETL Specification documents to load data from source to target using various transformations according to the business logic. • Developed Data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database. • Possess expertise with relational database concepts, stored procedures, functions, triggers, and scalability analysis. • Created complex formulas & calculations within Tableau to meet the business logic. • Designed and developed weekly, monthly reports related to the marketing and financial departments using T-SQL. • Developed views, functions, procedures, and packages using SQL to transform data between source staging area to target staging area. • Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources. • Created visually impactful dashboards in Excel and Tableau for data reporting with respect to customer, policy information and analyzed to identify the key metrics. Show less



GGK International

• United Arab Emirates
• Advertising Services

• Business/Data Analyst

  • May 2014 - Oct 2015

  Roles and Responsibilities: • Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and ETL loading strategy designing. • Worked closely with the Enterprise Data Warehouse team to understand repository objects that support the business requirement and process. • Analyzed business requirements into system specification utilizing UML & RUP methodology. • Prepared Functional Design Specifications (FDS) employing Use case scenarios, sequence diagrams and class diagrams. • Documented Test Cases and assisted the QA Team with the Test Plan. Documented the Traceability Matrix for tracing the requirements and the Test Cases related to them. • Organized rules andons to flush out requirements, performed Use Case and workflow analysis, outlined business rules, and developed domain object models. • Involved in creation of project Status Reports as well as Requirement Traceability Matrix. • Performed GAP Analysis to generate reports to show Quality of the application compared with Initial Requirement Specification and change Specification. • Recommended and implemented changes to improve overall Business Process Flow. • Used MS Project to track real-time pictures of features and quality, priorities, roadblocks and risks for Requirement Management, Test Management and Defect Management. • Recommended system improvements strategies, based on knowledge derived from Test Results, Test Reports and Requirement Documents. • Involved in identifying the high-level test scenarios and ensured that logical and physical designs fit with the overall application and data architecture. • Worked with ETL developers for data transformation and validation. Show less