Human Resources Development Experience

Sameer R Sarangi

******.********@*****.***

Cell: 484-***-****

18+ years of development experience in Oracle, Python, Sybase, PowerBuilder and UNIX shell scripting

Expertise in Oracle databases (19c/12c/11g/10g/9i/ 8.x), PL/SQL programming, SQL loader, SQL tuning, database tuning, building complex queries, etc.

Experience in PL/SQL programming in developing advanced Object Relational Database objects, Packages, Triggers and Subprogram units

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables

Experience in Data Warehousing project including Extract, Transform, and Load (ETL) using SQLLDR utility and Snowflake

Used Oracle XML functions such as XMLELEMENT, XMLAGG, and XMLFOREST and created XML extracts from Oracle tables and vice versa

Worked on DBA Activities (User Create / Grant / Security / Synonym / Table Backup / Table Restore)

Data migration (bulk/batch dataload) from Oracle DB, time travel, SnowPipe, SNS Google cloud integration and other features in Snowflake Cloud Database

Proficient in object-oriented programming OOPS

4+ years’ experience in Python

2+ years development experience in .Net technology

Design, development and deployment of large software applications in both Client/Server and Web Server Environment

Developed project schedules and estimates, planned resources

Tracked project progress and managed expectations through successful project completion

Experience working in concurrent projects with global development team

Clients: BCBS Florida, Sony Music, New York City HRA, Sprint, BNP Paribas, New York City HPD, IFF, Merck pharmaceuticals, ING, Infosys

Domain: Media & Entertainment, Human Resources and Social Services, Telecommunication, Retail, Chemical, Pharmaceutical, Financials, Banking, Variable Annuity

Skills

Data modeling Erwin 4.1

Cloud AWS, Azure, Google Cloud

RDBMS Oracle, Sybase, SQL Server (Oracle 19c/12c/11g/10g/9i/8i, PL/SQL, SQL, SQL PLUS, Performance Tuning), MySQL 5.7

Languages Python, C, C#, PowerScript, Unix Shell scripting, VB.Net, ASP.Net, ADO.Net

Framework Flask and Django Framework, Net Framework 3.5 and 4.5, COM+ Enterprise Services, Active Directory and Enterprise Library

GUI/IDE/RAD PowerBuilder with PFC (8, 9.0, 10.5, 11.5, 12.0, 12.5, 19), Visual Basic

DB Programming T-SQL, PL/SQL, stored procedures

Miscellaneous Rapid SQL, Toad, Interactive SQL, SQL * Plus, SQL Server Management Studio, SQL Developer, Benthic Golden, Oracle Forms/Reports 6i, Info Maker, Power Designer, HP QC

Job Scheduling Tool Control M

SaaS MongoDB, Snowflake

Web HTML, DHTML, CSS, JavaScript

Application Servers EAServer 5.2, Tomcat

Version Control SVN, PVCS, Git, IBM Rational ClearCase, Visual SourceSafe, Merant Dimensions

Productivity Software Oracle SCM and E-Business Suite, Service Now, Jira, SharePoint 2007/2010, SAP Business Objects/Business Intelligence

Education: Bachelors in Information Technology, College of Engineering and Technology, India

BCBS Florida Mar 23 – Till date

Senior PL/SQL Developer

Oracle, PowerBuilder, Toad, SVN

Blue Cross Blue Shield of Florida is one the largest health insurance providers in the US. I was part of the claims processing team assisting in resolving claim processing issues.

Worked on the claims data processing processes involving institutional and professional claims.

Performed impact analysis on the stored procedures and packages

Performed root cause analysis for various claim processing issues.

Assisted in performance testing activities for certain claim areas.

Sony Music Jan 22 – Feb 23

Senior Data Engineer, Application Design

MySQL, Oracle, Python, Unix, AWS-Cloud, SAP Business Object & Business Intelligence

Sony Music Entertainment is one the world’s largest music, video, media production and distribution company with global presence.

Automated ETL processes with incoming data from various sources into central reporting system.

Performed impact analysis on database stored procedures and packages

Designed relational databases (logical and physical data models)

Created Unix scripts to automate jobs processing and scheduling

Created application architecture to build unified system to handle different partner data

Created web services (AWS API Gateway and Lambda) to create automated data loading process from various partners

Created reports in Business objects with multiple universe implementations

NYC Human Resources Administration May 14 – Dec 21

Senior PL/SQL Developer, Data Modeler, PowerBuilder Programmer, Application design

Oracle, Toad, PowerBuilder, Snowflake, Python

