We provide IT Staff Augmentation Services!

Msbi Developer Resume

Richmond, VA

SUMMARY

  • Over 9 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.
  • Ability to work in all stages of System Development Life Cycle (SDLC).
  • Experience in Error handling and debugging coding issues and troubleshoot production problems.
  • 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 using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Expertise in SQL Server 2005 Reporting Services (SSRS), SQL Server 2005 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) 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.
  • 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.
  • Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
  • Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
  • Integration of SSRS Reports using various web parts into Sharepoint (MOSS 2007) and various delivery mechanisms.
  • Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
  • Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
  • Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
  • Experience in .NET/C# application development environment to use SQL Server Databases.
  • Good experience 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

Tools: &Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0ProClarity 6.2,SharePoint 2007

BI Tools: SSIS, SSAS, SSRS.

Databases: MS SQL Server 2000/2005/2008 , MS Access 97/2003/2005/2008.

Language: T-SQL, PL/SQL, MDX,C, VB.net, C# (.NET)

Operating Systems: Windows vista/XP/2003/2000, Windows Server 2000/2003/2008 , UNIX.

Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services.

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Richmond,VA

MSBI Developer

Responsibilities:

  • Requirement Design and implement new BI/reporting solutions as per requirements gathered with business stakeholders.
  • Supported Business Intelligence, Data Warehouse bug fixing and daily money imbalance tickets.
  • General production support including SQL querying databases, SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services report creation running recurring reports.
  • Developed SQL scripts to resolve production issues and create reports.
  • Data Investigation and reporting - Extracts data from operational systems and reporting databases using a variety of tools, including SSIS. Worked on identifying relationships within the data and between databases, understands requirements of the customer, and the location of required data.
  • Answers developer and end user questions through the development life cycle
  • Completes functional testing on assigned projects.
  • Prepared documentation of methods, business requirements, SQL coding, and reporting criteria to a level consistent with departmental standards.
  • Explicitly used third party tool like Red gate for SOX auditing code schema changes for production servers VS previous change sets and submitted weekly and quarterly schema changes to KPMG.
  • Handled all the deployments using TFS from development to production servers using Footprint ticketing tool.
  • Worked on generating monthly renewals after the month end load.
  • Worked on couple of projects like encrypting Personally identifiable information in data warehouse and Guide wire project etc.
  • Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
  • Written automated batch scripts to pull files from SFTP path and process the files and backup them to archived path and delete from source path.
  • Written various T-SQL scripts to check whether data is ready from different sources and to view database tables log that accessed last time.
  • Used master child SSIS packages for better design and ease of maintenance.
  • Verify backend data with frond end Agency dashboard application.
  • Rebuilding Indexes and statistics as part of performance tuning exercise.
  • Created complex stored procedures, functions, ETL packages.
  • Worked with a team of business analysts, data architects, application developers, ETL developers to fix policy/clearance related data in the data warehouse.
  • Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.

Environment: SQL Server 2008 R2, 2014, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, Windows Servers, SharePoint, TFS.

Confidential, New Jersey, NJ

SQL Server/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 proc 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 Base.
  • Used SSIS to create ETL packages 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 2005/2008.
  • Process SSAS cubes to store data to OLAP databases
  • 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.

Confidential, Richmond, VA

SQL Server/SSIS Developer/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.
  • 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.
  • Constructed OLTP and OLAP Databases.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
  • Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
  • OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
  • 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 2005/2008 R2 Reports Services (SSRS).
  • Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
  • Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
  • Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
  • 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, SharePoint, PL/SQL, C#,VB.Net,ASP.NET, XML, Visual Studio 2008 & 2005,MS Visio 2007,TFS.

Confidential, New York, NY

SQL Server/BI Developer

Responsibilities:

  • Understand user requirements and Data Model defined and developed by the business analysts and data architects.
  • 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.
  • Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
  • 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 Targit.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
  • Responsible for gathering business requirements to create business user reports.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
  • 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.

Environment: Microsoft SQL Server 2005/2008 Enterprise Edition, MS Access, ETL Packages (SSRS,SSIS),Great Plains, PL/SQL, C#,VB.Net, HTML, IIS, Visual Studio 2008 & 2005, Visual Source Safe, DTS, T-SQL, VSS,TFS.

Confidential, VA

SQL Server Developer

Responsibilities:

  • Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
  • 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 2005.
  • 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.
  • Supporting ADO and Active-X connectivity to the database

Environment: SQL server 2000/2005,Oracle 9i/10G, MS VB Access, Windows 2003 Standard Edition, Windows 20

Confidential

SQL Developer

Responsibilities:

  • Involved in installation and configuration of SQL server 2000 on Servers.
  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Implement and maintain database security.
  • Implemented trigger and stored procedures and enforced business rules via checks and constraints.
  • Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
  • Going through the clients' requirements and coming up with database design and application architecture.
  • Troubleshoot and minimize production down issues.
  • Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
  • Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
  • Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
  • Data conversions and data loads from various databases and file structures.
  • Monitor failed and long running MS SQL Server jobs.
  • Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
  • Maintaining User account administration for Different domains.

Environment: MS SQL Server 2000/2005, SSIS, Visual Studio 2005, VB.net 2005.

Hire Now