We provide IT Staff Augmentation Services!

Onsite It Consultant Resume

MissourI

PROFESSIONAL SUMMARY:

  • 5 years of experience in developing BI applications utilizing SQL server, BI stack and Power BI.
  • Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, SQL Server and MS Access.
  • Hands on experience with various transformations such as lookup, conditional split, multicast, Derived column, merge, for each, for loop, Multi - cast, sorting, Data profiling, Bulk insert, Sequence container, Delayed validations etc. in Integration Services development.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
  • Experience with Power BI reports & dashboards with SQL Server/Tabular SSAS sources
  • Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations
  • Strong experience on Custom Visualizations like multi slicer and Hierarchy slicer.
  • Experience with DAX expressions like filters, Aggregate, Mathematical Functions etc.
  • Good Experience in working with filters/calculated columns/measures/relationships and transformations of Edit Query section.
  • Implemented On-Premises Gateway to refresh the data sources/creating a live connection with Tabular SSAS.
  • Implemented Role Based Security as part of security in Power Bi.
  • Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Dax, Azure, Conversions.
  • Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands.
  • Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
  • Experience in managing and automating control flow, data flow, events.
  • Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
  • Experience in Design, development of Business Intelligence Solutions using Power BI.
  • Thorough understanding on connection managers, Checkpoint, Transactions, logging etc.
  • Created Drill through reports, drill down reports, Sub reports, Cascading Parameters, Linked reports, Matrix etc. using BIDS.
  • Expertise in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export etc.
  • Experienced in Design and Optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
  • Worked on projects using Agile and Waterfall model methodologies.
  • Expert in designing complex reports writing like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
  • Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
  • Experience in working with Linux, NT, and Windows environment
  • Excellent problem solving and organizational skills

WORK EXPERIENCE:

Confidential, Missouri

Onsite IT Consultant

Responsibilities:

  • Successfully complete onsite tickets that have varying requirements and scopes
  • Build great relationships with customer contacts while providing highly technical onsite service
  • Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
  • Created New Calculated Column and Measure using DAX Expression.
  • Used Power Query to acquire data and Power BI desktop for designing rich visuals.
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Environment: SQL Server 2016, SQL Server Reporting Service, SQL Server Management Studio 2016, Visual Studio 2015, Team Foundation Server, DBA support responsibilities, Production environment support.

Confidential, Columbus, Ohio

SQL/PowerBI Developer

Responsibilities:

  • Done some free work for a library around my location helped maintained their records in a excel.
  • Networked with other stay-at-home moms and organized a 100+member communicating group for moms to swap baby products and exchange parenting advice.
  • Volunteered at local garage sales to prepare posters and maps and few other volunteering works at different places.

Confidential, Maryland

SQL/PowerBI Developer

Responsibilities:

  • Generated custom and parameterized reports using SSRS. Created various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI. Knowledge of publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.
  • Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
  • Used Power Query to acquire data and Power BI desktop for designing rich visuals.
  • Worked on the Power Bi reports & dashboards with SQL Server/Tabular SSAS sources
  • Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations
  • Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
  • Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
  • Created New Calculated Column and Measure using DAX Expression.
  • Created basic reports using Confidential files as source to fetch the data in Power BI. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
  • Collaborate with the BI team for development of BI architecture and components
  • Define the scope, use, and requirements of business data warehousing
  • Determine business and systems requirements and create reports
  • Solve technical problems related to data and guide team members
  • Develop and implement best practices in creating BI solutions, Dax
  • Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
  • Developed logical and physical data models.
  • Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
  • Designed and developed various types of reports using SSRS
  • Worked on formatting SSRS reports using the Global variables and expressions
  • Created parameterized reports, Drill-down and Drill through reports using SSRS
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications
  • Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
  • Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.

Confidential, New Jersey

Jr. SQL Developer (Intern)

Responsibilities:

  • Involved in complete Software Development Lifecycle (SDLC).
  • Wrote complex SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.
  • Advised optimization of queries by looking at execution plan for better tuning of Database.
  • Performed Normalization & De-normalization on existing tables for faster query results.
  • Wrote T-SQL Queries and procedures to generate DML Scripts that modified database objects dynamically based on inputs.
  • Designed and developed different types of reports like matrix, tabular, chart reports using SSRS.
  • Maintained positive communication and working relationship with all business levels.
  • Coordinating with onshore/offshore & stake holder’s team for task clarification, fixes and review.
  • Reviewed, analyzed and implemented necessary changes in appropriate areas to enhance and improve existing systems.

Confidential, Indiana

System Administrator

Responsibilities:

  • Installed and Configured Microsoft SQL Server 2008R2/2012.
  • Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
  • Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server.
  • Developed, monitored and deployed SSIS packages.
  • Worked in transferring the data using SQL Server Integration Services packages Extensively used SSIS Import/Export Wizard for performing the ETL operations
  • Hands on experience with SQL server Always on High Availability Groups.
  • Utilized Integration Services (SSIS) to produce a Data Mart for reporting.
  • Strong experience in working with BCP, SSIS (DTS, DTSX) packages for Data Integration Services.
  • Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
  • Expertise in creating Property Expressions, Script Tasks for SSIS packages
  • Responsible for Application security of the developmental application system databases.
  • Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008R2/2012 via SQL Server Integrated Services.
  • Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
  • Implemented Snowflakes Schema and Star Schema.
  • Worked with Development teams in relation to application tuning and Performance tuning.
  • Used Performance Point Server to create reports, scorecards and dashboards.
  • Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.
  • Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008R2/2012.
  • Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Created data driven subscriptions for different users using Report Manager.
  • Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS2008R2/2012. Extensively worked in sorting the data, defining subtotals for the reports
  • Identified and added the report parameters and uploaded reports on to the report manager and organized them in folders.

Confidential

Jr. System Administrator

Responsibilities:

  • Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008R2/2012.
  • Created data driven subscriptions for different users using Report Manager.
  • Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS2008R2/2012. Extensively worked in sorting the data, defining subtotals for the reports
  • Identified and added the report parameters and uploaded reports on to the report manager and organized them in folders.

Hire Now