We provide IT Staff Augmentation Services!

Senior Msbi Consultant Resume

Wilmington, NC

PROFESSIONAL SUMMARY:

  • Over 14 years of IT experience with strong software development background for the domains Manufacturing, Finance (Treasury - Derivative Trading risk management), Healthcare, Telecom e-commerce Intranet B2B, Automotive
  • 10 plus years of experience in requirements gathering, analysis, design, development, implementation and maintenance of Databases, SSRS, SSIS, SSAS and Power BI as developer and technical leader
  • Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2008 R2/2012
  • Experience in analyzing, mapping, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
  • Experience in Data Modelling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints, Development, Implementation, ETL and Reporting in SQL Server
  • Good Database development experience for both OLTP & OLAP Systems using MS SQL Server. Normalization/De-normalization concepts, database design methodology.
  • Experience in Crystal Reports and actuate reporting development
  • Familiar with Azure data factory, Blob storage, SSIS Integration and agile concepts
  • Experience on system analysis, data analysis, migration projects BO to SSRS
  • Software development life cycle (SDLC) experience in all phases of Experience in QA, UAT, Production support
  • Ability to understand business processes and create technical solutions to meet those needs. Good analytical, problem troubleshooting/solving skills
  • Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player
  • Maintain good relation and working experience with multiple stake holders like business users, analysts, department heads, supervisors, planning leads, functional teams to design solutions as per the business requirements
  • Extensive knowledge and experience in developing scripts using T-SQL for querying against databases and query optimization Involved in designing numerous DB Objects like Tables, Constraints (Primary Key, Foreign Key, Unique), Indexes, Defaults
  • Involved in writing Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL
  • Experience in writing complex Stored Procedures, Indexed Views and Triggers for data consistency and manipulation.
  • Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities
  • Involved in Scheduling jobs using SQL Server Agent, Windows task scheduler
  • Test & Deploy across various SDLC Environments like QA, UAT, Production
  • Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS across various environments
  • Proficiency in Adhoc queries and Reports for Companywide users pulling data from data warehousing systems
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, Drill Down, Drill Through, Parameterized, and Cascaded, Graphs, Scheduling reports.
  • Building dynamic Cube reports using sass as data source
  • Experience in creating Adhoc reports, data driven subscription reports by using Report Builder in SSRS.
  • Report Performance tuning snapshot and cashing
  • Report utilization usage reports
  • Report manager activities
  • ETL source destination mapping and design documentations
  • Experience in designing SQL Server SSIS packages to import and transform data between databases and external data sources using various data transformation controls
  • Used control & data flow transformations like containers, OleDB command, execute SQL task, send mail task, derived column, conditional split, lookup, multi cast and script task etc
  • Proficient in High Level Design of ETL Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file).
  • Performance tuning source, transform, destination optimization
  • Experience in setting execution Auditing and Notifications by using Logging, Event Handler and execution utilization reports
  • Experience data loading ODC and data warehouse dimensions and facts tables
  • Troubleshooting and Configuration SSIS packages for portability
  • Experience in deploying the SSIS Packages with Package and Project deployment in SSIS Catalog, MSDB and file system from development, QA to production server.
  • Experience in creating Jobs, Alerts and schedule SSIS Packages.
  • Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
  • Experience in Designing and Building the Dimensions and cubes with star and snow flake schemas using SQL Server Analysis Services (SSAS).
  • Developed OLAP Cubes using SSAS with partitions, actions, KPI’s, Proactive caching, perspectives, slow changing dimensions
  • MDX Expressions
  • Used SSAS Cube in SSRS reporting and Power BI
  • Experience in developing Power BI Reports, Dashboards and Power BI Mobile report development.
  • Worked on all kind of reports such as drilldown, drill through and KPI based reports
  • Experience Direct Query, Live Connection, Import data connectivity
  • Used various sources into Power BI such as Oracle, Sql Server, SharePoint, and Excel etc
  • Created stored procedures and SQL queries to pull data into power pivot model
  • Data Modelling from multiple data sets, building relations and hierarchies
  • Used workbooks, Visuals with DAX, Custom Visuals
  • Create and publish Workspace App for business users to view the developed reports/dashboards by providing required access to the users
  • Q&A feature, What If parameters implementation in the reports
  • Scheduling automatic data refresh, row level security in power bi service
  • DAX expressions and Familiar with managing Gateways, create data sources

TECHNICAL SKILLS:

RDBMS: SQL Server 2000/2008/2008 R2/2012, Oracle, MS Access

Languages: T SQL, PL/SQL, MDX, VB

Tools and Packages: SQL Server Management Studio, Profiler, SQL Server Business Intelligence Development Studio (BIDS), Crystal Reports9.0, Visual SourceSafe6.0, SVN

Database Design Tools: MS Visio, Erwin

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

PROFESSIONAL EXPERIENCE:

Senior MSBI Consultant

Confidential, Wilmington, NC

