SUMMARY:

• Over 6+ years of IT experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), installation and configuration of MS SQL Server.
• Proficient in Microsoft suite of products like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Strong in SQL Server 2016/2 developer skills.
• Hands on experience with installation and configuration of MS SQL Server 2016/2012/2008 versions on Stand - Alone and Clustered base environment.
• Expertise in backup and restore using Import/Export wizard and generating scripts.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Expertise in scheduling database tasks like Jobs, Alerts, Notification and Emails.
• Hands on experience in writing SQL Queries, Scripts, Stored Procedures and functions.
• Experienced in performance tuning using SQL Profiler, Query optimization and Database consistency checks using DBCC commands.
• Knowledge of data extraction from different sources, performing transformations and populating the data to the destination using SSIS.
• Skilled in error and event handling: Precedence Constraints, Break Points, Check Point and Logging.
• Excellent work experience in creating packages to handle Incremental loads and Slowly Changing Dimensions to update data in Data warehouse using SSIS.
• Hands on experience in deploying SSRS reports in the test/production servers.
• Knowledge of creating Tabular reports, Drill-Down reports, Drill through, parameterized reports, Ad-hoc reportsusing SSRS.
• Proficient in deploying reports and creating subscriptions on the report manager to provide access to the specific reports to the business users.
• Worked on all activities related to the development, implementation administration and support of ETL process for large-scale data using SSIS.
• Create Business Intelligence reports and Design Dashboards.
• Create Dashboards on the data collected using Tableau Desktop.
• Analyze Social media (Facebook and Twitter) using Maltego.
• Gathering information (User name, email address, relationships) using Shadow Dragon.
• Goal oriented with business and technical background skills. Adaptable to new environment quickly.
• Meticulous and Articulate. Quick learner.
• Possessing excellent interpersonal, analytical and negotiation skills towards the accomplishment of organizational goals.
• Willing to learn and stay updated about the emerging Real - time Technologies.
• Ambitious to develop a career in a growing company where my skills and expertise will be utilized in achieving the goals and objectives of the organization.
• Ability to organize, schedule and coordinate workloads to meet established deadlines.

TECHNICAL SKILLS:

RDBMS::

MS SQL Server 2012/ 2008R2/ 2008, Oracle, Teradata, MS Access.

BI and SQL Tools: SSIS, SSRS, Business Intelligence Development Studio (BIDS), SSMS, Visual Studio, MS Visio.

TSQL: HTML, VBScript, PL/SQL

Opera21ting Systems: MS Windows 2010/08/07/03, Windows Server 2016/2014/2012/2008 R2, MS-DOS

Tools: Erwin, ER studio, ODBC, Teradata

Others: MS office 2013/2010/2007, Agile and waterfall methodology, Power Pivot, Qlik View, Tableau, MS Project Management, Tableau, Maltego, Shadow Dragon, SharePoint, Red Gate Pro, dB Forge SQL decryptor or, Tree Size.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, Texas

Software Engineer

• Actively participated in gathering business requirements and system specifications.
• Extracted Data from heterogenous source systems into the Operational Data Store and Data warehouse.
• Created SSIS packages to load the data into Data Warehouse using SSIS tasks like Execute SQL Task, Bulk Insert Task, Data Flow Task, and Send Mail Task.
• Created packages by implementing various transformations like Derived Columns,Conditional Split, Aggregation, Merge and Lookup for loading the data.
• Created SQL Agent jobs, maintenance plans to check SQL process failures to provide solutions and SQL Mail Setup.
• Worked on providing 24/7 support on rotation with multiple DBAs providing technical support in coordination with customer support.
• Automated and enhanced daily administrative tasks using scripts including space management, database backup and recovery.
• Created reports using SQL Server Reporting Services (SSRS) for customized and Ad-hoc queries.
• Created Tabular, Matrix, List reports and Parameterized reports, Drill down and Drill through reports.
• Develop and configure SSRS reports as per specifications provided by internal and external clients.
• Configure and setup Image archiving process on user’s PC on different windows platforms.
• Design and execute the test cases on the different applications as per HIPPA policy and TSG standards.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Analyzed complex reports and improved performance of reports by adding new filters to filter the data.
• Involved in Database writing SQL Queries, configure and troubleshooting TSG applications.
• Plan, design and implement application database code objects, such as stored procedures and views also work on SQL Server maintenance, patch deployment, backups.
• Identified data issues and provided recommendations for resolution to ensure optimal Performance. Work on support tickets, maintenance tasks and assigned projects at discretion of the Queue coordinator.
• Experienced working with Meditech and HIS applications.
• Experienced installing Windows Server 2012R2/ 2016 and Hyper-V.
• Management of Active Directory users, computers and group accounts
• Actively participated in interacting with users, team lead, DBAs to fully understand the requirements of the system.
• Performed database performance monitoring and tuning using system monitor, event log view, SQL profiler, SQL Query analyzer, stored procedure etc. monitored and resolved deadlocks and blocking.
• Created Indexes on columns having high selectivity and low density to speed up the execution of data retrieval queries and stored procedures.
• Create technical specifications and knowledge base documents.
• Work with business stakeholders, application developers. Production teams and across functional units to identify business needs and daily support issues.

