SUMMARY

• Over 9 years of IT experience in SQL Server (SSIS, SSAS, SSRS) using Microsoft technologies and Business Intelligence.
• Experience in all facets of Software Development Lifecycle (SDLC) including requirements gathering, analysis, design, development, Reporting, Testing, implementation, and post implementation support.
• Expertize in TSQL and PL/SQL writing SQL Queries, Stored procedures, Functions, Views, Triggers and cursors.
• Extensive experience in creating ETL packages using SSIS (SQL Server Integration Services) and writing SQL jobs.
• Proficient in creating reports using Crystal Report and SSRS.
• Experience in Qlikview reporting in Dashboard in chart form.
• Good experience in Autosys jobs, Automatic Job Alert.
• Proficient in performing various administrative tasks in SQL such as Attaching and detaching database, backup and restore the database, creating users and granting permissions on database.
• Experience in writing VBScript and batch files using DOS Commands.
• Experience in working Cloud Server. Cloud applications can be updated, tested and deployed quickly, providing enterprises with fast time to market and agility. This speed can lead to culture shifts in business operations.
• Experience in gathering business information, analyzing and documenting business and system requirements using standard templates.
• Experience in programming DTS and SSIS packages using SQL Server Business Intelligence Studio.
• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Experience in System Testing, UAT Support, Production Support and Maintenance Services.
• Good interaction skills with developers, managers and team members to coordinate job tasks.
• Good communication, interpersonal and analytical skills. Ability to communicate ideas issues and proposes solutions to both business and technology clientele.
• Experience in handling team of 5 members in onsite - offshore model.

TECHNICAL SKILLS

Languages: VB, ASP, HTML, JavaScript, PL/SQL, TSQL

Tools: Microsoft VSS, Business Intelligence, Jasper Reporting

Business Modeling Tools: MS Visio

Configuration Management: Test Director

Databases: SQL Server 2000/05/08/12 , Oracle9i

Operating Systems: MS DOS, Windows 9x/NT/XP.

Area of Interest: SQL Server 2000/05/08, Oracle 9i, SQL Server DBA, Crystal reports 9.0, SSIS,SSRS, and Jasper Reporting

Server: On-premises, Icloud.

PROFESSIONAL EXPERIENCE

Confidential - Cherry Hill, NJ

Senior - SQL Server Developer

Responsibilities:

• Applications is existing from the year 2016 and Mobility services.
• Document the solution definition for Business intelligence Reports like Crystal report & Qlikview & Finance enhancements.
• Involved in developing, implementing, and project supporting using SQL Server 2008, T-SQL, Stored procedures, user defined functions, triggers, views, complicated queries, indexing, etc.
• Client older version data bases migrated into systems thru Oracle Data Integrator is an Extract, load and transform tool uses for a graphical environment to build, manage and maintain data integration processes in business intelligence systems.
• T-SQL Queries for Adhoc reports for customer daily day to day transactions.
• Defects simulation & resolution through adherence / compliance to quality standards.
• Understanding the business requirement from customers for enhancements and customizations. Liaising extensively with clients for functional clarifications.
• Created data queries and reports using QlikView, SQL Server Management Studio, SSRS, and Excel. Created custom queries/reports designed for quality verification and information sharing.
• Performance tuning with the help of SQL Profiler and Analyser tool to find the long running queries in existing back end 2012.
• Developed SQL scripts for object transfer from one schema to another.
• Worked on Code Reviews for the code developed by other developers.
• Involved in writing test cases, unit analysis and integration testing for the development. Designed, developed and tested software using Agile Methodology.

Environment: PL/SQL,SQL Developer,QlikView&SSRS

Confidential - Baltimore, NJ

Senior - SQL Server Developer, PL/SQL

Responsibilities:

• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures, Functions, T-SQL and Packages in PL/SQL, Materialized Views, Dynamic SQL, Database Triggers and involved in creating and updating Packages to meet business requirements.
• Extensively used Dynamic SQL, REF Cursors, Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views.
• Created partitioning and indexes for Query Optimization.
• Performance Tuning of the SQL queries, which takes long time to process the request using SQL Profiler, Query Analyser, Explain Plans to reduce the response time.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator to transform the data.
• For the reporting MS Visual Studio using SSIS, and SSRS with extensive complex queries.
• Complex logic using T-SQL in stored procedure used for deriving financial SSRS reports and transactions.
• Developed SQL scripts for object transfer from one schema to another.
• Worked on Code Reviews for the code developed by other developers.
• Created Unit Testing Document with all possible Test cases/Scripts.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Involved in writing test cases, unit analysis and integration testing for the development. Designed, developed and tested software using Agile Methodology.

Environment: s: SQL 2012, PL/SQL,SSIS, SSRS

Confidential - Spring Field, Massachusetts

Senior SQL Server Developer

Responsibilities:

