We provide IT Staff Augmentation Services!

Sr. Sql Server Developer/bi Developer Resume

Boston, MA

PROFESSIONAL SUMMARY:

  • 8+ years of professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2012/2008R 2/2008/2005/2000 in Banking, Finance, Insurance, and Health Care Domains.
  • Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
  • Skilled in Data Warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
  • Expert in RDBMS concepts, Data Warehousing concepts, OLTP and OLAP.
  • Strong Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
  • Excellent in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
  • Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
  • Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created and formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports and custom reports .
  • Experience in providing SSRS server level, item level Security and Accessibility to various reports in a multi-user environment.
  • In depth understanding of SQL Server Migrations and problem management
  • Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
  • Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
  • Responsible for maintaining the efficiency of all the software and applications that run on UNIX system.
  • Having excellent communication skills, analytical skills, and understanding of business requirements in various domains.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. SQL Server Developer/BI Developer

Responsibilities:

  • Worked with business, application developers, and productionteams and across functional units to identify business needs and discuss solution options.
  • Participates actively in all phases of system development including planning and analysis, design, development, and testing.
  • Deliver Business Model, logical and physical data models using Erwin and also responsible for Forward Engineering in Data Modeling, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
  • Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
  • Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
  • Pushed all the created store procedures and functions to the development, and production servers.
  • Maintains application performance and scalability with a focus on performance tuning SQL queries, table design, indexing, and query plan analysis.
  • Created trace in SQL Profiler and used Database Engine Tuning Advisor (DTA) for Performance tuning on stored procedures and Scripts.
  • Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
  • Designing the ETL/SSIS process from the existing legacy DTS packages into SSIS Packages.
  • The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and for each loop. Set package configuration in SSIS to redirect path from test environment to production environment.
  • Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
  • Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as Interactive reports according to business requirements in time restricted environment using SQL server reporting services(SSRS) 2008.
  • Involved in scheduling, creating snapshot and subscription for the reports.
  • Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
  • Provide support to BA/SA/QA teams to verify data and provide data profiling related analysis.
  • Work with the QA team to create SQL based queries to validate data and provide support. Communicate effectively both in writing and verbally.

Tools: MS SQL Server 2012, MS SSRS 2010, MS SSIS 2010, T-SQL, Windows Server 2007, Erwin 8.0

Confidential, Portland, Oregon

SQL/ETL/SSIS/SSRS Server Developer

Responsibilities:

  • Planned, defined and designed data based on the business requirement.
  • Migrating Databases from SQL Server 2008 to SQL Server 2012.
  • Documented Up-gradation, Procedures from SQL Server 2008 to SQL Server 2012.
  • Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.
  • Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing; including data validation checks during staging, before loading the data into the data warehouse.
  • Performed incremental load with several data flow tasks and control flow tasks using SSIS.
  • Designed logical/physical data models using Erwin tool 8.0.
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Experienced in creating Job Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
  • Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.
  • Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles. Improved performance by creating clustered and non-clustered indexes and by optimizing the T-SQL statements using SQL profiler.
  • Designed and developed different type of reports including tabular forms, Matrix (cross Tab report) form, conditional, list items, charts and sub reports, custom report, drill down reports using SSRS.
  • Responsible for deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

Tools: MS SQL Server 2012/2008, Enterprise Edition, MS SSRS 2010,, MS SSIS 2010, T-SQL, VB Script, Windows Server 2007, Erwin 8.0

Confidential, Bethesda, MD

SQL/ETL/SSIS/SSRS Server Developer

Responsibilities:

  • Developed physical data models and created DDL scripts to create database schematics and database objects. Designed data models using Erwin.
  • Created indexes, constraints and rules on database objects for optimization.
  • Designedand developed SSIS ETL/SSIS packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
  • Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart usingLookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
  • Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during staging, before loading the data into the Data warehouse.
  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to the Data Staging, to SQL server. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
  • Configured files to deploy the SSIS packages across all environments.
  • Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
  • Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2.
  • Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, using SSRS. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
  • Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.

