SUMMARY:

• Overall 15 years of experience in all phases of software development life cycle (SDLC) having projects including, ERP Applications, Data Modeling, Reporting Projects, Adhoc Reporting, Data warehousing solutions from discovery stage to final implementation.
• Knowledge of Relational Modeling, Dimensional Modeling, Data Migration, Data Cleansing
• Proficient with SQL, PL/SQL
• Stored procedure expert, always considering the big picture while creating the SP design
• Involved in ER diagrams using ERWIN.
• Experience in Database Architecture, Design, Development and Maintenance using Oracle 11g/10g and SQL Server (2014/2012/2008/ R2/2005), DB2 9.x, 10.x tools and techniques for Large Enterprise Data Systems
• Extensive experience with Oracle PL/SQL in constructing database packages, procedures, functions, and triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity
• Experience in data analysis, SQL support, writing DDL for materialized views, production deployments and support, and PL/SQL development
• Worked on TOAD/SQL Developer to create/modify database packages, procedures, functions and triggers
• Extensive experience in gathering technical requirement and design new data models or update existing data models using ERwin
• Experience in advanced performance analysis and tuning within Oracle / DB2 as well as the other tiers of the infrastructure to identify and resolve bottlenecks and problems by analyzing query plans, managing indexes and locks, troubleshooting deadlocks and browsing thru reports like AWR, DB2TOP, DBI, Solarwinds and Dynatrace
• Expert in ETL (Data Extraction, Transforming and Loading) using SSIS, SSRS packages - Designed and implemented data warehouse projects
• Knowledge on Big Data concept - Hadoop, HIVE, IMPALA, HBASE, HDFS, MongoDB and Cassandra
• AWS Cloud Practioner with RDS, Redshift Knowledge
• Performed performance testing using JMETER, SoapUI, AquaStudio with different sessions
• Excellent communication, interpersonal, training, analytical and technical skills.
• Strong organizational, time-management and planning skills to deliver projects on time/budget, despite intense pressure and aggressive timelines.

TECHNICAL SKILLS:

Domain Knowledge: Insurance, Telecom, G-Governance - Utility, Media

Operating System: MS, Unix & Linux

Database: Oracle 8i/ 9i/ 10g, DB2 9.7/10.5, MS SQL Server 2005/ 2008, MS Access 2007, Netezza 7.x

BIG DATA: SQOOP, HIVE, IMPALA, HBASE, HDFS, MongoDB and Cassandra

Languages: PL/SQL, DB2 SQL, T-SQL, UML, XML, HTML, Python

TOOLS: Oracle Tool (SQL*Loader), TOAD, PL/SQL Developer, SSIS, VSS, Clearcase, ClearQuest, Serena PVCS, IBM QC, Aqua studio, IBM data studio, Erwin, Eclipse (Java), GITHub, Datical, CA Agile Centre, Solarwinds, Dynatrace, DBI.

MSOffice: Word, Excel, Powerpoint, Visio, MPP

Middleware: TIBCO BW, WPS, PEGA 6.x

PROFESSIONAL EXPERIENCE:

Confidential, Berkeley Heights, NJ

Sr. Associate

Responsibilities:

