SUMMARY

• 7 years of experience in Database - Design, Development, Support, and Deployment of enterprise applications in Airlines, Insurance and Telecom Domains.
• Highly proficient in Microsoft SQL Server, Business Intelligence tools - SQL Servher Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS).
• Hands on experience in creating process flow diagrams, data flow diagrams, export and import data between databases.
• Also performed data manipulation, system analysis, one to many and many to one relationship during data migration between two databases, and testing.
• Experience in extracting, loading data to/from sources like OLEDB, Excel, Flat files etc. using SSIS with Error handling, notifications and package configurations.
• Involved in the analysis of business requirements and technical requirements. Actively participated and interacted with team lead, technical manager, and lead business analyst to understand the business requirements.
• Experience in creating normalized tables by establishing foreign key and primary key relationship between tables.
• Experience in technical design implementation, creating/developing database objects like Tables, Views, Functions, Stored Procedures, Triggers, T-SQL queries, Dynamic Queries and Exception Handlers.
• Experience in analyzing, fixing, and testing the issues/bugs from Incident Management portals, Service Request processes.
• Support and monitor the Processes, Jobs, and Triggers as per the changes in the business requirements.
• Prepare the scripts for the DDL and DML operations which are being used during the deployment process as part of supporting the backend database operations during QA, UAT, Production deployments.
• Perform unit testing, user acceptance testing to check whether the data is loading into the target, which was extracted from different source systems.
• In addition to this, he has good experience at working in an Agile Environment using Scrum Methodology.
• Also have experience in Informatica, Oracle PL/SQL, and UNIX.
• Have good self-learning capability where he has developed knowledge in Informatica ETL.

TECHNICAL SKILLS

Relational Databases: Microsoft SQL Server, Oracle, PL/SQL

Development Tools: SQL Server Management Studio (SSMS), SQL Developer, SQL

Server Integration Services: (SSIS - ETL), SQL Server Reporting Services (SSRS), Microsoft Visual Studio

Operating System: Windows, UNIX

Source Control: GIT, TFS(Team Foundation Server)

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg, PA

SQL Developer

Responsibilities:

• Created SSIS packages for loading data to data warehouse databases and process SSAS cubes to store data to OLAP databases.
• Performed Extraction, Transformation and Loading (ETL) data from Flat file, Excel (spread sheet), MS SQL and Oracle to MS SQL Server database by using SSIS services and BCP utility.
• Used SSIS transformations such as, For-Each Loop Container, Sequence Container, Expressions, and Execute SQL task.
• Extracted data from oracle by staging the data and perform transformations and import to the target database.
• Worked with SSIS packages involving FTP tasks, Merge, and Merge joining, Sort, Pivot and Unpivot Control Flow Transformations.
• Scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Procedure to generate consolidated (fact/summary) data identified by dimensions using SSIS (ETL) depending on the frequency of the source data changes,
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Work on incidents and tickets within SLA supporting multiple applications from the backend (database).
• Used UNIX commands to manually run the adhoc-process and cron jobs as part of supporting the operations.

Environment: SQL Server, SQL Server Integration Services (ETL), SSAS, Server Integration Services, SQL server Reporting Service, Microsoft Visual Studio, SQL Server Management Studio, T- SQL, UNIX

Confidential

MS SQL Developer

Responsibilities:

• Was responsible for understanding and analyzing the business requirements.
• Created tables, views, procedures, functions, triggers, cursors, and stored procedures.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Perform Extract, Transform & Load processes using SSIS (ETL).
• Deploy and schedule reports using SQL Server Reporting Services to generate all daily, weekly, monthly, quarterly and random Ad-hoc reports for various business users.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Improved stored procedures and SQL Queries performance by analyzing execution plans and creating proper indexes using SQL Profiler and database tuning advisor.
• Responsible for detailed analysis and design using Microsoft Technologies for services that will support internal and external clients facilitate and deliver on business needs for functional and business mapping.
• Experience in providing logging, error handling by using event handler, and custom logging for SSIS Packages.
• Prepare scripts for the database changes done.
• Perform unit testing and integration testing.

Environment: MS SQL Server 2017, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, MS Office, OLAP, Oracle, Windows Server.

Confidential

SQL Developer

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Generate reports using SSRS with various sources and targets like Flat Files, CSV, database tables etc.
• Extensively worked on data modeling, data analysis, reporting, and SQL development.
• Execute process task using SQL CMD, BCP commands.
• Worked on SSIS packages with FTP tasks, merge, and merge joining, sort, pivot and unpivot control flow transformations.
• Perform support activities and fix the issues in SSIS and SSRS packages.
• Developed SQL queries with multi-table joins, group functions, sub queries and T- SQL stored procedures, user defined functions (UDFs) for data analysis.
• Perform data flow generic column mapping, excel files incremental loading using SSIS.
• Update/Modify the database objects as per the business changes
• Prepare SQL scripts for the changes done which are to be executed in higher environments.
• Created and modified the indexes on the tables and views for the improvement in the performance of SQL Stored procedures.
• Developed modular ETL applications which enable the flow of data between data sources using SSIS.
• Created data flow components that are used to perform aggregations, sorting, merging, modifying, joining, data cleansing, and distributing the data.
• Responsible for extracting, transforming and Loading data from flat files and inserting the data it into Oracle database tables.

Environment: Microsoft SQL Server 2016/2014, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, BIDS 2016/2014, Windows Server, MS Visio, Oracle, Windows Server.

Confidential

MSBI Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Perform the development activities, documentation and troubleshoot the ETL processes.
• Develop complex aggregate function, join, lookup transformation, stored procedures.
• Develop ad-hoc reports for various business users using the SSRS.
• Used various ETL tools like SSIS for data flow from source files like XML, Excel, tables and views to other databases or files with proper mapping.
• Responsible for extracting, transforming and loading data from flat files and placing it into Microsoft SQL server database tables.
• Created and modified tables, stored procedures, views, indexes, user-defined functions, and triggers etc.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created complex stored procedures with parameters and generated SSRS reports from them, where the user has a choice to input the parameters.
• Deploy and schedule reports using SQL Server Reporting Services to generate all daily, weekly, monthly, quarterly and random.

Environment: MS SQL Server 2012, SQL BI Suite (SSAS, SSIS, SSRS), Visual Studio, Visual Source Safe (VSS), Pl/SQL, MS Project, MS Access, Team Foundation Server, Oracle, Windows Server.