We provide IT Staff Augmentation Services!

Ms Bi Developer Resume

0/5 (Submit Your Rating)

Providence, RI

SUMMARY

  • Over 7 years of hands on experience various IT domains such as banking and healthcare SQL and MSBI Developer.
  • Highly proficient in operating MS SQL Server 2012/2008 suite of products like SSIS, SSRS and SSAS.
  • Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Testing and Implementation
  • Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
  • Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling
  • Strong SQL Server Developer experiences to develop complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL join and Query Writing. Strongly expertise to check logical and physical consistency of database by using Database Consistency Checks Utilities (DBCC).
  • Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle and MS Access.
  • Strong experiences in creating and deploying reports on web - portal by using SSRS, Report Builder and MS SharePoint.
  • Proficient in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).
  • Expert in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
  • Highly experienced 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 2008/2005 in Business Intelligence Development Studio (BIDS).
  • Good knowledge in developing Cubes and Dimensions using SQL Server Analysis Services.
  • Hands on experience in writing MDX queries to work with cube data.
  • Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
  • Conversant in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
  • Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2008/2005.
  • Strong programming and excellent analytical skills besides competent experience in handling critical situations.
  • Good presentation and communication skills and a good team player by providing healthy working environment
  • Strong leadership, communication, problem-solving and multi-tasking abilities.

TECHNICAL SKILLS

Database: MS SQL Server 2012/2008R2/2008/2005, Oracle 11g, MySQL, MS Access

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

BI Tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS)

Tools: MS Visio, MS Project, Visual Studio, Performance Monitor, SQL Profiler, Database Engine Tuning Advisor, MS SharePoint, MS Team Foundation Server

Programming languages: SQL, C#, ASP.NET

IDE: Eclipse, Oracle JDeveloper, SQL Developer

Operating Systems: Windows 7/XP

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

MS BI Developer

Responsibilities:

  • Gathered business requirements and worked in conjunction with the enterprise data warehouse architecture on the development of logical data models.
  • Installed and Configured SQL server 2008 R2/2012 on Development and production server.
  • Using complex T-SQL (SQL Queries, Joins, UDF, Trigger, Stored Procedure, and Index) to manipulate data, secure and optimize database.
  • Developed partition dimension tables and execute as parallel approach.
  • Conducted and monitored database management by usingSQL Profiler, DatabaseEngine Tuning Advisorand Index Tuning Wizard.
  • Built up high performance ETL package, migrated data from Oracle, Flat Files and MS Excel, cleaned and backed up data, and synchronized daily transactions by using SSIS.
  • Incrementally and dynamically loaded and transformed data by using SSIS (like, Change Data Capture, Slowly Changing Dimension).
  • Developed, monitored, scheduled and executed SSIS package by using MS BIDS and SQL Server Agent.
  • Generated reports from different Databases and OLAP data warehousing.
  • Executed daily report and list reports by using Pivot Command, Stored Procedures and Crystal Report.
  • Developed Parameterized reports, Drill-through reports, Drill-down reports, Matrix reports, Charts (like, Gantt chart) based on Business requirements by using SSRS.
  • Developed Ad-hoc reports and modified them by using SSRS and MS Report Builder. Created Cache reports and Snapshot reports for retrieving stored reports.
  • Developed Dashboard reports and implement them to MS SharePoint. Used MS Power View and MS Power Pivot to develop Dashboard reports.
  • Developed Dynamical reports including catching dynamical updated data from database by using VB.NET.
  • Configured out IIS, deployed and scheduled reports by using SSRS and Report server.
  • Designed SSAS solutions (Partition, Aggregations, Calculations, KPI)by using SSAS and MDX, and exported to Pivot table in MS Excel for analyzing performance of strategic business units.
  • Used MS Team Foundation Server 2010 to organize the process of project. Strong ability to handle multi tasks in project.

