SUMMARY:

Sr. SQL Server Consultant experienced in working with the Microsoft BI Stack supporting OLTP and OLAP databases. Designed various solutions using SQL Server . Well versed with tools like SSRS, SSAS, SSIS Oracle 10g, 11g, and PL/SQL. Familiar with scripting VB and C# code to enhance delivery of product. Proficient with ETL and data migration for operational systems and data warehouses. Proficient in designing durable, automated and scalable database solutions.

TECHNICAL KNOWLEDGE

SSRS: VB Scripting SSAS C# Scripting

T - SQL: SSIS Advanced Access Data Models

PL/SQL: SQL Server Advanced Excel Data Warehouse Data Architectures Data Driven Automation Data Mart AWS CLI

EXPERIENCE:

Sr. Database Consultant

Confidential, Dallas, Texas

Responsibilities:

• Designed a data mart to support loss productivity, granule usage and KPM business analysis.
• Provided master design templates to guide and inform resources for objects like SSIS packages, SSRS reports and data modeling.
• Created data mart to support Power BI reports and analysis.
• Guided developers in T - SQL, SSRS, SSIS and C# development.
• Optimized transactional reports and data mart performance with the assistance of execution plans.
• Designed SSIS packages to load and update the data mart.
• Trained users on Power BI functionality like drill down, slicers and hierarchy.
• Mentored and guided team on T-SQL best practices, stored procedure optimization and database design.
• Provided expert level advice to management on SQL development best practices.
• Set and followed database coding standards for the application and database team.
• Worked as lead SQL technical advisor for development and developers.
• Designed and developed database automated solutions for various departments like manufacturing and accounting.
• Modeled, documented and designed data mart used for manufacturing analysis.
• Created SSRS reports from the transactional system for individual business units.

Sr. Database Architect

Confidential, Dallas, Texas

Responsibilities:

• Recommended and performed database structural enhancements by analyzing the database schema, applications, and database performance.
• Developed database solutions by designing proposed changes to the database via index, table, and stored procedure design and modification.
• Planned the execution of database deployments by developing flowcharts and a planned step-by-step deployment action plans documenting changes and contingencies.
• Enhanced database performance by identifying and resolving production and application development problems like bad table partitions and inefficient application calls.
• Conducted to subordinate database engineers, applications team members and clearly explained objectives and benefits of database changes to executive staff.
• Deployed Idera and Red Gate database monitoring tools that put a spotlight on database issues and helped identify many other underlying issues.
• Mentored and guided team on T-SQL best practices, stored procedure optimization and database design.
• Provided advice to the entire staff on database issues, changes and served as the database resident expert.
• Lead and guided the team on the implementation of various database solutions and changes.
• Set database coding standards for application and the database team.
• Used SSIS to develop and deploy complex data extractions and support ETL operations.
• Dedicated to team success with respect database technology and database best practices.
• Worked on the migration of new database architectures and moved everything to AWS.
• Experienced with AWS CLI commands to move database files to and from AWS S3.
• Hands on developer and mentored all developers on T-SQL, SSRS, SSIS and C# for packages.
• Performed table partitioning on very large tables to enable performance benefits.

Sr. Data Architect

Confidential, Dallas, Texas

Responsibilities:

• Collaborated with various teams including DBA, data warehouse and software engineering to design SQL Server database solutions.
• Supported business reporting processes by loading data mart, data warehouse and source systems.
• Planned design and architecture meetings to discuss the scalability and overall health of the database.
• Assisted developers by instructing them on better scripting techniques, query plan analysis and index improvements.
• Suggested improvement to the database schema, ETL packages, SSRS reports and calls to database from the application.
• Examined data flows, data models and created data dictionaries with column mapping.
• Used advanced T-SQL programming constructs to design various tasks including table partition automation.
• Designed and implemented bullet proof database solutions involving error handling.
• Clearly communicated with management and development on design roadblocks or other constraints with respect to the database.
• Reviewed SSRS RDL design and recommended improvements to existing reports.
• Scripted C# when needed for SSIS solutions using script task.
• Designed and implemented Change Data Capture (CDC) for various tables.
• Worked with an Always On SQL Server 2012 configuration.
• Designed database partitions and partition schemes for the database scalability on large objects.
• Worked with PMO to define requirements during design and development processes.
• Reviewed and advised development on code before deployment and final production implementation.
• Participated in data architecture design and review of schema changes.
• Designed and implemented automated solutions for both OLTP and OLAP databases.
• Supported SQL Server, Oracle and MySQL database.

Sr. BI Consultant

Confidential, Dallas, Texas

Responsibilities:

• Designed automated solutions for various BI work tasks.
• Implemented Change Data Capture with SSIS for ODS/data warehouse solution.
• Worked with SQL Server versions 2008, 2012 and 2014.
• Worked through all phases of design, including conceptual design, detailed design, implementation, testing and production deployment.
• Authored C# scripts and SQL queries for accessing and analyzing data and associated metadata.
• Instructed BI/SQL development team on best practices for OLTP and OLAP delivery.
• Advised DBA team on how to promote scalability and efficiency using methods like table partitioning and column store indexes where needed.
• Updated database functionality by removing rigid code like cursors and improper uses of temp tables.
• Guided SQL/BI developers on solution to ingest vendor XML into database.
• Responsible for statement of work and effort on deliverables and work once deliverables were defined.
• Lead internal meetings, presenting and backed up database analysis findings to key stakeholders.
• Participated in internal client meetings to address current issues with the database.
• Ensured that database applications meet business requirements and systems goals.
• Identified, optimized and resolved database OLTP and OLAP issues.
• Analyzed existing database applications for effectiveness and efficiency.
• Developed strategies for improving and leveraging database work flow.
• Worked with business liaison to identify and analyze business needs.
• Initiated fact-gathering sessions to analyze and solve database related issues.
• Worked effectively with the project team to identify, estimate, prioritize and resolve issues.
• Developed business oriented data dictionaries.
• Provided input on best practices to developers and management for the database.
• Advised staff on database architecture and assisted developers in the data warehouse technology stack.
• Established new and improved on existing ETL standards.
• Worked with multiple teams to define an enterprise-wide approach for loading data from multiple systems.
• Profiled data to measure quality and integrity for customers.
• Developed database systems specifications based on business rules.
• Developed data flow, ER diagrams and technical specifications for the database.

Sr. SQL/BI Developer

Confidential, Denton, Texas

Responsibilities:

• Led and assisted developers with design, implementation and automated solutions for OLTP and OLAP databases.
• Provided development and design guidance to junior developers and contractor implementation team.
• Collaborated with DBA team to design server configurations for SSIS deployment.
• Supported business reporting and processes by loading data mart, data warehouse and source systems.
• Organized and led various architecture meetings for both technical staff and non-technical stakeholders.
• Enhanced performance by optimizing packages in SSIS and SQL query tuning.
• Created ETL packages in SSIS that assisted in refreshing daily sales transactions from POS and eCommerce site to the database.
• Documented data flows, data models and created data dictionaries with column mapping.
• Used advanced T-SQL programming constructs to complete various tasks.
• Performed quality checks and implemented error handling of data in SSIS.
• Effectively communicated with business customers as well as project management staff and other developers.
• Designed and modified SSRS RDL for adjustments to existing reports.
• Scripted C# and VB into various SSIS solutions using script task.
• Used various transformations like SCD, Derived Column and Multicast in SSIS.
• Resolved issues with SSRS delivery such as subscriptions email and data driven subscriptions.
• Created various reports for the end user using SSRS Data Driven Subscriptions.
• Performed DBA duties on periodic basis in weekly rotations.
• Worked with the PMO on validating requirements before design and development.
• Unit tested code before UAT and final production implementation.
• Knowledgeable with data analysis objects like SSRS report RDL and SSAS cubes.
• Accessed SSAS Multi-dimensional cubes to create SSRS reports.
• Designed and developed a solution to merge multiple retail customers using advanced SQL SSRS and SSIS.

Sr. BI Developer/Architect

Confidential, North Richland Hills, Texas

Responsibilities:

• Worked along with Sr. Architect to develop data mart and enhance data warehouse.
• Implemented and maintained various data driven solutions to enhance automation and delivery.
• Developed, tested and implemented data extraction, transformation and loading (ETL) processes using SSIS packages and advance T-SQL.
• Designed and developed solutions that were not only efficient but also scalable.
• Developed, maintained and troubleshot SSIS packages used in production.
• Utilized error handling tools in SSIS like check points to restart loads.
• Created packages in SSIS that assisted in refreshing daily, weekly and monthly reports.
• Researched, analyzed and resolved issues to related database systems SSRS, SSIS.
• Communicated with upper management and staff regarding system issues and product delivery issues.
• Managed multiple deliverables and communicated changes to deadlines.
• Designed and modified SSRS RDL for deployment or adjustments to existing reports
• Resolved issues with SSRS delivery such as subscriptions and data driven subscriptions.
• Used SQL Server Job agent to execute stored procedures, SSRS Data Driven Subscriptions, SSIS packages and database maintenance plans.
• Monitored the performance of all databases, for database size, performance, and hardware capacity.
• Developed extensive objects using T-SQL such as stored procedures, views, and functions for the use of the business.
• Collaborated with application developers and end users on project design and development plan.
• Monitored and fixed system issues that involved SSRS, SSIS and objects in SSMS.
• Developed and monitored scheduled jobs and maintenance plans.
• Granted and validated security roles, and accessibility of all database systems within the organization.
• Performed Database backups, Database restores, and created DB maintenance jobs.
• Worked with the Business to Define requirements and applied them in the design and development of projects.
• Tested code and performed UAT with end users before final production implementation.

Sr. SQL/BI Developer

Confidential, Plano, Texas

Responsibilities:

• Built reports for the mortgage fees due team using SQL Server 2008.
• Lead and advised Junior developers on projects, code and more efficient solutions.
• Analyzed Fees, fee types and collectable fees for Mortgage Fees Due team.
• Created packages in SSIS that assisted in refreshing daily and weekly reports.
• Developed, optimized, and maintained, stored procedures, views and cursors.
• Documented processes, packages and stored procedures that I developed.
• Prioritized multiple deliverables and communicated changes to upper management and business owners.
• Utilized Excel pivots, formulas and VBA to streamline and deliver reports and analysis.
• Developed SSIS packages to automate data flow for reporting.
• Refreshed database tables using SSIS packages.
• Developed and maintained complex SQL queries for mortgage fees reporting and analytics.
• Gathered requirements for reports and analysis met with upper management and department lead to evaluate the project business plan.
• Communicated changing project deadlines to business owners and management.
• Worked with the business to concisely define the details of projects and analysis confirmation.
• Analyzed business requirements and suggested changes when needed.
• Interpreted business requirements into technical design and execution.

BI/SQL Developer

Confidential, Dallas, Texas

Responsibilities:

• Supported various departments with reporting requests and maintenance of production reports.
• Used advanced T-SQL like ranking statements, while-loops and dynamic SQL.
• Analyzed and corrected various data anomalies from the portfolio management group.
• Guided and advised less experienced developers on best practices and solutions for projects.
• Restored various systems or problems at the developer level by making corrections to code.
• Created and deployed SSRS reports for the Portfolio Management group.
• Maintained and modified data for the .NET dealer customer site.
• Convened with managers and department leads to discuss business requirements and objectives for deliverables.
• Developed stored procedures ad hoc queries in SQL Server to maintain and support the business.
• Supported an Access database that had ADO Connection to the SQL Server database.
• Debugged and stepped though sub procedures VBA code for Access and Excel.
• Delivered reports in SSRS, Access/Excel and .net site via SQL Server.
• Rewrote complex reports from Access into SSRS or Stored Procedures for .NET site.
• Enhanced and created new operational reports for business efficiency.
• Wrote T-SQL in SQL Server Management Studio 2005 and 2008.
• Utilized Visual Studio 2010 for TFS deployment and minor code fixes.
• Created SSIS packages and utilized data flow many transformations like lookup, data conversion and aggregate.

SQL Developer/Analyst

Confidential, Irving, Texas

Responsibilities:

• Worked with bank mortgage data and supported LOBs with daily, weekly, and monthly requests and maintenance of reports.
• Knowledgeable in banking mortgage industry loan and default process.
• Supported the process analyst team by creating reports both ad hoc and formal by deliverable request.
• Used technical skill to implement business requirements and objectives for deliverables.
• Used Data Analysis, Pivots, and Charts to assist management decision making.
• Worked as a member of a technical MIS team but articulated concepts and ideas to non-technical LOB and staff.
• Created and updated stored procedures nesting dynamic SQL and cursors.
• Worked with directly with LOB management and staff to remedy any reporting anomalies.
• Mentored less experience team members on technical methods and business processes.
• Created reports in Oracle using SQL with various constructs like case statements, multiple table joins, set operators and sub queries.
• Delivered daily, weekly, and monthly reports via ODBC connection to Oracle from VBA.
• Developed and maintained VBA automation to produce reports.
• Used many different PL/SQL constructs such as stored procedures, anonymous blocks, and if then logic to create reports.
• Automated and increased efficiency of existing reports using SQL, PL/SQL and VBA.
• Proficient with a wide range of DDL, DML and DCL statements used in SQL.
• Utilized PL/SQL, to create stored procedures for report code modularity.
• Developed VBA sub procedures that contained variables, loops, functions, and forms.
• Created tables, indexes, views, and sub queries to obtain a sub set of larger data sets as needed.
• Exposed to G/L reporting and balance sheets that show the bank assets and debts.

SQL Developer/Data Information Analyst

Confidential, Plano, Texas

Responsibilities:

• Utilized T-SQL, Excel, and VBA programming to enhance and deliver reports.
• Delivered and modified existing reports via T-SQL, VBA, and Excel.
• Used built in functions and user defined functions to deliver reports.
• Demonstrated power user skill level of MS Access and Excel.
• Built MS Access databases and maintained existing database applications.
• Developed advanced level queries linking and importing data to Access.
• Gathered and manipulated raw data to create ad-hoc and supplemental reports for management.
• Automated and increased efficiency of existing reports using VBA.
• Wrote queries, views, and performed sub queries to on various data sets in SQL Server 2008.
• Worked with financial bank data and supported bankers with banking contest data.
• Supported the process analyst team to ensure timely and accurate delivery of data.
• Knowledgeable in banking financial analysis techniques and methodologies.
• Performed optimization of T-SQL scripts and stored procedures SQL Server 2008.

SQL Developer/Analyst

Confidential, Irving, Texas

Responsibilities:

• Developed process documentation and mapped business data to new data mart.
• Used VBA, Macros, Pivot Tables, and Graphs to produce reports.
• Deployed reports and performed queries using SSRS and Microsoft Access.
• Created and altered functions, triggers and stored procedures as needed.
• Used T-SQL to develop reports for management and staff.
• Streamlined business processes and productivity by using VBA.
• Created reports in SSRS for daily and weekly business activities.
• Gathered requirements for projects and managed other groups for timely deliverables.
• Developed and maintained price plan data/business models using advance Excel skill.
• Transferred data to source system using SSIS from flat files, excel and vendor data.
• Increased business efficiency by building reports and performing gap analysis.
• Extracted, tested, transformed, and loaded data using SSIS to data warehouse.
• Developed reports, using indexes, sub queries, and temp tables in SQL Server 2008.
• Created and maintained queries and ad hoc reports for data analysis.
• Developed pivot tables and charts in Excel to display trends and correlate data sets.
• Created and used T-SQL stored procedures, functions with SQL Server 2005 and 2008.
• Used SSIS for importing data from source system to data warehouse.

SQL Developer/Analyst

Confidential, Irving, Texas

Responsibilities:

• Developed routine and ad hoc reports using SQL Server 2005 and MS Excel.
• Developed and maintained daily, weekly, and monthly reports using SQL Server 2005.
• Used data mining tools and methodologies to assist with testing and design of new database.
• Developed reports by evaluating data quality and performing data cleansing as needed.
• Performed UAT and quality assurance and testing for external Vendor Data to data mart.
• Used Excel pivot tables to summarize data sets and for data analysis.
• Reviewed and modified functional requirements for business process and business exceptions.
• Proficient with Excel formulas used to calculate and create business models.
• Documented the business processes through different project life cycles.
• Developed and tested queries using SQL Server 2005 and Advanced Excel.
• Assisted technical teams with data cleansing activities to ensure data integrity and quality.
• Assisted in associates in using SSRS tools and data analysis.
• Communicated project goals, objectives, project status, and deliverables with client and staff members.
• Developed, and deployed T-SQL scripts for reports in SQL Server 2005.
• Worked alongside ETL team in development, test and production environments.