We provide IT Staff Augmentation Services!

Sql Database Administrator/power Bi.net Azure Developer Resume

Rockwall, TexaS

OBJECTIVE

  • To gain a responsible career position where I can fully utilize my professional experience as SQL Database Administrator /Power BI Developer while making a significant contribution to the success of my employer.

TECHNICAL SKILLS

  • Visual Studio
  • .NET crystal report
  • Microsoft SQL Server v2016, v2014, v2012, v2008 R2 v2008, v2005, v2000, v7.0, v6.5
  • SAP/3 ABAP/4, SAS
  • Visual Interdev
  • ASP
  • XML
  • Vbscript
  • Java script
  • HTML
  • Oracle
  • MS Access DBase IV
  • COBOL
  • FORTRAN
  • IBM AS/400 RPG/400
  • SCO Unix
  • Xenix

PROFESSIONAL EXPERIENCE

SQL Database Administrator/Power BI.Net Azure Developer

Confidential, Rockwall, Texas

Responsibilities:

  • The goal of this project was to remove SQL Server 2005 from the development, testing and production network. Successfully migration of applications and databases to the newest version of SQL Server 2016 SP1 to Azure cloud storage and virtualization software from over 50 SQL Server instances.
  • Applications were updated using SQL Server 2016 Integration Services, Reporting Services and Business Intelligence Development Studio. Created new SSIS scheduled agent packages to exact, transport and load data from SAP Business Warehouse and Oracle database server platforms.
  • SharePoint Database administration Microsoft SharePoint (Configuration, Development, Data Migration) SharePoint administration concepts including upgrade methodologies like database attach and in - place upgrade and alternate access mappings including SQL Server alias naming.
  • Using Commvault software managed backups, and recovery processes to ensure recovery timelines were met.
  • Gathered project information through project manager and business analysis, and make sure the solution implemented satisfied the requirements.
  • Extended the capabilities of Analysis Services cubes by defining Multidimensional Expressions MDX, Key Performance Indicators KPIs and create perspectives for viewing purposes.
  • Created complex reports such as Gauges, Matrix, Charts, Cascading Parameters, Sub reports and Dashboards using SSRS 2016
  • Scheduled and monitored SSRS report portal subscription and deliveries such as Email Delivery and File Share Delivery as required.
  • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Building dashboards, drill through, drilldown, Graph, Chart, cascading parameterized, and matrix reports, parameter reports, cascading parameter reports using SSRS 2016 and exported to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application. Microsoft report view control
  • Designed, reviewed, and created primary objects like Views, Indexes, Triggers based on business requirements and physical constraints.
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
  • Created Tabular Models judging by the data volume and corresponded with Microsoft BI tools.
  • Processed and maintained the cubes on a schedule directly in SQL Agent through SSIS Analysis Services Process task on rebuilding cubes iterations with the most current information.
  • Deployed SSRS reports into a reporting server and implemented security measures at report server by implementing authentication and authorization methods.
  • Created snapshot on the report server management to ensure that the reports on the server won't be affected by constantly changing database environment.
  • Excellent knowledge in writing T SQL Queries using various objects like views, tables, Joins, Sub Queries, triggers, stored procedures, and other advanced SQL concepts.

SQL Server/Azure Support Engineer

Confidential, Dallas, Texas

