We provide IT Staff Augmentation Services!

Bi/ Sql Developer (ssms, Ssrs) Resume

White Plains, NY

SUMMARY

  • SQL Server Developer/BI Developer with over 8 years of professional experiences in Database Design, Development and Maintenance using MS SQL Server 2008/2008 R2/2012/2014, SSIS 2008/2010/2012 , SSRS 2008/2010/2012
  • Highly proficient in Microsoft T - SQL (DDL and DML) in constructing Tables and Normalization on database Tables
  • Adept in using Microsoft T-SQL to create and optimize database objects - Tables, Views, Indexes, Triggers, Stored Procedure, Transactions, CTEs, Joins and performance tuning
  • Expert in using complex T-SQL queries, Dynamic SQL, Sub-queries and complex Joins
  • Profound understanding of all the phases of Software Development Life Cycle (SDLC) and Agile environment
  • Outstanding experience in specifying issues in database, Performance Tuning, Debugging, Troubleshooting and improving database performance
  • Extensive experience in data extraction, transforming and loading (ETL) using SQL Server Integration Services (SSIS), creating various packages depending on user requirements
  • Superior experience in usage of SSIS Control Flow Tasks (For loop, For each loop, Execute SQL task) and Data Flow Tasks such using transformation (Conditional Split, Data Conversion, Lookup, Derived Column, Merge, Union all, Merge join)
  • Proficient in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS packages
  • Experienced in creating reports for business analysis and management purposes using SQL Server Reporting Services (SSRS)
  • Used SSRS to create Drill Down and Drill Through, Ad Hoc, Parameterized reports, Sub-reports, Snapshots, designing report layout; applied variety of features using complex expressions to Calculate, Group, Filter and Format the contents of the report in SSRS
  • Knowledge of data warehouse, star schema and snowflake schema; experienced in developing OLAP Cubes, Dimensions using SQL Server Analysis Services (SSAS)
  • Experienced in handling data efficiently in OLTP and OLAP environment
  • Knowledge of data warehouse, star schema and snowflake schema
  • Proficient in using Tableau to generate different types of reports(Dashboard, Chart, Graph)
  • Excellent Communication skills, excelling as a team player and equally excelled when worked individually to achieve all project deliverables successfully

TECHNICAL SKILLS

  • T-SQL
  • Data Architecture
  • SDLC
  • MDX
  • MS SQL Server 2008/2008 R2/2012
  • SQL Server Analysis Services 2008/2010/2012
  • SQL Server Integrated Service 2008/2010/2012
  • SQL Server Reporting Services 2008/2010/2012
  • Report Builder
  • MS Access
  • MS Excel
  • MS Office
  • Tableau 7.0/8.0
  • MS Windows 8
  • MAC OS X
  • C#
  • JAVA
  • HTML
  • PHP
  • ASP.NET
  • Dreamweaver
  • SharePoint 2010/2013
  • Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE

Confidential, White Plains, NY

BI/ SQL Developer (SSMS, SSRS)

Responsibilities:

  • Analyzed and reviewed business requirements and interacted with Business System Analyst
  • Worked with Project Manager in estimating and planning the Project delivery and interacted with Source SMEs to define data mapping requirement
  • Wrote SQL command to perform ETL process including performing data transformations and creating reference data to populate data from Raw Database to Data Marts based on mapping document
  • Created dynamic queries, Sub-queries, CTEs, Joins, User Defined Function, Trigger, Stored Procedure to manipulate data, secure and optimize database
  • Troubleshoot SQL code across the ETL process from Raw Database to Staging Database and from Staging Database to Data Mart
  • Implemented code merge and automation process by using Excel connecting with SQL Server 2008 R2 for ETL data loading
  • Involved in UAT process, performed Data Quality Check on data in Data Mart based on expected value for each field for Quantitative Risk Management(QRM) data
  • Involved in building Centralized Data Dictionary in SQL Server database which ensured the business user to get source detail of each field in Data Mart conveniently
  • Prepared final data mapping documentation for Santander Bank business user
  • Involved in enhancements to the system: User defined as part of change controls and production fixes
  • Worked with Business Intelligence Architect in technical design to build solutions for finance regulatory reporting
  • Familiar with financial products (Bank Loans, Deposits, Securities and Derivatives)
  • Developed Matrix reports, Parameterized reports, Drill-through reports, Drill-down reports as per business requirements by using SSRS
  • Deployed types of reports into web-portal by using SSRS
  • Used TortoiseSVN to perform Version Control of SQL code

Environment: MS SQL Server 2008 R2, SQL Server Reporting Services (SSRS) 2008, TortoiseSVN, JIRA, MS Excel, MS Office, Windows 8/7.

Confidential, Iselin, NJ

BI/ SQL Developer (SSIS, SSRS, SSMS)

Responsibilities:

  • Gathered business requirements from sales team and business analyst team, and worked in connection with the enterprise data warehouse architecture on the development of logical data models
  • Installed and Configured SQL server 2012/2014 on Development and production server
  • Created dynamical queries, Sub-queries, CTEs, Joins, User Defined Function, Transaction, Trigger, Stored Procedure, Index and implemented as the business requirements to manipulate data, secure and optimize database
  • Tuned complex SQL queries and Stored Procedures to increase performance and worked on Exception handling with Try/Catch
  • Conducted performance tuning and monitored database management by using SQL Profiler and Database Engine Tuning Advisor
  • Designed and deployed various ETL packages to migrate the data coming from SQL Server and to synchronize daily transaction data by using SSIS
  • Incrementally and dynamically transformed data by using SSIS (Conditional Split, Data Conversion, Lookup, Derived Column, Merge, Union all, Merge join, Slowly Changing Dimension)
  • Generated reports from SQL Server Databases and OLAP data warehousing
  • Developed Matrix reports, Parameterized reports, Drill-through reports, Drill-down reports as per business requirements by using SSRS
  • Deployed types of reports into web-portal by using SSRS
  • Created visualization reports(Dashboard, Pie Chart, Bar Chart, Line Chart, Graph) to show the customer feedback on the services using Tableau

