SUMMARY

• Thirteen years of progressive experience as Application and Integration Architect, Oracle DB Consultant, Data warehouse Consultant, Senior Oracle Application Developer with strong working knowledge in all the phases of SDLC predominantly in the field of Banking, Finance, Insurance and Telecommunication.
• Expertise in setting up Data Ware housing environment, replicating Salesforce data and using ETL tool like Informatica to extract, transform and load data from several legacy systems into several systems mainly Siebel and Salesforce.
• Expertise experience in Informatica LOB admin duties which includes but not limited to set - up Informatica repositories and its related plug-ins, maintain all non-prod Informatica environments with prompt upgrades, install Power-Center binaries, set-up Informatica users, roles, folders, set-up code deployment for Informatica and deploy Informatica codes in all non-prod environments.
• Expertise Technical experience in setting up of Informatica 9.x in the UNIX/Linux server, power center binaries (9.0.1/ 9.5.1/9.6.1 ) in client servers, set-up Cipher for informatica repositories, MQ, Siebel and Salesforce plug-in binaries.
• Expertise Technical experience in setting up UNIX scripts to execute Informatica workflows using pmcmd and code movement using pmrep commands.
• Expertise Technical experience in Informatica Metadata Queries, automated Informatica code movement and automated Informatica workflows using various scheduling tools.
• Expertise Technical Experience in Informatica Power Center 9.x/8.x tool - Mapping Designer & Mapplets, Workflow designer & worklets and Various Complex Transformations.
• Expertise Technical Experience in UNIX Shell (Ksh, bash, csh), Perl, Informatica 9.x/8.x and Core JAVA.
• Strong Technical experience in setting up VPC, Subnets, NACL, Security groups, IAM user, group, roles, policies, EC2 instance, NAT instance, VPC endpoints, Dynamo DB, AWS RDS in fail proof Multi-AZ environments in AWS (Amazon Web Services) cloud along with maintaining their back-ups.
• Strong Technical experience in Oracle databases (12c/11g/10g/9i) PL/SQL programming, SQL loader, Database tuning, building complex queries, Hierarchical Queries, Dynamic SQL, Varrays, Associative arrays, Collections, Nested tables and Exception Handling.
• Strong Technical experience in using Oracle development tools such as Tool for Oracle Application Development (TOAD), Oracle Reports builder, Forms 6i, SQL developer, SQL* Plus, Oracle Enterprise Manager (OEM), Crystal reports, Business Objects, Informatica IDQ, IBM CDC and PL/SQL Developer.
• Strong experience in design, implementation, customization and production support of Oracle Applications 11i (GL module).
• Experience in python scripts to run Informatica workflows using pmcmd and migrate deployment groups in Informatica.
• Experience in migrating rules in SAS Dataflux.
• Experience in using version control tools like Sub-Version, Harvest, GitLab, GitHub, PC based version control (PVCS) and star team
• Experience in creating test plan, unit test cases using tools like Load Runner.
• Experience in writing technical specification document using tools like Word, Excel, PowerPoint, Visio.
• Experience in communicating with multiple levels of management, with in team and with external vendors in off-shore, near-shore and remote on-shore.
• Experience in Quality process like PCMM, CMMi, SDLC and Six sigma practices.
• Work in Agile and Waterfall methodologies.
• Excellent Organizational skills, Problem solving, Team Leading and Analytical skills. Self-motivated, Hardworking, ability to work Independently or Co-operatively in a team.

TECHNICAL SKILLS

Databases (DB): ORACLE 12c/11g/10g/9i, DB2, Netezza, Teradata and MS-SQL

Database Languages: SQL, PL/SQL, T-SQL, MS-SQL, SQR and DB2

Oracle Utilities: EXP/IMP,SQL Loader, EXPLAIN PLAN, STATS PACK, Automatic Workload Repository(AWR), Automatic Database Diagnostic Monitor (ADDM)

DB Development Tools: QUEST TOAD, Force.com, Oracle Enterprise Manager, SQL Developer, PL/SQL DeveloperSQL Navigator, SQL* Plus, ISQL* Plus, Erwin and SQL Server management studio

Reporting Tools: Oracle Developer 2000, Business Objects, Tableau and Crystal Reports.

