PROFESSIONAL SUMMARY:

• Software professional with 10.5 years of experience and excellent knowledge in varied tools and technologies
• Proficient in Oracle, PL/SQL, good knowledge in database design and architecture
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including normalization, constraints, querying, joins, keys, indexes, data import/export
• Experience in Performance Tuning, Optimization and High volume database Tuning using HINTS, EXPLAIN PLAN
• Extensive working experience in Advance PL/SQL, SQL Concepts like collections, Analytic Functions, Materialized Views and Partitioning Concepts
• Good ETL (Extraction, Transformation and Load) experience across various source and target systems like SAP BW, EROS, Legacy systems, AS400, Oracle 8i/10g/11g and flat files using Cransoft.
• Good knowledge in creating SSIS package
• Excellent knowledge in building complex but efficient data mapping and validation rules to effectively translate business requirements to technical solutions
• Well acquainted with SDLC model and also worked in Agile/Kanban software development methodology in various capacities including software developer, technology analyst, designer and technology lead among many others in critical projects in Media and Entertainment industry
• Involved in understanding business requirements & technical requirements from various business departments stakeholders
• Analyze, defines and documents requirements for data, workflow, logical processes, and interfaces with other systems, internal and external
• Extensive experience in an onsite - offshore model, bridging the gap between business and the IT (Software) team by gathering requirements, transforming them into deliverables, planning and managing them with high quality within timelines
• Excellent problem solving and troubleshooting skills
• Excellent testing and review skills
• Eager to take on challenges and quickly adapt to new technologies and concepts.
• Excellent Leadership qualities and a very good team player who possess good communication skills

TECHNICAL SKILLS:

Programing language: SQL, PL/SQL, Java, VB6,0, ASP, Unix Shell Scripting, Perl

Database: Oracle 8i/9i/10g/11g, SQL server 2003, 2008 R2

ETL Tool: Cransoft, SSIS

J2EE Frameworks: Spring 4.x, Hibernate 3.x

Web Technologies: XML, XSL, XSLT, HTML, CSS, JSP

IDEs and tools: Eclipse, Toad, Toad for data analyst, winSCP, Textpad, FileZilla, Appworx, ServiceNow, Remedy, Application/Web Servers BEA Web logic, IBM Web Sphere, JBoss, Sun One Application Server, Tomcat, JBoss, Tomcat

Versioning Software: VSS, SVN, CVS, Sharepoint

Agile Tool: JIRA

Operating Systems: Windows 9x/2000/XP, Linux, UNIX, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Burbank CA/ New York, NY

Tech Lead

Responsibilities:

• Provide 18/5 support for the retail application and make sure it’s up and running
• Analyzed requirements and performed technical and functional impact analysis, design and development
• Followed agile software development practice and scrum status meetings
• Developed Reports using complex queries as per client request as a part of production support
• Worked on day to day operational support tasks, handled member inquiries, verified daily data refresh from different sources related to interfaces and provide update to business
• Created various SQL and PL/SQL scripts for verification of different functionalities and everyday changes after various process
• Involved in Debugging Troubleshooting procedures, functions, packages, customizing the existing ones
• Used Oracle external tables, control files, views and materialized views for data load from interfaces
• Extracted data from the XML file and loaded it into the database
• Created tables, views, indexes, materialized views, procedures, functions, triggers, collections and packages for new requirements
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Worked on SQL performance tuning using Explain Plan / HINTS / Query Optimizer / Execution Plans and Indexes
• Used bulk collection for better performance and easy retrieval of data from interfaces
• Applied styles to HTML pages using external Style Sheets (CSS) files
• Used Appworx and Crontab for scheduling and monitoring of the Java based application
• Provided ideas on improving the existing application for better User experience
• Responsible for database design for the integration of Amazon Market Web Services (MWS) and Magento API with Confidential catalog listing
• Involved in the POC for migrating B2B web application to AWS cloud

Environment: Java 1.6, JSP, Java Script, HTML, CSS, Spring 4.1 & Hibernate 3, Oracle 10g, PL/SQL, Eclipse, UNIX, Perl, AWS, API, XML, JSON, winSCP, JIRA, Ant, Apache Tomcat, log4j, SNOW, Appworx, Crontab

