SUMMARY

• 8+ years of experience in Data Analysis, Design, Implementation, Administration, and support of Business Intelligence using SQL Server SSIS, SSAS, and SSRS.
• Advanced relational data modeling and database design (SQL Server, MS Access)
• Multidimensional modeling and experience building and fine tuning OLAP cubes (SSAS)
• Data transformation and ETL (SSIS)
• Advanced experience with Microsoft Excel (Pivot, Power Pivot, VBA highly desired)
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server .
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Worked on various projects on automating the ETL process from different data sources to SQL server using SQL Server Agent.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Experience in development of extracting, transforming and loading ( ETL ), maintain and support the enterprise data warehouse system and corresponding marts
• Experience with SSIS performance tuning using counters, error handling, event handling, re - running of failed SSIS packages using checkpoints and scripting
• Scheduled and maintained daily and monthly loads of classified data through jobs, tasks, and alerts.
• Worked on Power BI in creating dashboards and reports and visualizing data in hierarchy level.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment Wizard.
• Solid experience with ETL processes, worked extensively on data extraction, data integration and loading from different data sources using SSIS.
• Developed and deployed SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Expert in developing parameterized, linked, matrix, drill down and aggregation reports with various parameters and filters using SSRS .
• Hands on experience in generating on-demand and scheduled reports for business analysis or management decisions using SSRS .
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Interactive Data Visualization products focused on Business Intelligence such as MICROSOFT

TECHNICAL SKILLS

Database: MySQL, SQL Server 2005/2008/2008 R2/2012, 2014,2016, Oracle, DB2, Microsoft Access

ETL Tools: SSIS, Informatica, Talend, SAP - Business Warehouse, Power Query.

Data Modeling: Erwin, TOAD data modeler

BI/Reporting: Microsoft BI (SSIS, SSAS, SSRS), Self-service BI (Power Pivot, Power View, Power Query), DAX Studio, (Report Studio, Query Studio, Analysis Studio, Metric Studio), BIDS, Tableau, Power BI reporting tool.

Programming Language: SQL, T-SQL, PL/SQL, MDX, C, VB Script, C#, VB.NET, Shell Scripting, JavaScript, Java. Classic ASP, Asp.net, .Net framework.

Operating System: Windows 10, Windows 7, Windows XP, Windows 2000, Windows 95/98, MS DOS.

Database: MySQL, SQL Server 2005/2008/2008 R2/2012, 2014,2016, Oracle, DB2, Microsoft Access

ETL Tools: SSIS, Informatica, Talend, SAP - Business Warehouse, Power Query.

Data Modeling: Erwin, TOAD data modeler

BI/Reporting: Microsoft BI (SSIS, SSAS, SSRS), Self-service BI (Power Pivot, Power View, Power Query), DAX Studio, (Report Studio, Query Studio, Analysis Studio, Metric Studio), BIDS, Tableau, Power BI reporting tool.

Programming Language: SQL, T-SQL, PL/SQL, MDX, C, VB Script, C#, VB.NET, Shell Scripting, JavaScript, Java. Classic ASP, Asp.net, .Net framework.

Operating System: Windows 10, Windows 7, Windows XP, Windows 2000, Windows 95/98, MS DOS.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL Developer / Power BI Developer

Responsibilities:

• Developed Power BI model used for financial reporting of P & L and Headcount.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor.
• Created stored procedures and SQL queries to pull data into power pivot model.
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.

Environment: Power BI , SQL Server 2012, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Tableau, Power BI, Windows 10, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler

Confidential, Dayton, OH

MSBI/Power BI Developer

Responsibilities:

• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services(SSIS), Analysis Services(SSAS), and Reporting Services(SSRS) Implemented advanced data cleansing in SSIS using Derived Column, Fuzzy Lookup, Fuzzy Grouping and worked with various data transformations like Merge, Sort, Conditional Split and Multicast
• Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in providing Logging, Error handling by using Event Handler and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service
• 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, collaborates 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.
• 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.