ETL Tools: Informatica 9.6.1/9.5.1/9.0.1/8.6.1 , DataStage.

Data Tools: Informatica IDQ, Hadoop, SAS Dataflux.

Applications (CRM): Oracle Application 11i (General Ledger - Financial Module), Siebel 8.1.1 and Salesforce

Encryption Tool: Cipher Cloud.

Cloud Technology: AWS (Amazon Webservices) Cloud.

Operating System: UNIX, LINUX, AIX, Solaris, WINDOWS NT/2000 and DOS.

Version Control Tools: Subversion, GitHub, GIT Lab, Harvest, PC based version control system (PVCS) and Star team.

Scheduling Tools: Cyber-mation ESP, Zeke Scheduler, Maestro, Control-M, Autosys.

Other Languages: VB, Shell programming, Perl, COBOL, C /C++ and JAVA.

Other Apps/Tools/Utilities: HP Quality Center 9.2, HP Open View Service Center, Infra Enterprise, Defect change management system (DCMS), Lotus Notes 8, Microsoft Outlook, Mercury Load Runner, PuttyTelnet, WinSCP, Hummingbird, AnyClient, SiteScope Monitor.

PROFESSIONAL EXPERIENCE

Sr. Application Architect

Confidential, Charlotte, NC

Responsibilities:

• Gather business requirements, Design, set up Informatica UNIX environments to stage source and target files.
• Develop Informatica mappings and mapplets to extract and load data from Various Sources to load into Stage, Intermediate, Datamart and control tables.
• Define Directory structure, set up soft-link to the directories and set up user id to write to them.
• Write PMCMD scripts to run Informatica workflow from UNIX prompt.
• Work on Slowly Changing Dimension type2 to load the data into Reference tables.
• Write python scripts to Deploy deployment groups for Informatica migration.
• Use EXPLAIN to find query execution path and optimize long running Netezza queries.
• Create box jobs, file watcher jobs, command jobs for archiving the files and jobs to run the workflows through Autosys.
• Automate data migration using UNIX shell script which does data migration from DM to History automatically.
• Migrate SAS data flux rules from Dev.
• Automate the whole regression environment to run like PROD by triggering the jobs based on COB control file.
• Work on JIRA to track and fix tickets related to improvements and bugs in Agile environment.
• Create alerts in Site Scope monitor in lower lanes and promote them to PROD.

Environment: Oracle 11g/10g, Linux/UNIX, TOAD for Oracle, Toad Data Point for Netezza, Toad for SQL server, PL/SQL, Autosys, Informatica 9.5.1/9.6.1 , Harvest, Sub-Version, GIT Lab, GIT Hub, JIIRA, SiteScope, Dataflux.

Informatica Tech Lead / Data Integration Architect

Confidential, Columbus, OH

Responsibilities:

• Gather and analyze business requirements to support business needs in Salesforce using Informatica as Data Integration tool.
• Size MQ Storage, NAS, SAN by determining the data volume that gets processed and size and determine redo logs switch interval in Oracle Database for CDC.
• Set up CDC subscriptions in IBM Data stage environment to Capture Data Change in Oracle database and load them into Salesforce.
• Install Cipher certificates, Siebel binaries to enable connections through NW firewall and install Power center binaries on application servers to reduce load in Informatica servers.
• Upgrade from 9.5.1 to 9.6.1 Informatica version and install patches in Informatica servers to upgrade Soap from 27.0 to 33.0 and upgrade TLS 1.1 to TLS 1.2.
• Design appropriate data model using several dimension techniques like Type 1, 2, 4 for Oracle Data warehouse to host the data in intermediate Data marts.
• Generate RSA key for generic id’s and add them to trusted servers.
• Create sticky-bit on groups and soft links to access directories.
• Write Complex Informatica mappings using several transformations like Siebel source along with Siebel Business Service Objects, Siebel EIM Read, Siebel Load and Siebel Invoker transformations via Informatica Siebel plug-in., Salesforce Source, Targets, look-ups, Salesforce Merge etc. via Informatica salesforce plug-in, XML source, targets, MQ source and targets and extensively use transformations such as Update Strategy, Stored Procedure, Sequence Generator, Transaction control, Custom transformation, SQL, Aggregator, Look-up, Normalizer, Filter, Joiner, Router, Sorter, Union, Java, XML parser, XML generator etc.
• Write complex reusable shell scripts to pass mapping parameter values to Informatica workflows using PMCMD to control source code movement using pmrep command from Linux, to maintain Parent child relationship and near real time SLA of 20 minutes.
• Write complex SOQL to query Salesforce cloud data and Informatica mappings to replicate Salesforce data into local database.
• Create EIM jobs to populate data for one-time data fixes as well as creating new EIM jobs to populate data on the Siebel tables using IFB files and PL/SQL programs.
• Automate the informatica code movement in informatica environments like Dev, Test, PT.
• Write purge scripts to purge old logs and data in compliance with Nationwide Data retention policy accepted by business.
• Index tables, provide hints to SQLs or create Plans for SQL and put them in SPM for oracle DB to follow the next time.
• Work on the service center incidents P0, P1, P2, P3 and P4 and depending on the priorities take action on the incidents.

