SUMMARY:

• BI/Data Warehouse Development wif around 5 years of experience developing web - based server and component-oriented architecture applications.
• Working wif relative ease wif life cycle development process dat includes translation of requirements into functional and technical specifications,
• Designing, Developing, Testing, Implementation & Software development methodologies like Waterfall, Agile (SCRUM Extremely fast at learning new languages and software, adapting teh best technology for each solution.
• Demonstrated ability to handle simultaneous technical projects efficiently and also had noledge on R studio and Predictive Modeling.
• Good Knowledge on Oracle 11G SOA, Creating new services for data Extraction and also in Oracle Service Bus development. Hands on experience wif EDI implementation and documentation types and Oracle Fusion Middleware.

TECHNICAL SKILLS:

Programming Languages: C, T-SQL, SQL, PL/SQL, UML2.0, Shell Script, Batch script

RDBMS/Databases: MS Access, MS SQL Server 2000/2005/2008/2012, DB2,Oracle 11gSQL server 2008, MySQL. Oracle 12c, Oracle 11g, 10g and 9i

Database Tools: Toad for Oracle,SQL Server Management StudioEnterprise Manager, SSIS, SSRS, SSASBusiness Intelligence Development StudioData Transformation Services, Informatica

Web Technologies: HTML/HTML5, CSS, XML, JavaScript,.

Operating system: MS-Windows XP/7/8/10

IDE s & Utilities: Eclipse,IntelliJ and NetBeans, Visual Studio Code

Application Servers: WebLogic, Web Sphere, JBOSS, Jetty, Oracle Fusion Middleware

Build Tools: Ant/Maven

Version Controls: Git, SVN,TFS,GitLab

Continuous Integration: Jerkins, Bamboo

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Database Developer

Responsibilities:

• Design databases and ensuring their stability, reliability and performance
• Design, create, develop and analysis of database objects based on application design using multi-tier in teh client/server and distributed environments.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Maintain and modify programs; make approved changes by amending flow charts, develop detailed programming logic, and coding changes.
• Prepare test data, tests and debug programs; revise and refine programs to improve performance of teh application software.
• Perform execution of functional test plan, validate test results, and prepare documentation and data for analysis.
• Creating Exclusive Data Lineage documents how data fields were Modifying according to teh business Requirements between Sources to teh Reporting Layer.
• Developed ETL packages wif different data sources SQL Server, Flat Files, Excel source files, XML files and loaded teh data into target tables by performing different kinds of transformations using Packages.
• Assisted wif testing existing code and making necessary enhancements for Oracle 11G upgrade.
• Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries).
• Converted Data stage modules into PL/SQL packages and rewrote slow performing ETL modules for optimum performance.
• Developed and modified procedures, functions, triggers, forms, and reports deployed teh changes in teh system.
• Developing applications designing, developing, documenting, testing and debugging application software and systems dat contain logical and mathematical solution.

Environment: Oracle 12c, PL/SQL Developer, TOAD, SQL Developer, JIRA, Snaplogic, GitLab, ColdFusion, MS-Excel, MS-VISIO

Confidential

ENTERPRISE DATA WAREHOUSE/BI Developer

Responsibilities:

• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating teh integrity of teh data.
• Extensively worked on Views, cursors, CTE's, schemas, permissions issues wif client/server database design.
• Designed & developed various SSIS packages (ETL) to extract & transform data & involved in Scheduling SSIS Packages.
• Extensively used SSIS Import/Export Wizard, for performing teh ETL operations.
• Played Key role in team of ETL developers for re-writing DTS packages and updating them to SSIS packages.
• Building Meta Data Structure and Procedures for Enterprise Data Warehouse.
• Hands on experience wif Chef and OpsWorks in AWS cloud environment.
• C# and SSIS based ETL framework design for data extraction from flat files and Sybase OLTP systems
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded teh data into destination tables by performing complex transformations using SSIS/DTS packages.

Environment: SQL Server 2012, SSIS (2012/2008), Visual Studio 2010/2013, MS Excel 2010, TFS (2012), MS Power BI.

Confidential, NJ

PL Sql / T-SQL BI Developer

Responsibilities:

• Develop technical design documents and mapping specifications to build ETL Mappings to load data into target tables.
• Creating Exclusive Data Lineage documents how data fields were Modifying according to teh business Requirements between Sources to teh Reporting Layer.
• Developed ETL packages wif different data sources SQL Server, Flat Files, Excel source files, XML files and loaded teh data into target tables by performing different kinds of transformations using Packages.
• Assisted wif testing existing code and making necessary enhancements for Oracle 11G upgrade.
• Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries).
• Converted Data stage modules into PL/SQL packages and rewrote slow performing ETL modules for optimum performance.
• Developed and modified procedures, functions, triggers, forms, and reports deployed teh changes in teh system.
• Extensively involved in application tuning, SQL tuning, memory tuning and me/O tuning using Explain Plan and SQL trace facilities.
• Maintaining TFS Versions for Deploying DB objects to Production and QA Environments.
• Provided technical expertise wif data analysis, collection and documentation of metadata components and information delivery
• Utilized T-SQL extensively in order to replace SSIS transformations in order to improve teh performance of packages.
• Developing applications designing, developing, documenting, testing and debugging application software and systems dat contain logical and mathematical solution.

Environment: T-SQL, MS Excel, MS-Word, MS-Excel, MS-VISIO, Visual Source Safe (VSS), CVS, Crystal Reports 8.0/XI, Forms 5.0,Forms 6i, Reports 6i, Forms 9i,Reports 9i,Oracle Reports 10G,Oracle Forms 10G, Oracle Apex, SQL Server Management Studio.