We provide IT Staff Augmentation Services!

Msbi Analyst Resume

3.00/5 (Submit Your Rating)

Manhattan, NY

SUMMARY:

  • Over 8 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, QA, UAT and Production Environment)
  • Having 1+ years of testing experience in Hadoop stack, HDFS, Map Reduce, Sqoop, Pig, Hive, HBase,Parquet & Kafka
  • Having basic knowledge on Hadoop tools like Mapreduce, HiveQL, PIG and Sqoop
  • Having experience of maintaining project documentation on Confluence
  • Having experience of creating Dashboards in JIRA, and maintaining the code using bitbucket (GIT) and JIRA integration
  • Experience and Understanding of Software development life cycle (SDLC), And Testing life cycle
  • Experience with HP - ALM (Application lifecycle management) and BMC Remedy
  • Experience of maintaining and managing Kanban Dashboards
  • Worked in completely agile environment since last 3 years, having a lot of experience of working in waterfall, Spiral Methodologies in past
  • Having strong background in SQL Query performance tuning
  • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server Architecture based applications)
  • In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
  • Proficient in Data warehouse ETL activities using SQL, PL/SQL, PRO*C, SQL*LOADER, C, Data structures using C, Unix scripting, Python scripting and Perl scripting.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2012/2014)
  • Experience in creating dashboards, scorecards and building reports using performance point server 2007
  • SQL Server 2000/ 2005/2008/200 8 R 2/2012/2014/2016 RDBMS database development including T-SQL programming.
  • Strong experience in SQL, PL/SQL, Tables, Database Links, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Joins, Unions, Cursors, Collections, and Indexes in Oracle.
  • ETL implementation using SQL Server Integration Services (SSIS)
  • Design and Build Data Warehouse and Data Mart pulling data from different Business sources. The Data Mart was used for different Dashboard usage
  • Developing reports on SSAS & SSRS on SQL Server (2012/2014/2016 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture
  • Build MDX query for SSRS reports and SharePoint Performance Point reports and Dashboards
  • Experience working and creating ad-hoc reports, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects
  • Work with different version controls such as TFS/GIT and worked in an agile environment
  • Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin
  • Confident in work independently and proactively. Strong leadership, good communication and excellent interpersonal skills, problem-solving and multi-tasking abilities. Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure

TECHNICAL SKILLS:

Database: MS SQL Server 2005/2008/200 8 R2/2012, MS SQL Reporting Services 2005/2008/200 R2/2012/2016 MS SQL Server Analysis Services 2005/2008/200 8 R2/2012/2016 MS SQL Server Integration Services 2005/2008R2/2012/2016, Cloudera Distribution for Hadoop (CDH), MapReduce, HDFS, YARN, Hive, Pig, Sqoop, Spark, Scala, Elastic search, Kibana, Parquet, Flume, AWS, EMR

Programming Language: C#.NET, HTML, ASP. Net, Oracle 10g/11g, My SQL, Python 2.7, Linux

Operating Systems: Windows NT/ 2000 Server/ XP, Mac

Tools: DTS, Power designer Visual Studio 2013/2015, T-SQLMS Access, MS-Office, MS Excel, Tableau,Erwin,SQL Developer,Microsoft Visio,Toad Data Modeler, Toad for Oracle, Crystal Reports, Oracle Report Builder, Oracle Discoverer BI, Autosys, Oozie, Jenkins,Actimize

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, ny

MSBI Analyst /Developer

Responsibilities:

  • Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
  • Experienced in database design process and data modeling process.
  • Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
  • Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
  • Extracted data from various sources like SQL Server 2014 .CSV, Microsoft Excel and Text file from Client servers.
  • Experience in Data Warehouse Engineer for all ETL and Data Warehouse systems and databases for VIP. Provide analysis, design, development, review, validation and code review for all Informatica and Oracle project.
  • Analyzed business requirements and implemented data mart solutions for data mining and reporting.
  • Generated PL/SQL and Shell scripts for scheduling periodic load processes.
  • Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
  • Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
  • Design, Development, Testing and Implementation of ETL processes using Informatica Cloud.
  • Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
  • Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio.
  • Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
  • Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
  • Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
  • Convert specifications to programs and data mapping in an ETL Informatica Cloud environment.
  • Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Deployed and Tested (UAT) Reports in Multi User Environment. Created RSConfig Files and Ensure Report Security with Keys.
  • Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
  • Worked closely with QA team and helped them come up with test scenarios.
  • Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.

Environment: MS SQL Server 2016/ 2014/2012/2008 R2, SSIS, SSRS, SSAS, SSMS, Visual Studio 2013/2010, Import/Export tools, Power Designer tool, Power Designer Portal, T-SQL, PL/SQL, MS TFS, JIRA,NICEActimize

Confidential, NJ

Hadoop etl /MSBI Analyst /Developer

Responsibilities:

  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle, Salesforce and SQL 2016).
  • Extracted and Transformed data into Staging Servers named as Staging Server for historical data and Staging Server for load increment.
  • Developed technical specifications of the ETL process flow. Designed the Source - Target mappings and involved in designing the Selection Criteria document.
  • Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
  • Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
  • Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
  • Created and modified various Stored Procedures used in the application using T-SQL.
  • Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
  • Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
  • Extensive use of various ETL transformations like Router, Filter, Joiner, Aggregator, Lookup, Update Strategy, Sequence Generator, Sorter and Stored procedure.
  • Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers
  • Co-coordinate between the Business and the Off-shore team.
  • Requirement gathering and prepare the Design.
  • Export and Import data into HDFS, HBase and Hive using Sqoop.
  • Involve in creating Hive tables, loading with data and writing Hive queries.
  • Bulk load HBase using Pig.
  • Implement solutions using Hadoop, HBase, Hive, Sqoop, Java API, etc.
  • Work closely with the business and analytics team in gathering the system requirements.
  • Load and transform large sets of structured and semi structured data.
  • Load data into HBase tables using Java MapReduce.
  • Load data into Hive partitioned tables.
  • Configured Hadoop tools like Hive, Impala and Sqoop.
  • Ingested data into Hive tables from MySQL and Hive using Sqoop.
  • Ingested data into Hive tables from MSQL and Hive using SSIS.

