4+ years of experience as a SQL developer.
Good understanding of RDBMS.
Experience working in Agile methodology.
Experience in design and development of various relational databases using SQL server 2012/2008 R2/2005.
Experience in implementing various database objects like stored procedures, views, functions, triggers etc. using T-SQL.
Expertise in migrating from MS Access to MS SQL, MySQL to ORACLE, MS SQL to MySQL and vice versa.
Having knowledge of developing and monitoring SSIS, and SSRS packages.
Strong experience in Backup, Restore and Replication.
Strong experience in database Maintenance, Deployments, Performance monitoring.
Experience using various configuration management tools like JIRA, ALM, TFS etc.
Experience working on complex SSIS packages involving multiple data sources of different formats.
Excellent communication and inter personal skills with exceptional ability to learn new concepts.
Good at finding root cause for production issues and provide a quick resolution.
Ability to quickly understand the existing system, Environment.
Strong analytical skills, organizational and coordination skills
RDBMS: Microsoft SQL SERVER 2000/2005/2008/2012/2016, Microsoft Access 97/2000, Oracle Sybase.
Reporting tools: SSRS, ACTIVE Reports, Crystal Reports, Performance Point.
ETL tools: SSIS Integration Service (2005/2008/2012).
Languages: C, T-SQL, SQL, PL/SQL, Shell Scripting, Xml.
Tools: Microsoft office, Microsoft Visio, Erwin 4.0.
Database Utilities: Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, DTS/SSIS,
Database Tuning Advisor, Business Intelligence Development Studio (BIDS).
Version control: TFS, Visual source safe, PVCS, Team Coherence.
Webject Systems, Inc. April, 2014 to Present
Professional Project Experience
April 2015 - Present
Involved in development, deployment, scheduling, and troubleshooting SSIS packages in SQL Server2005/2008, 2012.
Created SSIS Packages using Control flow containers/tasks such as For Loop, For Each Loop, Execute SQL Task, Execute Package Task, Data flow tasks etc to load data from multiple source systems (File system, SQL & Oracle) into our Data warehouse system.
Involved in database design, normalization, de-normalization to build the data warehouse and reporting systems
Involved in complete life cycle of project, from Planning, Staging, development, Implementation and migration into production environment.
Generated multiple enterprise reports (SSRS/Crystal) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as Group by, Drilldowns, Drill through, Sub-reports, Dashboard, Matrix, Charts and Navigation Reports (hyperlink) etc.
Scheduled SSRS reports in Report Manager and created Linked Reports, Ad-hoc Reports and etc. based on the business needs.
Worked in Agile Environment.
Involved in installation, configuration, managing, monitoring and troubleshooting SQL Server.
Developed complex SQL Server database objects such as Stored Procedures, Views, Functions, Triggers using Joins, Variables and Temporary tables etc.
Generating complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
Prepared data validations scripts for various business teams across the organization for financial month-end closing activities, weekly/monthly Gross/ Net customer counts for Sales team.
Hands on experience in using DDL Triggers (After and Instead of Triggers) to keep track of data manipulations using audit functionalities.
Involved in query tuning by creating table Indexes, SQL Profiler and Index Tuning Wizard (ITW) for enhancing the query performance.
Experience in SDLC life cycle and deployed SQL Scripts/Objects from Development to Test, SIT, UAT and production environments and automated as SQL Agent Jobs.
Created complex SSIS packages with various DFT tasks such as Derived Column, Conditional Split, Data Conversion, Lookup, and Script tasks etc., using user variables to load into data warehouse systems.
Implemented standard and custom SSIS Package logging in SQL Server tables and text files.
Used SSIS Package Configurations stored in XML files and SQL Server Tables.
Deployed SQL Server SSIS packages to SQL Server and File system from development to test, SIT, UAT and production using package configurations and other 3rd party tools.
Involved in SSIS package automation using SQL Server Agent, Windows Scheduler and other 3rd party tools such as Control-M
Tools and Technologies: MS SQL Server 2005/2008 R2/2012/2016, Oracle 10g, Visual Studio 2005/2008/2010/2012 and 2013, SQL Server Reporting Services (SSRS 2005/2008/2012), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Visual Source Safe, Toad, MS Excel.
Client: Mustang Engineering
April 2014-April 2015
Mustang has established a worldwide reputation for quality engineering, design, project management, and construction management services to the oil and gas; refining and chemical; pipeline; automation and control; and process and manufacturing industries. Performing with energy, innovation, excellence and quality, Mustang provides a full range of services for offshore structures and onshore production facilities, pipeline projects and non-energy process and industrial facilities.
Involved in complete life cycle of project, from Planning, Staging, development, Implementation and migration into production environment
Worked with end-users to analyze, understand, and gather requirements for BI Solutions
Created schemas, views, stored procedures, Triggers and functions for Data Migration.
Written T- SQL, Pl/SQL queries for data retrieval from different data sources
Fine-tuned SQL queries using hints for maximum efficiency and performance
Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
Involved in migrating the data from Oracle and FTP servers to the SQL server Data bases through Visual studio 2008.
Migration and conversion of Crystal reports to SSRS reports.
Wrote T- SQL code/Stored procedures to create datasets for SSRS reports.
Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
Performed unit testing of reports on QA databases
Tested ETL Packages and fixed bugs using SQL 2008 Business Intelligence Development Studio.
Worked with installation, configuration and deployment of SQL Server Reporting Services (SSRS), developed various enterprise reports, drill thru reports, drill down reports and multi-valued parameter reports.
Worked with SSRS 2008 Report Builder and allow customers build their reports using Report Builder.
Involved in documenting the entire technical process.
Supported technical teams involved with MS SQL issues and operations.
Tool and Technologies: SQL Server 2005/2008/2012, Oracle10g, MS-Access, SMS, SQL Profiler, Security Manager, SSIS (2005/2008/2012), SSRS (2005/2008/2012), XML, Crystal Reports, Oracle 10g, Toad, TFS, .Net (Asp .Net, C# .Net).
Education And Qualifications: Bachelors Of Technology (Jawaharlal Nehru Technological University).