Senior Technical Developer Resume

SUMMARY:

A competent, professional and dedicated Senior Technical Developer having 6+ years of experience in IT. Responsible for the design, development, support and maintenance of ETL/Relational Database/reporting applications

TECHNICAL SKILLS:

BI & ETL: Informatica Power Centre 9.x, OBIEE, Dimensional Modelling

Programming: SQL, PL/SQL, UNIX Shell Scripting, Perl

Database: Oracle 9i/10g/11g/12 c, DB2, MS SQL Server

Tools: Toad, Oracle SQL Developer, Control - M, Putty, ITSM, SVN, Websphere MQ

Operating Systems: Linux, UNIX, Windows

PROFESSIONAL EXPERIENCE:

Confidential

Senior Technical Developer

Responsibilities:

Designed, developed and tested various database components (Oracle) for various Marketing subject areas
Integrated data from heterogeneous sources like flat files, Cobol files, databased to Enterprise Data Warehouse
Worked independently on one of the ETL projects that involved all phases of Software Development Life Cycle
Performed Bulk data load during historical data push using PL/SQL
Prepared various technical documents, including Business Requirements, Functional and Technical Specifications
Used various oracle packages such as DBMS OUTPUT, DBMS STATS, DBMS UTILITY, DBMS SMTP
Prepare monthly reports and present it to the management
Develop data access queries through Oracle BI tools
Troubleshot various technical issues related to ETL process/Reports/dashboard
Worked in Materialized views to display sync data in customized dashboard
Maintained existing historical and incremental ETL’s with occasional upgrades and enhancements
Partitionedthe fact tables andmaterialized viewsto enhance the performance
Identify critical issues and processing faults to optimize BI dashboards and reports
Perform testing sessions for reports and dashboards and resolve process issues
Acquired in-depth knowledge on several marketing functional areas such as lead scoring and nurturing, opportunity, email and campaign management etc.
Used server- based scheduler (DBMS SCHEDULER) to schedule packages in a systematic way
Identified and resolved performance bottle-necks to improve report response time
Worked on software development Agile best practices
Performed backup and recovery tasks
Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scripts for loading tables
Troubleshot live application issues in the timely fashion
Designs, writes and modifies reports, programs, scripts, and modules which meet reporting needs

Confidential

Business Intelligence Associate

Responsibilities:

Involved in analysis, design, testing, implementation and maintenance phase of several Business intelligence projects
Developed Informatica ETL mappings/sessions/workflows and conducted unit/system testing
Troubleshot and resolved various ETL/FTP related Production issues
Designed Control-M jobs that automated the ftp process of loading flat files posted on the ftp server
Strong domain knowledge in Finance/Banking (Mortgage)
Proficient using query tools like TOAD, SQL Developer, PL/SQL developer
Conducted feasibility checks and impact analysis related to new requirements/system changes
Provided post implementation and on-going production support
Developed various PL/SQL components such as REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections
Maintained existing data migration program with occasional upgrades and enhancements
Worked on database space savings by optimizing the existing tablespace and index reorganization
Re-designed and coded existing PL/SQL integration into ETL processes
Participated in designing logical/physical database during ER modelling
StrongData Modelingexperience usingER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin
Developed PL/SQL Packages, Procedures, Functions, Cursors
Excellent SQL coding & tuning skills with in-depth knowledge in analyzing SQL using various tools like Explain plan, TKPROFandAUTOTRACE and performance tuning using HINTS
Coded and tested various database objects such as views, sequences, synonyms and bulk collect using PL/SQL
Handled bulk and user-defined exceptions
Applied focused development changes across oracle database and saw the changes applied through the life cycle of environments

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship