SUMMARY

• 8+ years of experience in Application Development and database management using SQL, Oracle PL/SQL and Developer Oracle Application Express (APEX).
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and Micro Strategy.
• Expert at utilizing all versions of dynamics AX modules and their allied modules
• Comfortable working in ERP environments.
• Expert in using the SQL CLR integration feature in Visual COBOL.
• Proficient in Design using Visio, Development (client server technologies), Testing (excel and HP quality center), Implementation ( PBD, PBR, DLL, EXE using PowerBuilder IDE Build Method tools).
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Enforced data integrity using integrity constraint and database triggers.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Working with new data quality services DQS in SQL 2012 as part of creating rules for data mapping and data cleansing.
• Hands on experience using DQS services and DQS task for Data Cleansing and creating rules for business.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Extensively used Cubes & Rollups for making cross tabular reports.
• Strong knowledge of Star Schema, Snowflake Schema, Dimension and Fact table.
• Expertise in handling errors using Exceptions.
• Making structural changes to the database objects.
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP)
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Hands on experience with Oracle APEX 3.2/4.0/4/1.
• Proficient in data windows, data window buffers, PowerBuilder Events, Dynamic Data windows, window types and window events.
• Experience in working high - transacted OLTP systems.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementation and maintenance.
• Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases..
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

TECHNICAL SKILLS

Data Modeling Tools: Erwin r7.1/7.2, ER Studio V8.0.1 and Oracle Designer

OLAP Tools: Microsoft Analysis Services, Business Objects

ETL Tools: Microsoft SSIS, SSRS and Informatics 7.1.3, Power BI

EDI Tools: PowerBuilder 10, TOAD, PLSQL Developer

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML

Database Tools: Microsoft Dynamics AX, Micro focus Visual COBOL, Microsoft SQL Server 2000/2005/2008 , DB2, Oracle 12c/10g/9i, MS Access, Teradata, Power BI, PowerBuilder Reporting (Data windows).

Packages: Microsoft Dynamics, Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects

Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7

PROFESSIONAL EXPERIENCE

Confidential, Chicago

SQL Server DBM

Responsibilities:

• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Worked with tier 1 ERP solutions such as SAP JD Edwards IFS and incorporated their functionality into Microsoft Dynamics AX.
• Used Visual Cobol for RDBMS support to convert and use raw Cobol data into oracle server.
• Involved in creation of conceptual Modeling covering all the business requirements.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Metadata, Data Definitions and Data Formats.
• Developed related PowerBuilder objects like windows, data windows, user objects and database objects like stored procedures, packages, function types, table views using Oracle PL/SQL.
• Designed Physical and Logical Data model and Data flow diagrams.
• Installed Dynamics AX software and trained end users.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Supported APEX applications and conducted performance tuning for PL/SQL.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Used Oracle APEX 4.0 for designing application structure.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Performed a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of data using Visual Studio 2017.
• Hands on approach with both Data Quality Server and Data Quality Client approaches of a DQS server.
• Built knowledge bases of student data in order to cleanse the invalid and/or irrelevant data.
• Created data quality projects to perform data cleansing and data matching activities.
• Expert in data matching to identify and remove data redundancy.
• Worked as a DQS admin and also as a DQS user like kb editor and operator for varying clients and varying projects.
• Involved in writing several Queries and Procedures.
• Built database objects like Tables and Views.
• Involved in the Database Design (Relational and Dimensional models) using ERwin.
• Defined both logical views and physical data structure using ERwin.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Extracted required data from the database tables and exported the data to different sources in different formats
• Worked with several tools to access and perform several operations on database.
• Experience in Generating Reports.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Confidential

SSRS Developer

Responsibilities:

• Collected User Requirements by participating in meetings and studying existing System.
• Developed Power BI reports using query logic based on business rules and visuals selected by Michigan State Department of Transportation.
• Creating E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow diagrams using Oracle Designer.
• Created database objects like tables, views, Sequences, Directories, Synonyms, stored procedures, function, and packages, Cursor, RefCursor and Triggers.
• Involved in analysis, design, coding and Testing.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.
• Front End Screen was developed using Forms 9i.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Used SQL LOADER to upload the information into the database.
• Used Explain Plan for query optimization.
• Created Database design and converting them into database objects.
• Wrote test cases and performed Unit testing.
• Involved in writing Technical Specification Documentation.
• Extensive use of Unix Shell Scripts, Cron jobs and Autosys to automate process.
• Used PL/SQL to create Packages, Functions, and Procedure.
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Involved in testing the application for Oracle 9i to 10g upgrade.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.

Confidential

SQL SERVER (SSIS/SSRS) DBA

Responsibilities:

• Worked with installing, designing and managing MS SQL Server 2008.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Worked on formatting SSRS reports using the Global variables and expressions.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2005.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.