PROFESSIONAL SUMMARY:

• 10 years of IT experience as a software engineer which includes Software Development, Data Extraction, Business Intelligence, Performance Tuning, ETL Development, MS SQL Server, SSIS, SSRS, SSAS, MSSQL, C#, Ado.Net, ASP.NET, GIT HUB, Jenkins.
• Highly skilled and experienced in agile process for diverse applications.
• Strong Database skills in MS SQL servers, C#, ASP.NET, SSIS, SSRS, SSAS.
• In depth knowledge on Transact SQL. DDL, DML, creating indexes Views, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Experience inMicrosoft Visual C#in script component of SSIS.
• Expertise in writingT - SQL Queries, Dynamic-queries, sub-queries and complex joins for generatingComplex Stored Procedures, User-defined Functions, Views and Cursors.
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Developing experience and understanding of SSAS, OLAP cube and architecture.
• Experience in Data Extraction, Transforming and Loading (ETL) between various systems using SSIS.
• Develop high-performance data visualizations, reports, and dashboards utilizing Power BI.
• Utilize DAX to create Measures for visualizations in Power BI.
• Creating visually appealing dashboards for business stakeholders.
• Experience in code repositories like GIT.
• Worked on Autosys. Have knowledge in creating and monitoring Autosys Jobs.
• Have basic knowledge on Jenkins.
• Have good knowledge on agile methodology - PI planning, sprints, scrum
• Worked with onshore teams to coordinate with the development process.
• Involved in designing and updating the application documentation as required.
• Excellent knowledge of software development life cycle
• Willing to update my knowledge and learn new skills to perform efficiently.
• Strong problem solving, analytical skills, good verbal, written communication and presentation skills and ability to work in a time-constrained and team-oriented environment
• Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS:

Operating Systems: Win 2008/2010 server.

RDBMS: MS SQL SERVER 2008/2010/2012.

Database Tools: SQL Enterprise Manager, Management StudioSQL Server 2005, Query Editor, SSAS.

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS)

Reporting Tools: MS SQL Server Reporting Services (SSRS), Power BI.

BI Tools: MS SQL Business Intelligence, Business Objects.

Programming Languages: C#, Ado.Net, Asp.Net, and XML.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

• Work with an agile development team to develop, test, and maintain web-based business applications built on Microsoft technologies.
• Work with teammates in the migration of older applications to current Microsoft technologies, including migration of legacy data.
• Develop high-performance data visualizations, reports, and dashboards utilizing Power BI.
• Utilize DAX to create Measures for visualizations in Power BI.
• Understand requirements and design of intended solutions.
• Analyze and resolve technical and application problems.
• Understand requirements and design of intended solutions.
• Participate in the user stories and requirements discussions.
• Develop SQL queries, scripts, schema, stored procedures, and reports

  Perform unit testing and defect resolution.

• Contribute to overall development efforts within an agile environment.
• Build, debug, monitor, and troubleshoot databases and ETL processes to ensure optimal performance, reliability, and integrity.
• Communicate with team members to define data repositories and analysis needs.

Confidential

MSBI/SQL Developer

Responsibilities:

• Created custom tasks in ETL packages.
• Involved in creating DB structures along with Architect.
• Create, test and document the test scenarios.
• Implementation of Complex Stored Procedures, CTE, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.

Confidential

MSBI/SQL Developer

Responsibilities:

• Worked on MDS implemented stored procedures to integrate data with MDS DB.
• Worked on Autosys job’s creation.
• Provides technical documentation of the changes in given user story/bug.
• Implementation of Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports..
• Created and managed OLAP cubes using SSAS to feed to Power BI.
• Actively supported Business users for change requests and provide support to team members.

Confidential

SSIS Developer

Responsibilities:

• As a developer I am responsible for the systems study, analysis, understanding systems and design.
• Implementation of MS SQL Server 2010/2012 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed, deployed, and monitored SSIS Packages.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Text format data) to SQL Server.

Confidential

SQL/SSIS Developer

Responsibilities:

• Involved in designing the application as required.
• Implemented Data Access Layer using ADO.NETto connect and retrieve or manipulate database information.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.
• Involved in migration of SSIS Packages 2008 and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Involved in creating SP’s and Jobs.
• Provided support by troubleshooting and solving the issues.

Confidential

SQL/SSIS Developer

Responsibilities:

• Developed and Optimized Stored Procedures and Functions using T-SQL
• Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic sql, Merge statements. Built and monitored indexes to bring down processing times
• Created and scheduled SQL Agent jobs
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Involved in data transfer using Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Confidential

SQL/SSIS Developer

Responsibilities:

• Developed and Optimized Stored Procedures and Functions using PL-SQL
• Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic sql, Merge statements. Built and monitored indexes to bring down processing times
• Implementation of Complex Stored Procedures, User Defined Functions (UDFs) VIEWS