SUMMARY:

• Over 16 years of experience in Database Design & Development, Implementation and Deployment.
• US Lawful Permanent Resident (Green Card) since April 2017.
• Work experience with clients Confidential, S&P Global (Formerly Standard & Poor’s) and BASF.
• Proficient in programming in Oracle SQL, PL/SQL, TSQL (SQL Server), and in Visual Basic.
• Strong in SQL and PL/SQL Performance Tuning.
• Proficient in Data Modelling using CA Erwin and knowledge in Business Process Modelling.
• Hands on experience in Extraction Transformation and Loading using Informatica ETL tool.
• Experience in UNIX shell scripting, windows batch scripting and strong debugging skills in Java.
• Experience in configuration management, estimation and resource planning.
• Experience in Agile, Scrum and Waterfall methodologies.
• Worked as Business Intelligence and Data Warehouse Modeler.
• Preparation of high level system specification based on the business requirements.
• Involved in Database Design
• Worked with business and technical teams in understanding and translating the business needs into data models.
• Build data flows and develop conceptual, Logical and Physical data models.
• Review of Data model with business, functional and technical teams.
• To create logical and physical data models using ERWIN and reduce redundancy.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency.
• Developed complex ETL mapping and workflows using Informatica Power Center.
• Experience in Data Profiling and Data Quality.
• Create document and test cases for all the ETL workflows.
• Analyze the existing models and suggest remediation to migrate as per new or enhanced models.
• Implement business rules on the basis of software requirements specifications.
• Design activities and steps for implementing core business logic.
• Involved in Performance Tuning of PL/SQL packages and SQL queries.
• Coordinate between on - site and offshore teams.
• Coordinate with DBAs to deploy the Oracle scripts into database.
• Train, mentor and guide the team on product knowledge.
• Suggest technical solutions and best practices to the cross project teams.
• Impact analysis, estimation and implementation of change requests.
• To maintain a good customer satisfaction at every issue level from the beginning of the project.
• Assist in identifying process improvements for database performance, reliability and stability.
• Develop high performance complex procedures and functions using Oracle collections.
• Troubleshoot complex database issues in a timely fashion
• Provide project updates and metrics to client managers on regular basis.
• Involved in Database Design and Business Intelligence, data modeling using ERWIN.
• Creation of PL/SQL Packages, Stored Procedures, and database triggers.
• Written and managed more than 200 Packages, Stored-Procedures and Triggers in PL/SQL
• Written complex queries and stored procedures in TSQL.
• Migration of the existing reports of Avenue into iAvenue.
• Creation of new reports based on the user specific requirement using Crystal Reports.
• Preparation of root cause analysis for all type of tickets.
• Work on production critical tickets and resolving within the SLA.
• Creation of metrics, SLA, WSR, Ticket Support Handlers and version controlling.
• Interactions with Client, responding to queries, debug requests and solve the issues online.
• Involved in Requirement Analysis and Use cases preparation for Chemical Management Process.
• Created complex ETL mappings and workflows using Informatica.
• Involved in migration of ETL maps from Mercator to Informatica.
• Involved in Documentation and status report
• Involve in modification /development of existing / new shell scripts on user specific requirement.
• Preparation of Test cases and testing of modified scripts.
• To monitor batch jobs in Autosys, Control M, AppWorx, UC4 scheduler on daily basis.
• Interactions with Client, responding to queries, debug requests and solve the issues.

TECHNICAL SKILLS:

Databases: Oracle (18c, 12c, 11g, 9i, 8i), SQL Server, Teradata, RedShift, MongoDB and MS-Access

Tools: ERWIN, ER Studio, Dezign, TOAD, SQL Developer, PL-SQL Developer, WS-FTP, CUTE FTP, LANDesk, Snag IT, AHD, AppWorx, UC4, Control-M, Autosys, Mercury Test Director.

Languages: SQL, PL/SQL, VB 6.0, C, pro*C, Java

Reporting Tools: Crystal Reports (8.0), Business Objects XI R3, MicroStrategy (9.2).

