SUMMARY

• 6 years of professional IT experience in development of ETL and database applications using Oracle and Microsoft technologies.
• ETL tools design and development - PL/SQL packages, Informatica, SSIS.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Validation of operational sources usingETLprocesses for data warehouses.
• Implemented OLAP cubes in SSAS and reports in SSRS.
• Developed complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Business requirement gathering and analysis forETLdesign 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 InformaticaETL, SQL, PLSQL (by using Pipeline functions).
• Logical and Physical Design ofDatabaseand ER Diagrams using multipledata 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: Java, SQL, PL / SQL

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, Informatica. SQL Loader, ERWIN, SSIS, Eclipse, Visual Studio, CVS, Microsoft Team Foundation Server (TFS).

OS: Windows 98/XP/7/8, UNIX, Windows Server 2012

Future Interest: Big Data, Hadoop ecosystem, Cloud technologies

PROFESSIONAL EXPERIENCE

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.

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.

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.

Confidential

ETL developer / Database developer

Responsibilities:

• Technical lead of the project, time management, resource allocation and management, project planning and management.
• Ensuring that the project is delivered within the stipulated time and meets the required standard ETL process.
• Built complex database packages, procedures and functions in PL/SQL.
• Used analytic functions and SQL aggregation, analysis and reporting queries to prepare data for BI data marts.
• Used relational and dimensional modeling for database design.
• Maintain daily batch processes and its validation.
• Responsible for app migration among Development, Test, CT and Production environments.
• Database optimization and maintenance.
• Working experience of Agile and Scrum methodologies.