Responsibilities:

  • Provided solutions for the top database administrator staff for the Fortune 500 technology companies around the world during their worst critical situation. When the database server has a problem, they cannot solve on their own. These are the customer support case were handling Microsoft SQL Server call center premier support contracts.
  • Supported Microsoft Azure Power BI Designer, Power BI Portal, Power Query, Power View, Power Pivot and Power Map configuration and installation and customer problems and issues.
  • Serve as an expert related to issues internal to Azure SQL Database (including customer databases on Premium SKU). This includes query performance, TSQL syntax, query performance, throttling, Management Portal, Management Studio, administration, data loss, failover and customers using the Import/Export service plus BACPAC errors. Support Microsoft Azure Power BI Designer, Power BI Portal, Power Query, Power View, Power Pivot and Power Map.
  • Resolve SQL Server issues related to TSQL programming, data integrity/corruption, backup/restore, setup/upgrade and add/remove components, Database mirroring, Cluster failover analysis, han gs or unresponsive servers, SQL Server administration tools, auditing issues, database maintenance plans and exceptions related to SQL Server for SQL On - Premise and in Windows Azure Virtual Machine (IaaS) environments supporting SQL Servers Azure Databases.
  • Proven track record managing all phases Microsoft Premier customers of SQL Database versions for both production and development customer issues. Background successfully developing applications and systems in deadline-oriented environments. Extensive experience in Microsoft SQL Server Azure database platform, with expertise in Microsoft SQL Server Best Practices standards.
  • Developed reports such as tables, matrix, Gauges, Charts, parameter reports, cascading parameter reports using SSRS and exported to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application. Microsoft report view control.
  • Deployed SSRS reports into a reporting server and implemented security measures at report server by implementing authentication and authorization methods.
  • Created snapshot on the report server management to ensure that the reports on the server won't be affected by constantly changing database environment.
  • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Experience in working with SSAS 2005/2008/2008 R 2/2012/2014/2016 in creating multiple cubes in a database solution with multiple facts in a single cube with shared dimensions.

SQL Database Administrator/.Net Azure Developer

Confidential, Dallas, Texas

Responsibilities:

  • Microsoft SQL Server 2008 R2 baseline best practices was implemented - Using Microsoft Baseline Configuration Analyzer 2.0 and Microsoft Baseline Security Analyzer 2.3 that provided a high-level plan to update all the development and production SQL Server 2008 R2 to bring the instances up to Service Pack 3 preparation for migration to Microsoft SQL 2012 clustered Windows Cloud servers.
  • Providing architecture, development and maintenance of data-warehousing and OLTP relational databases.
  • Created automation SSIS maintenance plan packages of action to improve existing conditions and processes.
  • Provided analysis, recommendations, consultation and advice on the Database Engine, Analysis Services, Integration Services, Reporting Services and Business Intelligence Development Studio for business rules.
  • Scheduled SQL Server Agent Jobs to monitor data transformation and database updates.
  • Used SSIS for each loop to implement data updates from various sources to data warehouse.
  • Demonstrate strong ability of Extraction, Transformation and Loading ETL processes to acquire and load data from internal and external sources using SSIS, Import Export, BCP and Bulk Insert.
  • Experience in RDBMS database and tables design Normalization, De Normalization, Unique, primary, foreign keys and Clustered, Non-clustered Indexes.
  • Expert in designing Data Marts for different Business Subject Areas using STAR and SNOWFLAKE schema.
  • Proficient in Microsoft BI Tools and Table auto generate reports and dashboards.
  • Ability to create SSIS Packages using various Transformation like Lookup, Derived Columns, Conditional Split, Data Conversion, Aggregate, Merge, Merge Join, Sort, 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 Spreadsheet, Flat file, MS Access and CSV files to data warehouse.

SQL Database Administrator/.Net Azure Developer

Confidential, Hurst, Texas

Responsibilities:

  • As DBA finished the first implementation of a data warehouse with SQL Server 2014 Business Intelligence Edition as a team member on the DW/BI team. Administrator and architect of Master Data Services (MDS) and Data Quality Services that addressed incompleteness, non - conformity, inconsistency, inaccuracy, invalidity, and data duplication in the data warehouse.
  • Help in the adoption and successfully implemented agile practices into reporting development lifecycle. Gain deeper insights into the processes, challenges, critical success factors and benefits of Service Operation within the ITIL framework.
  • Responsibilities: Experience in creating hierarchies, partitions, aggregations and perspectives as and when required based on the complexity of the cube in SSAS.
  • Created Partitions, Aggregations to optimize cube performance.
  • Identified fact tables and dimension tables, and created data marts for various subject areas as required.
  • Created varies complex cubes according to analytical requirements and manage the performance of cubes by modifying measures and dimensions using SSAS 2014.
  • Increased cube usability by adding named calculations, defining display folders, modifying composite Key Columns, attribute relationships, and adjusting properties such as Discretization Method using SSAS 2016. Created SSIS packages to Extract, Transformation and Load ETL user data and other data from OLTP to OLAP. Participated in designing Data Warehouse using Kimball Architecture and generated dimension tables and fact tables.
  • Configured and deployed the new Project based deployment in SSIS 2016. Deployed the Projects to Integration Services Catalog and managed the security, and created SQL Server Agent Jobs to schedule daily data transformation.
  • Created and Managed OLAP Cubes using SSAS and created different KPIs to perform analysis based on business requirements.
  • Worked with SSAS cubes using multiple dimensions, perspectives, hierarchies, measures groups to analyze marketing efforts and prospective customers. Excellent SQL tuning skills and ability to trouble shooting and recover data failures.
  • Experienced in Data Modeling logical modeling, Entity relationship diagram ERD development/normalization and physical database schema design using CA Erwin data modeler.
  • Excellent SQL Server development skills including deep knowledge of SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, and SQL Server Reporting Services SSRS.

