We provide IT Staff Augmentation Services!

Sql /bi Developer Resume

0/5 (Submit Your Rating)

Norristown-pA

SUMMARY

  • 6+ years of experience as a SQL developer in Production, Development and Staging Environment using T - SQL, SSIS, SSRS and MS Office
  • Good knowledge of RDBMS and data warehouse concepts, OLTP & OLAP
  • Proficient with all aspects of T-SQL programming including views, stored procedures, CTE’s, functions, triggers and cursors.
  • Experience with writing complex sql queries, sub-queries involving multiple tables
  • Have developed various formats of SSRS reports including ad-hoc, parameterized, tabular, matrix, charts and sub-reports/drill down reports
  • Have improved performance of sql queries, views and stored procedures by reviewing execution plans, indexes and recommending improvements accordingly.
  • Experience in automating sql scripts using Jobs, sending alerts using SQL Mail.
  • Have hands on experience with using SSIS for ETL process and automating the process using SQL agent jobs and sending alerts.
  • Maintain positive communications and working relationships at all business levels

TECHNICAL SKILLS

  • MS SQL Server versions - 2005/ 2008/2012/2014
  • MS SQL BI Platform -SSRS
  • SSIS
  • SSAS
  • MS others -MS Visual Studio
  • MS Office suite
  • Application -MS Dynamics AX(ERP)
  • TimeXtender(ETL tool)
  • JIRA
  • TortoiseSVN

PROFESSIONAL EXPERIENCE

Confidential, Norristown-PA

SQL /BI Developer

Responsibilities:

  • Created tables, indexes, stored procs, views and functions based on the logical design approved by business users.
  • Designed ETL packages for integrating data from different sources like Oracle, SQL, Flat file data and applied various data transformation like conditional split, look up, derived columns.
  • Gathered business requirements and converted it into SQL stored procedures for database specific projects.
  • Performed production support when needed for existing processes that depend on SSIS packages and SSRS reports.
  • On-call support for any SSIS/SSRS related issues and helped fixed them immediately.
  • Modified existing SSIS packages to reflect the user changes and deployed them to Dev, Test and Production environments using sql configuration.
  • Created SSIS packages to gather data from SQL and Oracle databases and use different transformations to create files for reporting.
  • Developed SSRS reports and configured SSRS subscriptions per specification provided by internal users.
  • Inspected the reports and fixed bugs in stored procedures and also tuned reports.

Environment: SQL Server 2008/2012/2014 SSRS/SSIS/Visual Studio 2010

Confidential, Newton- NJ

SQL/BI Developer

Responsibilities:

  • Created and maintained databases, tables, views, user logins, indexes, check constraints and business rules using T-SQL.
  • Created indexes on selective columns for the fast retrieval of data inSQL Server Management Studio.
  • Designed and created SSIS packages to extract, transform and load data from flat files toSQL Server destination using various transformations like conditional split, look up, derived column, data conversion.
  • Created SSRS reports for Sales, Inventory, Production and Purchase department.
  • Assisted in moving the reporting needs off the OLTP database to the data warehouse using automated ETL tool.
  • Created shared data sources/datasets for SSRS reports so that it would be easier to deploy reports to different environments without change much of the report code.
  • Reviewed the existing database queries and performed a check on top slow running reports and optimized them by modifying the code or by adding indexes.
  • Developed and optimized stored procedures, views and functions per user requirements.
  • Created SSRS subscriptions to automate delivery as per specification provided by user and often stored the reports at a network share for users.
  • Inspected the reports and fixed bugs in stored procedures and also tuned reports
  • Created deployment manifest and deployed the packages using sql configuration to easily migrate code between various environments

Environment: SQL Server 2008/2012/SSRS/SSIS/Visual Studio 2010/ MS Dynamics AX/TimeXtender

Confidential, New York, NY

SQL/BI Developer

Responsibilities:

  • Worked very closely with operations team, trading desk and other higher management to take requirements and fulfill them accordingly.
  • Assisted the development team in writing stored procedures, CTE’s and views that would later be used as data source for reporting and data load.
  • Made sure that the naming conventions for tables and other objects were followed so that code deployment was seamless from dev to test to prd.
  • Created SSIS packages to extract data from trading database to create various custom trade notification reports.
  • Used data flow task\transformation\derived column task of SSIS to extract data from files and populate the tables that were used for further reporting.
  • Migrated ad-hoc queries to using stored procedures to improve query performance runtime.
  • Automated manual reporting tasks by using SSRS reports and creating subscriptions to schedule the delivery of reports on a daily & weekly basis.
  • Created views to simplify the sql code for reporting and provided access to these views for reporting.
  • Created SQL agent jobs to monitor and send out alerts if there are any ongoing locks/deadlocks caused by long running queries.
  • Created ad-hoc reporting as well as tabular and matrix with drill down support for business users and scheduled them as required.

Environment: SQL 2008R2, SSIS and SSRS. Visual Studio 2010. MS Office 2010.

Confidential, Blue Bell-PA

SQL Server Developer

Responsibilities:

  • Developed and created the new database objects such as tables, views, index, stored procedures, and functions.
  • Established foreign key relationships between various tables for data integrity and to prevent invalid data while performing insertion\deletion of records.
  • Created stored procedures and views to retrieve data from the database for users and ad hoc reporting.
  • Performed query tuning by reviewing execution plans and then updating the sql code to use the appropriate joins that can reference the existing indexes or suggesting new indexes to senior developers.
  • Used Visual Studio to create SSRS reports and then deployed and scheduled them to be delivered to the users on a daily\weekly and monthly schedule.
  • Converted many manuals excel reports for users into drill down and sub reports using SSRS reports.
  • Scheduled reports using SSRS subscriptions to generate daily, weekly, monthly and quarterly reports.

Environment: SQL 2008/2008R2. SSRS. Visual Studio 2008

We'd love your feedback!