Sql Server Data
Resume:
Ray Zhang
Personal Summary
●MS SQL Server Developer with about 8 years of strong experience in Finance, Service, Automobile and Government domains.
●Highly proficient in operating MS SQL Server 2016/2014/2012/2008R2/2008/2005 suite of products like SSIS, SSRS.
●Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
●Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
●Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
●Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
●Expertise in developing and designing Cubes using SSAS and Reports using SSRS and develop and maintain MS SQL Server Analysis Service (SSAS) cube/OLAP warehouse.
●Created Star schema dimensional modeling for the data mart and created dimension and fact tables based on the business requirement.
●Designed SSIS packages to Extract data from different sources like SQL Server 2016/2014, MS Excel, MS Access transform them and load into Dimension and Fact tables in Data Warehouse using SSIS
●Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
●Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data Warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
●Conversant in working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ DB2 databases
●Proficient in Creating SSIS packages to perform ETL related tasks and prepare SSIS Projects for deployment.
●Expert in Creating and Deploying SSRS Reports using SQL Server, DB2 on the portal for user accessibility.
●Highly experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Subreports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS
●Good at developing reports using different Reports Tools SSRS, Tableau, and MS Power BI.
●Design data visualization to create multiple charts by using MS Power BI and Tableau for business analysis.
●Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
●Conversant in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
●Proficient in performing DBA tasks including installing and configuring SQL servers and backups/restore and recovery of databases and Create Users and assign permissions based on the level of database access the user would need.
●Efficient in up gradation and migration from MS SQL Server 2005/2008 to MS SQL Server 2008R2/2012/2014.
●Strong leadership, communication, problem-solving and multitasking abilities. Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.
Education
Master of Business Administration - Information Systems
Bachelor of Science
Skillset
MS SQL Server 2016/2014/2012/2008 R2/2008/2005, MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), MS SQL Analysis Services(SSAS), Visual Studio 2015/2013, Microsoft Access, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, Database engine tuning advisor, C#/VB.NET, Erwin Data Modeler, Crystal Reports 8.5, Tableau, MS Power BI, T-SQL, Business Object XI R2, BO Designer, Toad, Desk I, Web I, Info view, Windows 2008/2003 Advanced Server/Professional, Windows NT 6.2/6.3 Server/Workstation.
Professional Experience:
HSBC, NY
Duration: Aug 2016 – Present
Role: Sr. SQL Developer/SSIS Developer/SSRS Developer/ETL Developer
Job Description:
HSBC is one of the world’s largest banking and financial services organizations. HSBC network covers Europe, Asia, the Middle East and Africa, North America and Latin America. The project was to implement the cash equity trading system and integrate new trading application using SQL Server BI platform.
Responsibilities:
●Created SSIS package to load data from Flat File to Flat File and Flat File to Data Warehouse and Data Mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
●Designed SSIS packages to Extract data from different sources like SQL Server 2012, MS Excel, MS Access, DB2 and transform and load into Dimension and Fact tables in Data Warehouse using SSIS.
●Highly proficient in operating experience with Microsoft SQL Server 2016/2014 and suite of products like SSIS, SSRS.
●Experience with SQL and other ETL Languages using structured and unstructured solutions and also working experience in created star schema and snowflake schema and load fact and dimension tables into the data warehouse.
●Implemented data modeling, using ERWIN creates new relational or dimensional data models or reverse engineers legacy databases to move into a new environment.
●Proficient experience with creating incremental and repeatable high-quality data load procedures and also implement repeatable data cleansing and data standardization steps and procedure within ETL.
●Developed C#/ VB.NET in script task and script component in SSIS.
●Performance tuning of T-SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard and responsible for data profiling, ETL development, source-target mapping, SQL tuning and optimization, testing and implementation.
●Developing, deploying and monitoring SSIS Packages on the daily, weekly and monthly basis in Development, Staging and Production environments.
●Conversant with SDLC methodologies including Agile, Relational and Dimensional Database design, Developing stored procedures and views and also design transactional and dimensional schema to support application requirement.
●Actively participating in interaction with users, team members, DBAs and technical manager to fully understand the requirements of the system and Design Database Backup and Restoration Strategy.
●Gathered report requirements and determined the best solution to provide the results in reports.
●Created Tabular Reports, Cross Tabs, and Drill down, Drill through, Charts, Maps, Functions and Maps using SSRS and Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS and Tableau.
●Creating reports subscriptions using SSRS to send data in PDF, Word and Excel format on Daily, weekly, monthly basis via emails and sending to shared folders.
●Performed development support, document reviews, test plan, functional and performance testing to data quality issues and integration of the system.
Tool & Technologies:
SQL Server 2016/2014, T-SQL, Visual Studio 2015, SSIS, SSRS, SSAS, Tableau, Erwin 9.6, C#/VB.NET, Microsoft Office, Team Foundation Server
Lincoln Financial, PA
Duration: March 2013 – May 2015
Role: Sr. SQL Developer/SSRS Developer/SSIS Developer/ETL Developer
Job Description:
Lincoln Financial Group provides advice and solutions that empower people to take charge of their financial lives with confidence and optimism. The project was analysis the business status and make decision support using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
Responsibilities:
●Worked with Data Warehouse Architect and Technical Architect in design sessions to develop high-level solutions architecture for SQL Server Reporting Services (SSRS) solution.
●Responsible for creating database objects using T-SQL to store and maintain the database.
●Used SSIS packages to migrate the data from history SQL version 2012/2008 to the new SQL version 2014
●Created SSIS packages with different data sources (CSV, SAP, Flat files, Excel source files) and loaded the data into target tables by performing different kinds of transformations using SSIS.
●Analyze and integrate disparate data and systems using ETL processes and logic to provide timely and accurate information to the business.
●Deployed and Schedule SSIS packages automotive executed on the server.
●Participated in data warehouse design and architecture sessions with the program management team
●Tested and stored all history versions of T-SQL codes, SSIS packages as well as reports using Team Foundation Server.
●Create database objects in SQL Server 2014 including Tables, Triggers, Views, Stored Procedures, User Defined Functions (UDF) and Indexes.
●Experience in design Conceptual, Logical and physical data model using data modeling tool Erwin and also doing forward and reverse engineering.
●Participated in developing the design, development and implementation strategy by working on deliverables such as Database Aggregation Design, Database Logical and Physical Architecture and Process Architecture
●Performance Tuning, backing up and restoring user databases
●Designed and implemented Parameterized and cascading parameterized reports using SSRS.
●Designed the data visualization reports by using MS Power BI.
●Involved in automating reports generated weekly and monthly basis for the business user.
●Involved in designing data visualization to create multiple charts for business analysis.
●Scheduled report execution and delivery.
Tool & Technologies:
Windows 7/8, SQL Server 2014/2012/2008, Visual Studio 2013/2010, SSIS, SSRS, SSAS, MS Power BI, MS Office 2013/2010
State Street, MA
Duration: Aug 2012 – Feb 2013
Role: SQL Developer/ SSIS Developer / Reports Developer
Job Description:
State Street is an American worldwide financial service holding company and offer assets under custody and administration, investment management services and investment research and trading services to institutional investors. The project combined the SQL server database with the new ERP system.
Responsibilities:
●Gathered data, Planned, Defined and Designed data based on business requirement and prepared documentation for further reference.
●Designed Data model by Erwin data modeler.
●Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users and created the logical and physical model.
●Developed SSIS packages using Lookup Values, Fuzzy Lookup and Fuzzy Grouping for data cleansing and implementing the constraint provided by Business in the mapping document.
●Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
●Modified the existing SSIS package to meet the changes in user's’ requirements.
●Scheduled Task for executing the stored SSIS packages, which were developed to update the database on a Daily basis.
●Created new Business Objects instances. Export the data files to system Developer and deploy the reports on the server for various business needs.
●Developing several complex reports, subreports using various features like (multiple grouping, drill down, parameterized fields, formulas by using SSRS and Tableau.
Tool & Technologies:
Windows 7/ Windows Server 2008, SQL Server 2012/2008R2, Visual Studio, SSIS, SSRS, Filemaker, Tableau, MS Office, MS Visio, Crystal Reports, Erwin 8
YAXIA AUTOMOBILE CORPORATION
Duration: May 2010 – Dec 2011
Role: SQL Developer/SSRS Developer/SSIS Developer
Job Description:
Yaxia Automobile Corporation sells passenger cars and after-sale services. The Company offers a variety of automobile services including new and used car sales, maintenance, brokerage, insurance, and driver training throughout China.
The project was analysis business status and generates the reports for Company management to assess the performance of the business.
Responsibilities:
●Designed and modeled SQL Server 2008 R2 and modified the existing SQL Server 2008 data warehouse and data marts.
●Developed database object such as Tables, Stored Procedure, Triggers and Indexes using T-SQL.
●Performed T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2008 R2.
●Designed a standard to use alias and contexts as per report requirement.
●Created various complex reports using drill down/up, slice and dice, filters and alerts.
●Involved in creating and publishing reports on the web using the Info View in Web Intelligence.
●Resolved loops using contexts, aliases and integrity check.
●Created Classes and Objects taking the information from the database. Also created measure objects.
●Created Complex & Multi-Dimensional reports, Master/Detail and Sub Queries in Crystal.
●Created Details, Summary, Cross-tab reports using filters, Sorting, Groupings based on Crystal fields.
●Exported the universes to the Repository to make the resources available to the users.
●Validated the data of reports by writing SQL queries in T-SQL Developer
●Trained the End Users and prepared User Manuals.
●Formatting reports and generated charts as per user requirements.
●Gathered requirements from interview, meeting and existing documentation.
Tool & Technologies:
MS SQL Server 2008/2008R2, Windows 7, Crystal Reports 11.0, SSIS, SSRS, MS Office 2010/2007, Windows Server 2008
JINGHU BUREAU OF STATISTICS
Duration: June 2009 – April 2010
Role: Jr. SQL Developer/SSIS Developer
Job Description:
JingHu Bureau of Statistics is part of City Government Department, is responsible for statistics for dedicated use in their respective work and provides necessary support in the application of statistics.
The project was the sixth China population census.
Responsibilities:
●Involved in designing from conceptual data model to logical and physical data model as user requirement.
●Setting up Manipulation languages (DML) implementing constraints and triggers for data integrity.
●Used joins, correlated, non-correlated subqueries and aggregate function for complex business queries from multiple tables.
●Created SSIS package using Aggregate, Conditional split, Data Conversion, Derived Column, Lookup, Merge, Pivot, Execute Package Task, Execute SQL Task and For Loop Container etc. to generate basic data for the report and to export cleaned data from Excel, Text file, Access, XML and other OLE DB files to data warehouse.
●Created stored procedures used in SSIS to load/transform data to the database.
●Created complex queries to automate data profiling process needed to define the structure of the pre-staging and staging area.
Tool & Technologies:
MS SQL Server 2008/2005, Windows XP/ Windows Server 2003, SQL Server Data Tools, SQL Sever Business Intelligence Studio (SSIS/SSRS)
Contact this candidate