Data Management Power Bi
Resume:
Technical
Skills:
SAP, SQL (****, ****, ****), DB2,
Oracle, Teradata-SQL, Progress, SSIS,
SSRS, DataStage, Pentaho, Tableau,
Power BI, Python, Azure SQL,
Dynamics CRM, ControlM, WinSCP,
Edit Pad Lite.
Cloud
Experience
2 years of experience with cloud
technologies, integrating cloud
solutions into data management and
analytics.
Operating
Systems
Microsoft Windows XP, Windows 7,
Windows Vista, Mainframe, Linux,
and UNIX.
Soft Skills Outstanding interpersonal
communication, problem-solving,
documentation, and analytical skills.
Summary
Over 8 years of experience in data analysis, business analysis, data application programming, ETL development, and next-generation databases.
Experience
Vigilanz
BI Analyst 08/2022-08/2023
● Supported operations and conducted data analytics projects for decision-making and solution development.
● Implemented data standards and automation tools for data extraction, synthesis, and validation.
● Monitored data quality, troubleshot, and resolved database issues.
● Utilized Python and SQL for scripting and querying.
● Generated dashboards and reports in Tableau, synthesizing them into actionable recommendations.
● Collaborated with marketing, research, and IT teams to achieve business results.
● Designed visualizations and dashboards with clinical teams for product enhancement.
● Created and maintained process documentation.
Kruti Thakkar
HOFFMAN ESTATES IL 60192
*************@*****.***
Education
● Master of Science in Information Systems -
DePaul University, Chicago, IL (June 2018)
Concentration in Database Administration
● Bachelor of Science in Business Administration - DeVry University, Addison, IL (June 2007)
Concentration in Business Information Systems
Certifications
● SQL Server Business Intelligence Program
(SSIS, SSAS, SSRS)
● Big Data and NoSQL Program
2
Beeline (Client: ComEd)
Business Systems Analyst III / Data Scientist 01/2022-08/2022
● Performed database design and architecture.
● Worked with large data volumes in Master Data Management platforms.
● Developed reports and dashboards in Tableau for corporate decisions.
● Pulled and analyzed AMI meter reading and customer usage data from SQL Server, Excel, and internal databases.
Robert Half (Client: SEIU Local)
Sr. Database Analyst/Developer 06/2021-06/2022
● Led a project involving list management and automated seniority list processes.
● Managed list processes and defined technology implementations.
● Performed ETL to load Seniority Lists into Union Ware Database.
● Troubleshooting and automated processes using SSIS integration. Healthware Systems
Jr SQL Database Developer 02/2021-12/2021
● Wrote and optimized SQL statements.
● Ensured database performance, security, and availability.
● Handled upgrades, backups, recovery, and migration of databases.
● Prepared and executed SQL scripts, including stored procedures, user-defined functions, views, and indexes.
● Created ETL SSIS packages for data migration.
● Designed interactive reports and dashboards in Tableau. Robert Half (Client: Smithfield Foods)
Data Analyst/Developer 01/2018-03/2019
● Built daily fill rate reports in Excel using complex formulas.
● Created SQL SSIS packages for data loading into Smithfield databases.
● Generated and published reports in Tableau and SSRS.
● Executed SQL ETL jobs in SAP and documented data migration project requirements.
● Designed data warehouse and data mart entities.
3
Robert Half (Client: Ispera Government and Network Systems) Sr. Database Analyst 06/2016-08/2016
● Managed SQL and Progress databases.
● Created SSIS packages for data extraction.
● Wrote complex SQL queries for data gathering.
● Performed ETL jobs, data mapping, analysis, validation, and cleansing.
● Created Pivot Tables and Charts in Excel and prepared SSRS status reports and dashboards. Experian
Sr. Database Analyst 07/2013-08/2014
● Monitored deliverable quality and timeliness.
● Generated m-load scripts for Teradata-SQL on UNIX.
● Created BTEQ, Fast export, multiload, and fast load scripts.
● Developed ETL transformations using DataStage.
● Reviewed and updated business and software requirements documents. DISYS (Client: Sears Holdings Corp)
Database Analyst 08/2012-07/2013
● Performed data analysis and mapping to validate data accuracy.
● Reviewed requirements and design documents.
● Created and maintained DB2 database objects.
● Designed and implemented ETL solutions in Pentaho.
● Automated data loading processes and generated SSIS packages.
● Utilized statistical methods for data analysis and developed reports in SSRS and Tableau. Motorola Solutions
Database Developer 08/2007-06/2012
● Performed relational database design and data analysis.
● Organized and created tables and normalized designs.
● Created and modified database objects like tables, views, and stored procedures.
● Maintained SQL Server database integrity and security.
● Created ad hoc reports and dashboards for stakeholders.
Contact this candidate