Sql Server Ms

Shehnaz Sheikh

Email: *******.******.***@*****.***

https://www.linkedin.com/in/shehnaz-s-3268921b/

SUMMARY:

-Almost 11+ years of robust experience as an MS SQL Server Developer, ETL Developer, and BI Developer.

-Extensive expertise includes designing, developing, implementing, and administering database systems using MS SQL Server versions 2019/2017/2016/2014/2012.

-Proficient in handling both OLTP and Data Warehousing Systems applications with skills in SSRS, SSIS, and basic SSAS.

-Developed T-SQL (DDL, DML) statements, ensuring data integrity through the implementation of constraints, rules, and addressing performance tuning, query optimization, and validation issues.

-Designed an efficient ETL architecture, leveraging SSIS, to facilitate the seamless transfer of data from OLTP to OLAP environments.

-Migrate data from Oracle, Teradata and Oracle to Microsoft SQL Server by using SSIS and DTS Utility.

-Developed SSIS packages to efficiently process and integrate data from various file formats, including flat files, XML, JSON and knowledge for XSLT transformation to XML.

-Demonstrated expertise in SSIS script transformations, proficiently scheduling and managing complex SSIS Packages for manual data transfers from multiple sources to SQL Server.

-Demonstrates a strong comprehension of Data Warehousing methodologies and concepts, including star schemas, snowflake schemas for dimensional modeling, along with proficiency in various reporting tools.

-Utilizes SSRS and Microsoft Access for customized and ad-hoc reporting, with foundational knowledge and practical experience in Tableau and Power BI.

-Possess a strong grasp of OLAP, Data Warehousing, and Operations Data Store (ODS) concepts, complemented by expertise in ETL technologies.

-Experienced in deploying SSIS packages on Cloud using PaaS, with hands-on experience in running and managing these packages using Autosys.

-Knowledgeable in various Azure Cloud services, including Azure Data Factory, Pipeline for ETL development.

-Experienced in directly engaging with application partners to resolve and troubleshoot issues related to Verint applications.

-Skilled in troubleshooting Verint speech analytic production issues, including transcription and analysis.

-Strong team player with excellent problem-solving skills, adaptable to new roles, and a self-starter with effective communication skills.

-Analyzes system performance, ensuring the achievement of performance goals and meeting availability requirements.

ACADEMIC BACKGROUND:

- Master of Science in Technology Management University of Bridgeport, CT USA 2009

- Bachelor of Engineering in Information Technology Sardar Patel University, A.D.I.T, V.V.Nagar Anand, GJ INDIA 2007

- Diploma in Computer Engineering Technical Examination Board, B.B.I.T, Gandhinagar, GJ INDIA 2004

TECHNICAL SKILLS:

Databases: MS SQL Server (2000/2005/2008/2012/2014/2016/2017/2019) and basic knowledge AZURE SQL Database

BI Tools: SSIS (2000/2005/2008/2012/2014/2016), SSRS (2000/2005/2008/2012/2014), Basic Tableau and Power Bi

Other Tools: Erwin, Oracle, Teradata, MS Access, T-SQL, Embarcadero, Microsoft Office, HP Quality Center, Visual Studio, PowerShell, Verint

Version Control: Team Foundation Server, Git lab, Bit Bucket, Visual SourceSafe

Cloud Knowledge: Azure Cloud, Azure Data Factory, dbt cloud(dbt core) transformation tool,Snowflake Data Warehouse

EXPERIENCE:

SQL/BI/ETL/Database Developer Global Data Management Inc Woodbridge NJ May 2016 - Present

Sr.SQL/BI Developer Client: Verizon, Piscataway NJ Oct 2019 - Present

-Work with the HR application team for backend code where users request to fix issues or add some enhancement development. Testing and troubleshooting code.

-Work on using SSIS (SQL Server Integration Services) for data extraction, transformation and loading (ETL) across different databases like Oracle, Teradata, JSON and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.

-Creating SQL XML file generating code for agent synchronization profile in Verint involves using T-SQL to generate the necessary XML structure based on the agent data.

-Optimized schema, design, develop, performance, and capacity planning of various data transformation processes related to the reports.

-Manage and monitor the system utilization by using the query optimizer and checking the execution plan.

-Directly involve an application partner person to troubleshoot and test code before deployment to production.