Big Data: Map Reduce, Hive, Hbase, Sqoop and Spark.

ETL Tools: Informatica (7.1.2), 8.x, 9.1.

Version Control: VSS, WinCVS, CVS.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Data Modeler / ETL Developer / DB Developer

Environment: Sql Server 2008, ERWIN, TOAD, Informatica 9.x.

Responsibilities:

• Create Data Model and Database Design for Business Intelligence reporting using Toad.
• Create and modify ETL mappings and workflows in Informatica to load from CREST Db to Target Db.
• Create complex SQL Queries to fetch and verify the data load.
• Work with business intelligence team to assist development of reports.

Confidential, New York

Sr. DB Developer / ETL Developer

Environment: Oracle (11g), ERWIN, Teradata, TOAD, SQL Developer, Cute-FTP, putty, Informatica 9.x, Windows batch programming, Perl, Shell scripting.

Responsibilities:

• Create complex stored procedures and packages in PL/SQL.
• Create and modify ETL mappings and workflows in Informatica.
• Create windows batch scripts and UNIX scripts to automate the process.
• Involve in Performance Tuning of PL/SQL packages and SQL queries.
• Develop high performance complex procedures and functions using oracle collections.
• Troubleshoot complex database issues in a timely fashion
• Provide project updates and metrics to client managers on regular basis.
• Coordinate between on-site and offshore teams.

Confidential, New York

Sr. DB Developer / ETL Developer

Environment: Oracle (11g), Sql Server 2005, ERWIN, TOAD, PL-SQL Developer, Cute-FTP, putty, Informatica 9.x, Java 1.6.

Responsibilities:

• Developed high performance complex DB procedures and functions using Oracle collections.
• Involve in Performance Tuning of PL/SQL packages and SQL queries.
• Interact with business teams to understand project requirements
• Prepare high level system specification based on the business requirements.
• Worked with clients in understanding and translating the business needs into data models.
• Build data flows and develop conceptual data models.
• Review of Data model with functional teams.
• To create logical and physical data models using ERWIN and reduced redundancy.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Develop data models according to company standards.
• Perform reverse engineering of physical data models from existing databases and SQL scripts for better understanding of the system.
• Involve in Database Design with DBA team.
• Assist in identifying process improvements for database performance, reliability and stability.
• Check to see data models and database are in sync.
• Troubleshoot complex database issues in a timely fashion
• Provide project updates and metrics to client managers on regular basis.
• Coordinate between on-site and offshore teams.

Confidential

Historical Load

Environment: Oracle (9i, 10g), Teradata, SQL Server, TOAD, PL-SQL Developer, Mercator, Informatica Power Center 7.3, 8.x, 9.x, Cute-FTP, putty, Mercury Test Director, Citrix, SharePoint, Nortel VPN Client, RSA Secure.

Responsibilities:

• Involve in Performance Tuning of PL/SQL packages and SQL queries.
• Develop high performance complex procedures and functions using oracle collections.
• Create of new ETL mappings and workflows.
• Prepare high level system specification based on the business requirements.
• Worked as MDM Data Modeler using Erwin.
• Worked with clients in understanding and translating the business needs into data models.
• Build data flows and develop conceptual data models.
• Review of Data model with functional teams.
• To create logical and physical data models using ERWIN and reduced redundancy.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Develop data models according to company standards.
• Involve in Database Design with DBA team.
• Check to see data models and database are in sync.
• Troubleshoot complex database issues in a timely fashion
• Provide project updates and metrics to client managers on regular basis.

Confidential

Data Modeler, Application & DB developer

Environment: V.B. (6.0), Oracle (8i), Sql Server, Crystal Reports (8.0), MS-Project, ERWIN and TOAD.

Responsibilities:

• Developed high performance complex procedures and functions in Oracle.
• Extensively worked in front end development using Visual Basic 6.0 and crystal reports.
• Worked as Data Modeler using Erwin.
• Worked with product owner in understanding and translating the business needs into data models.
• Build data flows and develop conceptual, logical and physical data models.
• Involved in Database Design.