Senior SQL Database Administrator/Developer

Confidential, Fort Worth, Texas

Responsibilities:

  • Had both DBA production and development responsibilities for over 20 MS SQL Server 2012, 2008 R2 servers across the United States and Mexico.
  • Helped reduce service requests backlog by 50 percent with the implementation of the scrum methodology and other agile methodologies, this highly productive approach helped the development team collaboration and reduced the software development time.
  • Created automation SSIS maintenance plan packages of action to improve existing conditions and processes; identifying improvement opportunities, generating ideas, and implementing solutions.
  • Team commitment by adhering to the team's expectations and guidelines; fulfilling team responsibilities; and demonstrating personal commitment to the team by being cooperative, collaborative, and flexible at all times.
  • Always maintained effectiveness when experiencing significant changes in work responsibilities or environment; adjusting effectively to work within new work structures, processes, and requirements.
  • Responsibilities:Participated in the Agile planning for Team Foundation Server to make sure that our team sprints satisfied backlogs. Experienced with Tabular Models to speed up analysis life cycle based on different data volumes.
  • Working experience with ASP .NET to display reports and experience using C# in SSIS scrip task.
  • Working experience in a Scrum team as a Scrum Master to facilitate the communication between Product Owner and other Scrum team members as well as ensuring sprints were accomplished in a timely manner.
  • Working experience with Agile planning under Solid communication skills interpersonal, written and oral, ability to multitask and to deliver quality project within deadline.
  • Demonstrated keen sense of detail and accuracy, and demonstrated excellent ability of adapting new technologies and tools. Such as TOAD for SQL Server, RedGate Toolbelt, LiteSpeed of SQL Server, and Solar Winds.
  • Interfaced with business analyst and Subject Matter Experts (SME) to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.

Senior SQL Database Administrator/Developer

Confidential, Plano, Texas

Responsibilities:

  • Microsoft SQL Server 2008 R2 Setup - System Configuration Check Reports. Provided a high-level plan to update all the development and production SQL Server 2008 R2 to bring the instances either up to CU 6 or Service Pack 2 on over thirty Microsoft clustered windows servers.
  • Senior level of expertise with relational database structures, data security, storage solutions, database virtualization, replication, and clustering as well as used other complex technical tools and SQL Sentry solutions.
  • Demonstrated senior level understanding of the interrelationship of hardware, OS, and SQL DBMS for the ongoing performance tuning and optimization of all the databases.

Senior SQL Database Administrator/Developer

Confidential, Irving, Texas

Responsibilities:

  • Performed proof-of-concept of requirements development strategy with implementation of SSRS 2008 R2 that uses multiple data sources and multiple data sets that had stop the team to meet clinical and business requirements. Break through solutions that team was unable to solve for months.
  • Have the ability to bridge the gap between technical and clinical non-technical staff with over ten years of working with the frontline health care administration staff members.
  • Project had more than 1000 operational reports that need to be rewritten in SSRS, SSIS 2008 R2 from Crystal Reporting v10 as a result of the clinical rewrite and data repository.
  • Initially trained Crystal Reporting developers the skills to conduct rewrite with on-the job /mentoring of six junior developers as their instructor SSRS expression programming class.

