SEARCH

MSBI Developer Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
MSBI DEVELOPER
Summary
  • Over 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/2008R2/2012/2014.
  • Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations. Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
  • 5+ years of experience in Analysis, Design, Development and Testing of Client-Server and Web-based n-tier Architecture for windows and web applications using Microsoft .NET Technologies. Good Exposure to entire Software Development Life Cycle (SDLC), documentation of software products with Agile Scrum methodology and also experienced in working with waterfall model.
  • 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
MSBI Developer02/2015 to 03/2016
UnitedHealth GroupSan Diego, CA
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • 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/2012) 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.
  • Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
  • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
  • 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.
  • Assists in the implementation of data access security measures by identifying, analyzing and resolving security and system problems relating to data access security and applications.
  • Extract and analyze data from internal databases to inform business decisions and actions and create reports and tools using VBA, MS Accesses, MS Excel, VB, and SQL With the ease of TFS, managed user permissions among team projects and also, further made it easy to identify any missing permissions.

  • Environment: Sql Server 2014/2012/2008R2/2005, T-Sql, TFS, Excel, MS Visio.
MSBI Developer03/2014 to 02/2015
T-MobileAtlanta, GA
  • Interacting with Business users, gathering and analyzing requirements.
  • Worked in test based Development process.
  • Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
  • Worked on creating Analysis and mapping documents.
  • Created SSIS Data Migration Template using sql server 2012.
  • Involved in developing Packages for implementing business logic through Stored Procedures and Functions.
  • Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) and stored procedures to overcome the transformation constraints.
  • Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL.
  • Worked on migrating data from non-relational database to relation database.
  • Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
  • Written complex stored procedures and SQL queries.
  • Worked on tuning the queries and fixing the stored procedures to get the data consistency.
  • Monitored SQL Profiler and Database Engine Tuning Advisor.
  • Recovering the databases from backup in disasters.
  • Implementing Point-In-Time Recovery solutions.
  • Unit Testing the SSIS packages with respect to its flow and performance issues.
  • Implemented Error handling and utilized Event handlers for automated notifications using SSIS.
  • Worked on creating many ad hoc and scheduled reports using SSRS.
  • Created drill down, drill through, sub and linked reports using MS SSRS 2012 as well as managed the subscription of the reports.
  • Designed and implemented ETL job restart ability using Checkpoints and optimal package design techniques in SSIS.
  • Working on TFS version tool.

  • Environment: Sql Server 2012/2008R2/2005, T-Sql, TFS, Excel, MS Visio.
SQl/MSBI Developer04/2013 to 02/2014
CenturyLinkMonroe, LA
  • CenturyLink is a global communications, hosting, cloud and IT services company enabling millions of customer to transform their businesses and their lives through innovative technology solutions. CenturyLink offers network and data systems management, Big Data analytics and IT consulting, and operates more than 55 data centers in North America, Europe and Asia. The company provides broadband, voice, video, data and managed services over a robust 250,000-route-mile U.S. fiber network and a 300,000-route-mile international transport network

  • Designed SSIS Packages, and/ or enhanced the existing SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task etc. to extract data from disparate sources (SQL Server, Oracle, Teradata, Access and Excel) to generate underlying data for the reports.
  • Developed T-SQL query, stored procedures and functions to retrieve data for reporting.
  • Validated the daily, weekly, monthly grain transformed data by comparing it with the source system.
  • Worked with internal customers to gather and analyze business requirements in order to identify and solve problems.
  • Responsible for building the report solution like drill-down, drill-through, and linked reports using SSRS, testing for quality and finally review with the customer to ensure the solution meets requirements.
  • Supported the efficient delivery of standard and ad-hoc reports with an emphasis on automating where possible.
  • Generated weekly, monthly and quarterly reports for the management using different techniques like data filtering, adding interactivity, deploying reports to report server in SSRS.

  • Environment: MS SQL Server 2012, MS SQL Server Integration/Reporting Services/ Analysis Services (SSIS/SSRS/SSAS), XML, Visual Studio 2010, C#.net.
SQL Server BI Developer02/2011 to 03/2013
BlueCross BlueShield AssociationChicago, IL

  • Blue Finder application provides all the BCBS members to locate a doctor, hospital or urgent care. This application also allows performing a nationwide search for a healthcare provider by specialty and name, either as a member or guest. BCBS members can login to their accounts using this application, and they can check their status and perform the actions. Allows use of Google API's to find nearby doctors and hospitals.

  • Responsibilities: Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.
  • Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
  • Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
  • Modified the existing SSIS packages to meet the changes specified by the users.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Developed Aggregations, Partitions and Calculated Members for cube as per business requirements.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
  • Worked on formatting SSRS reports using the Global variables and expressions.
  • Created Parameterized reports, Drill down and Drill through reports using SSRS.
  • Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
  • Responsible for Monitoring and Tuning Report performance.
  • Configured the report viewing security for various users at various levels using Report Manager.

  • Environment: SQL Server 2008/2008R2, BIDS 2005, SQL Server Reporting services 2012, Integration Services , Analysis Services , Oracle9i, DB2, TFS SQL Developer/SSIS/SSRS.
