SUMMARY:

• 11+ years of IT industry experience
• Proficient in gathering requirements from the client and analyzing them.
• Experience in providing solution design & approach against requirement.
• Experience in Data Modeling using ER Studio and Erwin in Life Science, Insurance, Banking and Merchant Services domains implementing in RDBMS such Oracle & SQL Server.
• Designed dimensional Data Modeling like Star and Snowflake schemas and also worked in physical & logical data modeling.
• Extensive experience in Database development.
• Proficient working experience in creating Oracle Stored Procedures, Functions, Packages, Cursors, Triggers and Indexes. Expert in SQL and Pl/SQL.
• Experience in data migration from flat files to database tables & vise - versa using shell scripting.
• Experience in Table partition, Performance Tuning of PL/ SQL & SQL code and Database Monitoring and Migration on Oracle 8i/9i/10g.
• Experience in SQL development in AWS Redshift DB.
• Analyzing data in Tibco Spotfire and publishing reports in Tableau.
• Worked for source system analysis based on business requirements for the purpose of pulling data or for migration purpose.
• Experience in Shell scripting in Unix/Linux.
• Understanding of Canonical Data Modeling.
• Knowledge of Big Data ecosystem.
• Thorough knowledge on Software Methodology and Agile Process.
• RFP done for several projects w.r.t. database requirement.
• Worked in entire life-cycle beginning from Requirements gathering, Data Model Design, ETL Design, Report Design, Testing, and Migration to Production and Post-Production Support.
• Experience in all phases of SDLC with specialization in requirement analysis, data analysis, database design, database development, performance tuning and Data Migration.

• Understanding Client needs and requirements.
• Analyzing change requests and business requirements.
• Act as an interface between Client and offshore Development Teams/Testing teams.
• Perform testing of data transformations.
• Prepare Source-to-Mapping (STM) for different application teams to help the ETL process.
• Communicate with clients on a daily basis.
• Propose changes to an existing Data Model to make it more efficient.
• Attend team meetings on a regular basis to discuss updates and project progress.
• Understanding the functionality of reports and measures in the dashboard.
• Performing data, functional and layout testing of the dashboard and document defects.
• Communicate with the developers and business SMEs regarding defects and follow up on them regularly.
• Manage script revisions and tracking through development team.
• Creating and designing the shell script files for data extraction as well as data load from database tables to flat file and vise-versa with log maintenance.
• Designing the Physical and logical Data model and delivering Mapping Documents using ER Studio.
• Propose changes to an existing Data Model to make it more efficient.
• Establish and maintain the version control of various models in the ER studio Data Architect tool.
• Ensure consistency among logical and physical data models.
• Creating and reviewing Database Design Documents.
• Coding in SQL PL/SQL like Stored Procedures, Packages, Triggers, Cursors, Performance Tuning.
• Tuning SQLs, indexing, analyzing executions plans to reduce performance bottle necks.
• Responsible for various stages of the SDLC from use cases, design, development, unit and system testing, performance tuning and user acceptance testing Designing Reporting warehouse and On Line Transaction Processing system for business users so that they can do all their business steps.

SKILLS:

Knowledge Area: Requirements Gathering & Analysis, Business Data Analysis & Reporting, Data Warehousing, Preparing Mockups and Wireframes, Data Visualization and Analysis, Data Migration, SQL, PL/SQL.

Tools: Aginity Workbench for Redshift, Tibco Spotfire, Tableau, Erwin, ER Studio, PL/SQL Developer, Toad, Putty.

Operating System: UNIX/Linux, Windows.

Languages: Shell Scripting, SQL, Pl/Sql, Python, C, C++.

Data Base: AWS Redshift, Oracle, SQL Server.

SCM Tools: SVN, VSS, TFS.

Others: Filezila, WinSCP, Beyond Compare, Araxis Code Merger.

Domains: Life Science, Merchant Services, Sales, Banking & Finance.

EMPLOYEMENT HISTORY:

Confidential, Thousand Oaks, CA

Responsibilities:

• Co-ordinate with Business stakeholder to finalize the functional requirement for development tasks.
• Communicating with offshore team members for task assignment and feedback.
• Transferring business requirements in actual code using SQL.
• Publishing the final report with business team.
• Perform tuning and optimization of application SQL.
• Provide guidance during development phase.
• Daily health checks of system.
• Analyze the data model and customize for new requirement.
• Peer Code Review and testing the same and Internal UAT support.
• Review and guide system test plan preparation.
• Giving KT of new enhancement to new team members.

Confidential

Responsibilities:

• Transferring business requirements in actual code using Oracle PL/SQL.
• Performing tuning and optimization of database configuration and application SQL.
• Provide guidance during development phase.
• Co-ordinate with Business stakeholder to finalize the functional requirement for development tasks.
• Analyze the data model and customize for new requirement.
• Daily health checks of system.
• Peer Code Review and testing the same and Internal UAT support.
• Review and guide system test plan preparation.
• Maintaining TFS and manage assignments of the team.
• Giving KT of new enhancement to new team members.