We provide IT Staff Augmentation Services!

Sr. Msbi Consultant Resume

Wilmington, DE

SUMMARY:

  • Microsoft SQL & BI developer with 6+ years of experience as database developer and data analyst with Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005, SSIS/SSRS/SSAS, OLTP and Power BI in various domains.
  • Participated actively in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, go live and Post Go Live Support.
  • Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL.
  • Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Experienced in programming Tasks Stored Procedures, Triggers, Functions, Views, CTE queries, T-SQL scripts, Cursors in various versions of SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016.
  • Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
  • Migrated data in various formats like text files, Excel spreadsheets etc. to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
  • Experience in solving Real Time issues with Index fragmentation, Index rebuild and reorganize, DBCC checks, Query Tuning, Error and Event Handling.
  • E xperience in the Design, Modeling, Development, Implementation, Maintenance in SQL Server Business Intelligence Developer (SQL, T-SQL, DTS, SSIS, SSRS Database Queries).
  • Strong Communication & Management skills with Excellent Role-playing capabilities and deliver under pressure and committed to teamwork.
  • Expert in creating various types of complex reports using SSRS (SQL server reporting services)
  • Working knowledge on Power BI reports.
  • Extensive knowledge in Administering, Managing and Troubleshooting Reporting services.
  • Experience in using Team Foundation Server tool.
  • Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
  • Good Domain knowledge around Financial services Industry and Manufacturing.
  • Prior experience with Quality Assurance and System analysis as well.

TECHNICAL SKILLS:

Developmental Skills: SQL, T-SQL, C#

MSBI Tools: SSIS, SSRS, SSAS, Report Builder, Power BI

Tools: & Utilities SQL Server Management Studio (SSMS) SQL Server Enterprise Manager

SQL Profiler: SQL Server Business Intelligent Studio (BIDS)

Team Foundation Server (TFS): Visual Studio

Databases: MS SQL Server 2005/2008/2008 R 2/2012/2014/2016 , MS Access.

GUI/Tools: MS Word, MS Excel, MS PowerPoint.

Operating System: Windows 10, 8/2008/2007.

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Sr. MSBI Consultant

Responsibilities:

  • ES XF uses data from a variety of source databases which contain data pertaining to a large variety of content sets including Financials, estimates, Equity prices and Company ownership. So, created SSIS packages to export huge data containing over 10 million records into SQL server database which has 10 partitions including PRIMARY FILE GROUP.
  • Worked on Subscribers and Publications as part of Replication scripts. Data is delivered into the XF feeds databases through replication set up on the tables containing data to delivered via XF.
  • Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS and in adding calculations using MDX.
  • Optimized MOLAP Cubes by partitioning them, Designing Aggregations, implementing Hierarchies and Calculated Members. Worked on MDX queries to access Cubes.
  • Extensively worked on ETL to transform data and load it into the DWH.
  • Real-time replication transfers the source data tables to XF environment servers and these tables have CDC in place. So, worked on CDC as part of it.
  • XF delivers this data to clients in subscribed packages. Each package typically has two forms - full and transactional delivery. So, worked on delivery packages using SSIS features.
  • Utilized GoldenGate for data replication where data is originated from both Oracle and SQL Server data sources.
  • Configured data partitioning/table partitioning on large tables containing millions of rows in Data ware house databases for better performance and performed Data Compression on large tables to reduce the Database size.
  • Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
  • Created Variables, Expressions for Connection String, Project Parameters, Package Configuration,
  • Parent package variables. Worked on Project level deployment in TFS 2012.
  • Created complex SQL scripts to implement Initial load and Incremental load of tables.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
  • Worked on SSRS 2016 to build parameterized, drill- down, interactive reports and dashboards for Business users to make decisions.
  • The XF metadata is used by the ES XF Engine to generate the feeds, to populate the FeedConfig file that is distributed with the data files, to create and maintain data tables etc. Worked on the implementation logic to achieve it.
  • Implemented the project using Agile/SCRUM methodology.

Technological Environments: SQL Server 2016, T-SQL, SSAS, TFS, SSIS, SSRS, VSTS.

Confidential, Wilmington, DE

MSBI Consultant

Responsibilities:

  • Created Data Flow diagrams and flow charts to display the flow of information in the system and make users understand the functionalities.
  • Worked with design and admin team to design physical database and its modifications.
  • Responsible for project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
  • Performed Data Analysis and Data profiling using SQL on various sources.
  • Collaborated with fellow team members through Team Foundation Server (TFS) for effective project management, which includes work issues and track on the update of versions.
  • Designed/build/deployed the SSIS package to import data from different data sources and performed ETL process before loading the data in to data warehouse using SQL server integration services (SSIS).
  • Created ETL SSIS packages both design and code to process data to client databases.
  • Created SSIS template for developing SSIS packages to dynamically deploy the packages into the development, Testing, and production environments.
  • Worked with Team Foundation Server (TFS) to report source code for Packages in Visual Studio 2012.
  • Created different formats of the reports using SSRS as per the end user and business requirements.
  • Worked on Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
  • Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
  • Performed system testing for the SSIS packages and SSRS reports.
  • Used Notification services to generate error messages and notify users through e-mails.
  • Participate in service operational reviews, ensuring SLA’s are met as per Clients Requirement.
  • Design, develop and implement database systems and store procedures based on client requirements.
  • Executing Oracle, SQL Server objects and compare data & performance statistics.
  • Creating OLTP tables and in-memory tables in SQL Server 2016 to improve database performance.
  • Working with Modern Apps developers to remediate application & test functionalities in Oracle & SQL Server.

Technological Environments: SQL Server 2012 R2, T-SQL, Windows 7, SSRS, SSIS, Team Foundation Server (TFS), Power BI, MS Visio, SharePoint, SCRUM.

Confidential, Birmingham, Al

SQL Developer

Responsibilities:

  • Gathered requirements and prepared business requirement documents (BRD).
  • Analysis of the requirements and providing estimation.
  • Development of new process.
  • Unit Testing.
  • Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
  • Created Database Objects - Tables, Indexes, Views, User defined functions, CTEs, Cursors, Triggers, Stored Procedure and Constraints.
  • Worked on Deploying Packages and providing security while deploying.
  • The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
  • Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
  • Tuned, monitored and maintained SQL Server Jobs.
  • Implemented database management techniques that include backup/restore, import/export and generated scripts.
  • Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.

Technological Environments: SQL Server 2012, BIDS, T-SQL

Confidential

SQL Developer

Responsibilities:

  • Analysis of the requirements and providing estimation.
  • Unit Testing.
  • Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Worked on Deploying Packages and providing security while deploying.
  • Tuned, monitored and maintained SQL Server Jobs.

Technological Environments: Windows Server 2005, SQL Server 2005, SSRS

Confidential

Team Lead/Sr. Developer

Responsibilities:

  • Developed GUIS.
  • Created developed images for German and Chinese languages.
  • Won the best performer award for the initiative in trying to automate the wireless testing.
  • Automated test process in GUI validation and wireless testing.
  • Worked in unison with Patni team members and Confidential tech members.

Confidential

Developer

Responsibilities:

  • Understanding Change request sent by the client.
  • Designed the User Interface for Viewer and Downloader module.
  • Development and Testing.
  • Created test cases and designed the format for the CSV file.
  • Developed reports using Active report tools.
  • Participated in business analysis meetings reviewing the requirements and end users to create user scenarios and functional specifications.

Environment: .NET 3.5, C#, VC++, Microsoft Visual Studio 2003, Windows XP, Windows server 2002, Oracle.

Hire Now