Uploaded File
Nishigandha
nishi.88.chaudhari@gmail.com
Dallas, TX 75205
Business Intelligence / Big Data Intern
10 years experience W2
0
Recommendations
Average rating
49
Profile views
Summary

Nishigandha is an MS - Information Technology and Management graduate from Naveen Jindal School of Management at UT-Dallas. She is a Business Intelligence and Analytics professional with over 5 years of substantial experience in data ware housing, data cleansing, data integration and data analysis using BI/ETL tools. Nishigandha is well proficient in Business Intelligence, Data Analytics, Reporting/Visualization and Technology Consulting. She also posses organisational expertise in project life cycle management starting from requirement gathering to implementation. Her prior industrial experience has given her vast exposure to client interaction in Health care domain and various financial service domains like Risk Management, Stocks and Equities.
• ETL Tools: Informatica Powercenter 8.6,9.5.1, Informatica Data Explorer, Informatica Data Quality, Informatica DT, Informatica Analyst
• ERP Tools: SAP BDW, SAP Business Objects, BEx Analyzer, SAP netweaver
• BI/Reporting tools : Base SAS, Xcelsius, Tableau, OBIEE, SAP HANA, WebI, Crystal Reports, Power BI, Advanced Excel Reporting
• Project Management: MS Project Professional, MS Excel, MS Powerpoint, SharePoint, MS Visio, Access, JIRA
• Database Design: Oracle, MS SQL Server, Star Schema, Teradata, DB2, Mondrian, Hadoop, XSD

Experience
Business Intelligence / Big Data Intern
Information Technology
Sep 2016 - present
  • Collected, cleaned and transformed Healthcare data (835/837, financial, remittance and patient accounting data) from disparate sources for big data analytics using SQL queries and stored procedures.
  • Created and maintained systems that leverage big data and traditional BI technologies (SSIS, SSAS, Mondrian).
  • Worked with the product owners and business analysts in analyzing business requirements.
  • Engineered big data platform for scale, performance, and rock-solid reliability.
  • Created and maintained MS SQL and Teradata databases.
  • Worked with engineering and product teams distributed across multiple locations.
  • Effectively documented and communicate results.
  • Implemented Agile/Scrum methodology.
SQL Business Analysis Teradata Scrum Business Intelligence Agile Methodology Big Data SSAS Analytics
Remove Skill
Graduate Teaching Assistant-Data Warehousing
Education
May 2016 - Aug 2016
Dallas, TX
  • Teacher assistant at the Naveen Jindal School of Management and responsible for:
  • Reported students' progress using data visualization and provided timely feedback and guidance.
  • Addressed questions and concerns from students by providing a reliable channel of communication.
  • Graded exams, reviewed projects and assignments, maintained records and proctored exams.
Data Visualization
Remove Skill
Technology Consultant
Banking/Financial
May 2014 - Jul 2015
  • Designed process and create dynamic transformations to import complex files in SWIFT Standards.
  • Captured investment banking data from equity transactions through swift network in data warehouse using Informatica.
  • Analyzed business needs to understand requirements and for preparation of technical specifications.
  • Built and enhanced 20+ swift messages under Prime Brokerage Systems to enable equity, security and stocks transactions between investment banks improving application performance by 8% and enhancing system security.
  • Perform testing of the Code to meet business and technical specifications including performance.
  • Designed 6 automated testing solutions for each message module to reduce testing efforts by 60%.
  • Customized prebuilt transformations in Data Transformation and integrated Powercenter with B2B.
  • Provided consulting to downstream application teams in investigating and resolving 27 production defects.
  • Performd migration of code to higher environments (SIT/UAT/PROD).
UAT PRIME Informatica Data Warehousing Automated Testing
Remove Skill
IT Application Specialist/Data Analyst
Information Technology
Jan 2014 - Apr 2014
  • Established 100+ rules by profiling ERP data and interpreted patterns using Informatica Data Explorer to certify data accuracy.
  • Designed requirement specification documents for 2 new source systems and implemented automated rules that reduced 16 hours of effort per week.
  • Gathered requirements and delivered end to end data quality solutions using IDQ ETL to for data profiling, standardization and cleansing.
  • Defined data quality solutions using IDQ, Created SQL queries on ERP data to generate analyzed dashboard, reports and scorecards for better decision making.
  • Integrated rules into an existing workflow to both test and allow for exception handling.
  • Created SQL queries on large source systems and analyzed the data patterns and trends to build business intelligence reports.
  • Implemented and validated 30 business intelligence reports, 30 profiles and scorecards on Sales Force Data, assisting the Data Governance team in maintaining and cleaning faulty data, improving data integrity.
  • Incorporated process improvement techniques like external and internal reviews to ensure 100% optimization and quality.
  • Collaborated with On-site Business Analysts on designing 2 requirement specification documents for new source systems, implemented automated rules for them that reduced 16 hours of effort per week.