SQl/MSBI Developer10/2010 to 02/2011
United Parcel Service UPSLouisville, KY
  • UPS is a leading global Freight Bill, Invoice Audit, Payment & Logistics Management Services Company offering enterprise-wide supply chain solutions.As a global business Partner, N Vision not only provides a prompt, accurate Freight Payment solution but, industry-leading information management Services necessary to help clients maximize efficiencies within their supply chain.

  • Responsibilities: Work closely with management and end-users to create and evaluate business requirements.
  • Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
  • Used different Control Flow Tasks and Data flow Tasks for creating SSIS Packages.
  • Designed packages using different types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks Experience in Error handling and debugging coding issues and troubleshoot production problems.
  • Involved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.
  • Involved in Extraction, Transformation amp; Loading (ETL) process and used Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor Implemented Informatica 8 new SQL transformation for executing SQL statements.
  • Involved in CreatingComplex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drilldown Reports.
  • Experience in writing custom code expressions in SSRS.
  • Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level Created Report Models for Business Users to create their own reports.
  • Designed & created OLAP Cubes with Star schema using SSAS 2008 R2.
  • Created Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
  • Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Create and maintain data model/architecture standards, including master data management (MDM).
  • Used master data management (MDM) to define reference data Managed security and user access to Analysis Services cubes using creation of Groups and Roles by creating windows AD and also Perspectives within the OLAP cube.
  • Monitoring nightly ETL process from various highly different source systems.
  • Sources included SQL based databases and Excel Files.
  • Also ensured that nightly backup jobs or cube processing or other ETL jobs didn't interfere with each other.
  • Managed SQL 2005 and 2008 R2 databases and nightly SSIS Processes.
  • Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
  • Monitoring the scheduled SSRS and Crystal reports.
  • Re-running the reports in case of any failures or data mismatches.
  • Involved in deploying the changes to QA, Staging and Prod environments.
  • Managed off shore team in Report migration project.
  • Followed agile methodology and coordinated daily scrum meetings.
  • Involved in Product Releases and support calls.

  • Environment: SQL Server 2008/2008R2, Windows Server 2003/2008R2, T-SQL, SSIS, SSRS, SSAS, Crystal Reports, BIDS.
Junior SQL/MSBI Developer03/2009 to 10/2010
MetLifeCary, North Carolina
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
  • Having hands on experience in DR Processes including Log Shipping and Database Mirroring.
  • Analyze large data sets and patterns using TSQL, Power BI, advanced Excel models like PowerPivot and Power Query to identify opportunities and risks in current operations and define solutions in daily business operations.
  • Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
  • Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
  • Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
  • Working knowledge with DMExpress ETL tool to filter data based on end requirements.
  • Working experience with Column store indexes, table partitioning in SQL SERVER 2012.
  • Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
  • Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008.
  • Create Calculate member in MOLAP cube using MDX in SSAS 2008.
  • Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
  • Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Configured Reporting Services in SQL Server 2008.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

  • Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL.
ETL developer11/2007 to 02/2009
Apollo Hospitals Hyderabad, India
  • Created SSIS packages to automate the ETL processes included Meta data on record count, file size and run time
  • Involved in Index Analysis and Performance Tuning.
  • Worked on reconciliations of balances from different systems.
  • Analyzed requirements with developers, business analysts and provided my inputs. 
  • Wrote and executed the test cases to perform System, Functional and Regression testing.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Wrote and edit SQL queries for database testing and reports verification.
  • Created SSIS packages, deployed on server and worked with DBA to run the package.
  • Worked on creating Run Book for the packages created to be executed.
  • Worked on StarTeam application to check in and check out the codes.
  • Worked on creating Visio diagrams to explain the design process.
  • Actively ensuring the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.

  • Environment: Sql Server 2005/2000, T-Sql, MDX, MS-Office, MS Access, Visio, ErWin.
Education
Bachelor of Technology: Computer ScienceJNTU,HYDIndiaComputer Science
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), Informatica, Visual Studio, Cognos, Crystal Reports, VBA Add-Ins, Excel Data Sorting Customer Service Data Scrubbing 

Excel Macros Logical Thinking QC Process 


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, Power Bi, Cubes(tabular).


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









Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • UnitedHealth Group
  • T-Mobile
  • CenturyLink
  • BlueCross BlueShield Association
  • United Parcel Service UPS
  • MetLife
  • Apollo Hospitals

School Attended

  • JNTU,HYD

Job Titles Held:

  • MSBI Developer
  • SQl/MSBI Developer
  • SQL Server BI Developer
  • Junior SQL/MSBI Developer
  • ETL developer

Degrees

  • Bachelor of Technology : Computer Science

Similar Resumes

View All
MSBI-Developer-resume-sample

MSBI Developer

Duke Energy

Atlanta, Georgia