• Key member of Solution Team - Analyzing BRD and SRS and attending the meeting with product / business team (Iteration planning meeting)
• Actively participated in the discussion since inception with various stakeholders to optimize the design of the whole process
• Worked on technical requirement specification and design based on SRS and BRD
• Data Model Creation and Modification based on the new / existing functionality change
• Designed a fully-normalized data model for transactional database and the star schema for the data-warehouse database
• Used TOAD / SQL Developer to write PL/SQL. Created tables, indexes, stored procedures, views, triggers
• Working on SQL Queries Performance Tuning, Indexing, Query Optimization.
• Created / Modified complex stored procedures. Identified inefficient queries and stored procedures and rewritten them which brought the load on the database server to improve the performance.
• Written queries using CTE, Derived tables, table valued functions and views.
• Working on ETL Jobs, Work flows, data flows and scripts to pull data from the source or legacy systems and load into target database.
• Worked extensively with Spatial Query and spatial indexes and handled XML in the stored procedures (Parsing input XML, creating XML output, XMLTABLE
• Identified bottlenecks in Cognos, Mictostrategy and fine-tuned complex scripts which is auto created by reporting tools
• Worked on POC using AWS technologies with S3, RDS, Aurora, Redshift
• Design of Data Purging and Archival using Big data concepts and imported tables from traditional tables into HIVE using SQOOP scripts using Hadoop
• Performed number of POCs before building the entire framework, Spatial and Oneclaim Integration was the challenging among POCs
• Proactive issue analysis by looking at the DB/stored procedure logs and provide enough details to other tracks to track down the issues within SLA
• Managed the part of database team
• Worked very close with external DBA team and resolved environmental issues on time and supported during non-office hours to debug environmental issues and the deployments
• Extensive support to QA/UAT/Production support team, extended support on weekends on the Go-live support, AVP checks.
• Used CA agile center to keep track of changes, hours worked on each tasks

Environment: Oracle, IBM DB2, IBM Netezza, SQL Server, TOAD, SSIS, ETL, HP ALM, Apache - Hadoop, Hive, IBM Data Studio, ERWIN, Aginity Workbench, IBM Infosphere Datastage, PVCS, Github, CA Agile Centre, HP ALM, MS-Visio, MS-Excel, MS-Word, MS-Powerpoint, ServiceNow, PEGA 7, Java, WPS, Pitney Bowes, Cognos, Microstrategy

Confidential

System Analyst

Responsibilities:

• Worked with Business Analysis and Client to understand requirement and documentation and requirements
• Quickly leant and taken control of core billing / charges engine immediately after joining the team.
• Worked on PL/SQL to create Packages, Functions, and Procedure for Development and Data Migrations projects
• Data Model Creation and Modification based on the new / existing functionality change
• Worked on a fully-normalized enterprise data model for transactional database and the star / snowflake schema for the data-warehouse database
• Used TOAD / SQL Developer to write PL/SQL. Created tables, indexes, stored procedures, views, triggers
• Working on SQL Queries Performance Tuning, Indexing, Query Optimization.
• Used analytic functions like OVER (PARTITION BY), FIRST VALUE, LAST VALUE, AVG, windowing (RANGE BETWEEN, ROW BETWEEN) etc.
• Created UNIX shell scripts Execute Query in Oracle, Returning values from SQL, Checking Database status etc.
• Worked on system analysis, design and development and used PL/SQL to write stored procedures, functions, views, triggers, synonyms using TOAD.
• Optimize queries and stored procedures and rewritten them which brought the load on the database server down by 40%.
• Used VSS for change management
• Worked on the Data Modeling, Data Quality, Address cleanse transformations for cleansing the data
• Worked on Performance Tuning and Query Optimization
• Involved in testing the application for Oracle 9i to 10g upgrade and DB2 9.7 to 10.5 upgrade
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Created the script to deploy the procedures and tables in production database.
• Worked on all the standards, guidelines and best practices documentation and also functional and Technical design specification documentation.
• Conducted UAT sessions during Onsite

Environment: UDB-DB2 9.7/10.5, Oracle 9i, IBM Data Studio, TOAD, ERWIN, Ramco Virtual Works, Crystal Reports, MS-VSS, MS- Visio, MS-Excel, MS-Word, MS-Powerpoint

Confidential

Senior Developer

Responsibilities:

• Worked with Business Analysis and Client to understand requirement and documentation and requirements
• Worked on PL/SQL to create Packages, Functions, and Procedure for DTH, RCOM GSM projects
• Worked on data loading through SQL*Loader
• Used TOAD to write/modify stored procedures, functions, views, triggers etc.
• Worked on Performance Tuning and Query Optimization for slow and time taking queries
• Worked on Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Coordinating with other teams like Clarify, SAP, IVR, SMS gateway, CAS to finalize the interface.
• Provided timely support in testing phase and post go live.
• Worked on multiple concurrent projects which demanding extra effort and time without performance degrade
• Awarded with Best Employee for the quick turnaround time of development and fixes and extended support for go live for Big TV DTH project.
• Awarded for contribution to CMMi level 3 process implementation as PM for the track.

Environment: Oracle 9i, ERWIN, Aqua Studio, SQL Developer, TIBCO BW, IBM Rational Clearcase, IBM Rational Clearquest, MS-MPP, MS- Visio, MS-Excel, MS-Word, MS-Powerpoint, Clarify, SAP, IVR, SMS Gateway, CAS

Confidential

Software Developer

Responsibilities:

• Worked with Business Analysis and Client to understand requirement and documentation and requirements
• Worked on PL/SQL to create Packages, Functions, and Procedure
• Worked on data loading through SQL*Loader
• Used TOAD to write/modify stored procedures, functions, views, triggers etc.
• UAT Support

Environment: Oracle 9i, Oracle D2K Suite, MS - VSS, Java, HTML, MS-Visio, MS-Excel, MS-Word, MS-Powerpoint

Confidential

Software Developer

Responsibilities:

• Part of Development team to build Directory Management System as a new product.
• Performed data verification, validation and loading
• Helped in Unit Testing and Functional Testing.
• Support to sales team / implemented various reports for Management
• Hawkpages.com portal development

Environment: Oracle 8i, Oracle D2K Suite, MS-VSS, Java, HTML, MS - Visio, MS-Excel, MS-Word, MS-Powerpoint, Crystal Reports