We provide IT Staff Augmentation Services!

Senior Consultant Resume

Bloomington, IllinoiS

PROFESSIONAL SUMMARY:

  • Having 9 years of professional experience in Data - warehouse, SQL Server Development and BI tools (SSIS, SSRS, SSAS) and Power BI.
  • Having good experience over T-SQL statements and Having three years of experience in pl/sql.
  • Created stored procedures, triggers, UDFs, views, tables, and generated T-SQL script for application.
  • Good understanding in Data Marts and Data Warehousing concepts (OLTP & OLAP) and worked with Data mining and slowly changing dimensions (SCD).
  • Extensive experience in database tuning, server logins and database permissions.
  • Creating and monitoring jobs for automating daily tasks like backups, checking integrity of databases, updating statistics.
  • Experience in creating and managing fragmentation of Indexes to achieve better query performance that increases my ability in Performance Tuning, Query Optimization.
  • Experience in building Star schema and Snow Flake schema depending on business requirements.
  • Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data base applications.
  • Manage SSIS packages, stored procedures, jobs, and utilize Server-Side tracing to identify performance issues with deadlocks & other locking issues.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
  • Participation of team meeting on a Bi-weekly basic for a discussion on the ongoing process and upcoming
  • Proficient in designing and developing SSRS reports such as Parameterized, Linked, Snapshot, Cached, Ad-hoc, Click-through, Drill-down, Drill-through, and Sub reports.
  • Experience in creating different data regions such as Table, matrix, List, Chart, Gauge and Map.
  • Working with sql server agent jobs to call and schedule SSIS packages.
  • Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Generated various reports using Power BI desktop and shared them using Power BI Service to the decision makers in the organization for strategic planning.
  • Explored data in a variety of ways and across multiple visualizations like Pie Chart, Bar Charts, Donut Chart and Line Graphs etc. using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization.
  • Utilized slicers and various filters to create different analytical dashboards that depicts critical KPIs enabling end users to make interactive analysis.
  • Experience in creating Calculated Columns and Calculated Measures using various DAX queries as part of the Data modelling in Power BI reports.
  • Implemented Power BI On-Premises data gateway for multiple users to share and analyze Power BI reports and Dashboards.
  • Working knowledge in Agile/Scrum Environment and used TFS team foundation server for source control.
  • Excellent skills in understanding business needs and providing technical solutions.
  • Good experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services ( SSAS ).

TECHNICAL SKILLS:

Databases: MSSQL Server 2014/2012/2008/2008 R2, Teradata, Oracle, Sybase and MS-Access.

SQL Server Tools: SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Query Analyzer.

Operating Systems: Windows 7/vista/XP/98/95, Linux, and UNIX

ETL/ Analysis Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI.

WORK / JOB EXPERIENCES:

Confidential, Bloomington, Illinois

Senior Consultant

Responsibilities:

  • Gather and analyze business requirements and translate business needs into long-term business intelligence solutions leveraging the Microsoft SQL Server platform (TSQL, SSIS, SSAS) and Power BI.
  • Creating and managing schema objects such as Temporary tables, Stored Procedures, Views, Indexes, and referential integrity depending on user requirements and converting them into technical specifications.
  • Developing the ETL processes using SSIS to load data from different sources to target SQL Server database by performing a different kind of transformations and automate, optimize, and execute process improvements on existing workloads.
  • Created numerous simple to complex queries involving joins, correlated sub-queries and CTE’s techniques for diverse business requirements.
  • Involved in Query Optimization, Performance Tuning rebuilding the Indexes at regular intervals for better performance and used string functions for space management in database.
  • Involved in developing SSIS packages for incremental loading process including getting data from transactional system to data warehouse.
  • Developed Power BI reports and dashboards from multiple data sources.
  • Designed Power BI data visualizations utilizing trend charts, maps, KPI’s etc., and created various Power BI reports.
  • As part of data modelling for the reports created calculated columns and Measures using various complex DAX formulas in power bi.
  • Designed Power BI reports with different kinds of filters and slicers to provide business users with effective interaction of reports.
  • Created Bookmarks, Drill through and Cross Reports to navigate through different reports in Power BI.
  • Created workspaces for the Power BI reports and dashboards to be shared within the technical team.
  • Developed actionable plans and reported out on on-going progress through technical documentation abilities and team coordination skills.

Environment: MS SQL server 2014, Visual Studio 2014, SQL Agent Jobs, Agile, MS Server Integration services (SSIS), Power BI Desktop, Power BI Service, DAX, MS Excel, Performance Monitor.

Confidential

