SUMMARY

• Over 8 Years of professional experience in Development, Implementation and Administration of Database Systems by working as both OLTP Data Warehousing Systems Applications Specialist and SQL BI Developer, Oracle Developer, Development & Support of Oracle Database 9i, 10g and 11g in Production, Staging and Development environments.
• Extensive experience in MS - SQL and Oracle PL/ SQL Development , involved in Design, Development and Support of MSSQL Server 2016/2014/ 2012/2008 and Oracle 11g and 12c databasefor both OLTP and OLAP Systems.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, Import/Export, Triggers, cursors.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Partitioned large Tables using partition technique .
• Knowledge of relational database, normalization/de-normalization.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Excellent understanding of Database modeling for OLTP/OLAP systems, Implementation and organization.
• Worked in OLTP and OLAP environment that includes Production Support and development databases in SQL server.
• Experience in Microsoft stack of BI solutions - SSRS, SSIS with MS SQL 2016/2014/2012/2008.
• Created SSIS packages to import data from various sources to SQL Server.
• Experience in ETL operations using SSIS Packages from Development Server to Production Server.
• Experience in transforming unstructured data from various data sources.
• Set up transactions, loggings, event handlers and checkpoints to handle errors.
• Migration of packages and Reports from SQL Server 2000 to SQL Server 2005.
• Expertise in SQL Server reporting services (SSRS) 2005/2008 in generating complex reports: Tabular, Matrix,Cascaded, TOPN, Parameterized, Chart, Sub-reports, Drill-down and Ad hoc reports.
• Experience in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Proven ability in Query Optimization.
• Designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Formatted reports for various visual representations using conditional formatting and templates.
• Worked on Version control systems like Subversion, GIT, CVS and Perforce .
• In-depth understanding of all stages of software development life cycle (SDLC).
• Extensive experience in using Oracle seeded packages like DBMS OUTPUT, DBMS SCHEDULER, UTL FILE, DBMS SQL and DBMS STATS.
• Proficient in advance features of Oracle 9i for PL/SQL programming like Using Cursor Variables, Ref Cursors, Nested Tables and Dynamic SQL .
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, Triggers and using the latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables .
• Very good experience in Oracle tools like SQL*Plus, SQL*Loader, SQL Developer using TOAD in secure databases.
• Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies .
• Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation .
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, prepare High level and Low level design documents.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
• Extensively worked on Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.

TECHNICAL SKILLS

TECHNICAL SKILLS: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services

Business Intelligence Tools: SQL Server Integration Services(SSIS),SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Crystal Reports 9.0/10.0

RDBMS: MS SQL Server 2008 R 2/2008/2005/2000 ,Oracle 10g/9i,MS Access

Languages: SQL,T-SQL, PL/SQL, C, C++, JAVA, C#, VB

Web Technologies: HTML, XML, VBScript, JavaScript,ASP,C#,ASP.NET,VB.NET

Data warehousing tools: Informatica, Business Objects, Cognos, Erwin

Office and Other Tools: Visual Studio 2008/2005, Visio, Visual Source Safe, Microsoft Word 2003/2007/2010 , Microsoft Excel 2003/2007/2010 , Microsoft PowerPoint 2003/2007/2010

Operating System: Windows 98, Windows 2000, Windows Server 2003, Windows NT, Windows XP, Windows Vista, Windows 7 Ultimate, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

SQL BI Developer

Responsibilities:

• Responsible for systems analysis, development enhancement, maintenance and support of Oracle based application
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Developer and Toad.
• Wrote SQL, PL/SQL programs required to retrieve data using cursors and exception handling.
• PL/SQL programming including triggers, procedures and packages.
• Established relationships between tables; created constraints.
• Involved in Performance tuning of PL/SQL Queries. worked with UNIX shell scripting
• Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remoteinstances.
• Provided ongoing support for MS SQL SERVER database servers for systems, which include creation, configuration, maintenance and upgrade.
• Involved in developing, testing, compiling, debugging and maintaining the data using SQL.
• Created Stored Procedures, Functions, views and SSIS packages in MS SQL database.
• Involved in the optimization of SQL queries, which resulted in substantial performance improvement for the conversion processes.
• Used SQL Server SSIS tool to build high performance data integration solutions including extraction,transformation and load packages for data warehousing.
• Manage source code, software builds, software versioning, and defect tracking on all software maintenance tasks and projects.
• Maintained Continuous integration effort with Subversion along with scheduled builds.
• Worked on Version control systems GIT Clear Case and Perforce.
• Supported 24 X 7 Production On call.

Environment: Oracle 12c, TOAD, SQL Developer, Shell Scripts, UNIX, Windows 2012, MS SQL Server 2016, VS2019 and SSMS.

Confidential, Chevy Chase, MD

SQL BI Developer

Responsibilities:

• Extensive experience with T-SQL in constructing Tables, implementing stored Procedures, Functions, Views, User Profiles, triggers, Data Dictionaries and Data Integrity.
• Worked on Normalization and Relational Database Management Systems.
• Experience of performance tuning, query optimization using Performance Monitor, SQL Profiler or other related tools.
• Experience with developing complex SQL Queries and stored procedures, and automating data retrieval from other data sources.
• Worked on creating Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS) using visual studio tool.
• Hands on Experience in Installing, configuring, managing, monitoring and troubleshooting SQL Server 2012/2014/2016.
• Design, develop, deploy and test ETL processes using SQL Server Integration Services, stored procedures, and functions.
• Create, schedule and monitor ETL Jobs using SQL Server Job Agent or other scheduling tools.
• Review and identify stored procedures, packages and functions for best practices, enhanced features and better performance.
• Provided support to staging and production cloud-based databases as well as create, operate, and maintain development and testing database environments.
• Writing ad-hoc queries to analyze the desired output from the relational model.
• Identify in-efficiently written SQL's for fine-tuning in order to improve performance.
• Bulk updates/inserts using merge statements.
• Writing analytical queries for faster processing and better performance.
• Using appropriate hints and query techniques for faster retrieval of information.
• Conversion and mapping of data, verifying the data integrity and validations.
• ETL activities like retrieval of data from external file using external table for data transformation.

Environment: Windows 2008, MS SQL Server 2014/2016, VS2016, SSMS, Oracle 12c and TOAD.

Confidential, NY

SQL BI Developer

Responsibilities:

• Involved in the development of custom stored procedures, functions, triggers using T-SQL
• Involved in the optimization of SQL queries, which resulted in substantial performance improvement for the conversion processes.
• Reorg/Rebuilding the indexes at regular intervals for better performance .
• Developed SSIS, SSAS packages in SQL Server 2014 using Business Intelligence Studio and created the jobs to schedule the SSIS packages in SQL Scheduler.
• Developed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task to generate underlying data for the reports and to export cleaned data from Text file to different data Marts.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Loaded Data into Oracle Tables using SQL Loader.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Developed Sub Reports, Matrix Reports, Charts, Ad hoc, Drilldown reports, using SQL Server Reporting Services (SSRS).
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Performed performance tuning of stored procedures using SQL Server Profiler.

Environment: MS SQL Server 2014/2016, Windows 2008, VS2016, SSMS, Oracle 12c and TOAD.