Senior Database/sql Developer Resume
PROFESSIONAL SUMMARY
- Over 12 years of experience in information technology, software programming and development, Application integration, Migration & Conversion
- Experience in Banking, Telecom and Retail Industry
- Experience in developing a requirement document, test scripts, User Acceptance Test (UAT) as well as migration scripts during the life cycle of a project
- Experience in Client Server and Web applications using SQL, PL/SQL, Unix Shell Scripts and relational databases like Oracle 9i/10g on UNIX and Windows platforms
- Proficient in Oracle including SQL, PL/SQL (Packages, Functions, Stored Procedures and Database Triggers and Cursors, Dynamic SQLs, External tables), Good programming knowledge in Oracle 9i,10g as well as Unix shell scripting, Worked on Informatica and tool like Pro*C
- Good understanding of ETL mapping & Data Modelling in data warehouse environment such as star schema and snow flake schema
- Proficiency with various tools like ESP, Control - M and Cron Jobs for Job Scheduling
- Interpret and convert business requirements into IT functional specs Technical requirement Docs
- Adept in providing Analytical Support to key business Applications /solutions
- Thorough Understanding of Software Development Life Cycle (SDLC), having experience to various phases like Requirements, Analysis/Design, Development, Testing, Software Engineering practices and Quality Procedures like Six Sigma and SEI CMM Level 5 standards
TECHNICAL SKILLS
DBMS/Databases: Oracle 11g/10g/9i/8i, Sybase
Oracle Tools: SQL*LOADER, PL/SQL developer, TOAD, SQL*PLUS, SQL DEVELOPER, ETL
Languages: SQL, PL/SQL, Pro*C, Base SAS
Scripting: SHELL
Solutions: Data Warehouse
Office Packages: MS-Office (Access, Word, Excel, PowerPoint)
Version Control: Subversion (SVN), PVCS, Clearcase, GitHub
Operating System: Windows, UNIX
PROFESSIONAL EXPERIENCE
Confidential
Senior Database/SQL Developer
Responsibilities:
- As a Sr Developer of the team, the primary responsibility of Membership team is to maintain the client(s) meta data and support transactional data
- I was involved in Project PSR/PCR discussions to identify the nature of projects and define the scope of impact
- Likewise, provide necessary documentation i.e. IA, checklists of the projects worked on and maintain Inventory of every project
- I am part of the refactoring team where we will identify the long running procs/jobs or procs with heavy usage of CPU time
- Identified procs will be refactored to perform better i.e., performance tuning using different techniques like identify the pain points and bridge the gap to perform better
- Besides my primary role in Membership team, I’ve played the other role as a Release member i.e., build master role where in, I was the primary contact of all projects PSR/PCR from my team which are going to production
- The primary responsibilities of build master role are, to gather the changes from all team members, validate them before providing the final build to
- \Release Engineering team for higher environment deployment(s)
- I was providing support for Product day in/day out activities and take care of Prod Confidential
- Last, but not the least, I was one of the primary responsible person for DEMO/Training environment refresh with Production copy regularly and Confidential
- I’ve learned new tools like Liquibase, GitHub, Jenkins for CI/CD pipeline and using them in day to day activities efficiently
Environment: Sybase ASE
Confidential, Atlanta, GA
Database/SQL Developer
Responsibilities:
- I was the database developer for one of the GM insourcing project named, confidential And, I’m part of other ongoing project, GLTO (Global Locate to Order)
- Loading of data from other DB’s for testing purpose using PL/SQL blocks
- For GDNM, creation of new tables/procedures and regular DB maintenance activities
- Automate the Quarterly and yearly jobs for GDNM
- I’ve learned the new job scheduling tool i.e., Autosys and migrated all GDNM jobs (DB and Unix/command level) to Autosys
- Similarly, rewritten/migrated the DB jobs of other applications i.e., GLTO, Manifest, RVM Residual Value Management System and VLS (Vehicle Locator Service) in/to Autosys
- Supporting and developing scripts in Oracle as part of ongoing Innovation projects like VID/VOD Vehicle Information Database/Vehicle Order Database i.e., writing Stored Procedures, triggers, views, etc.,
- Scanning the DB to find out the Unused Indexes to get rid of them for better query performance
- I was part of testing the multiple interfaces during 12c migration for GLTO
Environment: Oracle PL/SQL, Unix
Confidential, Sheffield Center, OH
Software Developer
Responsibilities:
- Responsible/one of the team mate for maintaining the Macy’s and Bloomingdale’s Point of Sale (POS) system
- Was part of understanding and documenting the POS system (Register & system functionality)
- Generate the reports from First Choice (FC) on a daily basis for middle management
- Was part of one of the POS project name, Credit Line Increase (CLI)
- Today, if a customer’s purchase exceeds the open to buy on their proprietary account, the transaction refers.
- The associate then calls customer service to initiate a potential credit line increase. As part of a continued effort to improve the customer experience at POS, additional customer information in order to increase a line of credit at point of sale (POS)
- Added a flag to smart parms to turn the CLI feature on and off
- Modify the Unix file (Parameter file) to add an indicator to allow whether Register can do CLI or not
- Later, the file is used to store in database and further download it to Register
- Accept the request from Register and transmit it to EPS system for further processing (decision making) using Unix shell script and Oracle procedures
Environment: C/C++, Oracle PL/SQL, UNIX shell script
Confidential
Functional & Technical designer, SME of EDI module
Responsibilities:
- CMS (Common Merchandising System was the colossal initiative by Confidential to bring every banner under one unique system
- A unique system built based on the study of every system functionality and build one common solution which works for every system
- I'm the SME for one of the critical modules, EDI (Electronic Data Interchange) and Inventory control (Stock status) for CMS
- As an SME, my job is to understand the EDI functionality of Confidential, LT and SAKS and propose one common solution
- Apart from EDI, I'm the owner/SME for another module, "Stock Status" for CMS, i.e.., building the End of Day (EOD) and Beginning of the Day (BOD) stock status
- After detail study, document the process of each business and come up with Functional Spec and Technical spec for every module
- EDI module has various transactions. For instance, the EDI modules I built are 850 (New Purchase Order), 860 (Change record of Purchase Order), 855 (Reverse PO request from the supplier), 852 (Send Sales & OH transactions to consignment/Lease vendors), 222 (Send Ticket request to third-party agencies for merchandise) and 824 (Reject report of 855)
- For Stock status, keep track of activities which will impact the inventory i.e.., transfers, RTV's, receipts, sales, etc. and build EOD and BOD stock status
- Later, transmit Stock status (inventory) data to multiple interfaces (downstream systems)
- Last, but on the least, build process for Mark Up or Mark Down the base retail price of every item
- Extract the Stock status data from different upstream legacy systems using Informatica and load into SQL database (Oracle 11g) and generate reports for business users for analysis purpose
Environment: Oracle PL/SQL, Unix Shell scripting, Pro*C, Informatica
Confidential
Software Engineer
Responsibilities:
- Extract call records from upstream system CPM system (CPM system extracts call leg records from exchange) and load into SQL database (Oracle 10g) using Unix Shell scripts and Oracle PL/SQL
- Process the call records using Oracle stored procedures and transmit it to downstream systems Macy for running the bill cycle
- Besides, extract International call records from legacy Mainframe system and load into Oracle database (Oracle 10g), process and transmit it to downstream system - Macy for running the bill cycle
- Business users use Abacus application - web URL to generate reports for analysis purpose (
- Oracle - SQL queries and PL/SQL procedures run behind the application to generate the reports) Software Engineer
- As an Application module lead, I am the single point of contact to Client for issues/concerns related to MORA application from Offshore Location
- Leading the team of any people related issues like handling the shift plans, shift rotation, leave approvals
- Understand the requirements related to call records and provide respective file named TAP
- Verifying the International Roaming calls, i.e., Confidential customer using the other network at different region
- Verifying the call rates for the calls and notify in case of any discrepancy
- Implementing new Carrier partners and performs testing
- Extract call records from upstream system CPM system (CPM system extracts call leg records from exchange) and load into SQL database (Oracle 10g) using Unix Shell scripts and Oracle PL/SQL
- Process the call records using Oracle stored procedures and transmit it to downstream systems Macy for running the bill cycle
- Besides, extract International call records from legacy Mainframe system and load into Oracle database (Oracle 10g), process and transmit it to downstream system - Macy for running the bill cycle
- Business users use Abacus application - web URL to generate reports for analysis purpose (Oracle - SQL queries and PL/SQL procedures run behind the application to generate the reports)
Environment: Oracle PL/SQL, Unix Shell scripting, Pro*C
Confidential
Software Engineer/Project Lead
Responsibilities:
- Project Leader (Major and Minor enhancements to the existing system, BUG fixing and providing Production support/ Maintenance)
- Understanding the requirements and provided a better solution approach along with alternate approaches
- Automating the existing manual process and implemented a new process for recurring tasks
- All projects and enhancements are developed using PL/SQL, Pro*C and Stored Procedures. Few projects are implemented in order to automate the existing processes from client end to avoid delays in providing the reports/data to the users
Environment: Oracle PL/SQL, Unix Shell scripting, Pro*C, Base SAS
Confidential
Software Engineer
Responsibilities:
- Change of interest rate (amount) paid by customers for loans on a periodic basis i.e., Quarterly, Semi - Annually and Annually
- After the new interest component implemented, the interest component payable by the variable interest rate customers should get affected whereas the interest component payable by the fixed interest rate customers should remain same
- Customer will be informed about the new interest rate via Mass Print Letters
- Provide support for the issues reported after the implementation of this activity
- Major/Minor changes requested by client
- Providing solution approach/analysis for the gaps in the process pro-actively
- The change request will be developed by using Pro*C and PL/SQL languages in Linux environment
Environment: Oracle PL/SQL, Unix Shell scripting, Pro*C, Base SAS
Confidential
Software Engineer
Responsibilities:
- Development, maintenance and production support which involves:
- Analysis of Transactional systems and mappings to the Warehouse
- ETL monitoring & troubleshooting. Review Data model, Code Extraction routines
- Database maintenance and backup
- Creation of Marts
- Bug fixing and Enhancement activities to the existing warehouse
- Handled enhancement projects like NIPPO, Dolphin
- System performance Analysis - To analyse the performance of the system during the daily batch process of loading the data into the data warehouse
- Operational Analysis - Build customized SAS programs to monitor the growth rate of the data warehouse (daily, weekly and monthly reports)
- Host systems to ODS Mapping Analysis (data formats, transformation, consolidation etc.)
- Analyse Confidential BASE SAS routines of Data warehouse to fix bugs reported
- All DWH projects and enhancements are developed using BASE SAS, SAS Macros and testing is done via client-server technology using SAS / Connect. Interface from SAS to oracle host is implemented using SAS/ Access software (using oracle engine)
- The major tasks handled during the project developments are:
- Preparation of document of understanding and estimates
- Preparation of design document, data model design for ODS and Data warehouse
- Build new Confidential routines to add to the data warehouse
- All the SAS programs running in batch are automated using shell scripts
- Data marts (for Sales, Marketing, Finance, etc.) are built using BASE SAS and SAS Macros
Environment: Oracle PL/SQL, Unix Shell scripting, Pro*C, Base SAS