SUMMARY:

• More than eight years of progressive work experience as business analyst, database analysis, design, development of databases for backend applications using SQL Server 2008R2, 2012, 2014 and 2016
• Extensive knowledge and experience with ER Diagram and design of logical and physical data modeling using Erwin, Visio, Toad and draw.io
• Experienced in creating and using Stored Procedure, Views, Triggers, schemas, and Complex queries, Common Table Expressions, Cursors, Functions, User - Defined Types and Dynamic SQL.
• Expert on installing and configuring MS SQL Server 2005\2008\2008-R2\2012\2016
• Hands on experience in configuring SQL Server Reporting Service, Report manager and Report Server
• Expert on Configuring MS SQL Integration Service Catalogs
• In depth experience in using SQL Server Data Tool (SSDT) and business intelligence development studio (BIDs)
• Sound knowledge of Data marts, Data warehousing, Operational Data Store (ODS), Dimensional Data Modeling, Star and Snow-Flake schema Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Hands on experience in configuring Data Flow source and destination connection strings
• Expert in creating Dynamic SSIS Packages with Parameters, local and environmental variables, XML configuration and check points.
• Hands on Experience on SSIS package development, deployment and scheduling.
• Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports, and interactive reports using SQL Server Reporting Service.
• Experienced in Database Optimization using SQL Profiler
• Experienced Creating and Managing Indexes.
• Experienced working on Agile Projects with Multiple Sprints cycles and Scrum meetings
• Experienced using Agile Project management tools like JIRA
• Experienced to translate reporting and analytical needs into technical solutions.
• Strong interpersonal & communication skills, Competitive analytical, logical, and problem-solving skills, Strong management, administrative and leadership skills to work in team

TECHNICAL SKILLS AND TECHNOLOGIES:

SQL Server: SQL Servers 2008/2008R 2/2012/2014/2016 and associated tools such as SQL server Configuration manager, SQL Server Reporting Services Configuration Manager, SQL Server Data Profiler, SQL Server Tuning Advisor

Other DBMSs: MySQL and Oracle 10g (10.2)

BI Design Tools: SQL Server BI Stack (SSRS, SSIS, SSAS), MS Excel Report builder 3.0, Visual Studio, Windows 2003 Server, Windows Server 2008, MS TFS, MS-Access.

Programming Languages and Environment: C#, Java, Python, Visual Studio, JavaScript and .Net Framework

Desktop Tools: Microsoft office 365 and lower versions (Word, Excel, Power Pivot, Outlook, and PowerPoint) to communicate solutions among team and to clients of BI solutions.

Cloud Environment: AWS, Azure and GCP

PROFESSIONAL EXPERIENCE:

SQL\ETL Developer

Confidential

Responsibilities:

• Design, create, improve and implement database systems based on the end user's requirements.
• Prepare documentations for database applications.
• Develop database schemas, tables, dictionaries and ensure the data quality and integrity in databases.
• Fix any issues related to database performance and provide corrective measures
• Create complex Stored Procedures, Functions, Views, Indexes, SQL joins and Sub queries for applications.
• Interact with the ETL Lead, Solution Architect, and other DB Team Members to understand business requirements and provide expert knowledge by ensuring delivery of business needs in a timely and cost-effective manner.
• Responsible for data collection, data staging, data movement, data quality and archiving strategies.
• Design and Develop complex SSIS packages for performing ETL process using SQL Server Integration Services.
• Use integration services for transferring and reviewing data from heterogeneous sources like (Flat file, Excel, CSV, Oracle, MS Access, and Oledb).
• Provides reviews of the deliverables and identifies gaps and areas of improvement.
• Provide, troubleshoot and upgrade the system as the need arises and provide post-implementation support.
• Responsible for Data Profiling to determine data integrity for transformation of Data from Source to Target.
• Experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Extraction, Transformation and Loading (ETL).
• Design automation processes to control data access transformation and movement and ensures source system data availability.
• Design the development for logical and physical data models.
• Experience in data warehousing architecture techniques including MOLAP, ROLAP, ODS, DM, and EDW.
• Develop several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Use Bulk Insert to load large data into staging table.
• Proficient in Testing methodologies, Test Matrices and Trace matrix.
• Develop various types of reports like Drill down, Drill through, tabular, matrix and parameterized reports using SQL Server Reporting Services (SSRS)
• Develop best practices for database design, ETL life cycle and development activities.

SQL/MSBI Developer

Confidential

Responsibilities:

• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.
• Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins and creating indexes wherever necessary.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like SSIS, BULK INSERT etc.
• Developed, monitored and deployed SSIS packages for ETL flow to validate, extract, transform and load data into database.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Deployed analysis projects using SSAS based on data volume, as well as developed of KPI's which helped the Business users for easy understanding.
• Documented and delivered Functional Specification Document to the project team by using SQL Server.
• Involved in scheduling the reports and setting security for reports.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track report history using SSRS.
• Developing and maintaining strong client relations with senior and C-level executives—developing new insights into the client’s business model and pain points, and delivering actionable, high-impact results
• Participating and leading client engagement in developing plans and strategies of data management processes and IT programs for the clients, providing hands on assistance in data modeling, technical implementation of vendor products and practices
• Facilitating, guiding, and influencing the clients and teams towards right information technology architecture and becoming interface between Business leadership, Tech leadership and the delivery teams
• Scoped Client requirements, supported business development and ensuring high levels of client satisfaction during delivery
• Designed and developed reports, scorecards and dashboards
• Participated with End-users and do requirement gathering and convert into technical documentation and provide best practice advice to customers and team members
• Prepared high - level Architecture designs for the SSAS/SSRS reporting solutions.
• Identified the performance bottle-necks in the report and resolve the same

Junior SQL Server DBA

Confidential

Responsibilities:

• Installed, configured and upgraded installations of SQL server 2008/2012/2014/2016.
• Involved in planning and administration of Failover clustered environment.
• Involved in performance tuning for the optimization of slow running queries and index maintenance.
• Automated SQL Server Agent jobs for Periodic Backups with Backup Devices and Database Maintenance Plan.
• Test databases and perform bug fixes.
• Report on daily basis of server backup status.
• Performed security administration including creating various user groups and assigning the accessibility according to requirement, monitoring the user accounts, creating user accounts, granting the privileges to users and groups.
• Provide authentication and authorizations for Database
• Implemented maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space).
• Develop best practices for database administration, governance and development activities.