SUMMARY

• 7+ years of experience working with IT industry working with Banking and Health Care sectors.
• Strong knowledge in developing PL/SQL objects such as procedures, functions, packages, views, materialized views, DB links & triggers.
• Experienced with relational databases such as Oracle 11g, Oracle 10g, SQL Server 2012/2008/2005 working experience on TERADATA as back end for the ETL Process
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Possess strong communication and problem solving skills developed through a variety of projects.
• Ability to work independently and also great team player.
• Experience resolving performance issues with Crystal reports, queries or sql jobs.
• Expertise in TSQL, PL/SQL, SQL Loader, UNIX Shell scripting, Erwin, Data modeling and Development DBA Activities.
• An effective team member with great communication skills, comfortable working alone as well.

TECHNICAL SKILLS

Databases: Sql server 2012/2008/2005, Oracle 11g/10g

ETL Tools: Informatica Power center 9.5/98.6/8.1, SSIS

Reporting: SSRS 2008, Crystal Reports

Operating Systems: Window 9X/NT/XP, UNIX.

GUI: SQL Loader, TOAD.

Scripting: Unix Shell scripting

Version Control: IBM Rational Clearcase, VersionOne

Other Tools: HP Quality Center, Vi editor

PROFESSIONAL EXPERIENCE

Confidential, VA

Pl/sql and Informatica Developer

Responsibilities:

• Develop PL/SQL procedures, functions, packages, views, and triggers for complex reporting environment.
• Fine tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Cost based optimization.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding actual tables and to eliminate the complexity of the large queries.
• Performed requirement gathering and analysis, data analysis and data profiling to verify the source to target mapping, identify discrepancies and bridge gap between requirement and solution.
• Worked with Informatica Designer of Functional Description, Scope and Detailed functional requirements.
• Designed and Created data cleansing and validation scripts using Informatica ETL tool.
• Responsible for creating, importing all the required sources and targets to the shared folder.
• Worked with Different sources such as Relational Data bases (Oracle, SQL Server, and MY SQL), Flat files, Xml files.
• Created mappings using Informatica Designer to build business rules to load data.
• Created Folders and placed all the tested ETL, Oracle and UNIX scripts in the Staging path for production movement.
• Created UNIX scripts for handling the ftp of source files, to make them execute in sequence as per the time stamp and to archive the processed files for future reference.
• Scheduled the jobs in Development and Testing environment using Informatica Scheduler.
• Prepared the data flow of the entire Informatica objects created, to accomplish Integration testing.
• Prepared Unit Test Plans.
• Supported user queries against availability of data from Data Warehouse.
• Interacted with the Business Analysts to understand the business & gather technical requirements.
• Interacted with Architect to understand the High level Design.
• Helped in creation of mapping specs for better code processing.

Technology: Unix, Teradata, Oracle, T - SQL, SQL server, Shell scripting, Vi editor, QualityCenter, Agile methodology, VersionOne.

Confidential, NJ

Sql Developer

Responsibilities:

• Abstracted relational and delimited text file to local environment and developed the code in Dev environment.
• Checking the file formats for the source flat files using UNIX shell scripts thereby ensuring input file formats are same as specified.
• Created Mapplet for error handling process to deal with null records.
• Developed code for landing environment and then for staging and finally developed Incremental load populate the target tables for atomic model.
• Developed code to move data to MDM environment and finally loaded target tables using truncate load.
• Loaded Historical data for specific period of time to the Atomic model.
• Developed code for backload and Incremental load.
• This normalized model was used as a staging area for the dimensional model which was Netezza based dataWarehouse.
• Used SCD type 1 to load dimensions in Netezza and Fact tables of DataWarehouse.
• Created Reusable sessions in Task Developer.
• Used Informatica scheduler to run the workflows in Dev Environment.
• Worked on Informatica Power Center tool - Source Analyzer, Mapping Designer and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Written PL/SQL packages, procedures and functions and developed Informatica Mappings to perform test loads.
• Extensively used SQL Developer to check if data is properly loaded into target systems by writing SQL Queries.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used Debugger in troubleshooting the existing mapping.
• Performed Unit test and Integration test for the process created in Informatica and all the test cases were well documented for process improvements.
• Created test scripts and Unit test plan documents.
• Created Deployment Document for Migration of code from Dev to Test and from Test to Production environment.
• Involved with testing team to test and Fix the code.

Technology: Informatica PowerCenter 9.1, Oracle 11g, SQL developer, Putty, Winscp, UNIX shell scripting, PL/SQL, Netezza, Aginity workbench.

Confidential, PA

SQL Developer

Responsibilities:

• Writing database queries, stored procedure, functions, sub-queries, joins using T-SQL
• Optimizing SQL queries using query hints, indexes, execution plan and SQL server profiler trace
• Responsible for troubleshooting install issues reported by installers during the Net-new, upgrade or a service pack event
• Root cause analysis of install issues using Siemens internal logs, event-viewer, fiddler trace, SQL server logs
• Having sessions with SQL server DBA to understand issues related to Logins out of synch, Database backups, Database corruption, Recovery
• Present issues in on-call meetings in front of developers
• Debugging and analyzing new builds during test installs and creating tickets for appropriate teams if it is out of scope
• Monitoring Day-end issues caused due to job failures in Siemens Datawarehouse tool
• Digging into OLAP (Online Analytical Processing) cube issues, ETL Backload issues and eliminating errors
• Direct interaction with Client
• Assist in improving installation and deployment documentation
• Familiarity with Healthcare environment/Software

Technology:Informatica,SQL server profiler, Query analyzer, SQL Server 2008R2/2008/2005 database permissions, logins, backup, indexes, statistics, stored procedures, T-SQL, Internet Information Services (7.0), Active Directory, Event viewer, Process explorer.

Confidential

SQL Server Developer

Responsibilities:

• Involved in the entire System study, analysis and design.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Involved in the analysis of how the purchase order process was organized.
• Created SQL tables with referential integrity and developed queries using SQL.
• Involved in writing Triggers which internally called procedures and functions.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Supported technical teams involved with MS SQL issues and operations.
• Involved in the maintenance of the database.