SUMMARY

• SQL Developer with 6 years of progressive experience in Database Design, Database Optimization, Application Programming, and Performance tuning.
• Diverse knowledge and experience of complex scripting T - SQL queries, Complex Stored Procedures, User Defined Functions UDF, and Database Triggers, using tools like SQL Profiler and Database Tuning Advisor DTA.
• Involved in the understanding of business processes, grain identification, and identification of dimensions and measures for OLAP applications. Created slowly Changing dimensions (SCD) and optimized fact table inserts.
• Proficient in creating complex T-SQL queries for data analysis and data manipulation. Organize analytical data, ensure data quality, and aggregate data for strategic reporting, and performance optimization on database solutions.
• Proficient experience in creating various types of reports like complex drill-down reports & drill-through reports, Matrix reports, sub-reports, and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, and Triggers.
• Extracted, transformed, and loaded data from heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, and flat files using connectors, tasks, and transformations provided by SSIS.
• Extensive knowledge in Extraction, Transforming, and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert, and BCP.
• Sophisticated grasp of SQL code generation, analytics, reporting, and business intelligence.
• Accomplished deadlock troubleshooting and resolving issues by debugging programs and managing databases.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, user and application table management, upgrades, and creating databases/file groups/files/transaction logs.
• Hands-on experience in Atlassian Jira tool, Bitbucket, and BMC Remedy.
• Experience in creating test data and unit test cases. Writing test cases and system plans to ensure a successful data-loading process.
• Technologically savvy and focused SSRS developer with a strong background in advanced data management and troubleshooting skills.
• Proficient at data architecture design, emerging data warehouse concepts, and new SQL development techniques.

TECHNICAL SKILLS

Operating Systems: Windows 10/7/Vista AdvancedServer, Windows NT.

Databases: MSSQLServer2016,2014,2012,2010, 2008 R2, 2008, Oracle, MS-Access.

Programming Tools: T-SQL, MySQL, VB, C#

Database Tools: MySQL, SQLProfiler, Query Analyzer, Profiler Database Engine Tuning Advisor (DTA).

Reporting Tools: SQLServerReporting Services (SSRS), Tableau, Power BI

ETL Tools: SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS)

Web Technologies: HTML, CSS, VB Script, XML, JavaScript, PHP

Other Tools & Utilities: Visual Studio, MS Office/Excel, Eclipse, FileZilla, Git, TFS, and Bitbucket.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL/BI Developer

Environment: - Microsoft SQL Server 2017/14, SSIS, SSRS, SSAS, XML, ETL, OLTP, OLAP, FTP, ASP.Net, C#, VB.Net, SQL Profiler, Windows XP, and Bit Bucket

Responsibilities:

• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like executing SQL Tasks, bulk insert tasks, data flow tasks, file system tasks, send mail tasks, active script tasks, XML tasks, and various transformations.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins, and other T-SQL code to implement business rules.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Applied various types of Control Flow tasks and Data Flow tasks like Container, execute a task, Script task, Transfer for Loop Container, Aggregate, Derived column, and Transfer Database Task according to the need of Data Transform and Data Cleansing and insert new data into Database using SSIS 2017.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Wrote Parameterized Queries for generating Tabular reports, Formatting report layout, creating reports using Global Variables, Expressions, and Functions, Sorting the data, Defining Data Sources and Datasets, and calculating subtotals and grand totals for the reports using SSRS 2014.
• Developed and created new database objects including tables, views, indexes, stored procedures and functions, advanced queries, and updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Created Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Imported the huge text files, and CSV files data from FTP through SSIS to the local environment.
• Deployed the SSIS Setup and Database Setup in production environments.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins, and created Clustered/Non-Clustered indexes wherever necessary.
• Created Temporary Table and Common Table Expression (CTE) for query Optimization and performance tuning.
• Resolved Bugs in the production Environment created by Quality Assurance.
• Reporting on a weekly basis to the project manager.

Confidential, Dallas, TX

SQL/SSIS Developer

Environment: - MS SQL Server 2017/2014, SQL Server Integration Services, SQL Reporting Services, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, TFS, Visio.

Responsibilities:

• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Tune various packages for reducing their processing time by using a parallel processing approach and using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server.
• Created and managed stored procedures, indexed views, user-defined functions, triggers, database constraints to meet business requirements and policies.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Applied various types of Control Flow tasks and Data Flow tasks like Container, execute task, Script task, Transfer for Loop Container, Aggregate, Derived column, and Transfer Database Task according to need of Data Transform and Data Cleansing and insert new data into Database using SSIS.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Used BCP to transfer the data files to another server.
• Responsible for creating parameterized and drill down reports based on the requirements using SSRS.
• Used TFS to store, run, view, edit and revert to different versions of the design in case of a system crash.
• Performed SSIS scripting using vb.net and C# Script to create XML File and Flat File.
• Translated requirements, designs and functional specs into effective test plans and test cases.

Confidential, Dallas, TX

SQL Developer

Environment: - SQL Server 2014, SSRS, SSIS, ETL, T-SQL, MS Excel, MS Access, MS Visio.

Responsibilities:

• Supported Extract, Transfer, Load (ETL) efforts using Integration Services tools. Created, configured, modified, and tuned SSIS packages.
• Gathered & analyzed requirements, understood business requirements & specifications from the business and technical perspective, redesigned the ETL process from the existing legacy DTS packages into SSIS Packages.
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, FTP Task, For Each Loop containers etc.
• Develop code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues.
• Develop Unit test cases and perform Unit testing of assigned components
• Interacted with clients to analyze business needs. Provided software product design and developed technical roadmaps for the solution through the project lifecycle and Confidential .
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Troubleshoot failed jobs on the server which involved stored procedures/SSIS packages.
• Scheduled the SSIS packages to run at different intervals to load the data.
• Very Strong ability to understand and support installation/upgrades of Third-Party Software.
• Responsible for creating schema objects like tables, views, and indexes.
• Designed and Developed the Dashboard Reports in power BI using DAX. Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server
• Used TFS for version control.
• Created documentation as required for operational support.