SQL Informatica Business Analysis Process Improvement Data Analysis ETL ERP Business Intelligence Data Governance IDQ Data Integrity Data Profiling
Remove Skill
ETL Developer/Data Analyst
Information Technology
Sep 2011 - Jan 2014
  • Led a team of 4 in Rules Assertion, increasing the scope of project by 50% resulting in client satisfaction and 33% increased productivity usage of resources.
  • Scheduled Project timelines for 4 sprints, negotiated release scope and created estimation plans for resource utilization.
  • Conducted daily stand-up meetings with the team of 12 to track status and address critical tasks and bottlenecks.
  • Mentored 9 employees, providing Knowledge Transition there by reducing training efforts by 108 hrs.
  • Coordinated and cascaded necessary inputs to downstream applications improving migration of data.
  • Coordinated and cascaded necessary inputs to downstream applications improving migration of data
  • Created STM (Source to Target) Mapping document to design ETL Process on large data sets.
  • Executed Complex SQL Queries and stored procedures to explore data internal trends and patterns.
  • Developed 500+ data quality rules using transformations like Source, Source Qualifier, Expression, Sorter, Joiner, Filter, Aggregator, Lookup, Sequence Generator, Router, Update Strategy, Stored Procedure, Normalizer in Informatica powercenter to automate the process of extracting erroneous data and reporting them onto dashboard with accuracy scores.
  • Created tasks like Session, Decision, Email in Workflow manager and integrated them to build a workflow and configured session level properties to increase efficiency of the code.
  • Evaluated and resolved production defects by drilling down to the root cause with help of the session logs and consulted fixes resulting in data accuracy.
  • Made use of Mapping parameters and variables to increase reusability of the code.
  • Incorporated best coding standards and practices to ensure 100% code optimization and code quality.
  • Made use of performance tuning techniques such as Data partitioning, Pushdown optimization, Indirect file type to handle large volume dataload.
  • Handled and led Informatica upgrade from 8.6 to 9.1.5.
SQL Informatica Data Analysis Stored Procedure Informatica Powercenter ETL Performance Tuning ETL Developer Project Management
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Information Technology & Management
University of Texas at Dallas Naveen Jindal School of Management 2017
Bachelor's in Information Technology
Maharashtra Institute of Technology
Skills
Informatica
2015
3
Project Management
2014
3
SQL
2021
3
Data Analysis
2014
2
ETL
2014
2
ETL Developer
2014
2
Informatica Powercenter
2014
2
Performance Tuning
2014
2
Stored Procedure
2014
2
Automated Testing
2015
1
Data Warehousing
2015
1
PRIME
2015
1
UAT
2015
1
Agile Methodology
2021
1
Analysis
0
1
Analytics
2021
1
Big Data
2021
1
Business Analysis
2021
1
Business Intelligence
2021
1
Business Objects
0
1
Crystal Reports
0
1
Data Cleansing
0
1
Data Governance
2014
1
Data Integration
0
1
Data Integrity
2014
1
Data Profiling
2014
1
Data Visualization
2016
1
Database Design
0
1
DB2
0
1
ERP
2014
1
Hadoop
0
1
IDQ
2014
1
JIRA
0
1
Microsoft Excel
0
1
Microsoft PowerPoint
0
1
MS Power BI
0
1
MS Project
0
1
MS SharePoint
0
1
MS Visio
0
1
OBIEE
0
1
Oracle
0
1
Process Improvement
2014
1
Requirements Gathering
0
1
Risk Management
0
1
SAP
0
1
SAP BW
0
1
SAP HANA
0
1
SAS
0
1
Scrum
2021
1
SQL Server
0
1
SSAS
2021
1
Star Schema
0
1
Tableau
0
1
Teradata
2021
1
Xcelsius
0
1