Senior Consultant

Responsibilities:

  • Provide SQL Development using MS SQL Server, SSIS and SSRS in relation to analyze and troubleshoot errors in the reports and packages.
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Created and developed ETL packages with different data sources (SQL Server, Oracle, Flat Files, Excel source files, XML files etc. ) and loaded the data into destination databases by performing different kinds of transformations using SSIS.
  • Created complicated reports like parameter-based reports, graphical reports, well-formatted reports, drill-down & drill-through reports, matrix reports, chart and tabular using SSRS .
  • Created Dimensions and Cubes with star schema using SQL Server Analysis Services ( SSAS ).
  • Performed data analysis to generate various trend reports and generated Ad-hoc, matrix and tabular reports using SQL Server Reporting Services (SSRS) based on client needs.
  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes.
  • Created packages in SSIS with error handling and worked with different methods of logging in SSIS & Deployed packages on different servers by configuring it.

Environment: MS SQL server 2014, Visual Studio 2014, SQL Agent Jobs, Agile, MS Server Integration services (SSIS), MS Server Reporting services (SSRS), MS SQL Server Analysis Services(SSAS), MS Excel, Performance Monitor.

Confidential

Senior Analyst Programmer

Responsibilities:

  • Developed Tables, Database objects, Reports and support the existing components.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures, functions. Created complex queries, which involve usage of Joins, Sub-queries, Functions, Temp tables etc.
  • Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
  • Developed different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Drill through reports using SSRS.
  • Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for databases and Scheduling the SSIS packages and Jobs.
  • Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
  • Developed custom reports using SQL Server Reporting Services (SSRS) to review scorecards, business trends based on the data from different retail locations.
  • Developed various T-SQL stored procedures, triggers, views and adding / changing tables for data load, transformation, and extraction.
  • Deployed SSRS reports on the reporting server and manage the subscriptions.
  • Experience in writing expressions using T-SQL and SSRS based on Business requirements.
  • Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
  • Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads.

Environment: MS SQL server 2012, Oracle, Visual Studio 2012, TFS,T-SQL, MS Server Integration services (SSIS), MS Server Reporting services (SSRS), MS SQL Server Analysis Services(SSAS), MS Excel.

Confidential

Senior Analyst Programmer

Responsibilities:

  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan.
  • Working with sql server agent jobs to call and schedule SSIS packages.
  • Created indexes (Clustered, non-Clustered, Unique) for better performance.
  • Tested the data with complex queries, joins and sub queries.
  • Created packages to migrate data from different data sources to data warehouse.
  • Created packages for database maintenance.
  • Data migration (Import & Export using BCP) from text to SQL Server2008.
  • Created packages with ETL transformations.
  • Created SSIS Packages using Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, and MS Access and CSV files to data warehouse.
  • Expert in redesign of SSIS packages for performance reasons.
  • Created the SSIS packages directly load the SAP documents through SSIS packages and it will give messages based on that we can confirm success and failure status.
  • Based on the client requirement created SSRS reports also.

Environment: MS SQL server 2012, Oracle, Visual Studio 2012, TFS, T-SQL, MS Server Integration services (SSIS), MS Server Reporting services (SSRS), MS Excel.

Confidential

Senior Analyst Programmer

Responsibilities:

  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Working with sql server agent jobs to call and schedule SSIS packages.
  • Worked in Data Partition or table partition (Improving performance for large databases).
  • Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Performed Production support and on Call duties.
  • Executed Change management scripts on weekly basis.
  • Created monitoring scripts to alert for production issues.
  • Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
  • Reviewed DB Scripts from the development team before releasing them into the Production.
  • Develop Backup & Restore scripts for SQL Server as needed.
  • Created indexes (Clustered, non-Clustered, Unique) for better performance.
  • Tested the data with complex queries, joins and sub queries.
  • Created packages to migrate data from different data sources to data warehouse.
  • Data migration (Import & Export using BCP) from text to SQL Server2008.
  • Expert in redesign of SSIS packages for performance reasons and develop New ETL packages.
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
  • Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
  • Deployed the generated reports directly on the client's workstation.
  • Created complex stored procedures for better performance to generate reports.
  • Created dashboards and scorecards using Dundas charts.
  • Building parameterized reports and returning subsets of the data with query parameters, mapping report parameters to query parameters.
  • Deployed reports on share point performance server.
  • Documentation for all kinds of reports and DTS and SSIS packages.

Environment: MS SQL server 2008R2, Oracle, TFS,T-SQL, MS Server Integration services (SSIS), MS Server Reporting services (SSRS), MS Excel.

Hire Now