SQL Server Resume

SUMMARY

7 - 15 years of experience with information technology programs and services, with demonstrated expertise in enterprisedatamanagement and related technologies
Enterprise Dataarchitecture principles and standards, best practices, industry standards
Enterprisedatamodel development and standardization experience. Excellent knowledge of Conceptual, Logical and Physical data models
Thorough knowledge of Sybase Powerdesigner, ERwinDataModeleror a comparable data modeling tool
Working knowledge ofdatawarehousing concepts and the ability to convert a physical design into a dimensional design
Knowledge of Agile development methodology and concepts
Participate and oversee all stages of systems development life cycle (requirements, design, coding, testing, and implementation)
Create Tables, Views, Indexes, Sequences, PL/SQL Packages, Stored Procedures, Functions, Triggers, SQL statements in Oracle
Performance Tuning including tuning/optimizing existing SQL, PL/SQL code
Experience with two or more of the following DBMS technologies: Oracle, Microsoft SQL Server, Sybase, MySQL…etc.
Reviewing Business Requirements Documents (BRDs) and/or User Stories (Agile methodology) and translating them into viable conceptual and subsequentlylogicaldatamodels
Translate the business requirements into design artifacts, employing the core design principles

TECHNICAL SKILLS

Experience with any ETL tool (Informatica, DataStage, etc.)
Experience with any Business Intelligence (BI) tool (i.e. Cognos, MicroStrategy, Business Objects, etc.)
Experience with anydataprofiling/datadiscovery tool such as IBM Information Analyzer
Understanding of BigDataplatforms (e.g. Hadoop, HDFS, NoSQL, DataLake etc)

PROFESSIONAL EXPERIENCE

SQL Server

Confidential

Responsibilities:

Profiling thedatain the source system(s) by writing SQL statements
Develop mapping documents that demonstratedatalineage
Revisingdatadictionaries, governance practices, and standards
Converting logicaldatamodels into working physicaldatamodels and, document and maintain lineage between the two artifacts
Script generation and maintenance and Check-In/Check-Out along with Source Version Controls and generation across multiple database environments.
Exposure to Moderndataarchitecture, BigDataIn-Memory processing, HadoopDataLake, develop models inDataLake to enable Self-service Business Intelligence
Effective communication skills and customer relationship management skills
High level of proficiency with PC based software programs and automated database management systems (Excel, Access, PowerPoint, Word)