Maryam HemmatShahnavaz
Kansas City,Missouri
Summary
Experienced SSIS and SQL Developer proficient in data design and development on Microsoft SQL Server, with expertise spanning various versions. Skilled in T-SQL, performance tuning, and troubleshooting, specializing in the creation of triggers, tables, stored procedures, functions, and views. Adept at developing SSIS packages and designing data warehouses using SSAS. Demonstrated ability in problem-solving, adaptability, and effective teamwork, with strong communication skills. Experienced in Agile/Scrum methodology, data visualization tools such as Tableau and Power BI, and proficient in scripting languages including Javascript. Bringing a wealth of knowledge in database development, performance improvements, and programming languages such as C, C++, Delphi, VB .NET, C#.NET, Python, and R. Currently pursuing a Master of Science in Information System Business Analytics with an expected completion date of 04/2024.
Overview
16
16
years of professional experience
Work History
SSIS and SQL Developer
IIBAZAR Co.
11.2013 - 02.2023
- Design and implement ETL procedures for intake and transformation of data from both internal and external sources, incorporating data quality and verification steps
- Provide on-going maintenance and support as required to ensure the availability and performance of enterprise data and analytic environments for both external and internal users
- Create standards for data extracts, analysis, reports, change management processes, etc
- Build and maintain the logical, conceptual and physical data models for the data warehouse
- Develop and maintain database stored procedures, userdefined functions, views, triggers and other common database objects
- Write custom and ad-hoc SQL queries and update queries.
- Tested databases and performed bug fixes.
- Designed and created database systems after reviewing end user's requirements.
- Developed database dictionaries and schemas.
- Prepared documentation for database applications
- Established successful protocol for program development and database maintenance.
- Built software according to expressed product parameters and code limitations.
- Supported innovative product engineering and collaborative decision-making throughout development lifecycle.
- Performed root cause analysis to identify system issues.
- Prepared charts and diagrams to illustrate system operation results to staff in other departments.
- Developed technical specifications and plans, documenting details into user manuals for future reference.
- Collaborated with business analysts to understand project requirements, customer expectations and timelines.
Visual C and VB Developer
Information Technology Pishgaman Kahkeshan Co.
03.2011 - 03.2012
- Design, Develop, maintain, and support application software of Core Banking System.
Delphi Developer
Rayan Nazm Co.
03.2009 - 03.2011
- Developing graphical end-user applications and tools
- Ensuring that functionalities and/or modules developed integrate properly into the existing system
- Working as part of a team to meet company goals and objectives.
Delphi Developer
Pars System Consultant Co.
04.2007 - 03.2009
- Developing graphical end-user applications and tools
- Ensuring that functionalities and/or modules developed integrate properly into the existing system
- Working as part of a team to meet company goals and objectives.
Education
Master of Science - Information System Business Analytics
Park University
Kansas City, MO05.2024
B.Sc. in Computer Engineering- Software -
Qazvin Branch of Islamic Azad University
Qazvin, Iran09.2005
Associate Degree of Computer -
Qazvin Branch of Islamic Azad University
Qazvin, Iran02.2003
Skills
- Data Design and Development on Microsoft SQL Server 2017/2012/2008R2/2008/2005/2000, T-SQL, Performance Tuning, Troubleshooting, Develop SSIS Packages, SSRS, SSAS and Data-warehousing Server 2012/2015/2017
- T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, Table Types
- Performance Tuning and Query Optimization
- Developing packages in SSIS
- Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
- Problem-solving
- Adaptability
- Teamwork
- Communication
- Personal Development
- Detail-oriented
- Performance Improvements
- Error Identification and Correction
- Scripting Languages: PHP, Python, Javascript
- Agile/Scrum Methodology
- Data Modeling
- SQL Reporting
- Database Development
- C Programming Language
Timeline
SSIS and SQL Developer
IIBAZAR Co.
11.2013 - 02.2023
Visual C and VB Developer
Information Technology Pishgaman Kahkeshan Co.
03.2011 - 03.2012
Delphi Developer
Rayan Nazm Co.
03.2009 - 03.2011
Delphi Developer
Pars System Consultant Co.
04.2007 - 03.2009
Master of Science - Information System Business Analytics
Park University
B.Sc. in Computer Engineering- Software -
Qazvin Branch of Islamic Azad University
Associate Degree of Computer -
Qazvin Branch of Islamic Azad University