• Prepared program specification for the development.
• Created new UI for requirement.
• Developed new Tables, views, triggers, cursors, stored procedure, T-SQL, functions and SQL scripts.
• Executed SQL blocks using cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Client older version data bases 2002 migrated into systems thru an Extract, load and transform tool uses for a graphical environment to build, manage and maintain data integration processes in business intelligence systems.
• Created numerous processes through MS Visual Studio (SSIS, SSAS, and SSRS) and MS SQL Server 2008/2002 to develop a data warehouse project.
• Modified existing code and developed procedures to perform certain function.
• Created partitioning, indexes and Explain plan for Query Optimization.
• Created test scripts and test cases to perform Unit and integrated testing.
• Worked on Code Reviews for the code developed by other developers.
• Prepared technical and release documentation.
• Designed, developed and tested software using Agile Methodology.

Environment: s: SQL 2012, PL/SQL,Crystal Reports

Confidential - New Jersey

Senior - SQL Server Developer / PL/SQL Developer

Responsibilities:

• Prepared program specification for the development.
• Created new UI for requirement.
• Developed new Tables, views, triggers, cursors, Stored Procedure, T-SQL, functions, packages and SQL scripts.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Involved in developing, implementing, and project supporting using SQL Server 2008/2012 database. T-SQL for Adhoc & SSRS reports.
• Complex logic using T-SQL in stored procedure used for deriving financial SSRS reports and transactions.
• Performance Tuning of the SQL queries, which takes long time to process the request using SQL Profiler, Query Analyser, Explain Plans to reduce the response time.
• Defects simulation & resolution through adherence / compliance to quality standards.
• Liaising extensively with external and (or) internal clients for functional clarifications.
• Designed, developed and tested software using Agile Methodology.

Environment: s: SQL 2005, SQL 2012, Microsoft SSIS, SSRS,PL/SQL

Confidential - Portland - Oregon

SQL Server Developer

Responsibilities:

• Created numerous processes through SSIS,SSRS Reports and MS SQL Server 2008 to develop a data warehouse project. Some of the reports migrating from Client old system Crystals report. Provide training on BI reports.
• Developed numerous ad-hoc queries and reports to collect and present information that satisfied clients and contributed to achieve organizational goals.
• Develop new reports using T-SQL/ Automatic Job Alert alerts based on business criticality and gaps identified.
• Generated database design to the highest level of scalability and performance.
• Created database Triggers for the security purposes and Auditing data.
• Creating SQL, Object Views, and database objects. Developed the stored procedures for data transformation purposes.
• Involved in developing, implementing, and project reports using SQL Server 2008.
• Understanding the business requirement from customers for enhancements and customizations.
• Integrated functional and Regression testing
• Designed, developed and tested software using Agile Methodology.
• Involved in daily stand up meeting and weekly demo for each sprint.
• Create complex JIRA workflows including project workflows, field configurations, screen schemes, permission schemes and notification schemes.

Environment: Environments: SQL 2008, Crystal Reports, SSIS,SSRS

Confidential, Houston - Texas

Oracle PL/SQL Developer

Responsibilities:

• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures, Functions and Packages in PL/SQL, Materialized Views, Dynamic SQL, Database Triggers and involved in creating and updating Packages to meet business requirements.
• Extensively used Dynamic SQL, REF Cursors, Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views.
• Created partitioning and indexes for Query Optimization.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator to transform the data.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and worked on Oracle databases which is to develop and maintain for the real production environment.
• Jasper reporting is extensively used in PL/SQL Scripts.
• Created Unit Testing Document with all possible Test cases/Scripts.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Worked on Code Reviews for the code developed by other developers.
• Involved in writing test cases, unit analysis and integration testing for the development.

Environment: Oracle 9i, SQL, PLSQL, SQL Developer,Jasper Report.

Confidential - Indianapolis

SQL Developer

Responsibilities:

• Designed and developed Oracle objects such as Tables, Views, Indexes, Procedures, Functions and Materialized Views, Dynamic SQL, Database Triggers and involved in creating to meet business requirements.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views.
• Created partitioning and indexes for Query Optimization.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.
• Responsible for analyzing, Design and developing the code logic in SQL databases which is to develop and maintain for the real production environment.
• For the reporting purpose extensively used SQL Scripts.
• Document the solution definition for Business intelligence Reports like Crystal report & Finance enhancements using MS SQL Server 2008.
• Created Unit Testing Document with all possible Test cases/Scripts.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Developed SQL scripts for object transfer from one schema to another.
• Worked on Code Reviews for the code developed by other developers.
• Involved in writing test cases, unit analysis and integration testing for the development.

Environment: SQL Developer, Crystal report.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designed and developed Oracle objects such as Tables, Views, Indexes, Procedures, Functions and Packages in PL/SQL, Materialized Views, Dynamic SQL, Database Triggers and involved in creating and updating Packages to meet business requirements.
• Extensively used Dynamic SQL, REF Cursors, Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views.
• Created partitioning and indexes for Query Optimization.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator to transform the data.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and worked on Oracle databases which is to develop and maintain for the real production environment.
• Document the solution definition for Business intelligence Reports like Crystal report & using PL/SQL.
• Created Unit Testing Document with all possible Test cases/Scripts.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Developed SQL scripts for object transfer from one schema to another.
• Worked on Code Reviews for the code developed by other developers.
• Involved in writing test cases, unit analysis and integration testing for the development.
• Prepared technical and release documentation.

Environment: Oracle 9i, Jasper reports, Crystal Reports