SUMMARY:

As DBA, I add immediate value to a team by leveraging my in - depth technical skillset of plan implementation of new systems, different types information technology documents of Database management to drive system performance, include expertise in database administration, system administration, installation, configuration, upgrade, network and object-oriented programing. In addition, I have a commanding skill on data mining, and creating hundreds of reports and database tools that supported government agencies, communities and currently giant retail stores as well as today's leading manufacturers.

CORE COMPETENCIES INCLUDE:

• Design, Develop, Install, Administer, And Implement Complex Data Delivery Systems
• Test, Development and Cluster Server Environments.
• OLAP Cube and MDX Query Development
• New Product Development
• MS Visio Modeling Tools and Strong Knowledge of Relational Database Modeling and Dimensional Modeling Concepts.
• Analyze Business and Technical Requirements Data Warehouse Data Models (SSIS, SSAS & SSRS).
• T-SQL Programming Skills Creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, and Cursors.

TECHNICAL EXPERTISE:

Languages: T-SQL, C#, VBA, XML, HTML, PHP, R, python and Shell Scripting.

RDBMS: SQL Server 2012/2008r2/2005, Oracle 11g/10g/9i/8i, MySQL and MS Access

Database Design Tools: MS Visio, FACT & Dimensions tables, Physical & logical data modelling

DWH / BI Tools: SQL SSRS, SSAS, SSIS, Excel, Tableau, and (Cognos & Crystal)

Operating Systems: Windows NT/XP/2003, MS-DOS, and Unix - Trapeze, CMS, Spider and Maximo

PROFESSIONAL EXPERIENCE:

Confidential, New Carlton, Maryland

BI Developer

Responsibilities:

• I installed SQL Server with minimum access privileges service account to improve security and to attain high ratings in Service Organization Control (SOC) audits.
• I implemented security patches per Application detection and Security Technical Implementation Guides (STIGs) within the SQL server databases, configurations of different applications and on Window serve. Including, TDA encryption, Window extended protection (registry change) and Application modifications.
• I created and assigned appropriate database roles and privileges.
• I performed database maintenance, database monitoring and space management to utilize resources efficiently and to improve database performance.
• I Created SQL objects like Tables, Stored Procedures, Views, Indexes, defaults, user defined data types and functions
• I Performed database backup (full backup, differential and transactional backup) to recover database at the time of disaster.
• I involved in configuring, patching, testing, monitoring, and supporting multiple heterogeneous database instances, maintaining the databases at current release and maintenance levels.
• I worked with partners and team members within Technology to provide professional consultation services on technology best practices, standards and policies/guidelines.
• I functioned as primary contact for business users, stake holders and higher management during project lifecycle.

Confidential, Bethesda, Maryland

BI Developer

Responsibilities:

• Ensure delivery of quality software products.
• Perform system software applications testing.
• Make recommendations to purchase hardware, software and coordinates installation
• Administrate systems/database environment solutions for multiple projects with varying schedules
• Determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Support the planning of system/environment requirements for individual projects
• Schedule, plan, and oversee database / system upgrades
• Installed, configured SQL Server 2008 & 2012 in development, test, and production environment
• Write T-SQL, MDX and VBA codes for Report Development
• Create, Monitor and review SSIS Packages
• In charge of developing, Monitoring, optimizing and delivering dozens of reports
• Develop new reports using SSRS, Excel, Market Master and ProClarity
• Perform data quality reviews and data validation.
• Conduct trend analysis as well as evaluate statistical methods and technical research techniques
• Customize and Innovate new report development and delivery ideas.
• Planned and implemented system integration and acceptance testing operations.
• Ensured delivery of quality software products.
• Performed system software applications testing.

Confidential, Washington, DC

BI Developer

Responsibilities:

• Plan and implement system integration and acceptance testing operations
• Plan and create database jobs
• Provide troubleshooting of database instances and OS level support in a consolidated SQL Server environment leveraging a wide-array of configurations, including local and multi-site failover clustering and Hyper-V virtualization
• Responsible for prototyping solutions, preparing T-SQL test scripts, and conducting tests for data replication, extraction, loading, cleansing, and data modeling.
• Perform data validation and Involved in Data modeling, Database Redesign, and E-R Diagram
• Conduct trend analysis as well as evaluate statistical methods and technical research techniques
• Develop integrated action plans and issue technical bulletins with implementation instructions.
• Develop specifications for user instruction manuals based on customers' needs.
• Work on in maintenance of database objects such as tables, indexes, views, synonyms etc.
• Develop overall testing plans, criteria, and specifications.

Confidential

BI Developer, Data Analyst SME

Responsibilities:

• Develop various Reports, conduct gap analysis for mapping data elements, Legacy system analysis, Design Use Case specification, and develop data conversion specifications (T-SQL and Excel).
• Provide technical writing support for functional requirements and data conversion specifications
• Develop integrated action plans and issue technical bulletins with implementation instructions.
• Develop specifications for user instruction manuals based on customers' needs.
• Develop web service specifications for interface between multiple applications
• Demonstrate strong oral and written communication skills, with the ability to communicate technical topics to management and non-technical audiences, as well as interface with the customer in daily bases: SSA/DCPS stakeholders.
• Coordinate the preparation of testing and implementation plans.
• Oversee the migration of systems to the production environment and monitor systems for stability, accuracy and performance.
• Serve as senior expert on the application of system architecture modeling tools in the architectural planning process.

Confidential, Chillum, MD

BI Developer, Data Analyst

Responsibilities:

• I created ad-hoc reports per provider’s performance metrics, and maintain data Integrity. Runs and maintains store procedures, udf, triggers.
• Prepared weekly & monthly quality assurance reports (38 executive reports & charts)
• Improved report performance by optimizing queries and settings.
• Installed / maintained computers, laptops, peripherals and software applications
• Installed configured Linux operating system on laptops and desktops for different application use
• Assisted with web development and maintenance
• Created ad-hoc reports per provider’s performance metrics, and maintain data Integrity. Runs and maintains store procedures, udf, triggers.
• Developed tabular, matrix, and graphical reports from multiple data sources using excel and SQL Server Reporting Services and other similar tools.
• Analyzed, validated, data reconcile data submitted by service contractors using; Excel, SQL SSRS, Trapeze, Crystal, Congo’s, and CMS (Call Management Center).

Confidential, Washington, DC

Developer/Research Assistant

Responsibilities:

• Installed, Configured, and Administered SQL Server 2005 & 2008 in development, test, and production environment
• Working experience and strong knowledge in disaster recovery
• Rebuild databases using backups
• Installed, Configured and Managed Database Mirroring, Replication and Log Shipping
• Maintained Fail-Over Cluster Servers in SQL Server 2005 & 2008
• Monitoring and Performance Tuning:
• Performed database monitoring and Performance tuning
• Monitor Servers activity, and worked with clients to solve different problems
• Performed index and statistics management
• Managed SQL Server Error Logs, space usage, growth pattern
• Managed BLOCK and LOCK
• ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases
• Migrated MS Access 2003/2000/97 databases into MS SQL Server