SUMMARY:

• 10 + years of experience in IT industry as an Analysis, Design, Development, Implementation and Maintaining the applications in Oracle 9i using Oracle ( 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 .
• Developed materialized views for 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

CHANGE MANAGEMENT:

• Maintain source code with proper versions.
• Provide required access to the repository to the team members, based on their roles.
• Maintain all project related documents, like Design documents, test cases, and release notes with correct and updated versions.
• Conduct Bi-Weekly audits to make sure all the configurable items are updated and in place. Use a standard checklist for this audit.
• Provide all the required documents during External Audits and represented the functional group in Confidential audit for the company.
• After the development and unit testing is complete, responsible for pushing the changes to Confidential environment and testing the applications.
• Once successful, move the changes to QA environment. Here, testing team will test the application and log the issues in defect tracking system. We track down the issues in tracking system to closure. Then, we go ahead with the Production release and perform Confidential with the users and work on the issues at run time.
• After the successful completion of Confidential, the applications will Go Live to all the users and we provide production support.
• All these processes include proper documentation as well, like High Level Design document, Detailed Design Document, Test cases, Release Notes etc.

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 like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS).
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in 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.
• Defects simulation & resolution through adherence / compliance to quality standards.
• 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 like Bulk Copy Program (BCP), and SQL 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 writing parameterized queries, drill through reports and formatted SQL server Reports in 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 the SSAS cubes.
• 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 PowerBI, 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).
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used 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 in Unit testing, System testing to 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.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used 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 like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in 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:

• Created SSIS packages 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 in Unit testing, System testing to 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, I ndianapolis,

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 in Unit testing, System testing to 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.