New York City, Human Resources Administration enhances the quality of life for all New Yorkers by providing temporary help to eligible individuals and families with social service and economic needs in order to assist them in leading independent lives. These goals are accomplished through the effective administration of a broad range of social welfare programs and services.

Designed relational databases (logical and physical data models) and other complex data models

Used Oracle analytical functions to write complex ad-hoc queries required for business reporting

Applied 19c features enhancements in analytical functions like LISTAGG

Used JSON_SERIALIZE function to convert BLOB form to JSON

Worked on data mappings to efficiently consume third party data and data from other agencies

Created Function, Stored procedure, Packages, Tables, Views, Sequence, Grants, Database Triggers

Used Oracle XML functions such as XMLTYPE, XMLSEQUENCE, EXTRACTVALUE to generate XML from Oracle database and vice versa

Partitioned table, created Materialized View, Global Temporary Table, Dynamic SQL, Bulk collect.

Built the architecture to rewrite time critical processes in Oracle using XML schema

Created online and citywide reports for Management console

Developed screens and NVO to implement the new enhancement using Power Script

Worked with PowerBuilder Menu, MDI screen, Response windows

Used various data window types in reporting, input and data objects for data sharing in the application

Loaded data into SnowFlake tables using internal stage tables using SnowSQL

Used copy command to bulk load data from files into tables

Created SnowPipe to ingest data from SnowFlake stage and cloud storage using SQS/SNS services

Used various extraction functions FLATTEN, GET, XMLGET to massage data into the desired format

Designed and implemented AHRA module in Python using Flask framework

Worked on Flask to create API's for accessing the database

Used various library in Python to achieve various functionalities.

Used Python and Flask to create XML processing, data exchange and business logic implementation

Evaluated Git for version control tool for maintaining source code

Participated as required to design, develop, test, and integrate applications

Leading the team for the client facing application

Sprint, Overland Park, KS Aug 13 – Apr 14

Oracle Developer

Sprint is one of the leading providers of telecommunication services in the North America. This project consists in implementing new changes in various channels of the application.

Oracle EBS, SCM, PowerBuilder, PL/SQL

Design and validate technical solution for the change request

Conversant in implementing Oracle Supply Chain and Manufacturing modules (PO, OM, Adv. Pricing, INV, BOM, WIP, WMS).

Created multiple conversions to support client's migration from a legacy system to Oracle ERP suite of applications including

WIP, BOM, Purchasing, Inventory, and Order Management.

Functional design and design review of Oracle Applications data conversions, interfaces, custom reports and custom applications

Analyzed and designed staging tables, wrote inbound interface programs in Sales Order Management Module

Develop stored procedures, packages, function, sequence, database Triggers and modify existing to implement new requirement

Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL).

Developed windows, user objects and NVOs for the back and front office modules of the application

supporting Sprint business

Designed database objects, wrote queries, stored procedures, triggers etc.

Provided technical expertise to the team

BNP Paribas, NYC Jun 12 – Jul 13

Lead Sybase Developer

BNP Paribas is a leading banking services provide in the EMEA region with its offices across the globe. With its multiple lines of businesses like retail banking, investment services, assets management and others it ranks 4th in the world. Current project focuses on the investment LOB and mainly caters to order processing and management, fund and static data management, confirmation letter generation and lots more.

PowerBuilder, Sybase, QC, StarTeam, UNIX

Design technical solution for the change request

Develop stored procedures and modify existing to implement new requirement

Maintained and developed the T-SQL codes to develop new enhancements

Wrote UNIX scripts to extract complex reports and send it to various clients

Develop front end screen to implement new changes in the application

Designed database objects, wrote queries, stored procedures, triggers etc.

Wrote and tested unit test to validate the changes

Provided technical expertise to the team

NYC Housing Preservation and Development Mar 10 – May 12

Senior PowerBuilder Developer

PowerBuilder, Oracle, Toad

New York City, Housing Authority Section 8 Program was to assist very low-income families to afford decent and sanitary housing in the public and private market through the provision of housing assistance in the form of rent subsidy. Involved in the development of the section 8 program, enhancement, and maintenance of the application

Lead the identification, analysis and selection of complex information technology and business practices to support strategic business process and plans.

Designed implementation and technical solution for the section 8 program module.

Participated as required to design, develop, test and integrate applications of high complexity.

Designed user objects to implement complex business logic for routing complaints in the new program

Developed screens and NVO to implement the new enhancement using Power Script

Created reports for various levels in the organization

Created unit test plans, test data and tested the code

IFF, Allentown, PA Feb 09 – Apr 10

Senior PowerBuilder Developer

