SUMMARY:

• 3+ years of IT experience in Database Design, T - SQL, Data Modeling, Data and Database Security, Requirements Analysis, ETL Development, Businesses Intelligence, Report development, Database Administration, Application Development, Testing, Implementation and Deployments using SQL Server 2017/ 2016/ 2014/2012/2008 /2005 & Oracle 11g,12c.
• Experience in Creating Complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Experience in Database Design, Development and business intelligence of Microsoft SQL Server.
• Strong experience in Business Intelligence (BI) using Visual Studio 2017/2016/2015/2010/2008/2005 .
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2017/2 /2008/2005 databases and scheduled them according to requirements.
• Experience in Designing, developing and testing various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases
• Played an instrumental role in Migration Data from Excel, Flat file, OLE DB using DTS, SSIS and other ETL Tools.
• Developed various complex reports from different data sources such as SQL Database and Cubes by using Reporting tools like (SSRS) and expert in fine tuning the reports. Created many Drill through and Drill Down reports
• Experience in working with Monitoring tools like SQL Profiler, Oracle Grid, HPPM, TOAD to monitor Top SQL, DB Instances, CPU Utilization. Memory Utilization.
• Experienced in creating, designing, processing of cubes using SSAS.
• Responsible for Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Hands on experience with Data Modeling tool like Microsoft Visio,ERWIN.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks and performing SQL tuning.
• Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization.
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.
• Proficient work experience in backend technologies such as Java, JSON, XML, C#.
• Experienced various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.

TECHINICAL SKILLS

Languages: T-SQL, PL/SQL, VB.Net, XML, HTML, C#, C, C++.

ETL Tools: SSIS, Data Stage, (Visual Studio 2017,2016, 2015,2014,2012,2008)

RDBMS: MS SQL Server 2017,2016,2014,2012, 2008, 2005, Oracle 11g,12c, MS Access, DB2, FoxPro database

Reporting Tools: SSRS, POWER BI, Oracle Grid 12c, HPPM, DC Rum

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 4.1

Operating Systems: Windows 2012/2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5. Unix, Linux

Database Tools: MS SQL Server, SQL Server BI (SSIS, SSRS, SSAS) Oracle Enterprise Manager, Toad 12, SQL developer, DB2, DataStage, SQL Profiler, Query Analyzer, SQL Server Agent, SQL Prompt.

Internet Tools: ECG, FTP, Mailx, Mutt, TCP/IP

Other Tools: RedGate,TriZetto Facet, Citrix, Diagnostic Manager, IBM WebSphere (One Run, CMU ), TWS, Service Now, Ultra Edit, One Note, MS Outlook, SOAP UI

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

MS SQL SERVER DEVELOPER

Responsibilities:

• Create and maintain SQL stored procedures, triggers and Ad-hoc SQL or our Core Associations Management System as required by new integration and upgrade projects.
• Supporting and trouble-shooting existing SQL procedures in the context of the Business process flows of our Association Management System.
• Excellent report creation skills using Microsoft SQL Server 2017/2016 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Design, develop and integrate functional executive dashboard systems using Tableau Desktop and Server to enable easy interpretation of portfolio status, workflow, and actions.
• Learn and understand the association data and how our customers use it.
• Create, optimize and maintain complex T-SQL as part of stored procedures, views, functions, and queries.
• Design and develop highly configurable, fault tolerant ETL systems using SSIS and experience with development of SQL Integration Services packages and SQL Reporting Services (SSIS and SSRS).
• Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring.
• Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity and recommend changes as necessary.
• Create database design documentation at architectural and functional level.
• Recommend new strategies and architecture to enhance efficiency of data systems.
• Plan, manage and track database and SQL procedures system changes.
• Collaborate with application developers, variable programmers, PM, QA and other IT team members.
• Adhere to all policies and procedures related to security and protecting privacy of client and company information
• Employ sound data architecture principles and practices across all phases of project lifecycles and across all data architecture domains (data foundation, reporting and analytics, information delivery)
• Developing and maintaining back office SQL scripts and procedures
• Developing and maintain and automate existing and new portfolio of AMS back office processes based on SQL procedures, triggers, and ad-hoc scripts
• Perform support functions and develop fixes accordingly for our Association Management System
• Manage and actively participate in system and user acceptance testing
• Provide technology options and recommendations to solve for business challenges,
• Strong knowledge of database and system performance monitoring. Ability to share and communicate ideas both written and verbally to staff at various levels within the organization in a clear and concise manner that is relevant to each level.

Environment: SQL Server 2016/ 2014/2012/2008 , Visual studio 2015/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau 9.2,10. Team Foundation Server (TFS) 2015, SharePoint, MS .Net Framework code, C#, ERP, CRM software, Widows server 2012, Linux server, Microsoft Azure

Confidential, Alabama, GA

SQL Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• SQL Scripting, using Microsoft SQL Server Management Studio 2008 R2, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE, GROUP BY, and ORDER BY clauses
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Worked with Client to resolve the Data issues in FACETS Environment
• Worked with ETL team to resolve some of the data (ETL) issues (SSIS is used to move the data from FACETS.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for creating the reports basing on the requirements using SSRS 2012.
• Data migration (import & export - BCP) from Text to SQL server.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2008.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Build reusable macros to control QlikView objects for ease of use by the users.

Environment: SQL Server 2014/2012/2008/2005 , SSIS, SSRS, QlikView, Visual studio 2008, FACETS, MS Visio 2007, XML, VB.Net, TFS. FoxPro database, MS Access

Confidential

SQL Developer

Responsibilities:

• Installation and configuration of SQL Server 2008, 2008R2, 2012.
• Create database, table, views primary key and foreign key.
• Create maintenance job.
• Designing databases and ensuring their stability, reliability, and performance.
• Design, create, and implement database systems based on the end user's requirements.
• Improve application's performances.
• Prepare documentations for database applications.
• Memory management for database systems.
• Develop database schemas, tables and dictionaries.
• Ensure the data quality and integrity in databases.
• Fix any issues related to database performance and provide corrective measures.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Take regular database backup.
• Test databases and perform bug fixes.
• Provide authentication and authorizations for Database
• Develop best practices for database design and development activities.