SUMMARY:

• Years of experience in the IT industry as SQL Developer/Admin.
• Expertise in writing T - SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• I have worked and in implemented BI solutions for various business domains as a Business Intelligence Developer.
• Database and Data Warehouse Architecture, enhancing scalability and performance.
• Experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 7.0/2000/2005/2008/2008 R2/2012/2014 in Enterprise Production, UAT, SIT, Test, Development Environments.
• Experience in handling all XML specific storage models (Unstructured, Structured - Schema Based and Binary XML-11g )
• Expertise in XML - XML, DTDs, XML Schema and XSLTs.
• Experience with Data migration utilities (Import & Export - BCP, Bulk Insert) from text to SQL Server.
• Involved in the Re-Design of the XML Schema for the Content Store XML-Database.
• Software Development Change Management Work Flow ASP VB scripts Java Scripts IIS and SQL Server.
• Used Power shell to automate admin tasks.
• Wrote Java Script to add the Functionalities to the web pages.
• Developed Stored Procedures for the Java and .NET Front End Development Team
• Expertise in setting up/installing High availability environments like active-active and active-passive SQL clustering on windows clustered server 2003/2008/2012/2012 R2, Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping and Always On Availability (AOA).
• Experience in creating complex report with parameters, drilldown, drill through and other functionality in BI reporting (SSRS).
• Built the data mart using Star/Snowflake Schemas for various business Units.
• Creating relational Conceptual, logical and physical model and dimensional model star/snowflake schema using Embarcadero's ER Studio, Microsoft VISIO and SQL Server Diagram.
• Worked on OLTP for optimization and to facilitate the processing of large numbers of concurrent updates
• Developed SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.
• Experience in multidimensional data modeling, such as Kimball, star schemas, snowflakes, normalized and de-normalized models.
• Good understanding of Ralph Kimball (Dimensional) & Bill Inmon (Relational) model Methodologies.
• Extensively Used the XML SQL Oracle (Extract, ExistsNode, ExtractValue, XMLSequence, AppendChildXML) functions to generate, insert and manipulate XML files in Oracle 11g XML-DB.
• Created and used XML for data management and transmission.
• Used SSIS, T-SQL Stored Procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Assist in managing and prioritizing work for SQL Developers.
• ASP.Net/C#.Net web form to display data.
• Developed advanced SSIS PO RESENT and ASP.NET based PO closure.
• De-Normalization techniques for both OLTP and OLAP Star Schema/Snowflake schema
• Generated multiple Enterprise reports from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting features.
• Created an automated process that alerts customers that changes occurred with their scheduled events and processes their response in order to reduce the amount of manual follow up that occurs for the internal staff.
• Well versed with database installation, configuration, maintenance, monitoring, backups and recoveries.
• Experience in Batch Processes, SSIS, DTS, BCP, Import, Export, DBCC commands, Backup Restore, Database monitoring tools and Application support.
• Worked on data access layer using ASP.Net and C#
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s and Query Execution Plans.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Strong knowledge in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI.
• Performed daily DB activities on various servers which include Database consistency, Integrity health checks, Index tuning, backup and restore strategies etc.
• Actively involved in capacity planning/requirement analysis and I/O capacity using SQLIOSIM.
• Perform performance tuning, optimization, Bug Fixing and Enhancement during the various quality assurance testing cycles and for the Production dash board report using Database Performance monitoring tools.
• Created and developed tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Troubleshoot performance problems and fine-tuning of databases.
• Design and implement SSIS automatic scheduled ETL processes on data warehousing and business intelligent.
• Experience in software installations, Database Migrations and Database Capacity Planning.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Snapshot, Transactional and Merge Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring.
• Provided 24x7 supports to SQL application developers in implementing the applications on production server.
• Handled Scheduled backups and restore operations with Lite speed 5.0 and monitored the tasks and Maintenance plan.
• Installed service packs and security fix on production, test and development servers.
• Created and developed tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Installed service packs and security fix on production, test and development servers.
• Experience in migrating from Mainframe DB2 to SQL Server. Also good experience in converting COBOL+DB2 business logic into SQL Stored Procedures.
• Highly motivated self-starter with a strong analytical problem solving, having ability to multi-task, work in a team environment.
• Strong attitude towards learning new technologies and sharing ideas.

EXPERIENCE:

Sr. SQL Developer/DBA

Confidential, San Francisco, CA

Responsibilities:

• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic. Installed and Configured SQL Server 2000/2005/2008/2012/2014/2016
• Created and modified stored procedures, functions, and database schemas.
• Purpose of the project to migrate Crystal Reports to SSRS by using SSRS 2017 Due to Migration from legacy to Source.
• Worked with SME'S to gather and Document requirements and ensured that the solutions meet their business needs.
• Involved in the Re-Design of the XML Schema for the Content Store XML-Database.
• Creating the models, views and controllers using ASP.NET MVC 5, C#.NET.
• Developed new SSRS reports by following the complete RDLC (Report Development Live Cycle).
• Developed Reports in various styles such as tabular, matrix, drilldown, drill through, main reports with conditional sub reports and Dashboards.
• Generated multiple Enterprise reports from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting features.
• Experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• Participated in analysis of gaps and recommended solutions based on database development direction and roadmap.
• Developed a Custom Package which parses and compares fields from a xml using DBMS XMLDOM package.
• Monitored Indexes (XMLType: XMLIndex) and analyzed their status for performance tuning and query optimization
• Developed packages in MS SQL to export interval data in XML format.
• Developed SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.
• Worked in multidimensional data modeling, such as Kimball, star schemas, snowflakes, normalized and de-normalized models
• Built a Data Warehouse with Kimball philosophies
• Used the Ralph Kimball methodology, star schemas with conformed dimensions and fact tables.
• Tested SSRS reports thoroughly by teaming up with business Analysts prior to user testing.
• Used visual Studios Team Foundation Services TFS for source control.
• Designed and developed Store Procedure, Queries, Views and CTE's necessary to support SSRS Reports
• Modified legacy Store Procedures to be utilized for reports.
• Created Dashboards using Power BI.
• Visualized data using Power BI, implemented SSIS business intelligence life cycle such as SSIS package configuration (XML Configuration, SQL Server, Environment variable, Parent Package Variable), Deployment, Scheduling packages in Development, Test, Production environments.
• Helped SIS team to extract the data from external sources by using SSIS and Loaded into Data Warehouse.
• Generate Reports using SQL Server Reporting Services (SSRS). Created and maintained database objects, created complex Stored Procedures, Tables, Views & SQL Joins and statements for various applications.
• Made DDL changes for redesigning the schema. Loaded data from various data sources using MS Data Transformation Services. Created and wrote database objects such as tables, indexes, views, procedures, functions, triggers, SQL code with proper grants to all the users and roles.
• Implemented XML Gateway which will update the PO commitment and Commitment Line Items thru XML Listener web service and XML Publishing Services.
• Design and implement SSIS automatic scheduled ETL processes on data warehousing and business intelligent.
• Use various SQL tools, Stored Procedures, complex SSIS packages, C# and .NET on SQL server 2008 R2 for businesses application; Apply complex queries for data integrity, data analysis. Integrated SSIS with SQL Server Agent which runs several processes.
• Designed and implemented the security of the Databases (Creating User Groups and Granting Permissions). Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general troubleshooting. SQL performance tuning by modifying SQL or adding/changing indexes.
• Very good experience in migrating from Mainframe DB2 to SQL Server. Also good experience in converting COBOL+DB2 business logic into SQL Stored Procedures.
• Worked with performance tools like SQL Profiler, Database Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server database as well as performance.
• Created Merge Replication between different data centers. Resolved issues; designed and managed database security.
• Experience in software installations, Database Migrations and Database Capacity Planning.
• Created logical and Physical database design, data structures, primary key, foreign key and implemented large databases using Erwin.
• Designed and developed ETL processes using SSIS to receive customer files from data warehouses and load them into transaction processing systems.
• Extensive experience in T-SQL in creating triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Involved in SQL security and planning; administrating and creating user accounts for proper access, SQL/Server system databases and tables, SQL Profiler and Enterprise Manager/Management Studio, and Server monitoring and capacity planning to ensure adequate CPU, disk space, and memory on all SQL servers.
• Provided on-call support for various projects. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers. Automated and enhanced daily administrative tasks including space management, database backup and recovery.
• Install and configured SQL server 2012 failover cluster.
• Developed DTS packages to transfer the data between SQL Server and other database and files.
• Migrated DTS packages to SSIS packages.
• Checked Database Health and consistency by using DBCC Commands and DMVS.
• Performed daily DB activities on various servers which include Database consistency, Integrity health checks, Index tuning, backup and restore strategies etc.
• Used log shipping for synchronization of databases.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions per requirements.
• Provide database administration support to 24x7 high availability environments.

Environment: SQL Server 2000/2005/2008/2012/2014/2016 , SQL Server Tools SSMS, PL-SQL, ASP.NET, C#, XML, XML Schema, Star Schema/Snowflake schema/Kimball methodology, Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS, SSAS, MS EXCEL 2003, MS Access 2003, SQL server 2008 R2, MS SQL Query Analyzer, SQL Profiler, SQL server 2012 failover cluster, SSIS, Power BI service, Power BI (Power Query, Power Pivot), SQL Sentry, Quest Spotlight, Windows 2003 Server, T-SQL, Microsoft Dynamics AX/365, C# and .NET, MS Visio and MS Office.

SQL Developer/DBA

Confidential, Wichita Falls, TX

Responsibilities:

• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
• Monitor and tuned indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2000.
• Developed various T-SQL stored procedures, triggers, views, and created/modified tables for data extraction, data load and transformations.
• Supported development team on database related issues, troubleshooting queries and stored procedures, recommended indexes and index optimization.
• Used SSIS, T-SQL Stored Procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML
• Expert in designing VLDB (Very large databases) using design methodologies like STAR Schema, Snowflake Schema.
• De-Normalization techniques for both OLTP and OLAP Star Schema/Snowflake schema.
• Data Warehouse and Data Mart development and modification Kimball / Inmon
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Created and used XML for data management and transmission.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Creating relational Conceptual, logical and physical model and dimensional model star/snowflake schema using Embarcadero's ER Studio, Microsoft VISIO and SQL Server Diagram.
• Integrate data from disparate data sources into the single star schema or snowflake schema and identify points to use, design, and populate aggregate tables.
• Written XMLA script to delete old cube partitions for preliminary batches and executed in Analysis Services to reprocess the cube dimension
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Wrote Java Script to add the Functionalities to the web pages.
• Developed Stored Procedures for the Java and .NET Front End Development Team
• Developed web applications using J2EE and SQL components, including EJB, JDBC, Java Servlets and JSP.
• Coordinate with the application development team working on Java to provide them with the necessary stored procedures and packages and insight into the data.
• Extensively involved in designing and documenting, upgrading procedures and project plans for MS SQL Server 2000 to MS SQL Server 2008.
• Built effective queries for high-performance reports and rendered them to HTML, XML and Excel formats using SSRS
• Used the XML SQL Oracle (Extract, ExistsNode, ExtractValue, XMLSequence, AppendChildXML) functions to generate, insert and manipulate XML files in Oracle 11g XML-DB.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Import data from different data source to create Power BI reports and dashboards.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Created components and libraries using ASP.NET, C#, .NET and XML.
• Implemented features in ASP.NET MVC application using NHibernate Structure Map and jQuery.
• Developed database monitoring and tuning strategies.
• Employed the Database Engine Tuning Advisor to analyze the performance effects of workloads and implemented its recommendations wherever appropriate.
• Actively involved in capacity planning/requirement analysis and I/O capacity using SQLIOSIM.
• Rebuilding the indexes at regular intervals for better performance.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Snapshot, Transactional and Merge Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring.
• Perform performance tuning, optimization, Bug Fixing and Enhancement during the various quality assurance testing cycles and for the Production dash board report using Database Performance monitoring tools AAG (AlwaysOn Availability Groups) and DAAG (Distributed AlwaysOn Availability Groups).
• Configure Log Shipping for disaster recovery solutions.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server and develop Distributed Queries.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s and Query Execution Plans.
• Rebuilding the indexes at regular intervals for better performance.
• Resolved PASS production crises that PASS was freeze up due to a database deadlock. My code ensures the WEB accesses concurrency without paralyzing the system.
• Handled Scheduled backups and restore operations with Lite speed 5.0 and monitored the tasks and Maintenance plan.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Snapshot, Transactional and Merge Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring.
• Provided 24x7 supports to SQL application developers in implementing the applications on production server.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Designed and create databases, tables, views, store procedures and triggers. Performed joins of various types and on multiple tables. Perform Database and table scripting for quick creations of table with similar objects and structures.

Environment: SQL Server, SSRS, MS EXCEL 2003, PL-SQL, MS Access 2003, MS SQL Query Analyzer, XML, SQLIOSIM, SQL Server Tools SSMS, JAVA, Java Scripts, Profiler, ASP.NET, Star Schema/Snowflake schema, Kimball/Inmon Methodologies, C#, Power BI Dashboard, Java Servlets, Export & Import (DTS), ETL DTS, SQL Profiler, SQL LiteSpeed, Litespeed 5.0, SQL Sentry, Quest Spotlight, AAG, DAAG, SSIS, Windows 2003 Server, Microsoft Dynamics AX.

SQL Database Administrator

Confidential, Plano, TX

Responsibilities:

• SQL Database Administrator, Database Programming.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Rebuilding the indexes at regular intervals for better performance.
• Created SSIS packages for different data loading operations for many applications.
• Very extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice- versa.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Monitored and modified Performance using execution plans and Index tuning.
• Used Tortoise Subversion SVN as the source control/version control software for the code base.
• Installed service packs and security fix on production, test and development servers.
• Database objects creation, DB object migration and data conversion.
• Used JDBC to Connect Java Applications to Oracle Database.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Worked with customers on Application rollouts and server migrations.
• Created and developed tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Created and developed tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Recovering the databases from backup in disasters.

Environment: SQL Server 2005/2000, SSRS, MS EXCEL 2003, MS Access 2003, PL-SQL, MS SQL Query Analyzer, SQL Profiler, Java, Java Script, SSIS, SQL Server Enterprise Manager, Windows 2003 Server and MS Office.