We provide IT Staff Augmentation Services!

Sql Server Developer/bi Developer Resume

Parsippany, NJ

SUMMARY

  • Around 7.5 years of experience in Development and maintenance of database applications on SQL Server 2005/2008/2008 R2/2012 in OLTP/OLAP/BI environment.
  • Installation and configuration of SQL Server Management Studio 2008 R2, 2012/2014.
  • Experience in writing complex SQL queries involving multiple tables inner and outer joins.
  • Extensive experience in writing Transact - SQL(DDL/DML) queries.
  • Highly experiencedin writing Complex Stored Procedure and Functions.
  • Worked Extensively on ETL process using SSIS package.
  • Experienced in Performance tuning, and optimization of procedures and queries, SQL Server Agent.
  • Extensive experience in Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
  • Expert in designing ETL data flows using SSIS, creating mappings/workflows to extract data from SQL Server and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
  • Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
  • Experience in creating configuration files to deploy the SSIS packages across all environments.
  • Experience with various tasks such as Execute SQL task, for each loop container, Data Flow task, File System and transformations such as Aggregate, Lookup, Merge Join, multicast, conditional split, derived column.
  • Implemented checkpoints at package level.
  • Experience in Error and Event Handling, Precedence Constraints, Break Points, Check Points, Logging.
  • Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
  • Experience in Drill-down, Drill-through And Cascading reports using SSRS.
  • Experience in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
  • Good Knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
  • Quick learner and proactive team member with good Communication skills and Leadership capabilities.

TECHNICAL SKILLS

Languages: C, T-SQL, C#.Net.

RDBMS: Microsoft SQL Server 2012/2008 R2/2008/2005, MS-Access.

ETL Tools: SSIS 2012, SISS 2008, SISS 2005, DTS

Reporting Tools: SSRS 2012,SSRS 2008R2,SSRS 2008,SSRS 2005

Web Technologies: HTML, XML.

SQL Server Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), SSIS, SSAS, SSRS, Data Transformation Services(DTS), SQL Profiler.

Operating System: Windows 2000, Windows Server 2003, Windows NT, Windows XP/7/8.

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

SQL Server Developer/BI Developer

Responsibilities:

  • Involved in gathering the user requirements.
  • Created stored procedures, triggers, Joins, functions and views.
  • CreatedSQLserverReports using SSRS 2008.
  • Created Tabular, Drill-down, Drill-Through and Sub-Report and linked reports usingSQLSERVERReporting Services.
  • Created a drill down multi parameterized report using SSRS, created shared dataset and data source.
  • Identified the data source and defining them to build the data source views.
  • Debugging reports and deploying reports.
  • Involved in SSRS report deployment and reportserverconfiguration.
  • Developed various types of reports like drill down, drill through, matrix, cross tab, Parameterized and cascading parameterized reports using SSRS.
  • Created SSIS Packages to import and export data from Excel Spreadsheets, Text files, PDF and CSV files.
  • Scheduled the reports to run automatically.
  • Configuring the report viewing security.
  • Created schedules and subscriptions.
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
  • Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution.
  • Creating Stored Procedures for reports generation.
  • Responsible for log backups and restoration.
  • Analyzed the existing application programs and tuned SQL queries using Execution planand SQLProfiler.
  • Proficient with SQLserveragent for scheduling jobs,SQLprofiler for database tuning
  • Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables.
  • Worked as adeveloperin creating complex Stored Procedures, SSIS packages, triggers, tables, and views and otherSQLjoins and statements for applications.
  • Designed and implemented stored procedures and triggers for automating tasks.
  • Tested applications for performance, data integrity and validation issues.

Environment: MS SQLServer2008R2, MSSQLServer Reporting Services 2008, Windows 2003server, SQLProfiler.

Confidential, Livingston, NJ

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

  • Created Table, Stored procedures and defined functions.
  • Created SQL scripts for tuning and scheduling.
  • Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
  • Developed various operational, drill-down and drill-through reports using SSRS.
  • Worked on Star schema (identification of facts, measures and dimensions) and Snowflake schema.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Created reports using Report Builder from OLTP and OLAP data sources and deployed on report server.
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
  • Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.
  • Responsible for deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

Environment: MS SQL Server 2008 R2, MS SQL Server 2012, Reporting Services (SSRS), Integration Services (SSIS), Import/Export Wizard, SQL Server Management Studio, T-SQL,Report Builder, Window 7, visual studio 2008.

Confidential, Jersey city, NJ

MS SQL BIdeveloper

Responsibilities:

  • Involved in Developing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
  • Designed ETL packages dealing with different data sources (SQLServer, Flat Files) and loaded the data into target data sources by performing different kinds of transformations usingSQLServerIntegration Services (SSIS).
  • Responsible for SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
  • Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
  • Worked on various tasks and transformations like ExecuteSQLTask, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
  • Created stored procedures, Triggers, User-defined Functions, Views.
  • Responsible to supportSQLServers with ever-changing workloads, and achieving some level of predictable performance (or minimizing variance in plans and performance).
  • Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups.
  • Created Packages, Jobs and Sending Alerts usingSQLMail, database Backup, Recovery and Disaster Recovery procedures.
  • Creating parameterized various Reports usingSQLserver2008 R2 Reporting Services.
  • Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non queried parameters).
  • Created various SQLqueries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
  • Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL SERVER 2008, MS SQLServer2005, SSIS, SSRS, Microsoft Visual Studio 2008,SQLProfiler, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential

SQL Server 2008-R2, SSIS, SSRS.

Responsibilities:

  • Creating jobs for scheduling the SSIS packages.
  • Getting data from different data sources.
  • Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc.
  • Worked with various tasks such as Control Flow (Execute SQL task, for each loop container, Data Flow task, File System task, FTP task etc.) and transformations such as Aggregate, Sort, Lookup, FuzzyLookup, Merge join, multicast, conditional split derived column, Export and Import columns etc.
  • Loading these data into data warehouse like SQL Server.
  • By using these data warehouse, based on client requirement we generate the multilingual reports in SSRS.
  • Performance tuning of packages.

Environment: SQL Server integration Services (SSIS), SQL Reporting Services (SSRS), SQL Server 2008-R2, Windows Server 2003.

Confidential

SQL Server Developer

Responsibilities:

  • Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
  • Validated change requests and made appropriate recommendations.
  • Standardized the implementation of data.
  • Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
  • Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
  • Managed user access and Created new security accounts.
  • Performed Backup and restore of databases.
  • Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
  • Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
  • Updated the statistics information for both the old and new servers.
  • Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel

Hire Now