Uploaded File
Nishigandha
nishi.88.chaudhari@gmail.com
Dallas, TX 75354
BI/DW Engineer III
11 years experience W2
0
Recommendations
Average rating
77
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 8 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.
  • BI/Reporting tools : Python, 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
  • ETL Tools: Informatica Powercenter 8.6,9.5.1
  • ERP Tools:SAP BDW, SAP Business Objects, BEx Analyzer, SAP netweaver
  • SDLC : Agile, Iterative Key Strengths:
  • Analytical Thinking
  • Requirements Gathering
  • System Analysis
  • Relationship Building
  • Customer Interaction
  • Problem Solving
  • Organization Skills
  • Communication Skills
  • Conflict Resolving
  • Interpersonal Skills
  • Initiator
  • Detail oriented
  • Managerial Skills
  • Business Analysis
  • Data Analysis
  • People Management Interests:
  • IT Consulting
  • Business/Data Analytics
  • Data Warehousing
  • Business Intelligence/Big Data
  • Dash-boarding /Reporting
  • Project Management Contact: (E): nishi.88.chaudhari@gmail.com ; (M): +1(469) 877-8226

Experience
BI/DW Engineer III
Jul 2021 - present
No skills were added
Remove Skill
Senior Data Engineer
May 2020 - Jul 2021
Austin, TX
Data Engineering
Remove Skill
Senior Business Intelligence Developer
May 2019 - May 2020
Austin, TX
BI Developer Business Intelligence
Remove Skill
Business Intelligence Developer/Analyst
Aug 2017 - Apr 2019
Austin, TX
BI Developer Business Intelligence
Remove Skill
Graduate Teaching Assistant - Business Data Warehousing
May 2016 - Aug 2016
Dallas, TX
Worked as a Teaching 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 Data Warehousing
Remove Skill
Informatica Technology Consultant
May 2014 - Jul 2015
An Investment Bank facilitates all the functions of trade settlement on behalf of a third party broker, and sends settlement instructions (Payments,Bookings, General Ledger) to its Custodian. This can be done wth the help of Outbound (MT950,MT940,MT548,MT547,MT545,MT565) and Inbound (MT103,MT101,MT202,MT210,MT304,MT540,MT542,MT541,MT543) Swift Messages that come in Prime Brokerage System of the Bank. Roles
  • 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)
Data Warehousing Informatica
Remove Skill
Informatica Data Integration Specialist
Jan 2014 - Apr 2014
Symantec Corporation has its business data classified into several source systems (on the basis of customer,enterprise,etc).Business provide metrics calculation and data quality rule assertion. Then these rules are automated so that data quality checks can be applied on the live data. And project also includes generating business intelligence Trend Reports, Data Profiles, Scorecards. This is done to identity fundamental data quality issues inherent in the data. Responsibilities •        Standardized, cleaned and profiled data in IDQ and Oracle to validate data quality, ensure accuracy and draw trends •        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
Business Analysis Business Intelligence Data Governance Data Integration Data Integrity Data Profiling ETL IDQ Informatica Oracle Process Improvement SQL OPTIM
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 OPTIM
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
Information Technology & Management (MIS)
University of Texas at Dallas - Naveen Jindal School of Management, 2015 - 2017
Information Technology
Maharashtra Institute of Technology, 2006 - 2010
Bachelor's in Information Technology
Maharashtra Institute of Technology
Certifications
Sun Certified Java Developer
Sun Microsystems, 2009
Certification in Retail Banking
Tata Consultancy Services, 2013
Skills
Informatica
2015
4
BI Developer
2020
3
Business Intelligence
2021
3
OPTIM
2014
3
Project Management
2014
3
SQL
2021
3
Data Analysis
2014
2
Data Warehousing
2016
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 Engineering
2021
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 Objects
0
1
C#
0
1
Crystal Reports
0
1
Customer Service
0
1
Data Cleansing
0
1
Data Governance
2014
1
Data Integration
2014
1
Data Integrity
2014
1
Data Mining
0
1
Data Profiling
2014
1
Data Quality Assurance
0
1
Data Visualization
2016
1
Database Design
0
1
DB2
0
1
ERP
2014
1
Hadoop
0
1
IDQ
2014
1
Java
0
1
JIRA
0
1
Microsoft Excel
0
1
Microsoft Office
0
1
Microsoft PowerPoint
0
1
Microsoft SMS Server
0
1
MS Power BI
0
1
MS Project
0
1
MS SharePoint
0
1
MS Visio
0
1
mSQL
0
1
NCR
0
1
OBIEE
0
1
OBIEE Dashboards
0
1
Oracle
2014
1
PL/SQL
0
1
Process Improvement
2014
1
Public Cloud
0
1
Python
0
1
Requirement Analysis
0
1
Requirements Gathering
0
1
Risk Management
0
1
SAP
0
1
SAP BI
0
1
SAP BW
0
1
SAP HANA
0
1
SAS
0
1
Scrum
2021
1
SDLC
0
1
SQL Server
0
1
SSAS
2021
1
Star Schema
0
1
Swift
0
1
Tableau
0
1
Teradata
2021
1
UNIX
0
1
Xcelsius
0
1
XML
0
1
Awards
JSOM Community Champion - OWLIE Awards 2016, 2016
Technical Excellence Award, 2014
UT Dallas Naveen Jindal School of Management Dean’s Excellence Scholarship, 2015, 2015