Tools: MS SQL Server 2008R2, SQL server integration services (SSIS) 2008R2, SQL server reporting services (SSRS) 2008R2, SQL server analysis services (SSAS) 2008R2, VB.Net, C#, SQL profiler, TSQL. Erwin tool 7.2, Windows 2007

Confidential, Hillsboro, OH

MS SQL Server/ETL/SSIS/SSRS Developer

Responsibilities:

  • Worked as a SQL Server Developer and Crystal Enterprise Reports Developer/Administrator in support of Service Management System.
  • Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
  • Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.
  • Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Performed user acceptance testing on new and modified reports.
  • Displayed pie charts, bar graphs for analysis by top-level management using Analyzer in the reports.
  • Developed database triggers and stored procedures using SQL cursors and tables.
  • Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
  • Implemented various types of control flow and data flow transformations in packages to handle different logics and Created SSIS package for Market Value Process feed.
  • Used C# scripts in SSIS script task to run custom scripts in package flow.
  • Created command files to execute the SQL Server Integration packages using dtexec utility and passed connection and variable values to the packages.
  • Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent. Designed and developed Data Transformation Process.

Tools: MS SQL Server 2008, SSIS, T-SQL, SQL Server Integration Services (SSIS).

Confidential, Bedminster, NJ

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Actively participated in interaction with users, Team Lead, DBA's and technical managers to fully understand the requirements of the system.
  • Performed Migration of data from SQL Server .
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
  • Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
  • Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.
  • Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
  • Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.
  • Deployed reports in to Report Manager. Created Ad-Hoc reports using Report Builder.
  • Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
  • Created report in SQL Server 2005 and deployed them on local-host for remote access.
  • Developed Multi-dimensional Objects Cubes, Dimensions using SSAS.
  • Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS.Wrote MDX queries to access data from OLAP cubes.
  • Ran DBCC and fixed data corruption in application databases.
  • Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Tools: MS SQL Server 2008/2005,, SSIS 2008, SSRS 2008, SSAS 2008, Visual Studio 2008, T- SQL, XML, ADO.NET, ERWIN 7.1, PL/SQL, MS-Access, MS-Excel

Confidential, Boise, ID

SQL Server Developer

Responsibilities:

  • Involved in gathering the report specifications by interacting with the business users
  • Responsible for Data Modeling based on the client requirements, data analysis, loading data from Data feed to Data Warehouse tables.
  • Redesigning the ETL/SSIS process from the existing legacy DTS packages into SSIS Packages.
  • The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and for each loop. Set package configuration in SSIS to redirect path from test environment to production environment.
  • Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
  • Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
  • Modified stored procedures to meet current design and used them in SQL Server.
  • Created various Database Objects - Tables, Indexes, Views, and Roles, complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.
  • Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
  • Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS. Configured and maintained Report Manager and Report Server for SSRS.
  • Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
  • Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.

Tools: MS SQL Server 2005/2000, Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005,T-SQL, VB Script, Windows Server 2003, Erwin 4.1.

Confidential, Newport Beach, CA

Data Analyst/SSRS Developer

Responsibilities:

  • Upgraded MS SQL Server 2000 databases to 2005 using detach/attach, backup and recovery and by replication.
  • Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
  • Involved in SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
  • Performed transformations using various SSIS tasks such as conditional split, derived column, that performed data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
  • Used ETL to implement the slowly changing transformation to maintain historical data in data warehouse.
  • Created Views to reduce database complexities for the end users.
  • Designed and implemented stored procedures and triggers for automating tasks.
  • Created Sub-reports, Drill-down reports, Summary reports, and Parameterized reports in SSRS.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
  • Created alerts for successful or unsuccessful completion of scheduled jobs.

Tools: MS SQL Server 2005, T-SQL, SSIS 2005, SSRS 2005, MS SQL Profiler, SQL Query Analyzer, Index Tuning Wizard, MS Access, Crystal Reports 10/9, Visual Studio 2005.

Hire Now