We provide IT Staff Augmentation Services!

Msbi Developer Resume

Chicago, IL

SUMMARY

  • 7+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008 /2008 R2/2012.
  • Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
  • Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
  • Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
  • Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
  • Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
  • Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
  • Expertise inFunctional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing.
  • Responsible for Reviews and documentation for reporting the status to the project manager.
  • Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
  • Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
  • Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
  • Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
  • Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
  • Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#, ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server Denali, 2014,2012,2008R2, 2008,2005,2000

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Informatics, Visual Studio, Cognos, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball &Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, ProClarity, Microsoft Office (MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

MSBI Developer

Responsibilities:

  • Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
  • TOAD is used to test various ETL process flow graphs to meet the Business rules and Technical Requirements.
  • Writing SQL Queries to retrieve data from database.
  • Extensively worked on debugging ETL process graphs.
  • Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
  • Provided ongoing Qlikview implementation and support.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
  • Created efficient, robust SSIS packages for data movement and loading with error checking and well-documented code.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
  • Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
  • Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
  • Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
  • Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQLServer 2008 Analysis Services (SSAS).
  • Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
  • Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
  • Repaired/recreated PPS reports damaged in the conversion process.
  • Worked on Filtered Views, views and Base table integration between different Source systems.

Environment: Windows2003 Advanced Server, ODBC, OBIEE, MS SQL Server 2005/2008/2012 , TSQL, PL/SQL 11g, Informatica, Visual Studio 2008, SharePoint 2007/2010, Qlikview, Lotus Notes, Oracle, SSRS, SSIS, Erwin.

Confidential, Minneapolis, MN

SQL Server BI/ETL/SSIS/SSAS/SSRS Developer

Responsibilities:

  • Designed and developed SSIS Packages to import and export data from MS Excel,SQLServer 2012 OLE DB and Flat files.
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers etc.
  • Involved in ETL architecture enhancements to increase the performance using query optimizer.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Created SSIS packages for Data Conversion using data conversion transformation. Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
  • Involved in developing Parameterized, Chart, Graph, Dashboard, Gauge, Data Bar reports with Drill down, Drill through and Cross-tab using SSRS base on the insurance data.
  • Experienced in writing complexSQLQueries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
  • Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
  • Developed Charts and other visualization using Power View. Developed Power Maps using Excel 2013 for Reporting.

Environment: MSSQLServer 2012, MSSQLServer Data Tools, MSSQLServer Business Intelligence Development Studio (SSIS, SSRS, MSBI SQL), T-SQL, MSSQLServer Management Studio (SSMS), Power BI, Power View, Power Maps, Power Pivot, TFS, Reporting Services Configuration Manager, Windows 7/8, TFS.

Confidential, Overland park, KS

SSIS/SSRS/SSAS Developer

Responsibilities:

  • Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
  • Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
  • Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
  • Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
  • Worked on Database Compression for different databases to save space across different environments.
  • Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
  • Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
  • Repaired/recreated PPS reports damaged in the conversion process.
  • Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
  • Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
  • Interacted with vendors, developers and customers to manage the business requirements.

Environment: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition, ODBC, OBIEE, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.

Confidential, Minneapolis, MN

SQL Server Developer/SSIS Developer

Responsibilities:

  • Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
  • Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
  • Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
  • Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
  • Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
  • Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
  • Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
  • Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
  • Designed and developed custom .NET components and user controls using ASP.NET
  • Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
  • Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQL Server 2005, 2008Integration services.
  • Involved inrelational database modelinglike, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
  • Created complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage config files.
  • Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
  • Created Tablix reports, Tabular/Matrix reports based on requirements.
  • Created Dashboards using SSRS.
  • Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
  • Created databases, tables, and fields for data entry,performingdatabase capacity planning.
  • Enhanced anddeployed the SSIS packagesfrom development server to production server andscheduled jobs.
  • Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

Confidential

SQL Server BI Developer

Responsibilities:

  • Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
  • Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
  • Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
  • Responsible for Design and Normalization of the database tables.
  • Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
  • Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
  • Gathered requirements for the creation of Data Flow processes for the SSIS packages.
  • Used various Control Flow Tasks in the development of various complicated packages.
  • Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Developer and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
  • Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
  • Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
  • Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
  • Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
  • Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2000/2005, T-SQL, Windows Server, Microsoft Visio, Performance Monitor, SQL Server Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).

Hire Now