SUMMARY

• Overall 12 years of experience in Software Design/Development & Project Management.
• Expert in using Actimize Visual Modeler 4.9 & RCM designer 5.1, Informatica Power Center 9.01/8.1.1, Informatica Data Quality, PL/SQL, UNIX, Shell scripting,, Erwin Data modeling tool, and Informatica Metadata Manager.
• Expertise in ETL Architecture, Error Handling Strategies, Unit Testing and Systems Integration Testing.
• Expertise in developing Actimize flows and execution plans and configuring AIS Instances and RCM repositories.
• Designing Alert Types and setting Thresholds and Inclusion/Exclusion lists.
• Good Experience in managing a team of developers with an extended support from offshore
• Project Planning, implementation and monitoring
• Coordinating with Senior management on project timelines and resource requirement
• Leverage technical, business and financial acumen to communicate effectively with client executives and their respective teams.
• Expert in agile and waterfall project management methodologies. Able to manage large project teams and known for high - quality deliverables that meet or exceed timeline and budgetary targets
• Excellent Troubleshooting and Analytical skills
• Strong knowledge and hand-on experience of Data Analysis, Data Profiling and Data Modeling.
• Comfortable in DWH Technologies like Metadata Management, Dimensional Modeling, Star Schema data modeling, Snow flaking, Late arriving dimensions, Rollup and aggregation strategies and data mart creation.
• Extensively involved in End to End solution design involving data modeling and design of end to end extract transform and load processes with data coming from heterogeneous source systems to target systems.
• Performance Tuning of ETL mappings using best practices like push down optimization, avoiding memory and CPU intensive transformations like Aggregator and Ranker.
• Performance Tuning of SQL and PL/SQL code using techniques like Bulk Collection, Merge Statement, inline views, parallelization, using Hints etc.
• Good experience in implementing SQL analytical functions such as rank (), row number ().
• Good experience in implementing table partitioning, materialized views with Query rewrite facilities available in ORACLE RDBMS.
• Implemented version control using SVN, manage the version control for the project.
• Scheduling application related jobs (UNIX,Informatica, SQL) through Autosys and ControlM.
• Ensuring Informatica best practices based on velocity guidelines.
• Strong experience working with clients to gather and analyze business requirements.

TECHNICAL SKILLS

Technical -System Design & Development: Requirements Analysis, ROI Analysis, Project Scheduling, Gap Analysis, Design, Development and Implementation, Data modeling, Systems Engineering, System Migrations/Integrations, Enterprise wide Implementations ETL Design / Architecture, Development, Testing,QA, Rollout Support,Tuning and Scheduling, SQL Tuning, Exadata Migration

Languages, Software and Tools: Informatica Power center 9.x, 8.x, 7.x, Informatica Data Quality, Actimize Visual Modeler and RCM designer, C, Erwin Data Modeler, UNIX, SQL* Loader, Toad and PL/SQL, Control-M, Autosys

RDBMS: Oracle 10g/9i and Exadata, DB2, SQL Server

Operating Systems: UNIX, Windows XP/2007

PROFESSIONAL EXPERIENCE

Confidential, Jersey City NJ

Senior Data Architect ETL

Responsibilities:

• Responsible for designing and implementing complete Actimize work flows to cater surveillance requirement and coordinating with business users to get UAT signoff on critical solutions. ;
• Managing and Guiding a team of developers with an extended support from offshore for the implementation of solution designed;
• Designing Alert Types using RCM Designer; Setting up Thresholds, inclusion/exclusion lists in RCM Repository for various surveillance models and making sure that the link is properly established in corresponding AIS code for the model;
• Setting up Dev/QA and Production AIS Instances and assigning proper port numbers and number of connections per instance and other parameters in ais config.xml file.;
• Setting proper Staging area, data and metadata folders and their location on AIS server;
• Translating business rules related to catching fraudulent transactions and compliance violations in actimize detection flows ; Project Planning, implementation and monitoring;
• Coordinating with Senior management on project timelines and resource requirement;
• Design the job schedule and get it implemented using Autosys; Guide release management team to ensure seamless code migration and version control (using SVN) of the developed code;
• ETL Design and fine tuning the ETL code for performance gain ; Fine tuning the PL/SQL code for performance; Design the Autosys jobs and schedule the data load strategy;
• Verify the test plan and test results prepared by testing team; Data Modeling using Erwin; Analyze defects raised by users and fix them
• Leverage technical, business and financial acumen to communicate effectively with client executives and their respective teams.
• Work with 3rd party vendors such as Informatica, oracle and Actimize to sort out any tool level issues

Confidential

Sr. ETL Developer

Responsibilities:

• Work with BAs/users to finalize the requirements.; Create High level & low level design for the ETL process ; Do the data profiling and analysis on source data ;
• Evaluate the quality of data and workout strategies to handle Late arriving dimensions and conforming values ; Chalk out extensive error handling and reporting strategy and launch informatica and DB jobs.;
• Design and implement complex ETL mappings to full fill business requirements.; Creating shell scripts to preprocess the source provided data files. ;
• Fine tuning the PL/SQL code for performance ;Fine tune the ETL code for performance gain ; Work with release management team to ensure seamless code migration and version control of the developed code ;
• Coordinate with offshore team to get the code developed and meet project milestones. ;Work with 3rd party vendors such as Informatica and oracle to meet tool level challenges ;
• Design & Implement the Control-M and schedule the data load strategy.; Verify the test plan and test results prepared by testing team, coordinate with users to get UAT signoff on deliverables ;Analyze defects raised by users and fix them

Environment: Informatica Power center 8.1.1, Informatica Data Quality. UNIX shell scripting, UNIX AIX 64-bit, Sun Solaris 32-bit, Oracle 10g, Control-M