Senior SQL Database Administrator/Developer

Confidential, Fort Worth, Texas

Responsibilities:

  • Aggregate Spend project for governmental entities reporting platform to bring transparency to the influence a manufacturer may have over a specific medical professional or healthcare industry through manufacturer spending allowances or manufacturer sampling giveaways.
  • The replacement of extensive legacy reporting and exhaustive manual process of gathering data from both automated and manual business processes across the organization.
  • Then, manually compiling and validating the data. The repeated manual processing of data may have opened Confidential to errors in reporting thereby potentially making them out of compliance with one, or more regulatory bodies.
  • SQL development for SSIS packages that populate the staging area of the Aggregate Spend project using a series of pre - built Extract-Transform-Load (ETL) processes. Once the data has been moved from files into the staging area, additional ETL processes performed any necessary lookups, aggregations, and relations and populated the Aggregate Spend project star schemas.
  • Provide ASP database design and Microsoft's Business Intelligence Development Studio (BIDS) using SQL Server 2008 SSMS, SSIS, and SSRS to appropriately capture and accurately report Confidential data to the various State and Federal agencies that have legislative requirements on manufacturer spending reimbursements or manufacturer sampling giveaways.

Senior SQL Database Administrator/ Developer

Confidential, Plano, Texas

Responsibilities:

  • A full lifecycle Disposition data mart project where I developed the Data Mart (OLAP) schema design layout and construction "As - Is" vs. "To Be" the software modeling and Meta-modeling.
  • Conceptual data models, Logical data models (LDMs), and Physical data models (PDMs) diagrams for the project using Erwin 4, Microsoft Professional Visio 2010, and DBVisualizer, IBM's iseries AS400 navigator for Admin.
  • Using data modeling techniques as Entity-Relationship (ER) modeling, Dimensional modeling, Dimensions, Facts, Factless Facts, Conformed Dimensions, Slow changing.
  • Development on MS SQL Server 2008, 2005 SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Business Intelligence Tools, Transact SQL, and Visual Studio (ASP.NET).
  • SharePoint site Administrator for the project performed all the change control management for all shared documentation and project management like the master data file listing.
  • Accomplished; home loans has a very high volume of data and when they write an aggregation production query on their legacy transaction system would take many hours to return the values. After our team's Disposition data mart was built the same result set is now taking only minutes.

Senior SQL Database Administrator/ Developer

Confidential, Carrollton, Texas

Responsibilities:

  • Project Senior DBA that lead and advise the Management Report Analysis team members on complex reporting manager configuration, report designer issues with ad hoc SQL programming with SQL Server 2005 and 2008 Reporting Services platforms development.
  • Assist development staff with the debugging and optimization of SQL queries and stored procedures migrated from Access's Visual Basic for Applications (VBA) code.
  • Programming with Visual Basic.Net 2008 as front - end design report forms that was migration from IBM DB2 databases, Sybase databases and Microsoft Access databases.
  • MS Business Intelligence Development Studio (BIDS) and Visual Studio.NET solutions
  • Developing reporting criteria and creating metrics, understanding the reporting platform being implemented and developing program for the unit management staff.
  • Serve as liaison with internal customers, and management report analysis team members to strategize and align their processes to sell real estate (REO) and reduce Confidential 's credit losses and exposure to losses.
  • Coordinate strategy execution for day-to-day reporting operations and distribution reports for the team members engaged in reducing potential losses or foreclosure on delinquent loan. Articulate their goals and expectations working with limited allocated resources and management of limited time project workflow.

Senior SQL Database Administrator/Developer

Confidential, Plano, Texas

Responsibilities:

  • Project Senior DBA creating the process of employee's performance matrix scorecards and dashboard reporting on the customer accounts master database.
  • Working with Visual Basic for Applications (VBA) as a front - end design for SAP/6 ABAP/4, Microsoft's SQL Server, FoxPro, and Microsoft's Access databases.
  • Proactively evaluate physical and logical design of the databases for the internal coding system and the user interface repository databases.
  • Created the data schema and data dictionary for the project databases.
  • Performing needs assessment and defining configuration and user requirements. Developing Data-Warehouse User Interface working with programmers, developers and analysts to resolve technical issues.
  • The database creator and developer of all users stored procedures and SQL queries to insert, update, and deletion of data on all the tables.

