We provide IT Staff Augmentation Services!

Sql Server/bi Developer Resume

Richmond, Va

PROFESSIONAL SUMMARY:

  • Over 3 years of experience as Microsoft SQL Developer and its products like Microsoft SQL Server Integration Services and Microsoft SQL Server Reporting Services and an overall 5 years of experience with database methodologies and techniques.
  • Extensive experience in handling various challenging enterprise projects from Client Server application Design and implementation of Microsoft technologies like SQL Server 2014/2012/2008/2005/2000.
  • Experience in Health Care, Finance, Health Insurance and Pharmaceutical Domains.
  • Proficiency in the use of T - SQL for developing stored procedures, tables, views, SQL optimization, joins, and query writing.
  • Extensive experience in Extract Transform Load (ETL) development, data integration and loading from heterogeneous data sources using SQL Server Integration Services (SSIS).
  • Advanced extensible reporting skills with different types of reports such as Drill-down, Sub reports, Parameterized and Cascading Reports and formatting those using SQL Server Reporting Services (SSRS).
  • Development of Data Transformation processes, Packages to Import & Export Data from a variety of sources using DTS, SSIS 2012/2008 R2, and Transact-SQL Scripts.
  • Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.
  • Experience in using SQL Server Profiler to monitor the SQL server for Deadlocks, Long running queries and tune the same to improve performance.
  • Supported team in resolving SQL Reporting services and T-SQL related issues.
  • Familiar with Data warehouse concepts such as OLAP (Online Analytical Processing) and OLTP (Online Transactional Processing).
  • Documentation of SQL Server system and database operations, technical specifications, functional specifications, best practices, policies and procedures.
  • Excellent analytical, Interpersonal and communication skills, fast learner, hardworking and versatile team player.
  • Ability and experience to work on multiple projects and eager to learn new things.

TECHNICAL SKILLS:

Database Systems: MS SQL Server 2014/2012/2008 R2/2008/2005, MySQL

Web Development: Web Services, HTML, CSS, JavaScript

Languages: C, C++, .NET, SQL, T- SQL, PL/SQL, and R

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS

Analysis Tools: SQL Server Analysis services(SSAS)

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports, Business Objects

Database Tools: ERWIN, Microsoft Visual Studio Database Team Edition, SQL Loader, SQL Server Query Analyzer, SQL Server Mail Service, SQL Server Profiler, Visio

Tools: MS Office (2010/2013), Visual Studio (2008/2010), SQL Server Data Tools 2012,Salesforce,BIDS

Operating Systems / Virtual Machine: Server 2012/2008, VMware ESX 4.5

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SQL Server/BI Developer

Responsibilities:

  • Gathered functional requirements and Business requirements and written the technical specifications.
  • Created database objects like tables, views, stored procedures, triggers, and cursors using DDL, DML statements as per functional requirements.
  • Developed highly optimized Stored Procedures, Functions, and Database Views to implement the business logic and created clustered and Non-clustered indexes.
  • Wrote complex stored procedures for querying the data by defining parameters.
  • Designed SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Created SSIS Packages using Fuzzy Lookup, Pivot Transformation, Aggregate, Data Flow Task, Execute SQL Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Designed, deployed, and maintained complex reports using SQL Server 2012 Reporting Services (SSRS).
  • Worked on formatting SSRS reports using the Global variables and expressions.
  • Reports writing based on tickets submitted from front-end people using SQL Server Reporting Services (SSRS).
  • Troubleshooting Users, Profiles, Record types, Groups etc., during d ata migration process.
  • Optimized SQL statements for customer summary reports.

Environment: ASP .Net, SQL Server 2012/2008 R2, SSIS, SSRS, MYSQL.

Confidential

Software Engineer

Responsibilities:

  • Gathered functional requirements and Business requirements and written the technical specifications.
  • Involved in designing Employee Record Keeping software.
  • Participated actively in client meetings and produced detailed level design document for the customer portals.
  • Involved in various Phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
  • Created database objects like tables, views, stored procedures, triggers, and cursors using DDL, DML statements .
  • Developed stored procedures and views for managing efficient data retrieval and application development.
  • Designed, deployed, and maintained complex reports using SQL Server 2012 Reporting Services (SSRS).
  • Created reports to retrieve data using Stored Procedures that accept parameters.
  • Extensively used reporting tool ( SSRS, Web focus) to create reports as per user requirements.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of operations.
  • Created SSRS reports, which contain Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
  • Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in VSS.
  • Helped the production team in analyzing bugs & resolving them.

Environment: SQL Server 2012/2008 R2, SSIS, SSRS, Query Analyzer, SQL Profiler.

Confidential

Database Intern

Responsibilities:

  • Created and administrate attendance databases for all programs and events.
  • Eliminated duplicate data from database tables.
  • Contact area alumni to encourage attendance and recruit alumni to assist with the events.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Coordinate, manage and execute event logistics and details.
  • Marketed, assessed, improved and acquired funding for programs and events.

Hire Now