SUMMARY:

• Over 20 years IT experience in Analysis, Database Design, Development, Implementation, Debugging and Testing of various software applications as Oracle PL/SQL Developer.
• Five years of experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) for 2016, 2014, 2012, 2008 R2.
• Possess solid understanding of logical and physical data modeling techniques for both relational and dimensional models.
• Proficient in database modeling for OLTP, Data Marts, Operational Data Store (ODS) and OLAP.
• Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
• Familiarity with Star and Snowflake schema data modeling techniques for OLAP database design.
• Hands on expertise with ETL process using SSIS to load and process high volumes of data for front - end and reporting applications.
• Proficient in Debugging, Testing, Deploying Complex Stored Procedures.
• Hands on experience and proven track record of expertise with performance tuning.

TECHNICAL SKILLS:

Languages and Software: MS SQL Server 2016/2012/2008 R2, Oracle 10g/9i, SSIS/SSRS/SSAS 2012/2008, Informatica, SSMS 2016/2012/2008 , T-SQL, PL/SQL, Agile/Scrum/KanBan, TFS, Tableau

PROFESSIONAL EXPERIENCE:

Confidential

Senior Report Developer

Responsibilities:

• Generated new SSRS Tabular and Matrix reports in support of operations
• Developed new and modified existing reporting SQL stored procedures which combined data from legacy MES system (Mercury) with new MES system (Mercury 2.0) so that users have a single point of truth
• Created a variety of SSRS, Crystal, and Excel reports in support of custom MES platform
• Tuned SQL stored procedures using a variety of query optimization methods
• Worked with Epicor ERP in support of data and reporting requirements
• Coordinated with Tableau administrator and DBA to migrate existing Tableau reports to use new SQL views which combined Mercury + Mercury 2.0 data
• SSIS packages and associated jobs to create flat files to interface between MES and ERP systems
• Created prototype DW and loaded with SSIS packages

Confidential

Senior BI Developer

Responsibilities:

• Extracted data from various sources like SQL Server 2008/2012, Oracle, DB2 and text file using SSIS.
• Handled performance tuning and optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments.
• Worked with end users and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved in planning and designing SSAS Cubes and building attribute relationships for hierarchies and measures.
• Experience in creating jobs, SQL mail agent, alerts and schedule SSIS packages using SQL Agent scheduling.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Created ETL packages with different data sources (SQL Server, Flat Files, DB2, Oracle) and then loaded the data into destination tables by performing various kinds of transformations using SSIS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Worked in Agile/Scrum methodology based on sprints.
• Maintained offshore team, responsible for the work allocation and status of the application.
• Deployed and maintained reports in SharePoint 2010 and played critical role in providing the support to the business users.
• Developed packages to retrieve job history and SSISDB history and load into tables.
• Developed Dimensions, Fact and SSRS reports to analyze job data to increase performance of daily and half hour job cycles.
• Experienced in slowly changing dimension in SSIS packages.
• Performed incremental data load packages in SSIS.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures and UDF’s on MS SQL server.

Senior Oracle Developer

Confidential

Responsibilities:

• Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in Windows environment.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Feasibility study, planning, implementation, testing, deployment and close-out.
• Created logical and physical Database Design, data structures, Data Modeling, Schema Design.
• Applied Database Tuning and Optimization, Normalization in the new database design.
• Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, sequences, and synonyms.
• Tuned SQL queries using EXPLAIN PLAN and Hints for query optimization.
• Used Materialized Views, Packages and Dynamic SQL.
• Created programs to transform data from Legacy systems into Oracle database.
• Tested and modified codes for quality.
• Experience in Client-Server application development using Oracle 10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Extensive experience with Oracle Forms and Reports (8i and 9i).
• Migrated Oracle 8i to 9i.
• Migrated Developer from 6i to 9i .

Oracle Application Designer/Architect

Confidential

Responsibilities:

• Technical Analyst/Application Architect that designed and developed a new fully integrated tracking system that spans all the various investment options, using Oracle’s Developer 6i (forms, reports and extensive PL/SQL (triggers, procedures, functions, packages)) and dynamic SQL.

Confidential

Contract Oracle Developer

Responsibilities:

• Technical Lead in r e-architecting an Oracle web-delivery reporting system to a single database.
• Used Developer 2000 v2.1 (forms, reports and extensive PL/SQL).

Confidential

Contract Oracle Developer

Responsibilities:

• Technical Lead that desi gn and built a new Oracle web-based application that provided data integrity and availability throughout the Confidential Corporation.
• This included interviewing users, to convert several Confidential client/server applications, and working with DBAs, to develop table structures and security.
• System was developed using Developer v6.0 (forms, reports and stored PL/SQL).