SUMMARY

• 10+years of experience inITindustry as anAnalysis, Design, Development, Implementation and Maintaining the applications in Oracle 9i usingOracle (SQL, PL/SQL) and SQL Server (SSIS, SSAS, SSRS) using Microsoft technologies and Business Intelligence.
• Strong Experience in designing and developing oracle objects Tables, Views, Indexes, Functions, Stored Procedures, and Triggers.
• Developedmaterialized viewsfor data replication in distributed environments.
• Proficient in advance features of SQL programming like Using Records and Collections, Exception Handling, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in SQL, SQL Query Analyzer and SQL Profiler and query optimization tools like SQL Trace, Execution Plan.
• Familiar with SQL*Loader to load data from external source like flat files into database tables.
• Knowledge of creation of Oracle/SQL Users, Roles, and privileges.
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• Proficient in creating reports using Crystal Report / SSRS and programming DTS and SSIS packages using SQL Server Business Intelligence Studio.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports. Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Designed, developed, implemented, and supported Power BI dashboards. Integrated data sources and databases with Power BI and designed and developed data models and backend queries for presenting data.
• 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.
• Good experience in Autosys jobs, Automatic Job Alert.
• Have good knowledge in Accounts Payable and General Ledger and worked in critical finance customization such as automation of payment and pay roll automation journal voucher.
• Experience in writing JavaScript, VBScript and batch files using DOS Commands.
• Experience in working AWS Cloud Server. AWS Cloud applications can be updated, tested and deployed quickly, providing enterprises with fast time to market and agility.
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
• Strong analytical and problem - solving skills, excellent communication and presentation skills, and good team player.

TECHNICAL SKILLS

Mark-up Languages: HTML, XML

Scripting Languages: JavaScript, VBScript, ASP

RDBMS: MS SQL Server 2008, 2005,2008,2012,2016, Oracle 9i/10g/11g, MS Access

Operating Systems: Windows XP/7, Server 2003, 2008 R2, 2012 R2

IDE: MS Visual Studio 2010, 2008, 2005,2016,2017 MS Visual Basic 6.0

Web Servers: IIS 8.5/8.0/7.5/7.0/6.0/5.1 , AWS cloud

Versioning Tools: Visual Source Safe 8.0 (VSS), Subversion (SVB), Team Foundation Server (TFS)

Ticketing Tools: Jira

Reporting Tools: Crystal Reports, SSRS, Power BI, Jasper Reports, Tableau

PROFESSIONAL EXPERIENCE

Confidential -- Milwaukee, Wisconsin

MSBI Developer

Environment: SQL SERVER 2016, SSRS, Power BI, Visual Studio 2017

Responsibilities:

• Document the solution definition for Business Intelligence Reports like SSRS & Finance enhancements.
• Involved in developing, implementing, and project supporting using SQL Server 2012, T-SQL, Stored procedures, user defined functions, triggers, views, complicated queries, indexing, etc.
• Experience in ETL processes involving migrations and in sync processes between two databases of client old system into our application.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS).
• Expert in generating writingparameterized queries, drill through reports andformatted SQL server Reportsin SSRS 2016 using data from ETL Loads and various heterogeneous data sources.
• T-SQL Queries for Adhoc reports for customer daily day to day transactions.
• Designed, developed, implemented, and supported Power BI dashboards. Integrated data sources and databases with Power BI and designed and developed data models and backend queries for presenting data.
• Created data queries and reports using 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 2016.
• Worked on Code Reviews for the code developed by other developers.

Confidential -- Cherry Hill, New Jersey

Senior SQL Developer

Environment: SQL SERVER 2012, CRYSTAL REPORTS, Power BI, SSIS, SSRS, AWS

Responsibilities:

