SUMMARY

• More TEMPthan 7 years of experience in Microsoft BI stack with SSIS Developer/SSRS Developer/SSAS Developer/Database developer/ BI developer/Data warehousing
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) / Data Transformation Services (DTS)
• Excellent skill in Power BI report on - prem and cloud
• Excellent skills in High Level Design of and implementingETLpackages usingSSIS 2008/ 2005/2008/2010/2012/2014/2016/2017/2019 for integrating data using OLE DB /ODBC /FTP connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available inSSIStoolbox such asData Conversion, Conditional Split, Bulk Insert, Merge, Lookup andUnion all etc.
• Skilled in SQL Server 2005/2008/2010/2012/2014/2016/2017/2019, Business Intelligence tools/SQL Server Data Tool(SSDT)/Team Foundation Server (TFS)/Data Warehousing and ETL processes.
• Good Hands on experience inData Warehouse Designand analysis of various approaches for maintaining different dimensions and facts in the process of building a data warehouse application.
• Experience in Dimensional Data ModelingStarandSnowflake Schemas.
• Proficient in work with Business intelligence development service(BIDS)
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS)
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2010/2012/2014/2016/2017/2019 ) generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reportsand Cascaded reportsinSSRS 2005/2008/2010/2012/2014/2016/2017/2019 .
• Working experience using in SQL Server Analysis Services (SSAS)
• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
• Proficient in analytical query using MDX
• IT domain focused on delivering Business Intelligence analysis tools.
• Database Analysis, Reporting, Development and common Administration tasks
• Ability to deliver comprehensive BI through MS solutions including MS Excel, Microsoft Office
• Understanding Power BI, Share Point, Excel Services, PowerPivot
• Experience in all phases of MS Access database development and design
• Experience working with SQL Server 2005, SQL Server 2008,SQL Server 2012 / 2014 programming dynamic queries, and stored procedures.
• Proficient in DML and DDL operations in SQL
• Ability to analyze and interpret data to create marketable information.
• Skill in Visual Basic Coding
• Proficient in Power BI (Creating Dashboard)/ Create a complete on-prem Reporting platform using Power BI optimizer.
• Skill in Microsoft office project and Microsoft Visio
• Experience in work with ColdFusion development

TECHNICAL SKILLS

• Data Warehouse
• ETL
• SQL Server 2005/2008/2012/2014/2016 data marts data modeling
• SQL Management Studio
• SSRS
• SSIS
• SSAS
• T-SQL
• Power BI Dashboard

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

Senior BI Developer

Responsibilities:

• Lead BI Project Team
• Distribute project to the team member
• Develop team member's BI skill set (SSIS, SSAS, SSRS and Power BI)
• Monitoring and Maintaining SSRS and Power BI Report (on-Prem)
• Developing Critical report in SSRS/Power BI
• Helping and monitoring other member's development work.
• Create new Power BI report platform
• Create ETL process (SSIS) pull data from multiple sources
• Maintaining SQL Database which used SSRS/Power BI report source
• Creates a new Power BI on prem Reporting platform/ Technical support and Maintaining dis on-prem reporting platform

Confidential, Houston, Texas

MSBI Support and Developer (Power BI)

Responsibilities:

• Company migrating data from Oracle to Microsoft SQL. I has to consult and develop new ETL process that pull data from existing source to new created Data structure.
• Two phases:
• Initial load: Create ETL process to load data one time: Used import export/Back up restore/ detach-Attached DB/SSIS Package which one suitable
• Incremental load: Create a complete ETL system with all applicable feature to load data from source to Destination (Stage-> Main)
• Converting ALL existing report in Power BI

Confidential, Clearfield, UT

BI/SQL Consultant

Responsibilities:

• Create multiple Data Mart for different departments
• Create ETL process using SSIS
• Create new SSRS Report and Modify existing Reports
• Worked on small length projects as a BI Consultant while looking for full time job (March-2017 - October-2017)

Confidential, Phoenix, AZ

Responsibilities:

