Sql Bi Dev Lead Resume
5.00/5 (Submit Your Rating)
TX
SUMMARY
- 14+ Years of technical and functional experience in Information Technology, Database Administration, Architecture and Developer for very large and complex databases in SQL Server 2016, 2014, 2012, SQL Server 2008 R2, 2008 and 2005.
- Microsoft Certified IT Professional - SQL Server Database Administrator 2008.
- Microsoft Certified IT Professional - SQL Server Database Developer 2008.
- Microsoft Certified Technology Specialist - SQL Server 2008 Business Intelligence Development.
- Microsoft Certified Technology Specialist - MOSS 2007 Application Development.
- Technical expertise in SQL Server 2000/2005/2008/2012/2014/2016 and SQL Server BI Suite (SSIS, SSRS, SSAS)
- Handled all aspects of Development Lifecycle including Architectural Design, Feasibility Studies, Scheduling, Release, Documentation and Support.
- Development Projects in SQL Server 2000/2005/2008/2012/2014/2016 and Microsoft.Net.
- Interaction with Clients during requirements, Design, Acceptance.
- Expertise in Administering SQL Server 2000/2005/2008/2012 and SQL Server Data.
- Involved in Process Definition and Process Improvement.
- Review of Specifications, Design, Code, Test Plans. Internal Auditing of the projects.
- Generation of status reports and managing team to ensure delivery on time.
- Upgrade from SQL 2000 to SQL 2005, SQL 2008 and SQL 2012, 2014, 2016.
- Handling all responsibilities in SQL Data Model (Logical and Physical) up to third Normal form.
- Extensive usage of filegroups, Capacity Planning, Creating Indexes for better performance.
- Designing, Setting up environments for Development, UAT, Production.
- .Net Framework upgrade from 3.0 to 4.0.
- SharePoint Portal migration from MOSS 2007 to MOSS 2010.
- Expertise in publishing/deploying application along with SharePoint portals using SharePoint designer.
- Created, Scheduled and monitoring jobs using Control M tool.
- Developed web applications using C#.net, ASP.Net, ADO.Net, XML, AJAX.
- Creating Master Data and Test Data. Creating & scheduling regular maintenance jobs.
- Administering SQL Server High Availability and Disaster Recovery strategies.
- Preparation of Project specific Coding Standards and Templates.
- Expertise in writing Stored procedures, User Defined Functions and Creating Views, Triggers.
- Creating Backups and Restoring Databases (Full and Transactional), USERs, Roles
- Expertise in ETL process i.e., creating SSIS packages with error handling.
- Designing solution framework for SSIS packages and Optimizing ETL Process.
- Migrated data from different sources, Oracle, Excel files, Flat files, older version of SQL Server.
- Used all typical features of SSIS like, FTP, Looping, Sequencing, File handling, XML tasks, Lookups, Scripting, Configuring packages, Logging events, Variables, Expressions and so on.
- Integrated .Net assemblies with SSIS Packages.
- Created Batch files to execute packages from DOS prompt.
- Expertise in creating and deploying reports on Report servers using SSRS.
- Optimization and tuning of report queries to improve performance. Integrating reports with .Net.
- Knowledge in Datawarehousing Concepts, Data Mining, Data Marts, Facts, Dimensions, Cubes.
- Good knowledge on visualization tools like TABLEAU, QLIKView.
- Helping out the development team in SQL Coding and Maintained Data Dictionary.
- Created and maintained Database project in Microsoft.Net.
- Preparation of Test Scenarios, Test Cases, Driving and executing Unit tests, Integration tests, System tests, User Acceptance tests.
- Expertise in Debugging, Troubleshooting and resolving live, high-impact issues
- Extensively used SQL Profiler to monitor the activities and for Index tuning wizard.
PROFESSIONAL EXPERIENCE
Confidential, TX
SQL BI Dev Lead
Responsibilities:
- Designed Schema, Database Normalization up to 3NF and created required Tables.
- Created requirement documents and other mapping documents.
- Creating SSRS Reports, Publishing Reports, and Deploying to report Server.
- Created SSIS Packages to extract data from excel sheets to SQL Database.
- Helping out the development team in SQL Coding and Maintained Data Dictionary.
- Maintaining the Databases across production and Development QA servers.
- Rebuilding / Monitoring the indexes at regular intervals for better performance.
- Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
- Extensively worked on SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
- Created, Scheduled and monitoring jobs using Automate tool.
- Coding views, stored procedures, triggers, functions and creating SSIS packages, SQL Agent jobs etc.
- Deployment of SSIS packages to UAT and productions environments with configuration variables.
- Reviewing all SQL code which is going to UAT and PROD and make required recommendations.
- Prepared the project management and technical documentation.
- Unit Testing the SSIS packages with respect to its flow and performance issues.
- Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services. Extensively worked on DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
Confidential, TX
Sr Database Architect
Responsibilities:
- Coordinates with the Onsite/Offshore team with respect to build and maintenance releases.
- Responsible for installation and configuration of SQL server 2014 and 2016.
- Migrated SQL server 2008 to SQL Server 2014/2016 in Microsoft Windows Server 2012 Enterprise Edition.
- Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2014.
- Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services. Extensively worked on DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
- Rebuilding / Monitoring the indexes at regular intervals for better performance.
- Used Quest Foglight PI for performance monitoring and reporting.
- Reviewed and handled all change requests accordingly and supervised the changes are in place with in time.
Confidential, TX
Sr Database Architect, Team Lead
Responsibilities:
- Designed Schema, Database Normalization up to 3NF and created required Tables.
- Created requirement documents and other mapping documents.
- Coordinates with the Onsite/Offshore team with respect to build and maintenance releases.
- Created SSIS Packages to extract data from excel sheets to SQL Database.
- Helping out the development team in SQL Coding and Maintained Data Dictionary.
- Maintaining the Databases across production and Development QA servers.
- Coding views, stored procedures, triggers, functions and creating SSIS packages, SQL Agent jobs etc.
- Deployment of SSIS packages to UAT and productions environments with configuration variables.
- Reviewing all SQL code which is going to UAT and PROD and make required recommendations.
- Prepared the project management and technical documentation.
- Unit Testing the SSIS packages with respect to its flow and performance issues.
- Responsible for installation and configuration of SQL server 2012 database on Dell Servers.
- Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services. Extensively worked on DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
- Rebuilding / Monitoring the indexes at regular intervals for better performance.
- Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
- Extensively worked on SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
Confidential, TX
Database Administrator, ETL Lead
Responsibilities:
- Migrated database from SQL 2005 to SQL 2008 and to SQL 2012. Convert DTS packages to SSIS and equivalent Confidential -SQL
- Reviewing all SQL code which is going to UAT and PROD and make required recommendations.
- Restructured the existing deployment process to make it fast and efficient.
- Prepared the project management and technical documentation.
- Unit Testing the SSIS packages with respect to its flow and performance issues.
- Responsible for installation and configuration of SQL server 2005 database on Dell Servers.
- Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
- Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
- Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services. Extensively worked on DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
- Rebuilding / Monitoring the indexes at regular intervals for better performance.
- Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
- Extensively worked on SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
- Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
- Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
- Eenforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
- Followed Agile model for the development activities.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Complete documentation about the database. Recovering the databases from backup in disasters.
Confidential
Database Architect, ETL Lead
Responsibilities:
- Responsible for installation and configuration of SQL server 2005 database on Dell Servers.
- Involved in data modeling for the application and created ER diagram using ERWin.
- Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project. Upgrade from SQL 2005 to SQL 2008.
- Implemented database standards and naming convention for the database objects.
- Developed SSIS packages to extract, transform and load into the database from source system.
- Query optimization and performance tuning.
- Documented Tech Spec and HLD, LLD Documents.
- Maintaining the Databases across production and Development QA servers.
- Backup/Restore between different environments.
- Provided relevant documentation such as install guides, implementation plans etc.
- Coding stored procedures, triggers, functions and creating SSIS packages, SQL Agent jobs etc.
- Creating Jobs to pull data from OLTP database to External Interfaces.
- Creating SSRS Reports, Publishing Reports, and Deploying to report Server.
- Helping out the development team in SQL Coding and Maintained Data Dictionary.
- Maintaining the Databases across production and Development QA servers.
- Coding views, stored procedures, triggers, functions and creating SSIS packages, SQL Agent jobs etc.
- Deployment of SSIS packages to UAT and productions environments with configuration variables.