Senior SQL Database Administrator/Developer

Confidential, Midland, Texas

Responsibilities:

  • Primary Responsibilities Include: SQL Server 2008 and 2005 database servers' developer and administrator.
  • Development on MS SQL Server 2008, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Business Intelligence Tools, Transact SQL, and Visual Studio (ASP.NET).
  • Experience with agile development methodologies, test driven development and spreadsheet application development. Experience working with financial applications and all types of property management.
  • Providing architecture, development and maintenance of data - warehousing and OLTP relational databases.
  • Provided analysis, recommendations, consultation and advice on the Database Engine, Analysis Services, Integration Services, Reporting Services and Business Intelligence Development Studio for business rules.

Database Administrator/Developer/Programmer

Confidential, Fort Worth, Texas

Responsibilities:

  • Primary Responsibilities Include: SQL Server 2005 and 2000 database servers' developer and administrator.
  • Providing architecture, development and maintenance of OLAP data-warehousing and OLTP relational databases.
  • Provide analysis, recommendations, consultation and advice on the Database Engine, SSAS Analysis Services, SSIS Integration Services, SSRS Reporting Services and BIDS Business Intelligence Development Studio.
  • Documenting technical architecture, system use and system maintenance. Prototyping solutions, preparing test scripts and conducting tests on data replication, extraction, loading, cleansing and modeling related to all aspects of SQL Server Management Studio.
  • Performing needs assessment and defining configuration and user requirements. Developing Data-Warehouse User Interface working with Architects, Developers and Analysts to resolve technical issues.
  • Designing components and performing complex coding/programming, de-bugging and testing within a OLAP data-warehouse and OLTP relational systems. Defining unit-testing "best practices" and performing system-Integration testing.
  • Performing research and analysis of data-warehouse-related software and vendors-including new software releases, features and capabilities. Coordinating and conducting Requests-for-Proposal (RFPs) and Proof-of-Concept (POC) engagements.
  • Assisting with Data Maintenance-including data-source gathering, data integrity, data extraction and transactional loading. Providing estimates for the completion time of assigned tasks and assisting in the review of others' time estimates for project management.

Senior Database Administrator/Programmer

Confidential, Bedford, Texas

Responsibilities:

  • On-the-job /mentoring of four junior DBAs and instructor of SQL programming class for actualities.
  • Build and maintain terabyte size databases using actuarial data processing structures under SOX guidelines and terminology.
  • Rapid application development of Transact code and database structures based on defined database models and business requirements for life insurance policy claims.
  • Implementation of Microsoft Baseline Security Analyzer to assess the administrative vulnerabilities present on multiple database file servers.
  • Implementation of Microsoft Best Practices Analyzer to verify compliance for SQL Server operation and management. Measurable improvement of all databases performances and efficiencies, and lead to the development of applications that were better and easier to maintain.
  • Implementation of Microsoft SQL Server 2000 Reporting Services for rich web base reporting capabilities in report definition format of all compliance/non-compliance reports. Supported Business Objects and Web Intelligence universes for life insurance policies reporting.

Microsoft SQL Server 2000 Specialist/Programmer

Confidential, Dallas, Texas

Responsibilities:

  • Creating templates to build new tables and control tables for their Power builder application called Psychconsult by Askesis Development Group, which is a web based application.
  • Creating new patient medical records hardcopies output reports using their report generator Crystal Report pulling data from SQL Server and Oracle tables.
  • Development and administration of the patient database medical record user interface forms for their scheduling and billing their clients.
  • Creating tables, data marts in SQL and moving data over from Oracle 8i into SQL Server 2000. Administration, performance tuning and stored procedures.
  • Working experience with MS SQL Server 2000, Visual Basic v6.0, Power builder, Crystal Enterprise v10 and Oracle 8i database server.

