Msbi Developer Resume
New Sterling, VA
SUMMARY
- Over 6+ Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2014/2012/2008 R2/2008/2005 in Production, QA and Development Environments.
- Strong experience with T - SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
- Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
- Experience in Error handling and debugging coding issues and troubleshoot production problems.
- Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2005.
- Experience in Managing Security of SQL Server 2005/2008 R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
- Expertise in SQL Server 2005 Reporting Services (SSRS) and SQL Server 2005 Integration Services (SSIS) and in Business Intelligence (BI).
- Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2).
- Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
- Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
- Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
- Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
- Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
- Good knowledge in creating OLAP cubes using SQL Server analysis services (SSAS).
- Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
- Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Vision and Erwin Tool for logical and physical design of databases.
- Skilled in design of logical and physical data modeling using Erwin data modeling tool.
- Worked with Business Analysts, Web development team, and users on database solutions.
TECHNICAL SKILLS
Databases: SQL Server 2015/2016, 2012/2008 R /7, Access, MySQL
Database Tools: SQL Server Management Studio, Query Analyzer, Query Optimizer, SQL Profiler, Business Intelligence Development Studio(BIDS),Visual studio 2010/2008 (SSIS/SSRS), POWER BI
Languages: T-SQL, PL/SQL, Java, C++, C#, Python, JavaScript, HTML, CSS
Reporting Tools: SQL Server Reporting Services (SSRS), Report Builder
Version Control Tools: Visual Source Safe (VSS), Team Foundation Server (TFS), GIT Hub, Microsoft Office SharePoint
Operating Systems: Windows Server2003/2008, Windows XP/7/8.1/10, Linux(Fedora)
PROFESSIONAL EXPERIENCE
Confidential, New Sterling, VA
MSBI Developer
Responsibilities:
- Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
- Involved in database Schema design and development.
- Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
- Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
- Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
- Executed stored procedure using BATCH files.
- Developed stored procedures and functions for designing various reports.
- Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
- Used Batch Files to Import Data from other Data Bases.
- Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
- Enhancing and deploying the SSIS Packages from development server to production server.
- Wrote the ETL scripts to load the data into database from various source files. Experienced in error
- Handling and troubleshooting the scripts in failure to load the data into database.
- Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
- Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
- Expert in SSIS Deploying and Scheduling
- Identified and Defined Key Performance Indicators in SSAS 2008.
- Defined report layouts for formatting the report design as per the need.
- Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
- Generated Reports using Global Variables, Expressions and Functions for the reports.
- Created reports and Dash boards using Microsoft Performance Point service.
- Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
Environment: SQL Server 2008/2012/2014 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#,VB.Net, XML, Visual Studio 2008 &2005,MS Visio 2007.
Confidential, Lexington, MA
MSBI / SSRS Developer
Responsibilities:
- Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
- Involved in designing the physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
- Extensively used T-SQL to manipulate and architect to produce results for users.
- Performance tuning of Queries and Stored Procedures.
- I Used SQL profiler to view indexes performance to mostly eliminate table scan.
- Worked with development teams in the design of physical databases and in modification.
- Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
- Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
- Created SSIS process design architecting the flow of data from various sources to target.
- Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
- Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
- Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
- Created ETL SSIS packages both design and code to process data to target databases.
- Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
- Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
- Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2008 R2 Reports Services (SSRS).
- Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007.
- Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
Environment: SQL Server 2008/2012 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, MS Access 2003,Oracle, PL/SQL,VB.Net,ASP.NET, XML, Visual Studio 2008 & 2005,MS Visio 2007,TFS.
Confidential, Fort Worth, TX
SQL Developer
Responsibilities:
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
- Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
- Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
- Extract, Transform and Load source data into respective target tables to build the required data marts.
- Created ETL process using SSIS to transfer data from heterogeneous data sources.
- Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
- Designed SSAS cube to hold summary data for Target dashboards.
- Developed Cube with Star Schema.
- Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
- Responsible for gathering business requirements to create business user reports.
- Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
- Generated Reports using Global Variables, Expressions and Functions for the reports.
- Responsible for scheduling the subscription reports with the subscription report wizard.
- Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
- Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
- Proficient in configuring the Report Server and Report manager to set up roles and security on the reports.
- Hands-on experience of setting up schedules for push and pull delivery methods using Standard and Data Driven subscriptions in SSRS
Environment: Microsoft SQL Server 2008 Enterprise Edition, MS Access, ETL Packages (SSRS,SSIS), PL/SQL,,VB.Net,ASP.NET, HTML, Visual Studio 2008 &2005, DTS, T-SQL, Oracle, TFS.
Confidential, Augusta, ME
SQL Server Developer
Responsibilities:
- Analysis, Design and data modeling of Logical and Physical database using E-R diagrams.
- Involved in database Schema design and development.
- Designed tables, constraints, necessary stored procedures, functions, triggers and packages using T-SQL.
- Audited the Front-end application calls to SQL Server.
- Created efficient Queries, Indexes, Views and Functions.
- Enforced Security requirements using triggers to prevent unauthorized access to the database.
- Optimized the Database for best performance, with DBCC, partition table.
- Design and develop the payroll module using MS SQL Server 2008.
- Migrated data from MS Access to SQL Server.
- Performance Tuning of the client databases for better performance on a regular basis.
- Responsibilities include writing of scripts for Database tasks, releasing Database objects into production.
- Running DBCC consistency checks, fixing data corruption on application Databases.
- Worked in establishing connectivity between VB applications and MS SQL Server by using ADO.
Environment: SQL server 2008, Oracle, MS VB Access, Windows 2003 Standard Edition, Windows
Confidential
MS SQL Server Developer
Responsibilities:
- Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system.
- Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).
- Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
- Implemented Exceptional Handling.
- Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
- Creating and automating the regular Jobs.
- Tuned and Optimized SQL Queries using Execution Plan and Profiler.
- Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
- Involved in performing database Backup and Recovery.
- Worked on Documentation using MS word.
Environment: Windows 2000 Server, SQL Server 2005, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.