Environment: MS SQL Server 2016, SQL server Reporting Services 2015, SQL Server Integration Services (SSIS), SQLServerManagement Studio, Cloudera, AWS EMR, JIRA,PL/SQL, Bitbucket, GIT, Docker, Python 2.7, PostgreSQL, Google Analytic, Json, AWS S3, Oozie,Jenkins,JMeter,QuerySurge,Tableau

Confidential, CHARLOTTE, NC

MS SQL Server/SSIS/SSRS/BI Developer

Responsibilities:

  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle, Salesforce and SQL 2016).
  • Extracted and Transformed data into Staging Servers named as Staging Server for historical data and Staging Server for load increment.
  • Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
  • Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
  • Designed and developed ETL Mappings to extract data from flat files, Oracle database to load the data into Teradata database.
  • Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
  • Created and modified various Stored Procedures used in the application using T-SQL.
  • Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
  • Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
  • Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
  • Created Project Expense Statements in all Data marts and other Financial Reports using SSRS. Developed yearly and quarterly company expense reports.
  • Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
  • Creating relational database to analyze data in the data warehouse, using different Sybase tools like Toad for Sybase and Toad Data Modeler.
  • Worked on Team Foundation Server tool for Version Control 2015.
  • Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
  • Created daily tasks including backup and restore by using MS SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2016.
  • Documented all work, so user can easily understand the flow of process.

Environment: MS SQL Server 2016, SQL server Reporting Services 2015, SQL Server Integration Services (SSIS), VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin7.3, SQL Server Profiler, Database Engine Tuning Advisor, SQL DEVELOPER, Oracle BI Discoverer, Oracle Report Builder.

Confidential, SAN RAMON, CA

MS SQL Server/SSIS/SSAS/SSRS/Data Warehouse Developer

Responsibilities:

  • Created entity relationship (ER) diagram for proposed database to display the various relationships between entities
  • Created database objects such as tables, Views, Stored procedures, functions, triggers etc. during the development of the database and to serve customized functionality as needed
  • Developed codes with better performance by testing and ensuring code run at optimal while keeping in mind blocking and deadlocking situation and creating codes to avoid such scenario
  • Designed and developed dynamic SSIS package to perform extract, transform and load (ETL) data across different platforms, validate the data and achieve the data files into the database
  • Experience in designing of on-line transactional processing (OLTP), operational data store (ODS) and decision support system (DSS) (e.g., Data Warehouse) databases, utilizing Data vault (hub and spoke), dimensional and normalized data designs as appropriate for enterprise-wide solutions.
  • Experience working with different package configuration types such as Project Package configuration, XML configuration etc.
  • Created error handling on packages by redirecting errors, error Log shipping and saving error log in RDBMS
  • Perform Unit testing of codes and packages with self-generated sample data following guidelines specified.
  • Created SQL jobs to process packages and load data at specified times and specify certain action upon failure or success of the job.
  • Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Generated context filters and data source filters while handling huge volume of data.
  • Built dashboards for measures with forecast, trend line and lines.
  • Published Workbooks by creating user filters so that only appropriate teams can view it
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2012.
  • Experience in creating ad-hoc reports Using Report Builder 1.0 and Report Builder 3.0.
  • Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
  • Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Environment: Windows OS, MS SQL Server 2008, MS SQL Server Reporting Services 2008, MS SQL Integration Services 2008, T-SQL, ERWIN, Microsoft Visio, Toad for Oracle,Tableau9.0,9.1.

Confidential, Bethpage, NY

SQL Server/SSIS/SSRS developer

Responsibilities:

  • Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
  • 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.
  • Reversed engineer backend database to change the T-SQL scripts, create Views, Index, Stored Procedures, Triggers, CTE, Constraints and UDF to improve performance drastically.

Environment: Windows OS, MS SQL Server 2012, MS SQL Server Reporting Services 2012, MS SQL Integration Services 2012, T-SQL, ERWIN, Microsoft Visio.

Confidential, Jericho, NY

MS SQL Server Developer

Responsibilities:

  • Migrated heterogeneous databases to MS SQL Server 2008R2.
  • Developed logical and physical data model using MS Visio and mapped the data into database objects
  • Designed and created different ETL packages using SSIS from My SQL Source to SQL server 2008R2
  • Created SSIS Packages to export and import data from Text files, CSV files, Microsoft Access and Excel Spreadsheets
  • Designed and implemented SSIS packages for data integration
  • Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them
  • Extensively worked on Cross Tabbed and Matrix reports using SSRS
  • Designed and implemented indexing to optimize transactional and reporting performance.
  • Installed SQL Server on Windows 2008R2 Server.
  • Assisted in the Analysis and Design of database.
  • Designed drilldown, drill through, and parameterized report using SSRS.
  • Deployed generated reports onto the Report Server to access it through browser.
  • Designed, reviewed, and created primary objects such as views, indexes, views and store procedures.
  • Worked with User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least update to improve the query performance.
  • Defined referential relationships with the measure groups and fact tables.
  • Documented the development work and production release for future .

Environment: Windows OS, MS SQL Server 2008R2/2012, MS SQL Server Reporting Services 2008R2/2012, MS SQL Integration Services 2008R2 /2012, T-SQL, ERWIN, Microsoft Visio, SQL profiler.

We'd love your feedback!