| Nidhi is OPEN TO WORK for the role of Business Data Analyst / Systems Analyst/ Product Analyst at Remote, Remote, USA |
| Email: [email protected] |
| Hi, Hope you are doing well. Kindly find the attached resume for your reference. Please let me know. If this profile works for you. Expected rate: $72/hr (Negotiable) Visa: H1B Location- Woburn, MA Relocation-MA, CT, PA, NY, NJ, RI, NH Regards, Pardeep [email protected] Direct No. - (203)552-2554 Nidhi A Woburn, MA [email protected] (203)552-2554 SUMMARY Analyst with 7 plus years of experience working in Finance, Retail and Telecommunication industry with a good understanding of business relationships and requirements. Experience with software development life cycle (SDLC), Agile, Kanban and Scrum Methodology. Expertise in analyzing data, building client relations, querying using SQL, Project Management, collecting business requirements and Reporting In-depth work experience in Software Development Life Cycle (SDLC) using Waterfall and Agile Scrum methodology Thorough experience in eliciting business needs and converting them into system specifications Strong knowledge and experience in conducting system analysis, business and system process design, diagramming data, and process mapping, data extraction, data mapping and data conversion Expertise in Sprint planning using story points and reviewing burndown chart to see the progress of the scrum team Knowledgeable working with ETL process Extract, Transform and Load of data into a data warehouse. Excellent knowledge of Data Warehouse concepts and worked on data mapping and conversion projects Expertise in using SQL to perform analysis by using joins, views, CTEs and stored procedures Experience creating dashboards and reports using Tableau, Power BI and YellowFin BI tools Used Excel for parsing files by using Macros and performing complex calculations for stakeholders using VLOOKUP, HLOOKUP, XLOOKUP Helped QA team in creating Test Strategy, Test Plan, Test Scenarios and Test Cases from Functional Requirement Specifications Hands on experience using ETL tools like Informatica and cloud based database using Snowflake Excellent working knowledge in Project Life Cycle and clear understanding of Project Management Excellent business communication and presentation skills. Adapt at creating, editing, and coordinating extensive communication networks to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts Experience working in DevOps lifecycle with the teams to align development and operations to optimize quality and delivery TECHNICAL SKILLS Programming/Scripting Languages: SQL, PostgreSQL, T-SQL, Unix, Linux, Python (Pandas, NumPy, Matplotlib, Seaborn) Analytics and Visualization: Tableau, Microsoft Excel (Pivot Tables, VLOOKUP, Macros), Yellowfin, MS Power BI, Google Analytics Database: Microsoft SQL Server, MySQL, Microsoft Access, Oracle, Azure Tools/Software: JIRA, Informatica, Snowflake, Visio, MS SQL Server, SSMS, SSIS, QuickBooks, DB Visualizer EXPERIENCE Business Data Analyst, Fidelity Investments, MA June 2022 Present Project 1: Creating ETL pipeline using Informatica to automate the process of fetching incoming files and using SQL to manipulate the data and generate automated reporting Project 2: Using Excel to perform complex calculations to analyze the contributions made by ppts and the company match provided by the client based on ppts tenure and forecast contributions and benefits that the company will have to pay as per the vesting schedule of the ppt Project 3: Drafting Technical Spec Document for the developers to help with the design process, table names, data conversion in order to generate automated reports using Python to analyze various criteria inorder to be eligible for company match in different buckets for ppts who are active in more than one plan Managing a dynamic team of Data Engineers, Business Consultants, and QA Engineers, ensuring precise coordination and timely delivery aligned with project requirements Communicating with business teams and clients to gather information about their data and technological needs and customizing solution through automation resulting in a 25% increase in operational efficiency, leveraging Informatica to automate data gathering and generate scheduled reports across multiple product lines (Retirement, Pension, Stock Plan services). Creating business/technical requirement documents for the analysts and engineers to help them translate business into technical requirements and help them design unique solutions Writing complex queries using SQL to validate the reports generated by the development team and coordinating and guiding them if there are any discrepancies by reviewing the code and mapping in Informatica Performing ETL warehousing processes using SQL, Python, and Unix scripting in Informatica, reducing manual effort by 60% through streamlined workflows and automated processes accessing diverse databases on various platforms. Managing multiple projects each exceeding $10M in scope, ensuring that discovery, development, testing, and deployment are all completed within the allocated hours, thereby preventing budget overruns and ensuring efficient use of resources by providing optimal design Collaborating with cross functional teams and stakeholders to track various phases of the project development lifecycle using Agile and Sprint methodology in JIRA and ensuring adherence to timelines and achieving project milestones as planned Systems Analyst, Fidelity Investments, MA November 2020 June 2022 Project : Processed large incoming pdf/excel financial files using Macros in Excel and created data mapping and conversion document for engineers that listed what elements to convert and how to convert the democratic, loans, deferrals, swift payments and distributions for 401k data by gathering requirements from the clients and ensuring files are processed and data conversion is done accurately by doing self QA before going live Parsed large 401k retirement data files using Macro in Excel and creating pivot tables to calculate market value for reporting purposes resulting in a 20% improvement in processing time. Got involved from the beginning of the life cycle process to the end including PRK calls, creating Data Element Listing (DEL) doc to map fields to tape Specs (80b files), meeting with engineers to resolve any issues, checking the reports and doing Post live review of the reports etc. Created dashboards and reports in Power BI to track project completion during various phases of the projects leading to a 30% increase in project tracking efficiency. Drafted data conversion document by listing elements to map, where to map, and how to convert various data fields of 401k data, improving data mapping accuracy by 25%. Used JIRA to track ongoing projects using Kanban methodology, coordinating with 5+ cross-functional teams to ensure tickets were assigned appropriately and resolved on time, achieving a 95% on-time resolution rate Product Analyst, Financial Sciences Corporation, NJ Aug 2019 June 2020 Project 1: Worked on enhancing the payments application ATOM to send, receive and schedule several international payments across 250+ countries based on their regulations and process transactions from the EDI files for several clients Project 2: Analyzed transactions and banking statements using SQL to generate live reporting and charts using YellowFin BI tool. Perform forecasting for clients to calculate funds required if they scheduled payments across several branches every week for a span of several months Managed SDLC of a project using Waterfall method and tracked progress to successfully in order to deploy latest releases to the clients Used ATOM application for ETL purposes, performed data masking for sensitive data, visualization and transforming raw data received from clients using Db Visualizer software Worked on enhancing payment module by creating specification for payment files (EDI820, EDI824, EDI997) to integrate Fed wire, ACH and FX payment types, which increased cost saving by 20% Created reports and visualizations using Yellowfin BI tool and built interactive dashboards for live reporting using SQL Conducted testing and coordinated with developers to ensure issues are getting resolved and delivered Data Analyst, Mystery Diamonds Inc, NY Aug 2018- Aug 2019 Developed and maintained databases using SQL, mapping it with Express software which reduced manual work by 75% Performed ad-hoc analysis on inventory and build reports using MS Excel to help making key business decisions Analyzed transaction and behavioral data using Excel to identify trends in customer purchase and business revenue for B2B companies Prepared spread sheets of inventory using Excel, invoiced clients, entered payments and received bills using QuickBooks Uploaded inventory and purchased items from Rapnet and performed pricing and inventory analysis Business Analyst, DC InfoTech, Mumbai, India March 2016- March 2017 Created several interactive dashboards using Tableau for quarterly team goals and weekly billings. Identified new markets for internet services using competitive analysis data; increasing target market by 20% and performed market analysis to efficiently achieve objectives, increasing sales by 15% Performed data quality checks on datasets to ensure planned consistency in sensitive data. Leveraged advanced MS Excel skills (Pivot tables, V-lookups, Macros) to provide analytics on routine product campaigns and their return on investment EDUCATION Master of Science, Information Systems, Pace University, NY | GPA 3.68 May 2019 Bachelor of Science, Information Technology, Usha Pravin Gandhi College, Mumbai, India May 2016 This email is generated using CONREP software. A50055 Keywords: quality analyst business intelligence database active directory information technology microsoft Connecticut Massachusetts New Hampshire New Jersey New York Pennsylvania Rhode Island Nidhi is OPEN TO WORK for the role of Business Data Analyst / Systems Analyst/ Product Analyst [email protected] hotlist |
| [email protected] View all |
| Wed Oct 30 23:21:00 UTC 2024 |