Environment: MS SQL Server 2012/2014, SQL Server Integration Services (SSIS) 2012, SQL Server Reporting Services (SSRS) 2012, SQL Profiler, Tableau 8.0, MS Office, Windows 8/7, TFS.

Confidential, Albany, NY

BI/ SQL Developer (SSIS, SSRS, SSMS)

Responsibilities:

  • Actively supported business users for change in requests
  • Involved in gathering business requirements and provided documentation to plan, define and design data
  • Created detailed reports for the sales department to help them analyze the customer behavior and customer feedback and involve in supporting generating reports for end-users
  • Performed ETL packages to extract data from OLTP data sources such as Excel, Access, Text files and Oracle, SQL Server using SSIS
  • Implemented slowly changing dimension transformation to maintain the historical data in data warehouse
  • Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, Look up, Data Conversion, Merge, Merge Join
  • Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases
  • Created effective User Defined Function, Stored Procedure, Triggers, Transactions to facilitate data consistency and efficient data manipulation
  • Developed dynamic SQL queries for reports on Enterprise Data Warehouse(OLAP) and Operational database(OLTP)
  • Used Execution Plan to optimize the performance of database
  • Created user defined financial reports to provide on demand financial data analysis
  • Created Multi-Dimentional cubes using SSAS based on business requirements
  • Generated reports of various output formats as requested by the management such as drill down, drill through reports
  • Performed complex expressions to group data, filter and parameterize reports
  • Deployed the generated reports created using SSRS to the server
  • Generated different types of visualization reports (Dashboard, Pie Chart, Bar Chart, Line Chart, Graph) using Tableau

Environment: MS SQL Server 208R2/2012, SQL Server Integration Services (SSIS) 2010, SQL Server Reporting Services (SSRS) 2010, SQL Server Analysis Services (SSAS) 2010, SQL Profiler, Database Engine Tuning Advisor, Tableau 7.0, MS Office, Windows 7, SharePoint 2010.

Confidential, Woodbury, NY

MS SQL Developer/ BI Developer (SSMS, SSIS, SSRS,SSAS)

Responsibilities:

  • Designed Data Warehouse and analyzed various approaches for maintaining different dimensions and facts
  • Designed ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS
  • Used event handler for error handling of Packages
  • Used bulk insert in SSIS for faster transfer of data
  • Used T-SQL to create tables, views, user defined functions, CTEs, Index for implementing application functionality at the database side for performance improvement
  • Modified T-SQL Stored Procedure/Triggers for validating the integrity
  • Used ETL packages to extract, transform and load data into data warehouse by using SSIS
  • Built Multidimensional Expressions (MDX) queries for Analysis Services & Reporting Services
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS
  • Created parameterized, drill down, drill through and subreport using SSRS
  • Generated weekly and monthly reports for the financial advisors in wealth management team

Environment: MS SQL Server 2008R2/2012, SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS) 2010, MS SQL Server reporting Services (SSRS) 2010, T-SQL, MS Excel, MS Office, Windows 7, TFS.

Confidential, Boothwyn,PA

BI/ SQL Developer (SSIS, SSMS, SSRS,SSAS)

Responsibilities:

  • Responsible for designing logical as well as physical database
  • Defined data types, created database and database objects such as tables and views
  • Tested the table with complex queries such as Joins, Sub-queries and Temp Tables
  • Converted complex business logic into T-SQL Stored Procedures and User Defined Functions
  • Created indexes (Clustered & Non-clustered) to reduce data retrieval time
  • Used Try Catch in stored procedure to perform error log mechanism
  • Created ETL packages to migrate data from different data sources to data warehouse by using SSIS
  • Created Custom Logging in SSIS packages
  • Wrote queries to create drill down, drill through and ad-hoc reports on regional analysis on pharmacy, nursing and benefits services using SSRS
  • Actively supported business users for changes in reports as and when required using SSRS
  • Used complex expressions to group data, filter and parameterize reports
  • Deployed reports on server using SSRS and created linked reports and snapshots
  • Designed and created data mart, fact tables, dimension tables and online analytical processing (OLAP) cubes for the analysis of business condition using SSAS

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS) 2010, SQL Server Reporting Services (SSRS) 2010, SQL Server Analysis Services (SSAS) 2010, T-SQL, MS Office, Windows XP.

Confidential

MS SQL Server Developer (T-SQL, SSIS, SSRS)

Responsibilities:

  • Carried out a Developer’s role on MS SQL Server 2005 and MS Access Databases
  • Developed logical and physical database by using Normalization
  • Developed complex T-SQL in creating tables, constraints, indexes and views
  • Designed and Implemented the Stored Procedures and Triggers for automating tasks
  • Generated daily reports by using SQL queries and Stored Procedures
  • Analyzed database growth and space requirement
  • Created ETL packages to extract data from global datacenter and load data to local datacenter
  • Involved in generating and deploying various reports such as parameterized reports, matrix reports by using expressions and parameters

Environment: MS SQL Server 2008/2005, MS Access, T-SQL, SQL Server Integration Services (SSIS) 2008, MS SQL Server Reporting Services (SSRS) 2008, MS Office, Windows XP.

Hire Now