We provide IT Staff Augmentation Services!

Sql/bi Developer Resume

3.00/5 (Submit Your Rating)

Golden Valley, MN

SUMMARY

  • 6+ years of total IT experience in Database Development and Implementation of Client - Server Applications & Database systems using SQL Server 2008R 2/2012/2014.
  • Experience working with Microsoft BI tools SSIS and SSRS.
  • Experience in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.
  • Experience in scripting complex stored procedures, TSQL scripts and tuning queries for performance.
  • Experience in applying SQL Server Indexes (clustered and non-clustered) on database tables for high performance.
  • Experience in whole cycle of DTS/SQL server integration services (SSIS 2008R2/2010/2012) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
  • Experience working on Data Migration projects from Different Source Systems to SQL Server.
  • Experience in data modeling.
  • Experience in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008R2/2012/2014) generated drill down reports, parameterized reports, linked reports, sub reports, charts.
  • Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
  • Experience working on Data Marts, OLAP, Dimensional Data Modeling, Star Schema Modeling for building Data Warehouse.
  • Experience in creating dashboard and KPI using Datazen.
  • Experience working as on call support.
  • Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
  • Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
  • Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2014/2012/2008 Scripting Languages T-SQL, PL/SQL and Visual Basic

Tools: and Packages: SQL Server Management studio, Enterprise Manager, ProfilerBusiness Intelligence Development Studio (BIDS), DTS, SSIS

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), Performance Point Server.

Application Packages: MS Office, MS Outlook (Microsoft Office Suite).

PROFESSIONAL EXPERIENCE

Confidential, Golden Valley, MN

SQL/BI Developer

Responsibilities:

  • Collected business requirements from users and translated them as technical specifications and design documents for development.
  • Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
  • Worked on ETL Tools for designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets to and from SQL Server using BIDS.
  • Develop custom Logging/Error Handling for SSIS Packages.
  • Developed efficient Stored Procedures to support SSIS Packages and Business Intelligence Reporting.
  • Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various business users.
  • Involved in creating efficient multiple parameterized stored procedures for various kinds of reports.
  • Worked on Table Partitions for better performance in SQL server 2012/2014.
  • Created Charts, Tabular, Matrix, Drill Down, Drill Through, Cross Tab reports using SSRS.
  • Worked on performance tuning using query optimizer and SQL server profiler.
  • Involved in administering/deploying/scheduling SSIS packages.
  • Created dashboards and KPIs using Datazen.
  • Involved in optimizing of existing procedures for faster response times.

Environment: SQL Server 2012/2014, SQL server integration services (SSIS), Analysis Services(SSAS), SQL Server Reporting Services (SSRS), SQL Server Data Tools, Team Foundation Server(TFS)

Confidential, Charlotte, NC

SQL/BI Developer

Responsibilities:

  • Continuously interacted with end user to gather business requirements.
  • Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task, Execute process task etc. Worked with various transformations and containers like for loop container, for each loop container etc.
  • Generated different types of Reports like Tabular, Matrix, and Charts.
  • Created stored procedures and user-defined functions for different Reports.
  • Deployed and configured the reports in the Report Server.
  • Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis.
  • Created complex correlated sub queries to generate reports.
  • Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
  • Generated reports by passing parameters through URL Developed reports using SQL Server Reporting Services(SSRS).
  • Performed data mapping the report columns with the database tables and columns. Documenting the data mapping and relationships between tables.
  • Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
  • Maintained report security by creating Service Accounts and Security Groups and configuring in the Report Server.
  • Worked on performance tuning using query optimizer and SQL server profiler.

Environment: MS SQL Server 2005/2008/2012 , MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), T-SQL, PL/SQL, Visual Studio 2008/2010, BIDS, Windows 2003/2008 Server

Confidential, East Greenwich, RI

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

  • Created SQL Server Reports using SSRS 2008/2012.
  • Identified the Data Source and defined them to build the Data Source Views.
  • Developed Query for generating drill down reports in SSRS .
  • Identified and worked with Parameters for parameterized reports in SSRS.
  • Responsible for transferring the data using SSIS packages.
  • Developed, monitored and deployed SSIS packages.
  • Analyzed reports and fixed bugs in stored procedures.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Implemented different types of constraints on tables.
  • Managed index, statistics and optimizing queries by using execution plan for tuning the database.
  • Monitored Scheduled jobs and alerts.
  • Responsible for interacting with stakeholders, requirement gathering and delivery management.

Environment: Windows 2007 enterprise, SQL Server 2012, SQL Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, Team Foundation Server(TFS)

Confidential, Mount Laurel, NJ

SQL/SSIS Developer

Responsibilities:

  • Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system.
  • Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages.
  • Experience in SSIS script task, look up transformations and data flow tasks using T- SQL.
  • Expertise in generating reports using linked reports, sub reports and filters in SQL server reporting services(SSRS).
  • Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
  • Maintained database documentation, including data standards, procedures, and definitions for the data dictionary.
  • Involved in administering/deploying/scheduling SSIS packages. Involved in setting up security for SSRS reports.

Environment: Windows 2007 enterprise, SQL Server 2008, SQL Integration Services(SSIS), Business Intelligence Development Studio (BIDS)

We'd love your feedback!