SUMMARY:

• Having years of analytical and problem solving skills in information technology.
• Development experiences in Oracle PL/SQL, Tableau, ELT/ETL ODI, JAVA and client server technologies. Looking for an opening in ETL related technologies including design, development and testing
• Maintenance, reverse engineering, code - review and documentation
• Analyze and assess current processes and define document improvements
• Recommend method and procedural changes
• Involved in tasks that encompass requirements gathering, system, screen design, user, functional requirements
• Simplified and documented various business layer code documents involving
• Utilized Agile/Scrum practices
• Normalized databases including entity relationship and modelling
• Created line and pie charts and graphs, histogram reports for data analysis
• Defined conceptual logical and physical model
• Developed PL/SQL, Stored Procedures, Functions, Triggers, and Packages.
• Involved in SQL tuning using Explain Plan
• Knowledge in Java Design patterns
• Involved in J2EE applications
• Involved in defect tracking including planning and running tests
• Created Sheet, Dashboards and Custom SQLs in Tableau

PROFESSIONAL EXPERIENCE:

Confidential

Consultant Data Cleaning and Modelling

Responsibilities:

• Gathered information from various agencies and analyzed data in Tableau
• Designed sheets and Dashboards using views and tables.
• Used various marks, table functions, calculated fields, parameters, actions in Tableau
• Utilized calculated fields, functions, tab reports, graphs, actions, trend lines of tableau.
• Created various calculated fields in Tableau and derived fields in Oracle
• Optimized SQL and views for tableau.
• Created derived columns for tableau SQL and audited various tableau SQL
• Wrote procedures to extract loading and transformed using pl/sql.
• Simulated the procedures in ODI KM and wrote the same as procedures n functions
• Created various reference data, divided variables(numeric/categorical), wrote procedures.

Confidential

Developer / Data Analyst

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering Built complex queries using SQL and wrote stored procedures using PL/SQL
• Worked in Data modeling, Data mapping and Data flow
• Involved in Requirement gathering and writing Functional and Technical documents
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Implementing complex business rules by creating ODI interfaces.
• Created ODI variables and KMs for generic import to DW
• Experience on ODI Knowledge Modules like, LKM, IKM, JKM, and CKM.
• Good Understanding of architecture and functional parts of Oracle Data integrator.
• Functional experience includes identifying the sources and mapping them with data marts

Confidential

Oracle Developer

Responsibilities:

• Reviewing and developing data models and database designs with development teams, entity-relationship models are used with relational databases, normalizing, and de-normalizing, indexing, and defining views.
• Created database objects like tables, views, materialized views, procedures and packages.
• Worked on Performance tuning queries, database tuning, suggesting and implementing alternative approaches like range partitioning of tables, use of global temporary tables.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Prepared system test cases and perform system testing.
• Analysis of functional specifications & communicating the same to team members.

Confidential, New Jersey

Java Developer

Responsibilities:

• using JSP tags to invoke Servlets
• Involved in server side coding using Servlets
• Developed Business components JavaBeans and database connections using Confidential .
• Involved in Designing and creating database tables
• Wrote various queries using SQL and used SQL server as the database

Confidential, New Jersey

Software Analyst

Responsibilities:

• Involved in design and development of ETL process full data warehouse life cycle
• Involved in designing the procedures for getting the data from all the source systems to Data Warehousing system
• Extracted the Data from different sources systems like Sybase, Oracle, DB2, and flat files and loaded them into Oracle database
• Utilized mathematical functions, built-in-workflow and data mining through Business Objects
• Created Oracle Stored Procedure to implement complex business logic for good performance and called from Informatica using Stored Procedure transformation.
• Debugging techniques to for mappings and used session log files and bad files to trace errors occurred while loading.
• Creating test cases for Unit Test, System Integration Test and UAT to check the data
• Responsible for migrating the folders or mappings and sessions from development to production environment

Confidential, Confidential, NY

Developer

Responsibilities:

• Developed a module to update currency rates in Sybase databases of Fidessa Trading System, using C++ .Wrote C-shell scripts establish a communication link between Confidential London and New York trading systems.