Ms Sql Server Developer / Bi Developer Resume
4.00/5 (Submit Your Rating)
Montgomery, NJ
PROFESSIONAL SUMMARY:
- 6+ years of strong MS SQL Server Developer experience in Finance, Banking, Telecommunications, and Ecommerce domains with expertise in MS SQL Server 2014/2012/2008 suite of products like SSRS, SSAS, and SSIS.
- Proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
- Experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
- Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2014/2012/2008.
- Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
- Expert knowledge and experience authoring, managing and deploying reporting solutions using SSRS.
- Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
- Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
- Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin, Microsoft Visio and SQL Server Enterprise manager.
- Strong leadership, communication, problem-solving and multi-tasking abilities.
- Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.
PROFESSIONAL EXPERIENCE:
Confidential, Montgomery, NJ
MS SQL Server Developer / BI Developer
Responsibilities:
- Involved in Planning, Defining and Designing database and BI operation (ETL, Reporting) based on business requirements and provided documentation.
- Used SSIS and T-SQL to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
- Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, 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.
- Tune various packages for reducing their processing time by modification, increase buffer and memory operation and using parallel processing approach.
- Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
- Created SQL server dynamic configurations for SSIS packages.
- Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
- Scheduled the packages to run automatically for incremental data and deploy them to their destination servers.
- Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
- Optimized the performance of queries with modifications in T-SQL queries, materialized views, SQL server profiler & Tuning advisor.
- Responsible for creating reports based on the requirements using SSRS 2014.
- Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2014.
- Modified the existing ERD’s to insert more tables, columns and constraints using MS Visio 2013.
Confidential, Warren, NJ
MS SQL Server SSIS / SSRS Developer
Responsibilities:
- Assist in Business Analysts to gather technical requirements.
- Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
- Created various SSIS packages to transfer data from various source files into data warehouse.
- Deployed the packages to the appropriate destinations using SSIS.
- Used various SSIS tasks for Data Scrubbing and validation checks while loading data to DWH.
- Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
- Responsible for creating reports based on the requirements using SSRS 2012.
- Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
- Defined the report layout and identified Datasets for the report generation.
- Created different type of reports including Tablix report, Conditional, Drill-down, Parameterized Report and Cascade Reports.
- Designed and created Report templates, bar graphs and pie charts based on the internal Sales data.
- Scheduled the monthly/weekly/daily reports to run automatically.
- Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
- Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
- Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
Confidential, Redmond, WA
MS SQL Server SSIS/SSRS Developer
Responsibilities:
- Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.
- Assist data modeler to create tables needed for ETL processing and develop ETL framework.
- Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
- Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2008 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
- Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view during extraction of data.
- Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
- Generated reports on account information, detailed summary reports using adhoc reporting to be used by the clients and advisors.
- Created many complex database code objects such as Stored Procedures/ views/ Functions and used them in Reports directly to generate reports on the fly.
- Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
- Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
- Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
- Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
Confidential, Wayne, NJ
MS SQL Server Developer / BI Developer
Responsibilities:
- Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
- Created SSIS Packages to integrate data coming from Text files and Excel files.
- Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
- Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
- Created Query Parameters and Report Parameters to control data returned by the query and filter data Confidential report level.
- Created linked, unlinked and on-demand sub Reports.
- Understood the various complex reporting requirements of company and created web reports using Reporting Services.
- Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
- Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
- Established Inner Join, Outer Join and created Indexes whenever necessary.
- Modified report content and exported reports in multiple formats based on user input.
- Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
- Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
- Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
- Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
- Created User Defined functions for sharing formulas across multiple reports.
- Modified existing reports according to requirements of the end users.