Leading and delivering data engineering strategies to build a scalable data architecture and customer feature rich dataset for Business Users

• Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.• Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.• Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.• Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.• Developed, implemented and maintained data analytics protocols, standards and documentation.• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.

• Assist project manager in developing realistic action plans with time schedules, critical dates, resource and cost estimates.• Ensure optimal utilization of allocated resources.• Lead small teams in a project• Maintaining Oracle Database. SQL Tuning of code developed by developers• Creation and execution of data fix scripts using Abinitio, PL/SQL.• Ensure effective coding - in adherence to the coding standards• Ensure quality of implementation as per the defined standards• Ensure timely and effective documentation as per the defined standards• Developing applications using PL/SQL, Informatica , Sun Solaris. • Maintain quality records and generate reports for senior levels• Initiate process improvement and ensure compliance to quality standards.• Keep abreast with latest technologies and bring about regular self up-gradation• Regularly monitor the progress of the module(s) involving review of all deliverables, slippages, defects etc and take corrective measures, if required Present assignment/module status report periodically to the project manager.

•Interacting with the customers, data analyst, and the technical team to carry out analysis of the business requirements.•Participated in the review and approval of the technical transformations requirement. Used technical transformations document to design and build the extraction, transformation and loading modules.•Working with the client’s Database Administrator to design the data warehouse, temporary tables and user schemas.•Communicating with the developers and the client’s Data Analysts to refer with and clarify the logical structures of the source tables, and resolve any discrepancies.•Extracting data from the various sources and transforming it in accordance with the Business logic mentioned by the client.•Query Optimization / Query Performance Tuning For Large Database •Project scheduling and analysis•Monitoring development activities and reporting project progress.•Delivering and implementing the project as per scheduled milestones. •Involved in analysis of database, Query optimization, indexing, and Ensuring effective utilization of the indexes used in the SQL or PL/SQL code.•Involved in analysis and report generation – Oracle Export, Import, writing SQL scripts to populate the data warehouse tables.

• Interacting with the customers, data analyst, and the technical team to carry out analysis of the business requirements.• Participated in the review and approval of the technical transformations requirement. Used technical transformations document to design and build the extraction, transformation and loading modules.• Working with the client’s Database Administrator to design the data warehouse, temporary tables and user schemas.• Communicating with the developers and the client’s Data Analysts to refer with and clarify the logical structures of the source tables, and resolve any discrepancies.• Extracting data from the various sources and transforming it in accordance with the Business logic mentioned by the client.• Query Optimization / Query Performance Tuning For Large Database • Project scheduling and analysis• Monitoring development activities and reporting project progress.• Delivering and implementing the project as per scheduled milestones. • Involved in analysis of database, Query optimization, indexing, and Ensuring effective utilization of the indexes used in the SQL or PL/SQL code.• Involved in analysis and report generation – Oracle Export, Import, writing SQL scripts to populate the data warehouse tables.

 Production Database Management. MIS Generation from Production Database as per Business requirement. Business Rules Implementation, Policies and Definition Implementation. EMI Conversion Rule Definition in System. Post Production Support /Patch Deployment & Testing.