Responsibilities:

  • Supporting day to day business needs for the plant business uses and leadership
  • Reporting requirements gathering from the business users, analyse, design, develop, publish to the production for business to access and production support
  • Used BI tools and Databases like SSIS, SSRS, SSAS, POWER BI, SQL Server, Oracle
  • Part of the report development Manufacturing Performance and Productivity budget vs actual Variance, Inventory, Planning, Plant Safety, Subroom Productivity reports being developed for the leadership team to make key decisions using ETL(SSIS), SSAS, SSRS, Power BI from sources Oracle, Excel to SQL Server
  • Cleanroom reporting : Splicing is one most important area in the plant, developed bunch of reports to represents Splice Efficiency, Rate, BAS reporting, By Room, Bench, Operator levels, Daily performance reports using SSRS, SSIS, SSAS, Power BI , Oracle, SQL Server
  • Fiber reconciliation reports : Power BI dashboard and reports have been created to visualize the production output in various stages like Draw, Bounce, WIP, Inventory and Losses of the fiber.
  • Involved Model, Design, Development of Data warehouse/ETL/BI Solutions
  • SQL Server integrations services (SSIS) package development, Proficient in High Level Design of ETL Package for integrating data from heterogeneous sources (Excel, CSV, SQL Server, Oracle, flat file). creating Jobs, Alerts and schedule SSIS Packages using SQL Server agent
  • Reports development using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, Drill Down, Drill Through, Parameterized, and Cascaded reports, Charts, subscriptions
  • Experience in Designing and Building the Dimensions and cubes with star and snow flake schemas using SQL Server Analysis Services (SSAS), MDX Expressions
  • Power BI Reports and dashboards have been created for the cleanroom and subroom outputs reel counts, fiber lengths and backlogs in specific production areas

Senior MSBI Consultant

Confidential, Stamford, CT

Responsibilities:

  • Data Analysis of Derivative Trade Source Data of Wall Street (WSS), FXPRESS, BONY and Global Banks
  • Data Modelling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints
  • Involved in data modeling for OLTP and Data Warehouse using Visio Data Modeler.
  • Total responsibility for all development and implementation of database, work that includes OLTP Database as well as various reporting data marts, ETL, providing data feed to various groups.
  • Created SSIS Packages using SSIS Designer to export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
  • Migrated Legacy data using SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
  • 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).
  • Creating multiple reports (SSRS) in Drill mode using backpack tables, crosstabs and charts
  • Actively involved Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.
  • Created Multidimensional cube using SSAS.
  • Deploying the changes to the Cubes in production databases and scheduled the processing of cubes as a SQL Server agent job.
  • Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers.
  • Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs trading data.
  • Used different Control Flow Tasks for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
  • Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types
  • Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and file files
  • Involved in Automating SSIS Packages using SQL Server Agent Jobs
  • Deployed Packages on both File System and SQL Server MSDB Using bat files, dtexec Utility and Import - Export Wizard
  • Implemented Complex ad-hoc Reports , Sub Reports, Linked Reports, Charts, Drill through , and Report Models Drill Down Reports, Email Subscriptions
  • Designed Large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters
  • Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views, MDX

MSBI Consultant

Confidential

Responsibilities:

  • System analysis for sales, manufacturing and marketing areas of the Alightech applications
  • Design ETL framework and set standards for overall data transfer from the various data sources to the Enterprise Services Warehouse, which encompasses extraction, Transformation.
  • Extensively used SSIS to implement Extract, Transform and Load from OLTP databases to staging area and finally transfer into data marts.
  • Optimized performance by tuning queries by modifying the existing index system and rebuilding indexes.
  • Worked extensively in writing and debugging complex queries, stored procedures, dynamic SQL Queries, Correlated Sub Queries, views, triggers, cursors and User Defined Functions.
  • Implemented Complex ad-hoc Reports , Sub Reports, Linked Reports, Charts, Drill through , and Report Models Drill Down Reports, Email Subscriptions
  • Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
  • BO to SSRS reports migration summary a detailed report
  • Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages . Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
  • Created and maintained Packages using Complex Store Procedures and T-SQL queries, Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types
  • Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and file files

Onshore Lead

Confidential, Hartford, CT

Responsibilities:

  • Onsite point of contact for the customer and high-quality delivery responsibility
  • Onsite coordination to the offshore teams, Knowledge transfer to the teams and orientation to the offshore team. Reporting to customer team.
  • Requirements gathering, functional & Technical Specification documents.
  • Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
  • Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
  • Created a High-Level Data Flow Diagram for ETL Design using SSIS as ETL Tool.
  • Created and developed queries for Drill Down and AD Hoc Reports using SQL Server 2008 Reporting Services (SSRS). Developed Parameterized reports, Cross-Tab reports, Snapshots, Drill down reports by using SSRS.Expand and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
  • Dashboards created for Customer care weekly, monthly, quarterly, yearly to business activities of UHC Operations

Reporting developer

Confidential

Responsibilities:

  • Created Functional & Technical Specification, Design documents documents.
  • Experience of Designing, Developing and deploying various kinds of reports using SSRS & Actuate reporting
  • Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.

Sr Support Analyst

Confidential

Responsibilities:

  • Support Analysts for the CRM product RR 360
  • Issue resolution and identifying root cause and raising tickets to development to fix the issues
  • Responsibility to coordination builds teams and users to the issues are fixed in Prod.

Team Lead

Confidential

Responsibilities:

  • Involved in Analysis of business, design and implementation of Reports and Front end.
  • SQL SERVER Database Administration, Crystal Reporting

Hire Now