• Company currently working with Arizona state lottery.gov. They are recently moving to Microsoft platform.
• Project purpose is to move existing data from variety sources with like (e:g CSV,TXT,FTP etc.) into newly created SQL transactional Database.
• Establish organized ETL process using SSIS (Container, Flow Task, Transformation components, Script task with C# or vb.net)
• Create Snow Flake and Star Schema Data ware house to create OLAP CUBE using SSAS.
• Create store procedure, views to use SSIS package and SSRS report
• Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet and modified existing package to newly created data warehouse. Involved in configuration and developing of SSIS packages using SSDT/TFS.
• Extensively using joints and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.
• Experienced in creating, designing, processing of cubes using SSAS.
• Responsible for creating and maintaining Analysis services objects such as cubes, dimensions, measures. Created report model on SSAS cubes as well as changing default configuration on existing cubes.
• Creating and modifying existing SSIS package from Oracle database to SQL database
• Deploying SSIS package into multiple environments using (Container, Flow Task, Transformation components, Script task with C# or vb.net)
• Creating and modifying existing SSIS package from Oracle database to SQL database
• Deploying SSIS package into multiple environment.
• Taking existing Oracle BI Publisher/OBIEE Dashboard and other reports converting to SSRS using SQL Server 2016
• Creating and uploading Analysis service report to power BI desktop tan create dashboard for upper level management. These dashboards published into Power BI server to make available to the user’s mobile device
• Comprehensive SOW that covers the back-end architecture, governance, security administration, etc.

Confidential

SQL and BI Developer

Responsibilities:

• Development, optimization, and maintenance ETL process using SSIS tool
• Created complex SSRS reports by pulling data using SSIS Package
• Design, document, optimize, and maintain scalable ETL packages utilizing SSIS
• Providing scheduled and ad-hoc reporting solutions, data analysis and general business intelligence. dis includes developing and deploying SSRS reports, automating current reporting packages, working with business analysis to interpret report requirements and developing SQL queries for complex data structures across multiple databases.
• Performed dataconversion from flat file into a normalizeddatabase structure
• DeployedSSISpackage into production environment and used package configuration to export various package properties to make package environment independent and scheduledJobsusingSQL Server Agent
• Creating user friendly Report using SSRS Platform
• Design, develop, document, and maintain reports with SSIS / SSRS, along with migrating reports to SSRS
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Developed different kinds of reports such aSub ReportsandCharts,Map etc.

Environment: Data Warehouse, ETL, SQL Server 2005/2008/2012/2014/2016 data marts, data modeling, SQL Management Studio, SSRS, SSIS, SSAS, T-SQL

Confidential, Dallas, TX

SQL and BI Developer

Responsibilities:

• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Create project and solutions using BIDS.
• Delivering Business Intelligence solutions to end clients
• Worked on writing ETL processes using SSIS in a data mart/warehouse environment
• Create SSIS Package for data transformation and execute data flow
• Worked on creating number of ETL processes using SSIS to populate data into Staging, Transformation, and Data warehouse databases tables
• ETL design and development, BI solution design and development, dashboard and visualization development, testing, and solution implementation and maintenance
• Responsible for loading & modeling data using SSIS in a data mart / data warehouse built using the dimensional data model (DM) in a MS SQL Server environment
• Responsible for design, develop and implementation of BI reporting solutions using SQL Server 2008 SSRS
• Develop in SQL reporting, or data package transitions
• Maintain and building and maintaining SQL Server Analysis Service (SSAS) cubes and associated data stores
• Develop reporting framework and reporting deliverables in SQL Server Analysis Service(SSAS)

Environment: Data Warehouse, ETL, SQL Server 2005/2008/2012/2014 data marts, data modeling, SQL Management Studio, SSRS, SSIS, SSAS, T-SQL

Confidential, Irving, TX

Sr Programmer Analyst

Responsibilities:

• Create SSIS Package for data transformation and execute data flow
• Create project and solutions using BIDS.
• Developed and delivered number of complex SSRS reports, SSIS packages
• Worked on creating number of ETL processes using SSIS to populate data into Staging, Transformation, and Data warehouse databases tables
• UsedSSISto create DynamicETL Packagesto validate, extract, transform and load data from online transaction Processing (OLTP)databases to data warehouse databases and involved in Data cleansing in the data transfer
• Migrated DTS packages from SQL Server 2008 to SQL Server 2008R2 asSSIS Packages
• Followed Microsoft recommended best practices in designing, developing and implementation of theETLusingSQL Server Integration Services (SSIS),including upgradingDTStoSSIS
• Involved in creatingSSIS jobsto automate the reports generation and cube refresh packages
• Responsible for design, develop and implementation of BI reporting solutions using SQL Server 2008 SSRS
• Developing BI solutions using SSIS, SSRS (BIDS)
• Developed reports using Microsoft BI Stack
• Parameterize report to make user friendly report for users.
• Worked on Microsoft BI Platform
• Creating Tabular and Multidimensional Cubes
• Strong understanding of OLAP database/cube architecture, Normalization & Data mining
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Design, implement, and support data warehousing requirements
• Implement business rules for data loading and integration working with relational database management systems
• Application development in Cold Fusion

Environment: Data Warehouse, ETL, SQL Server 2005/2008/2012 data marts, data modeling, SQL Management Studio, SSRS, SSIS, SSAS, T-SQL

Confidential, Irving, TX

Developer Analyst

Responsibilities:

• Development, optimization, and maintenance ETL process using SSIS tool
• Created complex SSRS reports pulling data using SSIS Package
• Design, document, optimize, and maintain scalable ETL packages utilizing SSIS
• Migrating SSIS packages from SQL Server 2005 to 2008 and SQL Server 2008 to 2012
• Performed dataconversion from flat file into a normalizeddatabase structure
• DeployedSSISpackage into production environment and used package configuration to export various package properties to make package environment independent and scheduledJobsusingSQL Server Agent
• Creating user friendly Report using SSRS Platform
• Design, develop, document, and maintain reports with SSIS / SSRS, along with migrating reports to SSRS
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Developed different kinds of reports such aSub ReportsandCharts,Matrixreports
• Creating analytical report using Report wizard and other tools.
• Published report and creating report using report builder
• Configured Server for sending automatic mails to respective people when a SSIS process failure or success
• Developed number of stored procedures, executing through SSIS packages. Used Merge’ statement for inserts and updates in the stored procedures.
• Configuring Data source and data source view using Cube wizard in BIDS
• Design, code, test, and document all new or modified BI systems, applications,
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Enhancement of existing SSAS OLAP cube report and modifying existing Data warehouse and data Mart
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Perform quality assurance and testing of SQL server environment.
• Application development in Cold Fusion

Environment: Data Warehouse, ETL, SQL Server 2005/2008, data marts, data modeling, SQL Management Studio, SSRS, SSIS, SSAS, T-SQL