Database Administrator/Programmer

Confidential, Fort Worth, Texas

Responsibilities:

  • As a database analysis (DBA) / Internet Developer as designer/developer of all data\schema modeling, XML integration of relational data and user stored procedures in Microsoft's Windows 2003 Server /SQL Server 2000 database Server.
  • Clustering management using cluster administrator for cluster mirrored servers.Log shipping, replication using transactional, merge, snapshot configurations.
  • Writing Secure Code - Implementing application security for Microsoft .NET Framework using cryptographic to help encrypt and sign data for better secure ASP.NET-built Web applications and Web services. Utilizing threat defense identifying strategies for defending common security threats such as buffer overruns, cross-site scripting, SQL injection, and denial of service attacks. Established threat modeling methodologies and how they can be applied with other best practices to help minimize vulnerabilities and limit damage.
  • Design the database rules engine for their web base software application for the banking industry that stores information on a customer enrollment ATM payroll check cashing system.
  • Develop all their user-stored procedures, triggers, and indexes for SQL database's tables. Using database modeling and schema development for both physical and logical design of database tables using forward engineering and schema generator for maintaining database referential integrity.

Database Administrator/Analysis

Confidential, Fort Worth, Texas

Responsibilities:

  • Design the database engine with SQL 2000 Server for E - commerce website development that stores information of over 6 million electronic components. Develop the user-stored procedures, triggers, and indexes for SQL database's tables.
  • Using database modeling and schema development for both physical and logical design of database tables using forward engineering and schema generator for maintaining database referential integrity.
  • Made physical and logical design changes that identify architectural issues and propose alternative solutions for the databases. Created the data schema and data dictionary, clustered and non-clustered table indexing. The programmer, using SQL 2000 Server (Transact) programming of all users stored procedures and insert, update, delete and cascading triggers for all the tables.
  • Providing data access methods for the Java business objects form pages developing code for eight to ten Java programmers accessing the database. Using business requirements and develop the technical requirements for individual modules in the software application.

Database Administrator/Analysis

Confidential, Fort Worth, Texas

Responsibilities:

  • Responsible for providing expertise to the Global Suite software development team in the design and development of enterprise Internet application using SQL 2000 Server (Transact) programming for the databases.
  • Created terabytes size databases for legal firms representing Fortune 500 Corporations. I designed large terabytes size databases for companies like Confidential, Shell Oil, and Walmart from start to finish.
  • Services included scanning and indexing all types of documentation related to the trial attorney's legal court cases. This involved the use of database management tools for support of performance tuning and security management, capacity planning, change management and fault management that includes database transactions, data partitioning and data referential integrity.
  • Work with Visual Basic for Applications (VBA) versions 6.0 & 5.0 with crystal report writer as a front - end design for Microsoft's SQL Server, FoxPro, and Access databases. Proactively evaluate physical and logical design of the databases for the internal coding system and the user interface repository databases. Created the data schema and data dictionary, clustered and non-clustered table indexing. The programmer, of all users stored procedures and insert, update, delete and cascading triggers for all the tables.

Database Administrator/Analysis

Confidential, Carrollton, Texas

Responsibilities:

  • As a database analysis (DBA) / Internet Developer was designer/developer, of user stored procedures and insert, update, delete and cascading triggers in Microsoft's NT/SQL versions 7.0 / 2000 Database Server Relational Database Management System (RDMS) using SQL language (Transact).
  • Using business requirements created business logic pages with XML code and user interface pages with ASP v3.0 code on the server side and Vbscript, Jscript and DHTML code on the client side for the development of their real estate web base application called; One Site.
  • Working experience with Computer Associates Platinum ERWin version 3.5.2 CASE tools for database modeling and schema development. For both physical and logical design of database tables using forward engineering and schema generator for maintaining database referential integrity. Using business requirements and develop the technical requirements for individual modules in the software application.
  • Working experience with Embarcadero's Rapid SQL 5.5 and DB Artisan for design/developing user stored procedures, triggers, and indexes for SQL database tables.

Hire Now