Data Analyst Database developer

JING WANG

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

Tel: 571-***-****; Herndon, VA.

Summary:

●Highly motivated Database Developer with over 10 years of experience in data analysis, including installation, configuration, upgrading, designing, deploying, and managing and monitoring Microsoft SQL Server database from development to production environment

●Good working knowledge with telecoms, manufacturing, banking, transportation and industry procedures and related processes

●Experience and good knowledge of RDBMS concepts and query tools for creating, updating and administering a relational database

●Experience in business process mapping, analyzing, defining and documenting business processes and rules

●Solid ability to write and optimize diverse SQL queries, including joins, index, aggregate functions, string functions, window functions, ranking functions, analytic functions and sequence functions

●Experience in creating tables, establishment of ERD, ETL, and deduping

●Experience in T-SQL (DDL, DML), triggers, views, user defined functions and complex stored procedures

●Experience in creating and managing clustered indexes and non-clustered indexes and optimization of queries using execution plan

●Experience in database design, including design of new database systems for applications and redesign of existing database systems, relationship, keys, constraints, indexes, and other constraints for data integrity and performance

●Good working knowledge in performance tuning, index tuning, error handling, maintenance, troubleshooting, query optimization

●Programing experience with.NET, C#, java

●SSIS/SSRS Technical Support for Operational reporting

●Excellent communicator, self-motivated, quick learner and determined to learn new technologies, strong troubleshooting skill and good team player with excellent interpersonal and teamwork skills

●Have ability to work well independently with minimal direction, excellent communication skills and the ability to work/collaborate with people in a team setting

Holding Permanent Resident Card (Green Card)

Professional Experience:

Data Analyst/SQL Database Developer in telecoms and manufacturing industries 2010-present

●Performed data extraction and manipulation over large relational datasets using SQL and other analytical tools

●Performed business analysis, technical analysis, system design, software programming, data modeling and report using quantitative data and texts

● Analyzed datasets, exploring relationships in the data, reporting issues identified along with analysis of causations and potential resolutions

●Supporting legacy data. Understanding of the old database and identifying the Junk data in SQL Server

●Mapping and transformation of data between the old and new database

●Conducted interviews with third parties on behalf of clients to improve client’s business needs

●Determined compliance of applications with legal rules, regulations, and requirements and communicated finds and decisions on compliance of applications to management

●Coordinated with clients, software developers, QA analysts, and other internal departments to establish a technical platform managing hundreds and thousands of references and related data, translating client’s business needs to technical problems to be solved, providing evaluations on development of the platform in various stages, and explaining complex technical issues to clients who do not have the relevant technical background in a clear and effective way

●Managed and coordinated timely completion of multiple concurrent projects, meeting deadlines and production obligations with required work quality

●Performed data analysis on large relational datasets using SQL commands such as DML (insert, update, delete, merge) and DDL (create, alter, truncate, drop), Triggers, Views, User Defined Functions and Complex Stored Procedures

●Performed data analysis on large relational datasets using optimized diverse SQL queries, including Joins, group functions, string functions, and ranking functions

●Developed predictive models and statistical analysis on selective subject matters in technical fields

●Wrote data queries to obtain lists of references from online databases for analysis

●Provided data analysis and data support on patient information using constituent management platform, managing data collection, data entry and deduping in the data environment

●Provided consulting service on data management, data integration and data exploration of a large scale of patient information and data modeling based on text analysis

●Assisted in evaluation of data analytical report, providing insights of issues of importance, views of risks and benefits from different perspectives

Database developer in banking and transportation industries 2007-2009

●Hands on experience on SQL Server in Windows and Unix environment

●Requirement Gathering and Understanding

●Performed Impact Analysis, Coding, Unit Testing and System Testing, Handled Operational Requests

●Effectively develop, and collaborate with others to develop, database-centric solutions within a distributed team of SQL / T-SQL and Java developers

●Develops technical system documentation

●Created databases objects including tables, indexes, views and stored procedure per the design requirements.

●Created and Tuned T-SQL stored procedures to implement business logic and Optimized ETL Scripts to reduce execution time

●Programming – utilize programming languages to create complex functions for use in databases

●Writing the test scripts, test cases and validating the data

●Support development team by building, optimizing and troubleshooting SQL stored procedures, views and triggers

Additional Information:

●C#, Python, Spring, Hibernate, JavaScript, Angular, HTML, CSS, Ajax, VBA, Linux, Shell, Visual Basic, TFS, Git, JIRA

Education:

●Bachelor of Computer Science Beijing University of Technology, Beijing, China

Contact this candidate