We provide IT Staff Augmentation Services!

Ms Sql Database/business Intelligence Developer Resume

5.00 Rating

Greensboro, NC

SUMMARY

  • MS SQL Database/Business Intelligence developer wif over eight (8) years of experience wif MS SQL Server 2012/2008/2005/2000 in various industries including finance, educational, health care and law enforcement
  • Experience wif installation and configuration of SQL Server 2012/2008/2005/2000
  • Extensive experience in MS SQL Server 2012/2008/2005 BI tools like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
  • Experience using T - SQL for developing complex Stored Procedures, Tables, Views, Triggers, User Defined Functions and data import/export functions
  • Hands on experience in analyzing query plans, fine-tuning and optimizing queries using SQL profiler and query execution plans, managing Indexes, Locks and troubleshooting deadlocks
  • Extensive experience in complete life cycle of SSIS Packages (Developing, deploying, scheduling, troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers
  • Proficient wif extraction and migration of data from various data sources like MS Access, Oracle, Excel, flat files and XML to teh SQL Server using import/export wizard, DTS/SSIS, bulk insert and BCP utilities
  • Highly experienced in providing Logging, Package Configurations, Error Handling using Event Handlers and custom logging for SSIS packages
  • Experience creating Cubes wif Dimensions and Fact tables in OLAP using SSAS and creating calculated measures and dimension members using Multi-Dimensional Expressions (MDX)
  • Proficient in creating Drill Down Reports, Ad-Hoc, data driven subscription, Parameterized reports, Charts using SSRS and MS Excel for data analysis
  • Strong understanding of teh principles of data warehousing using Fact Tables, Dimension Tables, star and snowflake schema and Slowly Changing Dimensions
  • Working knowledge in C#, ASP.Net and big data technologies like MapReduce, PIG, HIVE, HBase and SQOOP
  • Highly experienced in data architecture design and used data modeling tools like Erwin for designing teh logical and physical data models
  • Thorough knowledge in understanding teh business process, gathering requirements and coordinating ongoing iterative development of Software Development Life Cycle (SDLC)

TECHNICAL SKILLS

RDMS: MS SQL Server 2000/2005/2008/2012 , Oracle, MS Access

Database Tools: BIDS 2005/2008, SSDT 2012, Management Studio, Visual Studio, Analysis Services (SSAS), Query Analyzer, SQL Profiler, TFS

Data Modeling Tools: MS Visio 6.0, ER Studio 8.0.1, ERWIN 7.3

Programming Languages: SQL, T-SQL, PL/SQL, C#.Net, ASP.Net

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS) Import/Export Wizard, Bulk Insert, BCP

Reporting Tools: SSRS, Report Builder, Active Reports, Crystal Reports

Applications: MS Officer 2000/2003/2007/2013

Operating Systems: Windows 2000/XP/ 2003/2007/2010

PROFESSIONAL EXPERIENCE

MS SQL Database/Business Intelligence Developer

Confidential, Greensboro, NC

Responsibilities:

  • Planned, defined and designed data based on business requirements
  • Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views
  • Used SSIS and SQL procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse
  • Created jobs, alerts and scheduled SSIS packages using SQL Agent
  • Used SQL Server package configurations in SSIS packages for code promotion to Dev, Test and Production Environments
  • Identified database tables for defining queries to generate reports for analysis of data using SSRS
  • Performed T-SQL tuning and optimization of queries that took longer duration using SQL Profiler, SQL Query Analyzer and execution plans
  • Created different types of reports including Cross-tab, Conditional, Sub reports, and parameterized report
  • Scheduled Monthly Adherence for client and daily exception reports for nursing and IT groups.
  • Developed and implemented procedures to ensure teh quality, usability and accuracy of reports
  • Used Team Foundation Server (TFS), and Visual Source Safe (VSS) to store, run, edit and revert back to different versions in case of system crash
  • Involved in entire project life cycle including database design, development, testing, optimizing, and deploying on development and test servers

Environment: MS SQL Server 2008/2012, Microsoft Visual Studio 2012, SSIS, SSRS, T-SQL, C#, MS Excel, MS Windows/XP, Visual Source Safe, Team Foundation Server, SQL Profiler and SharePoint.

MS SQL Database/Business Intelligence Developer

Confidential, Seattle WA

Responsibilities:

  • Analyzed data to identify patterns and trends that may impact overall performance
  • Worked closely wif PM and other teams to create and test teh mappings from Source to Target
  • Created database objects like Stored Procedures, Triggers and User Defined Functions
  • Created views to maintain security of teh customer data
  • Created Indexes to achieve high level performance
  • Performed ETL operations to support incremental, historical data Loads and Transformations using SSIS
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call packages
  • Created ETL packages wif different data sources and loaded teh data into destination tables by performing transformations using SSIS
  • Used various SSIS functionalities like Joins, Conditional Splitting, Multi-cast, Union All and column conversions for better performances during teh package execution
  • Implemented Slowly Changing Dimensions for storing history using SSIS packages
  • Involved in teh design, development and maintenance of different cubes using SSAS
  • Maintained log information in text files to track errors and record teh package execution status
  • Developed various reports like Table, Matrix and Chart, Drill Down, Drill Through, Sub Reports, Parameterized, Table, Matrix and Chart reports using SQL server reporting services
  • Created reports using teh Power BI Desktop App and Power BI Service
  • Scheduled reports daily, weekly and on a monthly basis as per teh client’s requirements
  • Wrote teh business logic codes using C# to read data from Stored Procedures
  • Created user-friendly interfaces for different group users using ASP.Net for running different kinds of reports
  • Configured mail profiles for sending automatic mails to teh respective people when a job failed or succeeded
  • Implemented unit and integration tests

Environment: MS SQL Server 2000/2005/2008/2012 , SSIS, SSRS, SSAS, C#, ASP.Net, Power BI, Team Foundation Server, SQL Profiler, Query Analyzer, Visual Studio 2008/2013 and T-SQL

MS SQL Business Intelligence Developer/Data Analyst

Confidential, Cleveland OH

Responsibilities:

  • Analyzed teh client requirements and translated them into technical specifications
  • Created new database objects like Stored Procedures, Functions, Views, and Indexes using T-SQL in development, tests and production environment for SQL Server 2008
  • Developed SSIS packages to Extract, Transform and Load into teh data warehouse from Heterogeneous databases such as Oracle, MS Access and DB2
  • Developed SSIS packages wif monitored features and Logging capturing teh audit information of teh package and their execution results for support and troubleshooting
  • Created SSIS packages to pull data from teh SQL Server and exported to various data sources like excel, flat files and vice versa
  • Worked on SSIS performance tuning using counters, Error Handling, Event Handling and re-ran teh failed SSIS packages using checkpoints
  • Scheduled SSIS packages as a job, to run on a daily basis for data loading
  • Created AD-hoc reports and data driven subscription reports using Report Builder
  • Created Drill-Down, Parameterized, Sub Reports, Pie Chart and Bar Chart reports
  • Monitored teh performance of teh reports and modified SQL queries and functions to improve reports performance
  • Administered teh reports by creating roles and providing permissions for teh users/groups
  • Studied teh existing OLTP system(s) and created Facts, Dimensions and star schema representation for data warehouse
  • Created cubes on top of teh data warehouse for reporting purposes

Environment: MS SQL Server 2005/2008, Windows 7, SSIS, SSAS, SSRS, SSMS, ER Studio, C#.Net, Query Analyzer

We'd love your feedback!