Confidential, New York, NY

Tech Lead

Responsibilities:

• Hold discussions with Business stakeholders and come up with functional specifications.
• Working closely with functional/data owners to identify data objects and gather business rules for data mapping purposes.
• Identify, estimate, plan and control the work log essential for CRS implementation
• Preparation of business requirement and system requirement document
• Data modeling and design of data staging, transforming and cleansing techniques along with data modeling of the staging area
• Setup data server using Cransoft for ODBC/As400 connection to legacy systems
• Understand target system data requirements and came up with the database design
• In corporate mapping rules for the data.
• Design data workflows and develop transformation logic using Cransoft.
• Develop custom transforms to meet complex business requirements.
• Provide architectural inputs to the overall design and determine the integration points between different source and target applications
• Design and develop procedures for cleansing of master data and generate reports using SQL to present it to business users
• Create PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
• Was involved in duplicate data identification using SQL queries
• Create SSIS packages for some of the data load from source to target
• Acting as a bridge between the client teams and offshore to make sure that deliverables are of the highest quality within the stipulated time

Environment: Cransoft, SQL server, SSIS and PL/SQL, MPP, MS Excel, winSCP, JIRA, SNOW, VSS

Confidential, New York, NY

Technology Analyst

Responsibilities:

• Analyze requirements and perform technical and functional impact analysis
• Working closely with functional/data owners to identify data objects and gather business rules for data mapping purposes.
• Setup data staging, profiling, transforming and cleansing techniques along with data modeling of the staging area
• Setup data server using Cransoft for ODBC/As400 connection to legacy systems
• Understand target system data requirements and in corporate validation rules for the data.
• Design algorithms for cleansing of master data and generate reports to present it to business users
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
• Work on performance tuning of the long running jobs and automation of manual jobs

Environment: Cransoft, SQL server, SSIS and PL/SQL, MPP, MS Excel, winSCP, JIRA, SNOW, VSS

Confidential, IN

Sr. Developer

Responsibilities:

• Requirement analysis, estimations, design, test plans, development and testing of CSA application.
• Worked on new package creation for Spotify data packaging
• Was involved in a major change related to campaign creation process using the CSA application
• Worked on SQL performance tuning using Explain Plan / HINTS / Query Optimizer / Execution Plans and Indexes
• Application support

Environment: Java 1.6, JSP, Java Script, HTML, CSS, Spring 4.1 & Hibernate 3, Oracle 10g, Oracle Web Tool kit, SQL, PL/SQL, Eclipse, UNIX, Perl, XML, JSON, winSCP, Ant, Apache Tomcat, CVS, VSS, Remedy, Approwx, Crontab

Confidential, IN

Sr. Developer

Responsibilities:

• Requirement analysis, estimations, design, test plans, development and testing of SMART application.
• Improved the month end process that was taking 25 - 30 days to just 7 days by tuning the performance of several jobs by adding bulk collect in oracle PL/SQL packages and stored procedures.
• Created database objects including tables, clusters, indexes, views, sequences, functions, packages and procedures for new requirements
• Fine-tuned procedures/SQL queries for maximum efficiency using Oracle Hints
• End to end involvement in implementing suspense sales processes that helped clear millions of records that was in suspense
• Single point of contact for VB/ASP related development
• Provide support for any data issues in production environment
• Prepare migration scripts for the changes to existing system

Environment: VB, ASP, Oracle 11g, SQL, PL/SQL, MS Excel, HTML, Remedy, VSS

Confidential, IN

Developer

Responsibilities:

• Create the database objects including tables, clusters, indexes, views, sequences, functions, packages and procedures as per the design provided
• Develop the sales processing system using store procedures/packages with the defined rules provided
• Create Oracle jobs for loading the sales information and for reports generation
• Unit test case execution and scripts preparation for production migration of changes

Environment: Oracle 10g, SQL, PL/SQL, TOAD, MS Excel, Remedy, I reports, VSS