We provide IT Staff Augmentation Services!

Data Analyst/power Bi Developer Resume

Irvine, CA

PROFESSIONAL SUMMARY:

  • Over 7+ years of extensive experience in database design and development using MS SQL Server2016
  • / 2014/ 2012/2008.
  • Expert in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP & Bulk Insert utilities.
  • Expert in Data Modeling and Multi - Dimensional Modeling.
  • Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling and data modeling for Data warehouse.
  • Proficient in using Power BI
  • Experience in SFDC Integration using Web Service and Salesforce.com
  • Proficient in MS SQL Server suite of products like TSQL, SSRS and SSIS of MS SQL Server.
  • Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
  • Exploring App exchange applications and integrating them with Salesforce.
  • Maintained securities, roles, subscriptions in report manager in SSRS.
  • Expert in designing SSAS cubes with slowly changing dimension, partitions, Aggregation and KPIs.
  • Excellent ability to develop complex Crystal reports using custom SQLs, use of unions, creating subquery sections etc.
  • Extensive experience of writing complex T-SQL queries, Views, Triggers, Functions and Stored Procedures.
  • Developed complex reports using SSRS and deployed into MS CRM.
  • Experienced in migrating reports from Crystal Enterprise to SSRS.
  • Extensive experience in creating SQL Server analysis projects using MS SQL Server.
  • Experienced in creating complex SSIS and DTS packages for ETL purposes.
  • Implemented complicated transformations to be used in SSIS packages.
  • Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
  • Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries, and developing stored procedures and triggers.
  • Competent in MS Dynamics CRM, C#, XML, Fetch XML, HTML5, CSS, JQuery, JavaScript, SQL Server, SSIS and SSRS.
  • Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, RDB models, data dictionaries, and data integrity, SQL joins and query writing.
  • Developed a thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC).
  • Knowledge of Reverse and forward Engineering, Logical and Physical models, Dimensional Modeling.
  • Migration of data from Excel source to CRM using SSIS.

TECHNICAL SKILLS:

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SSRS (2014/ 2012/2008/2005/2000 ), MS Access, MS Excel, Crystal Reports, Tableau Desktop, Power BI

Database: MS SQL Server 2012/2008/2005/2000 , MS Access, Oracle 11g/10g/9i

Programming: T: SQL, PL/SQL, C, ASP.NET 4.5/4.0/3.5, C#.NET, VB.Net

Web Technologies: HTML, DHTML, XML, XSL, Java Script, CSS

Operating Systems: Windows 2003/2008 Server, Windows XP, Windows 7, Windows 8, Windows 10

Other Tools: MS Office Suite (MS Word, Power Point, MS Visio), ERWIN, Toad, Accurev, GITHUB

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Data analyst/Power BI developer

Responsibilities:

  • Involved in gathering requirements, analysis, and specifications from the clients.
  • Involved in KT sessions and different Controllers meeting to understand the Business.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
  • Developed reports like Ad-hoc report, charts, tabular, matrixes, and sub report. Deployed reports on web server for user viewing in windows and share point mode.
  • Involved in unit testing against the developed packages and scheduling, creating snapshots and subscriptions for the reports using SSRS.
  • Involved with SQL server 2014/2012/2008 installation, configuration, backup, recovery, and monitoring.
  • Worked on Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages
  • Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
  • Modified existing dashboards as per new requirements in Power BI .
  • Recreated reports from MS Excel to Power BI .
  • Explore data in a Variety of ways and across multiple visualizations using Power BI .
  • Created partition table for very large database for good performance.
  • Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
  • Increased query performance by performing monitoring, tuning, and Optimizing Indexes tasks using SQL Profiler.

Confidential, Cleveland, OH

Power BI developer

Responsibilities:

  • Interacted with the business users for understanding the business requirements and the existing system.
  • Analyzed the functionality and formulas of the data and created metric (KPI's) dashboard reports using the visualization tool.
  • Implemented Role based access security using Microsoft Power BI .
  • Developed Tableau and Microsoft Power BI Dashboards to showcase the result of data analysis from the database.
  • Used different types of visualizations Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
  • Created calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs using Microsoft Power BI data visualization tools.
  • Published reports and dashboards to the Power BI service through the Office 365 integration. Shared the dashboards among multiple users in the group.
  • Good Knowledge and experience on Power BI Gateways (Personal and On-Premise gateways).
  • Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.
  • Expert in implementing business related custom visuals in addition to the visualization tool to showcase the data in an easy and efficient manner.
  • Developed professional reports as per the business requirements using Power BI .
  • Expert in designing and creation of Power BI storyboards which can give a summarized story of the data about the business. Published dashboard, reports to online Power BI could service for the use of report consumers.
  • Wrote a python-based SQL generator that helped speed up a weekly reporting from several days effort to just running the automation and getting the report done in a few hours.

Environment: MS SQL Server 2016/2014, SSAS 2008, SSIS 2015/2013, SSRS 2017, PowerPivot, Power View, SharePoint, T-SQL, TFS, Agile

Confidential, Pittsburgh, PA

MSBI SQL Server SSIS/SSRS/ETL Developer

Responsibilities:

  • Gathered requirements from business users
  • Agile methodology was used throughout the project, performed pivotal role in planning and developing as well as aligning with the assigned sprints
  • Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using for each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimension and more
  • Performed ETL mappings using MS SQL Server Integration Services
  • Implemented Event Handlers and Error Handling in SSIS packages
  • Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases
  • Supported Production Environment by schedule the packages and make the package dynamic with SQL Server Package Configuration
  • Involved in Production support with Deployment of the SSIS Packages and schedule SSIS packages using SQL Server Agent Job
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
  • In script task I used c# code to pull webservices from Bank’s website
  • Created/Updated database objects like tables, views, stored procedures, function, packages
  • Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
  • I developed new functionalities using c# code in SSIS script task
  • Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete
  • Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS)
  • Involved in monitoring and tuning report performance by analyzing the execution plan of the report
  • Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS
  • Involved in table and index partitioning for performance and Manageability
  • Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization
  • Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance

Environment: MS SQL Server 2008/12/14/16 , MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer

Confidential, Dearborn, MI

SSIS/Power BI/SQL developer

Responsibilities:

  • Responsible for creating and designing SSIS packages.
  • Using Azure data warehouse for storing the data
  • Generating reports though power BI application
  • Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
  • Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
  • Use event handing to send e-mail on error events at the time of transformation
  • Use login feature for analysis purpose
  • Written some C# coding for automatic loading of metadata to SQL tables and mapping documents.
  • Added intelligent system in SSIS to identify actual change and new change in dimension
  • Worked with APS appliance for the Order Analytics Repository
  • Deployed reports onto the production and QA server through various ways
  • Created projects by two ways one is package deployment and project deployment
  • I also converted one project from package deployment model to project deployment model.
  • Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, SQL server)
  • Created Script task for calling the web services using VB Script by Postman
  • Used Power BI to compare data from one server to other server
  • Prepared the data mapping for all the migrated jobs using SSIS
  • Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance in order to tune them
  • Responsible for Development of the scripts (Perl and Shell) needed during the Data Migration phase of the project.
  • Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting
  • Worked with Microsoft experts for creating packages.
  • Created SSIS packages using CRM Dynamics
  • Created script to migrate SQL server object from one environment to another environment
  • Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
  • Modified the queries to achieve better performance
  • Designed ETL process using SSIS to extracted data from flat files, excel files and SQL server database
  • Built complex stored procedures in Azure and on APS
  • Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance
  • Wrote Perl scripts to automate manual activities.
  • Worked on TFS for performing tasks
  • Used Accruev and GitHub for code repository

Environment: MS SQL 2008 R2/2012, SSIS, Azure, Power BI, APS, XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, MS CRM, VBA (Visual Basic for Applications), SharePoint, DTS, Accurev, GITHUB, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Team Foundation Server, FTP & SFTP server, Perl scripting.

Confidential, Houston, TX

MSBI/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Responsible for creating and designing SSIS packages.
  • Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
  • Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
  • Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
  • Use event handing to send e-mail on error events at the time of transformation
  • Use login feature for analysis purpose
  • Added intelligent system in SSIS to identify actual change and new change in dimension
  • Design SSRS and excel reports, expense analysis, and balance sheet analysis.
  • Deployed reports onto the production report server through various ways
  • Worked on managing Tableau driven dashboards and reports
  • Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
  • Developed complex reports using SSRS and deployed into MS CRM.
  • Prepared the data mapping for all the migrated jobs using SSIS
  • Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance in order to tune them
  • Created SSIS packages using CRM Dynamics
  • Created script to migrate SQL server object from one environment to another environment
  • Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
  • Modified the queries to achieve better performance
  • Designed ETL process using SSIS to extracted data from flat files, excel files and SQL server database
  • Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
  • Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
  • Worked on migration of SSIS 2008 packages to SSIS 2012
  • Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc.
  • Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
  • Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
  • Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
  • Experience in working on different kinds of reports Parameterized Reports, Linked Reports, and Drill-through reports.
  • Wrote Python/Perl scripts to parse XML/JSON documents and load the data in database.

Environment: MS SQL 2008 R2/2012, SSIS, SSRS, XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, MS CRM, VBA (Visual Basic for Applications), Share point, DTS, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server.

Confidential, Houston, TX

QlikView developer/Data Ware House / ETL Developer

Responsibilities:

  • Worked with Business Intelligence team to learn about ongoing practices and processes.
  • Developed Reports & Interactive sheets as per the requirement of the clients.
  • Developed Dashboards using QlikView to monitor insurance and policy information.
  • Used various types of sheet objects for Dashboard creation.
  • Worked on QlikView and SAP database connection to extract the data and store it into QVD'S for best optimization practices.
  • Extensively worked with Variables and Aggregate functions.
  • Experience in use of Set Analysis for data comparison.
  • Developed complex Dashboards using KPI's, Filters, Variables and Prompts as per the client requirements.
  • Implemented multiple tiers of QVD architecture depending upon the complexity of the applications.
  • Implemented triggers to provide custom functionality in Dashboards.
  • Created event trigger and field event triggers and implemented Incremental reload.
  • Scheduled the Reloads as per demand and published Reports on the access point.
  • Involved in performance tuning & deployment of applications in QlikView environment.
  • Maintained the sheet security & controlled the sheets.

Environment: QlikView, QlikView Server / Publisher (QMC), SQL Server.

Hire Now