• Document the solution definition for Business Intelligence Reports like Crystal report & PowerBI & 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.
• Experience in ETL processes involving migrations and in sync processes between two databases of client old system into our application.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS).
• Accounts Payable and General Ledger and worked in critical finance customization such as automation of payment and pay roll automation journal voucher.
• Developed Monthly budget, Financial, and ad-hoc reports and interpret results.
• Proposed, developed, and implemented financial changes and improvements.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Experience in administration of MS SQL Server in AWS platform.
• Resolved problems in cloud applications by proper identification as per client requirements.
• Expert in generating writingparameterized queries, drill through reports andformatted SQL server Reportsin SSRS 2008 using data from ETL Loads and various heterogeneous data sources.
• T-SQL Queries for Adhoc reports for customer daily day to day transactions.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• 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 Power BI, 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.

Confidential -- Baltimore, Maryland

Senior SQL Developer

Environment: SQL SERVER 2012, CRYSTAL REPORTS, SSIS, SSRS, AWS, SSAS

Responsibilities:

• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures, Functions, T-SQL and Packages in SQL, Materialized Views, Dynamic SQL, Database Triggers and involved in creating 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.
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2008 & 2012(SSAS).
• SSASstorage and partitions, and Aggregations, calculation of queries withMDX, Data Mining Models, developing reports usingMDXand SQL.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2008 Analysis Services (SSAS).
• Resolved problems in cloud applications by proper identification as per client requirements.
• Performance Tuning of the SQL queries, which takes long time to process the request using SQL Profiler, Query Analyser, Execution Plans to reduce the response time.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator to transform the data.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• 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.

Confidential -- Spring Field, Massachusetts

Senior SQL Developer

Environment: SQL SERVER 2012, CRYSTAL REPORTS, Tableau, SSIS, SSRS, AWS, SSAS

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.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• SSASstorage and partitions, and Aggregations, calculation of queries withMDX, Data Mining Models, developing reports usingMDXand SQL.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2012 Reports Services (SSRS)
• Modified existing code and developed procedures to perform certain function.
• Created partitioning, indexes and Execution plan for Query Optimization.
• Created test scripts and test cases to perform Unit and Integrated testing.
• Integrated functional and Regression 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.

Confidential -- New Jersey

Senior - SQL Server Developer / PL/SQL Developer

Environment: SQL SERVER 2005/2008/2012 , PL/SQL, CRYSTAL REPORTS, Tableau, SSIS, SSRS, SSAS

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.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating writingparameterized queries, drill through reports andformatted SQL server Reportsin SSRS 2005/ 2008/2008 R2 using data from ETL Loads and various heterogeneous data sources.
• Performance Tuning of the SQL queries, which takes long time to process the request using SQL Profiler, Query Analyser, Execution Plans to reduce the response time.
• Developed custom, dynamic reports and integrated with Interactive Intelligence System using Crystal Reports.
• Defects simulation & resolution through adherence / compliance to quality standards.
• Liaising extensively with external and (or) internal clients for functional clarifications.
• Integrated functional and Regression testing.
• Designed, developed and tested software using Agile Methodology.

Confidential -- Portland - Oregon

Senior - SQL Server Developer

Environment: SQL SERVER 2008/2012, CRYSTAL REPORTS, SSIS, SSRS

Responsibilities:

• CreatedSSISpackages for File Transfer from one location to the other using FTP task.
• Used SSIS to create ETL packages to validate, transform and load data into data warehouse from different sources, consolidating and merging into one single source.
• Implemented Logging, Event Handlers and Error Handling in SSIS packages.
• Generated different types of reports like Tabular, Matrix and Charts. Extensive use of Pie, Column and Bar Charts using SSRS.
• Developed custom, dynamic reports and integrated with Interactive Intelligence System using Crystal 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.
• 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.

Confidential -- Houston - Texas

PL/SQL Developer

Environment: PL/SQL, Jasper Reports

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.

Confidential -- Indianapolis

Senior SQL Developer

Environment: SQL server 2008, Crystal Reports, SSIS

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.
• Created partitioning and indexes for Query Optimization.
• Tuning of the SQL queries, which takes long time to process the request using Execution Plans to reduce the response time.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• 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.

Confidential -- Lafayette, Louisiana

PL/SQL Developer

Environment: PL/SQL, Crystal Reports

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.