Confidential, New Jersey

ETL Developer

• Involved in understanding and analyzing the business requirements providing better approach to the system.
• Designed and developed various SSIS packages to extract and transform data and involved in scheduling SSIS Packages using SQL Server Agent.
• Used various transformation tasks to create ETL packages for data conversion.
• Extract Transform and Load the source data into the respective target tables to build required data marts.
• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of the Data Warehouse.
• Performed cost benefit analysis of different ETL packages to determine the optimal process.
• Developed T-SQL functions, triggers, Inner Joins, Outer Joins and Indexes.
• Implemented Custom logging, Audit and Email notifications using SSIS.
• Compensation assisted with payroll, tax and account processing.
• Discount and commission margins for Welcome, Claim free and multipolicy.
• Created Parameterized reports, Drill-down reports and List reports using SQL Reporting Services (SSRS).

Confidential

MS SQL Server Developer/BI Developer

• Involved in planning, defining and designing data based on business requirements and provided documentation.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Established the relationships between tables using Primary Key and Foreign Key constraints.
• Involved in DE-Normalization of existing tables using Pivot transformation for faster query retrieval.
• Created packages to extract the data from OLTP systems to Data Warehouse using SQL Server Integrations Services (SSIS).
• Created Alerts for successful and unsuccessful completions of Scheduled jobs.
• Used various SSIS transformations such as Conditional Split, Derived Column which were used for Data Scrubbing and Data Validation checks during Staging, before loading the data into the Data Warehouse.
• Developed SSIS packages for File Transfer from one location to the other using File Transfer Protocol (FTP) task.
• Used ETL to implement the Slowly Changing Transformation to maintain Historical Data in the Data Warehouse.
• Experience in Debugging, Error handling for SQL Server Integration Services (SSIS).
• Created Sub-reports, Drill-down and Parameterized reports in SQL Reporting services (SSRS).
• Created Reports using SSRS from various data sources and deployed on the report server.
• Performed T-SQL tuning and optimization of queries for reports that look longer execution time using MS SQL Profiler and Index Tuning Wizard.

Confidential

ETL Developer

• Involved in installation and configuration of SQL Server 2014.
• Extracted the data from sourceslike SQL Server and Excel using SQL Server Integration Services and loaded into the SQL Database.
• Created packages by implementing various transformations like Derived Columns, Conditional Split, Aggregation, Merge and Lookup.
• Developed stored procedures and used for designing SSIS packages.
• Used the SSIS Import/Export to migrate the data to the SQL Server.
• Developed packages in SSIS with logging, checkpoints and breakpoints.
• Involved in Performance tuning by optimizing the existing SQL Query using SQL Profiler.
• Created Parameterized reports, Drill-down reports and Tabular reports using SQL Server Reporting Services.
• Involved in weekly meetings directly with the manager to discuss about the progress and provided the technical feedback based on the requirement provided.

Confidential

ETL Developer/DBA (Intern)

• Involved in gathering business requirements and system specifications.
• Created new databases, tables and established relationships between the tables in the database.
• Created Database objects - Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure and Constraints.
• Used Bulk Copy Program (BCP) utility to publish table output to text files.
• Involved in extracting data from MS Access, Oracle, Excel and loading into the SQL Server Database using SSIS.
• Monitored performance and optimized SQL Queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Used SQL Profiler to view index performance to mostly eliminate table scan.
• Maintained the consistency of the client’s database using Database console commands (DBCC) .
• Involved in Performance tuning and optimization of T-SQL Queries.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Set up SQL mail and created jobs to automate and schedule many tasks.