Environment: Siebel 8.1.1, Salesforce, Force.com, Oracle 11g/10g, Linux/UNIX, TOAD, Oracle SQL Developer, PL/SQL, ESP, Maestro, Informatica 9.5.1/9.6.1 , Harvest, Sub-Version, GIT Lab, GIT Hub, HP Quality Center, Service One and HP Service center.

Senior Oracle Database Consultant

Confidential, Irving, TX

Responsibilities:

• Gather business requirements, analyze, design, code, debug, test and implement.
• Set up the oracle 11g database as per the requirements.
• Write complex SQL queries, advanced PL/SQL, triggers, materialized views, dynamic SQL, UTL FILE and handle exceptions.
• Set up connectivity between MS-SQL 2008 and oracle 11g database.
• Load data into MS-SQL database and Oracle 11g database.
• Size database objects for effective space management and optimal performance.
• Install application, web and ETL server in the LINUX environment to host MERCED application.
• Schedule jobs to archive application logs and load data into the MERCED database.
• Work with the MERCED vendor to resolve application issues.

Environment: Oracle 11g/10g/9i, SQLServer2008/2005, Linux/UNIX, TOAD, Windows2003, RAC, PL/SQL.

Senior Oracle Database Consultant

Confidential, San Antonio, TX

Responsibilities:

• Gather business requirements, analyze, design, code, debug, test and implement.
• Write complex SQL queries, PLSQL cursors, stored procedures, functions, packages, triggers, materialized views, dynamic SQL and handle exceptions.
• Sizing database objects for effective space management and optimal performance.
• Make structural changes to the database when design changes are made.
• Read, write or append an operating system file using PL/SQL package UTL FILE.
• Create row-level and statement level triggers to validate a transaction.
• Tune long running SQL queries using EXPLAIN PLAN and TKPROF.
• Monitors, analyzes and tunes performance bottlenecks in the client’s application database infrastructure using UNIX-based tools and Quest TOAD.
• Create and execute test plan.
• Write shell, Perl and JAVA utility scripts.

Environment: Oracle 11g/10g/9i, SQLServer2005/2000, Linux/UNIX, TOAD, Windows2003, RAC, PL/SQL, Crystal reports, Informatica, IBM AIX, IBM Tivoli Enterprise, Infra Enterprise, Star team.

Senior Oracle Application Developer

Confidential

Responsibilities:

• Create interface program to import data into Oracle Apps.
• Define GL SOB (General Ledger Set of Book) and FSG Reports in Oracle Apps.
• Design Reports in the report builder and register it in Oracle Apps.
• Create, register and automate concurrent programs, spawned programs in Oracle Apps.
• Load the legacy data into Oracle Apps using export import through SQL loader.
• Create triggers at form level, block level, Item level, alerts, procedures, and visual attributes using PL/SQL.
• Create PL/SQL programs using SQL Queries, PL/SQL packages like UTL FILE, DBMS OUTPUT, DBMS SQL, and GATHER STATICS
• Create Perl scripts and CORE JAVA to format reports and use UNIX Shell script to FTP reports to business users.
• Code, Test, Debug, Document and maintain programs.
• Provide Oracle Apps user training to business users.

Environment: Oracle 9i/10g, PL/SQL, Developer 2000, Sun Solaris, Forms builder, Report builder, Oracle Apps 11i General Ledger Module, TOAD, COBOL, Pro C, PVCS.