SUMMARY:

• 7 years of professional IT experience in ETL and database development\analysis\modeling\ETL using Oracle and Microsoft technologies.
• ETL tools design and development - PL/SQL packages.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Validation of operational sources using ETL processes for data warehouses.
• Implemented data models in Erwin data modeler.
• Business requirement gathering and analysis for ETL/Database design and development.
• Data profiling, data cleansing, data mapping, data modeling, data validation.
• Extensive knowledge in Development, Analysis and Design of ETL methodologies in all the phases of Agile and Waterfall Data Warehousing life cycle.
• Maintaining batch scripts and automation jobs.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages, exception handling and Triggers.
• Performance improvement of ETL, SQL, PLSQL (by using Pipeline functions).
• Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERwin.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• Web applications and interface design and development using Oracle APEX and TOAD utilizing SQL, PL/SQL.
• Extensive experience with Agile and Scrum.

TECHNICAL SKILLS:

Languages: SQL, PL / SQL, R, Scala

Technologies: ETL, Data warehouse, OLAP, BI

Databases: Oracle 10g/11g, SQL Server, MS Access

SDLC: Waterfall, Iterative, Agile, Scrum

Tools: Oracle APEX 4.0, Toad for Oracle, Tableau, SQL Loader, ERWIN, SSIS, Eclipse, Serena Version Manager, WinSCP, Reflection workspace, Visual Studio, CVS, Microsoft Team Foundation Server (TFS).

OS: Windows XP/7/8/10, UNIX, LINUX, Mac, Windows Server 2012

Future Interest: Big Data, Hadoop ecosystem, Data Science / Analytics

PROFESSIONAL EXPERIENCE:

Confidential, Suitland, MD

Database/PLSQL developer

Responsibilities:

• Contributed in development of oracle packages in PL/SQL.
• Developed SQL scripts to maintain and update the database for applications.
• Development of Bash scripts to run PL/SQL packages and procedures.
• Used Toad for Oracle in Query writing and SQL Loader in trouble shooting.
• Using tools like Serena Version Manager, WinSCP, Reflection Workspace etc.
• Working experience of Iterative methodology and prototype development.

Environment: Linux, Oracle, Toad, Serena Version Manager, WinSCP, Reflection Workspace.

Confidential, Plano, TX

Data Modeler / ETL developer

Responsibilities:

• Contributed in implementation and maintenance of data models in Erwin data modeler.
• Developed PL/SQL packages and SQL scripts to maintain and update the database for applications.
• Development of ETL routines in PL/SQL procedures in Informatica.
• Used Toad for Oracle in Query writing and SQL Loader in trouble shooting.
• Applied data profiling in data warehousing, data conversion and data migration.
• Working experience of Iterative methodology and prototype development.

Environment: Oracle, Erwin 9.5, Toad.

Confidential, Saint Cloud, MN

Data analyst / IT Analyst / Database developer

Responsibilities:

• Contributed in data modeling and designed ETL jobs in Data Services to build a data mart for reporting.
• Developed SQL scripts to maintain and update the database for applications.
• Identifying issues that can be corrected in ETL processing
• Developed reusable mappings and stored procedures.
• Access data migration to SQL Server.
• Performance and load testing: building the expertise in performance and load testing.
• Automated the Regression testing, Smoke testing and Integration testing with selenium.
• Gained expertise in working with Lending and Mortgage applications.
• Working experience of Agile and Scrum methodologies.

Environment: SQL Server 2014, Access, Selenium, Team foundation Server.

Confidential

ETL developer / Database developer

Responsibilities:

• Responsible for development of ETL routines in PL/SQL procedures, Informatica and SSIS mappings and KSH.
• Developed PL/SQL procedures using in memory structures, bulk loading, and pipeline functions.
• Designed and developed reusable ETL Mappings, Sessions, Tasks, Work flows, loading data from various sources using Informatica and SSIS which reduced overhead by 20%.
• Applied Partitioning and Indexing techniques on large data warehouse Fact tables in performance tuning and query optimization.
• Responsible for ETL package deployments on Development, Test, CT and Production environments.
• Active participation in requirement gathering and source system analysis.
• Used Toad for Oracle in Query writing and SQL Loader in trouble shooting.
• Experience of working with large amount of data daily coming from various XML, TXT and Excel data sources.
• Applied data profiling in data warehousing, data conversion and data migration.
• Monitoring and support of daily batch process and performance monitoring.
• Working experience of Agile and Scrum methodologies.
• Created design, Specification & technical documents.

Environment: UNIX Solaris 10, Oracle 10g, ETL, SQL / PL-SQL, Toad for Oracle, SQL Loader, ERwin, Informatica.

Confidential

Database developer

Responsibilities:

• Responsible for analysis/design, development, maintenance and testing the application.
• Used Oracle Apex 3.2 and 4.0 to develop forms and reports in application.
• Used relational and dimensional modeling for database design.
• Developed complex SQL queries and PL/SQL data structures and procedures to implement the logic within application.
• Responsible for app migration among Development, Test, CT and Production environments.
• Working experience of Agile and Scrum methodologies.
• Worked directly with End User throughout the whole project.
• Managed and conducted End User training sessions.
• Created design, Specification & technical documents.
• Working experience of Iterative methodology and prototype development.