Environment: MS SQL Server 2008 R2/2012, SQL Server Integration Services(SSIS) 2008 R2/2012, SQL Server Analysis Services(SSAS) 2008 R2/2012, SQL Server Reporting Services(SSRS) 2008 R2/2012, HTML, IIS, VB.NET, MDX, MS TFS, SharePoint, Oracle SQL, Crystal Report, SQL Server Agent, SQL Profiler, Database Engine Tuning Advisor.

Confidential, Westborough, MA

SSIS/SSRS/SSAS Developer

Responsibilities:

  • Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
  • Performed improvement of application by replacing the old cursor logic in various triggers by writing complex T-SQL queries.
  • Reverse engineered backend database to change the T-SQL scripts, create Views, Stored Procedures, Triggers and Functions to improve performance drastically.
  • Drew the flowchart of the trigger logic to remove the repetitive pattern in T-SQL scripts to reduce dependencies.
  • Created various types of performance reports from the TFS server database using SSRS.
  • Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, PSD (Staging Database) to data warehouse (PDW).
  • Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
  • Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
  • Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
  • Created jobs on daily basis and schedule job to update recent data by using SQL Server Agent jobs.
  • Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services(SSRS).
  • Scheduled execution and delivery of end of the day report using SSRS.
  • Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008R2/2008/2005, SQL Server Integration Services 2008, SQL Server Reporting Services 2008, SQL Server Profiler, C#, VB.NET.

Confidential, Bethesda, MD

MS SQL Server/SSIS/SSAS Developer

Responsibilities:

  • Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
  • Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008.
  • Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
  • Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target DW using SSIS (SQL Server 2008).
  • Designed SSIS Packages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.
  • Handled slowly changing dimensions to maintain the history of the data.
  • Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
  • Involved in Designing and deploying cubes in SSAS environment using Snowflake Schema Designs for the operational data
  • Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyse performance.
  • Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
  • Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, MS Visual Windows 2003/2000 and T-SQL, Erwin7.2, SQL Server Profiler.

Confidential

MS SQL Server Developer

Responsibilities:

  • Involved in transferring old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using DTS Packages.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
  • Created SQL server Reports using crystal reports for the manager and the brokers involved.
  • Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
  • Tested to optimize the procedures and triggers to be used in production.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
  • Research onupgrading the SQL Server from .
  • Researched on database issues (specifically performance issues).
  • Worked on Migration of SQL Server 2000 instances to SQL Server 2005.
  • Upgraded SQL 2000 to SQL 2005 for 36 databases.
  • Administered tasks such as scheduling, deployment and security.

Confidential

MS SQL Server Developer

Responsibilities:

  • Installed SQL Server 2008 and configured the database.
  • Migrated data from Heterogeneous data Sources (Excel, Flat file, CSV file) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data in to the tables from Text files, Excel file and CSV file.
  • Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop )
  • Created SQL Server Reports using SSRS 2008.
  • Developed Master Child Package by using Execute Package Task and Parent Package Variable Configuration.
  • Modified the Existing SSIS Packages and added more audits and alerts in case of package failure
  • Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement.
  • Created Views and Synonym to reduce complexity of end user Responsibility for gathering/refining requirements from the customer for developing reports.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Identified and worked with Parameters for parameterized reports in SSRS 2008.
  • Developed and deployed Cross-Tab reports, Sub-Reports, Drill-down reports, Drill- through reports, Linked reports by using SSRS based on different business requirements. Modified parameterized reports by using VB.NET.
  • Applied graphs and images into reports. Scheduled daily/weekly/monthly reports for executives, business analysts and customer representatives in different categories and regions based on business needs by using SSRS.
  • Created and deployed Star Schema for OLAP Cube generation. Developed a multi-dimensional database, OLAP cube and Pivot Tables by using SSAS.

Environment: MSSQL Server 2008/2005, SQL Server Integration Service, SQL Server Reporting Services, Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard), Windows XP, MS Access, MS Word.

We'd love your feedback!