-Developed basic PowerShell scripts and managed services, including starting and stopping operations on over 100 servers.

-Design, development, database creation and maintenance, performance monitoring and tuning, and troubleshooting where it is needed to improve.

Skills Used: MS SQL Integration Services 2008/2012/2016, MS SQL Server 2012/2016/2017/2019, Window 10, MS Excel 2013, Visual Studio 2010/2015/2017/2019, Linux, Teradata Client 15, Oracle, Ultra Edit, Jira tool, Verint WFO, PowerShell.

Database Analyst Client: Wells Fargo, North Brunswick, NJ May 2016 – Oct 2019

-Involved for one-time data migration from Sybase to SQL Server using SSMA and performed data validation after migrating data into the target system.

-Involved in deploying Packages in Azure cloud and responsible for daily Production support failing ETL and Autosys Job.

-Create Technical and Functional Documents including detailed description and screenshots showing functioning of the package and did data profiling and data mapping from source system before design ETL.

-Use SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer. -Involved and performed data migration for Sybase DB to SQL DB server and Oracle for multiple applications using ETL.

-Perform indexes performance improvement using Index tuning wizard for tuning of indexes.

-Validated source data before moving into the target system and performing some data cleaning and data profiling using ETL.

-Optimized schema, performance, and capacity planning of various data transformation processes related to the reports -Manage and monitor the system utilization by using the query optimizer and checking the execution plan.

-Performed and developed Python script for data analysis and data validation for business users.

Skills Used: MS SQL Integration Services 2012/2014/2016, MS SQL Server 2012/2014/2016, MS Excel 2010/2013, Visual Studio 2010/2015, Team Foundation Server (TFS), .Net C#, Sybase Central 6, SharePoint, Python 3.6

Data Analyst IPSOS MMA Inc, New York, NY March 2016 – May 2016

- Performed performance tuning of databases and T-SQL queries using Database Engine Tuning Advisor.

- Provided technical support to internal developers and external clients.

- Developed SSIS packages for data extraction, transformation, and loading.

- Created stored procedures, views, and database triggers in SQL Server.

Skills Used: SSIS 2008/2012, MS SQL Server 2008/2012,VB.net, Window XP, Word 2010, Visual Studio 2010, Excel 2010, Da Vinci Tool, T-SQL.

SQL Developer/DBA Cross Current Corporation, Doylestown, PA Mar 2012 – Mar 2016

- Created tables, indexes, views, stored procedures, and functions in SQL Server.

- Migrated MS Access databases to SQL Server and optimized query performance.

- Developed complex SSIS packages for ETL and used SSRS for report generation.

- Designed snowflake Data Warehouse databases and SSAS cubes.

- Participated in reverse engineering data modeling for data warehouse structures.

-Designed, generated, and deployed Business Intelligence (BI) reports using Visual Studio 2008 R2/2012/2014 and SSRS 2008 R2/2012/2014, effectively visualizing data insights for informed decision-making.

-Strategically dropped and recreated indexes on tables, significantly enhancing performance.

-Architected and constructed snowflakes Data Warehouse databases, facilitating the creation of cubes using SSAS for ad-hoc reporting.

Skills Used: SSIS 2008/2012/2014 (SSIS), MS SQL Server 2008/2012/2014, C#, SSRS 2008/2012/2014, SSAS, Source Safe, VB.Net, Window XP, Word 2010, Visual Studio 2008/2010/2012/2013, Excel 2010, HTML, JavaScript, TFS

Billing Technical Support eClinicalWorks, New York, NY Oct 2011 – March 2012

- Managed MSSQL and MySQL databases, including SQL query editing and execution.

- Provided technical support for Cognos reports and drill-down reports.

- Troubleshoot issues, execute solutions, and communicate results to customers.

Skills Used: MS SQL Server 2005/2008, MySQL, Windows Server 2008/2003, Windows NT 2003, Cognos

SQL Server Developer Client: Specialized Technology Resources (STR), Enfield, CT Sept 2010 - Dec 2010

- Designed logical and physical data models using Embarcadero data modeling tool.

- Developed complex SSIS packages for ETL processes and data migration.

- Created stored procedures, tables, views, and SQL joins.

Skills Used: SQL Server 2005/2008, SSIS, SSRS, Visual Studio 2010, Windows NT 2003, Embarcadero ER/Studio 8.5

Contact this candidate