Environment: Power BI , SQL Server 2012/2014, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Windows 10, MS Word, SQL Profiler

Confidential, Sacramento, CA

SQL Developer / BI Developer

Responsibilities:

• As part of the team, worked closely with DBA's to develop database and data warehouse with installation, configuration, performance tuning, optimization, backup and recovery in SQL Server.
• Involved in creating Tables, Stored procedures, Views, Functions, Triggers, and user profiles in SQL server.
• Used SQL Profiler, Query Analyzer to enhance performance of SQL server by tracing and tuning the query.
• Developed simple or complex cubes in SSAS (SQL Server Analysis Services) with Dimension table and Fact table either form of Star schema or Snow-flex schema.
• Worked on developing cubes with Derived column, Aggregation, KPI for decision-making, Prospective, measures and hierarchy.
• Created MDX queries to retrieve data from cubes and also to display SSRS (SQL Server reporting services).
• Proficient in creating ETL packages, extracting data from various heterogeneous sources like: Oracle and SQL server and transformed it using different transformation as Lookup, Fuzzy lookup and Slowly Changing Dimension SCD.
• Developed reports like: Tabular reports, Matrix, Drill down, Drill through, Cascading and Map using SSRS (SQL Server reporting services).
• Created Ad-hoc reports and reports with complex formulas based on managers requirement or client requirement.
• Worked on to build deploy Reports, managing Subscriptions, and creating Snapshot also Report cache.
• Expertise in error handling. Making the packages dynamically work by implementing Checkpoints, Break points, Data Viewer, Securing packages and managers.
• In-depth knowledge of working and implementation of Crystal reports 9.0, Converting Crystal reports to SSRS (SQL Server Reporting Services).

Environment: Power BI , SQL Server 2012/2014, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Windows 7, MS Word, SQL Profiler

Confidential

SQL Developer

Responsibilities:

• Involved in database performance tuning by using Execution Plan, Clustered and Non-Clustered Indexes to optimize queries.
• Optimized database performance by using SQL Profiler for monitoring T-SQL code and stored procedures.
• Analyzed detailed end user specifications. Designed and configured BI metadata layer.
• Created SSIS Packages to import and export data between Flat files, Excel spreadsheet and SQL server.
• Designed and created data model for relational data warehouse.
• Created SSIS packages to transform raw data into information stored in tables.
• Created SSIS packages to automatically update tables with monthly data using scheduled jobs.
• Performed various SSIS Tasks such as Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task in order to load data into Data Warehouse.
• Created script task to perform specific ETL jobs by using C#.
• Designed and generated OLAP cubes. Built reports, dashboards and scorecards on OLAP cubes.
• Modified and maintained cube Dimensions, Hierarchies and adding Aggregations to Cube.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using SSRS. Stylishly designed layout like Pie charts, Graphs and Linked Reports.
• Generated Parameterized Reports and cascaded Parameterized Reports.
• Provided support for production deployments and automation. Assisted in monitoring, job control and production support. Provided second level support for production issues related to the BI environment.
• Performed implementation and maintaining security in report development and report access at multiple levels including report groups, role-based and record level. Created report models for generating specific reports as per the client requirements and used row level security filters for report model.

Environment: MS SQL Server 2008, SQL server Reporting Services, SQL Server Integration Services, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin7.2, SQL Server Profiler, Database Engine Tuning Advisor

Confidential

SQL Developer/DBA

Responsibilities:

• DDL Scripts for generating Tables, Views and Functions.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Scheduling Jobs, Backups and Restore database
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Configured IIS and Deployed Reports and Analysis Project in to server.
• Extended Data to XML and Excel Spread Sheet.
• Developed reports using SSRS and Crystal reports, used table control, matrix control for cross tab reports.

Environment: MS SQL Server 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, SQL Server Profiler, Database Engine Tuning Advisor