Livecareer-Resume
Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA 94105
:
Professional Summary
Over 5 year of IT Experience in Database Design and Bi development on MS SQL Server 2014, 2012,2008 versions on various development, test and production environments with various business domains. *Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS). *Proficient in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes Created various Complex Formula Reports to query the database for business Intelligence. *Strong DBA/Development skills writing T-SQL scripts, worked extensively on ETL process using DTS, SSIS packages, handling data quality issues and generating various types of reports using SSRS on OLAP databases. *Demonstrated expertise in MS SQL Server 2012/2008/2005 and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services), SSAS (MS SQL Server Analysis Services) and T-SQL scripts. *Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan. *Evaluates and refine Business Intelligence goals, business objectives, decision support needs, data and performance requirements to meet departmental/project level objectives. *Provides design support for the development of business intelligence solutions. *Works on multiple tasks/projects as team member. *Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems. *Proficient in the use of query and reporting analysis tools. *Standardize data collection by developing methods for database design and validation reports. *Evaluates and validate quality of performance on completeness of Business Intelligence models and solutions. *Strong understanding of application systems, and business intelligence methods and the ability to quickly learn new software solutions. *Experience in deploying created reports in various sources like Web browser, XML and PDF. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements. *Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
Skills
  • Languages: SQL. HTML, XML. MySQL, Oracle 11g/10g/9i, MS SQL Server 2016/14/12/08, DB2 v8.1.
  • Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server.
  • Operating System: Windows 08/07/05/NT/XP, Linux, Mac.
  • ETL Tools: Informatica Power Center 9.6.1/8.6 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), Data manager10x, SSIS/SSRS.
  • Developments tools: Microsoft Visual Studio 2015/13/12/10/08 and 2005, PowerShell.
  • Tools: MS Visual Studio, MS Office (Word, Excel, PowerPoint, Access).
Education
San Francisco State University San Francisco, CA Expected in 2013 Bachelor of Arts : Business Administration - GPA :
Work History
Wells Fargo - SQL Developer
Great Falls, MT, 2016 - 03/2017
  • Involved in Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
  • Installed SQL Server 2014 and Management tools using SQL Server Setup Program.
  • Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.
  • Analyzed business requirements and built logical data models that describe all the data and relationships between the data.
  • Perform DML, DDL Operations as per the Business requirement.
  • Creating views and prepares the Business Reports.
  • Resolved production issues by modifying backend code as and when required.
  • Used different joins, sub queries and nested query in SQL query.
  • Documented the data such as entity relationships and attributes, file descriptions and definitions.
  • Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
  • Testing of code functionality using testing environment.


Neogenomics Laboratories - SQL/Bi developer
, , 05/2014 - 11/2015
  • Created SQL Server Reports using SSRS for management.
  • Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
  • Documented the data such as entity relationships and attributes, file descriptions and definitions.
  • Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical requirements.
  • Participated in developing logical model and implementing requirements on SQL Server 2012.
  • Created the database for the reporting team.
  • Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
  • Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical Database.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
  • Created indexed views and appropriate indexes to reduce the running time for complex queries.
  • To keep track of data manipulations using Audit functionalities.
  • Generated custom and parameterized reports using SSRS.
  • Reorganized database structures as needed, automated procedures at regular intervals.
  • Optimized long running Stored Procedures and queries for effective data retrieval.
  • Optimized SQL queries for improved performance and availability.
  • Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.

Wells Fargo - SQL developer & Tester
Greenwich, , 03/2013 - 04/2014
  • Participated in developing logical model and implementing requirements on SQL Server 2008.
  • Created the database for the reporting team.
  • Solved various T-SQL issues using Query Analyzer.
  • Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
  • Created ad hoc T-SQL Queries.
  • Created backup and restore operations.
  • Created Database Triggers to implement business requirements.
  • Created complex Stored Procedures and Functions to support the front-end application.
  • Optimized SQL queries for improved performance and availability.
  • Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
  • Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical Database.
  • Reorganized database structures as needed, automated procedures at regular intervals.
  • Optimized long running Stored Procedures and queries for effective data retrieval.
  • Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
  • Worked with DBA to maintain referential integrity by defining table and column level options such as primary/foreign keys, cascade delete and column constraints on applicable data-mart tables.
  • Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.

Cognizant - SQL Developer
City, STATE, 04/2012 - 02/2013
  • Participated in developing logical model and implementing requirements on SQL Server 2008.
  • Created the database for the reporting team.
  • Optimized SQL queries for improved performance and availability.
  • Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
  • Designed and developed the database based on these requirements.
  • Carried out a Developer's role on MS SQL Server 2008, MS Access Databases (using DTS (Data Transformation Service), T (Transact)-SQL, Stored Procedures and Views).
  • Involved in migration of SQL server 7 to SQL server 2008 using Upgrade Advisor.
  • Installed and Configured SQL Server 2008, Created Logins, Users and Maintenance Plans managing use of Disk space, memory and connections to the database.
  • Involved in assisting QA team in deploying and testing the application, which uses SQL Server as a database.
  • Involved in creation of stored procedures, triggers using T-SQL according to the requirement of the projects.
  • Involved in Performance tuning and optimizing for SQL Server Application by using performance monitor.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Disclaimer

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

67Fair

resume Strength

  • Formatting
  • Length
  • Measurable Results
  • Personalization
  • Target Job

Resume Overview

School Attended

    Job Titles Held:

    • SQL Developer
    • SQL/Bi developer
    • SQL developer & Tester
    • SQL Developer

    Degrees

      By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

      *As seen in: