Dba Sql Bi Developer resume example with 9+ years of experience
JessicaClaire
Montgomery Street, San Francisco, CA94105609 Johnson Ave., 49204, Tulsa, OK
Home: (555) 432-1000
Cell:
resumesample@example.com
Summary
Highly motivated Sales Associate with extensive customer service and sales experience. Outgoing sales professional with track record of driving increased sales, improving buying experience and elevating company profile with target market.
Skills
CERTIFICATION:
Microsoft Certified Technology Specialist, Querying Microsoft SQL Server 2012.
Certified in ITIL.
Certified in Information builders reporting.
Administrative, Microsoft Office, Validation
Ad, MS Office, XML
Agency, Office
Automation, Windows
Backup, Migration
Billing Systems, Multi-tasking
Business Intelligence, Enterprise
Business process analysis, Network
Capacity planning, OLE
Charts, Optimization
Configuration management, Oracle
Data conversion, DB
DTS, Pdf
Data warehouse, Personnel
Database administration, Policies
Database, Programming
Databases, RDBMS
Database design, Reporting
Database development, Requirement
Debugging, Script
Designing, Spreadsheet
Dimensions, Microsoft SQL Server
Direction, MS SQL Server
Documentation, SQL
ETL, SQL Server
Forecasting, Statistics
Government, Strategic
Graphs, Tables
Html, Systems support
DB2, Technical assistance
Information Technology, T-SQL
ITIL, Trouble shooting
Mentoring, Troubleshooting
Microsoft Certified, Upgrades
Excel, Upgrade
Mail, Upgrading
Databases
Scripting
Business operations
MS Office
Experience
DBA/SQL BI Developer, 10/2018 to Current Arkhya Info Tech / JNET – City, STATE,
JNET represents an unprecedented example of how individual agencies, at different levels and in different branches of government, work together to share information and achieve a common goal.
Building relationships and collaboration is critical to the success of JNET.
JNET provides a forum for participating agencies to collaborate and share ideas.
The JNET Steering Committee is comprised of members from 16 commonwealth agencies who are appointed by each respective agency head.
Members have a voice in the strategic direction of JNET, how and what data is shared, and how policy and technical issues affecting their organizations and integrated justice are addressed.
Responsibilities:.
Serve as support for database administration tasks including configuration management, backup/recovery, performance optimization, and space management.
Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Perform database deployments and provide support for application releases.
Interface with developers, network, virtualization, storage, and systems operations teams to resolve problems with applications and database systems.
Design, develop, test, deploy and maintain database security and audit solutions.
Perform SQL administrative tasks including installing and upgrading SQL server products, creating maintenance plans, and creating database objects.
Created parameterized reports, Drill down and Drill through reports using SSRS.
Install, configure, and deploy MS SQL Server.
Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases.
Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
Tuning T-SQL queries to improve performance.
Upgrade/migrate databases to current release levels.
Prepared the complete data mapping for all the migrated jobs using SSIS.
Document migration procedures and test results.
Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats.
Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Document the company’s database environment.
DBA/SQL BI Developer, 06/2016 to 09/2018 Radiss Tech Services / Prince George County Government-OIT – City, STATE,
The Office of Information Technology (OIT) provides support for all of the agencies, departments and branches in the County government.
OIT is a dynamic organization focused on Exploring and leveraging technology to move the County forward.
Responsibilities:.
Provides technical assistance and mentoring for staff for developing conceptual and logical database design and the physical database.
Help developers improve the performance of that query by tweaking it or modifying indexes.
Provides support in capacity planning, forecasting, and tuning.
Develops performance/tuning evaluation reports.
Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
Serve as support for database administration tasks including configuration management, backup/recovery, performance optimization, and space management.
Perform database deployments and provide support for application releases.
Assist developers with MS SQL Server issues and questions.
Interface with developers, network, virtualization, storage and systems operations teams to resolve problems with applications and database systems.
Design, develop, test, deploy and maintain database security and audit solutions.
Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure.
Plan and Lead database development, documentation and maintenance of databases including.
Created system for capturing, reporting, and correcting error data.
Work with developers, and systems support personnel in elevating and automating successful code to production.
Provide on-call support to production system to resolve any issues.
Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
Involved with Query Optimization to increase the performance of the Report.
Developed Reports for business end users using Report Builder with updating Statistics.
Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
Used Performance Point Server to create reports, scorecards and dashboards.
Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
Responsible to support the issues with reports on the enterprise environments (Development, Test and Production).
Having Knowledge in Socrata Open Data.
Updating and modifying Datasets into the Open data.
Migrating reporting tool from Microsoft to Information Builders.
Gathered, defined and translated client requirements into product stories and actionable tasks.
SQL/SSRS Developer, 02/2015 to 01/2016 Marlabs/ Zoll Life Vest – City, STATE,
The Life Vest wearable defibrillator is worn by patients at risk for sudden cardiac arrest (SCA), providing protection during their changing condition and while permanent SCA risk has not been established.
Responsibilities:.
SQL Server 2008 RDBMS database development using T-SQL programming, queries, stored procedures, views.
Developing reports using SSRS on SQL Server 2012.
Using SSRS creating well-formed reports and web-based reports for health-related applications and transactions.
Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
Worked extensively on migrating ad-hoc reports from SSRS2005 to SSRS 2008.
Worked on RDL files and Stored Procedures to fix the errors and modifications of the reports.
Migrating all reports into Production environment from testing.
Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
Used Joins and sub-queries for complex queries involving multiple tables from different databases.
Applied conditional formatting in SSRS to highlight key areas in the report data.
Performed Debugging on the Stored procedures for the requirement to handle the errors.
Used cascaded parameters to generate a report from two different Data Sets.
Involved with Query Optimization to increase the performance of the Report.
Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).
Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.
Gathered customers needs and requirements for new and upgrades projects.
Presented proposed solutions addressing customers needs and requirements.
Validating the reports like List, Crosstab and charts.
Testing the reports for number of Filters, Prompts, Calculated expressions, Drill Through, Master Detail Relationships.
Prepared business requirements documentation and elicited details from users of different areas and levels of the organization.
Created business process analysis and design.
Tested Stored Procedures for the application using SQL Server 2005.
Tracked and reported upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status, performance baselines, etc.
Environment: MS SQL Server 2012, SQL Server Reporting Services, SQL Server Integrated Services, Windows 2012R2.
DBA/SQL BI Developer, 10/2009 to 06/2013 DRD Trucks India Pvt Ltd – City, STATE,
Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
Responsible for installation and Configuration of SQL Server 2005 and 2008 database and configuration of Report manager.
Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2005.
Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
Developed, deployed, and monitored SSIS Packages.
Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
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.
Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
Created reports with Analysis Services Cube as the data source using SSRS.
Monitored SQL Server Performance and Activity by using SQL profiler.
Monitored Dashboard Reports for Performance Tuning and finding bottlenecks in database.
Monitored the server’s status, database file growths, disk space alerts etc.
Experienced in improving/Tuning SQL Server performance using native and third party tools.
Analyze reports for long running queries, locks, deadlocks, backup history check and retention.
Involved in trouble shooting of database and vendors’ application problems.
Monitored Space estimation for database objects.
Scheduled Alerts and Jobs Using SQL Server Agent (Automation).
Implemented SQL logins, roles and authentication modes as part of security policies Environment: MS SQL Server 2005, DTS, T-SQL, Enterprise Manager, SQL Profiler, MS Office, Pivot Tables.
Education and Training
Master of Science: Information Systems, Expected in 12/2014 Stratford University - Falls Church, VA GPA:
Bachelor of Science: Computer Science, Expected in 03/2009 Acharya Nagarjuna University - Guntur, AP GPA:
Activities and Honors
Accomplishments
A Microsoft Certified Professional with around 8+ years of IT experience in Data Design and Development on Microsoft SQL Server 2012/2008R2/2008/2005, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2012.
Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
Extensive knowledge of Normalization and Relational Database Management Systems.
Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
Hands on Experience in Installing, Configuring, Managing, monitoring, and troubleshooting SQL Server 2012/2008r2/2005.
Handled all SQL administration related issues which includes, Installing, Configuring, and troubleshooting Always-On, Replication, Mirroring, Clustering and Log shipping issues.
Analyze data and made performance recommendations that increased storage efficiency.
Analyze long running queries and tuned to optimize application and system performance.
Great ability to create and manage various database objects like tables, views.
Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
Experience in Performance Tuning and Query Optimization.
Experienced in using ETL tools in (SSIS) MS SQL 2012, MS SQL 2008, MS SQL 2005.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, DTS and SSIS services.
Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
Data analysis and data migration by transferring them using SSIS packages.
Experience with logical and physical data modeling and database design using Erwin.
Certifications
Microsoft Certified Technology Specialist, Querying Microsoft SQL Server 2012.
Certified in ITIL.
Certified in Information builders reporting.
Additional Information
Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.
Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008/2012.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.