PowerBuilder, Sybase, DB Artisan

Involved in the development, enhancement and maintenance of the application including enhancement and support

Created NVOs and data window objects and reports that used composite data window object

Wrote stored procedures, SQL and DDL, indexes for multiple functionalities

Designed the front-end screens and NVO to implement the new enhancement using PowerScript

Supported, evaluated, and continuously improved information technology and business processes to maintain alignment with business plans.

Created data input and report screens and updatable data window with painters

Wrote ad hoc queries on a day to day need basis from the business users

Created unit test plans and test data for the new enhancements and changes

Merck, Kenilworth, NJ Feb 08 – Jan 09

Data analyst and Developer

PowerBuilder, Oracle, Toad, Benthic Golden, Merant Dimensions, Input Accel, Symantec pcAnywhere

Integrating data from various sources into a central repository for CDAS (Clinical Documentation Automation System)

Used various built-in functions available in Oracle for data aggregation and conversion

Wrote batch jobs to gather database statistics after database refresh

Wrote stored procedures, functions and triggers, enabled constraints on the tables using primary and foreign key relationships

Fetched data from various flat file formats and MS Access (.mdb) files and involved in data validation

Modified NVOs and data window objects for the CDAS downstream application for data changes

Coded Unix shell scripts to validate files and notify the end user when a job completes

Involved in preparing design documents by analyzing various data points

Created and performed unit, functional and integration test plan and data validated using SQL

Resolved and fixed many postproduction issues and assisted the support team

ING, West Chester, PA Nov - 07 - Dec 08

Developer/Production Support Lead

PowerBuilder, EA Server, Shell Scripting, C#, ASP.NET 2.0, Sybase, SQL Server, Rapid SQL, SQL Server Management Studio, .NET Framework 3.5, IIS 6.0, PVCS, WS FTP Pro, IBM Rational Clear Case, Control M

Involved in the entire SDLC of the variable annuity projects including enhancement and support

Created NVOs and data window objects and reports that used composite data window object

Wrote Oracle, Sybase stored procedures, SQL and DDL, indexes for multiple jobs

Wrote UNIX shell scripts used to trigger the jobs called from Control M

Set up the EAServer components like message Service, message queue, connection cache, message listener and deployment of packages as part of Night Cycle Automation Phase I & II

Setting up the Control M properties to schedule the jobs based on the message listener architecture

Designed the front-end screens and NVO to implement the new enhancement using PowerScript

Extensively used the service-oriented architecture of PFC and its services like sort, filter, tree view and list view services etc

Created data input and report screens and updatable data window with painters

Developed the application logic using C# for minor enhancements in the web version of the application

Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application

Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database

Wrote ad hoc queries on a day to day need basis from the business users

Implemented utilities to FTP the files from the application

Infosys Technologies Ltd., India Aug 05 - Oct 07

Technical / business and data analyst

Analyzed legacy applications, collected & evaluated new requirements from business stakeholders & user groups to understand business requirements, goals, and risks and defined the technical scope and objectives of projects

Researched ING’s new business requirements and wrote TDDs highlighting the assumptions, constraints, discrepancies, pre- and post-processing interface steps, effect of API, deployment considerations and required error handling steps

Arranged JAD sessions with business, identified deficiencies, process/system gaps and recommend business process improvement

Determined performance, security, operational considerations, disaster recovery & business continuance plans.

Assisted technical resources in the evaluation of new functionality and helped to resolve system and process issues. Screen mockups were designed

Documented As-Is process and defined To-Be solution.

Addressed the usability issues in the user interface section of the design document

Analyzed and designed data mappings for extracting & loading data from legacy systems to target tables

Designed and analyzed the data model and created the required database tables, views and indexes

Developed creative solutions to meet business needs while complying with company and IT standards and guidelines

Project management

Translated project requirements into project scope, objectives and tasks

Developed detailed project schedules and resource plans, contributes to the effectiveness of a team that integrates multiple functions/disciplines

Evaluated project benefits and analysis at multiple project decision points

Participated in project review meetings for evaluating project progress and created project summary reports

Monitored the project progress using various trackers to meet the committed timelines

Identified project and production issues and assigned resources to provide solutions to avoid project delays

Attended weekly statues meetings and GO/NO-GO calls during major and minor releases

Testing / QA

Documented TDD/FDDs and traced requirements from FDD TDD test cases

Resolved production and regression issues and assisted and trained the QA and the support team

Created unit test plans and test data for the new enhancements and changes

Performed unit, functional and integration testing for the code changes

Wrote SQL queries to compare and test the data output

Contact this candidate