SUMMARY

• More than 10 years of IT experience in software analysis, design, and development.
• Over 6 years of experience in database and data warehouse application development including ETL data integration and report design and generation.
• Industry experience and business expertise in publishing, public services, transportation, e - commerce, healthcare insurance, consumer products, and IT consulting services.
• Sound knowledge and hands-on expertise in ER Modeling and Dimensional Modeling (Logical and Physical), Multidimensional Modeling, Data Warehouse Architecture, and Star & Snowflake Schema designs.
• Superior analytical and ETL design skills and solid experience in creating Mappings with various Transformations and implementing Slowly Changing Dimensions (SCD) as well as solving complex ETL problems using INFORMATICA Power Center and Oracle tools.
• Proficient in SQL PL/SQL programming including stored procedures & functions & triggers.
• Experienced in gathering and analyzing requirements and acting as a liaison between business users and IT teams to map the business & functional requirements to solve business challenges through technology solutions.
• Experienced with software Iterative and Evolutionary Development methodology - Agile, RUP and Waterfall (SDLC).
• Proficient with MS Office especially with Excel / Word / PowerPoint / Visio.
• Strong analytical, attention to detail, problem solving and decision-making skills. Highly motivated and self-starter.
• A Strong team player with effective verbal and written communication skills as well as interpersonal and presentation skills.
• Oracle Certified Database Administrator.
• Sun Certified Java Programmer.
• Master of Science in Computer Information Systems.

TECHNICAL SKILLS

Software & Tools: SQL Plus, SQL*Loader, ERWIN, TOAD, MS Visio, Oracle SQL Developer, Oracle SQL Loader, PL/SQL Developer, INOFRMATICA Power Center Designer / Workflow Manager/ Workflow Monitor/ Repository Manager, COGNOS Framework Manager/ Query/Report Studio, ODBC, Crystal Report, Oracle Developer Suite (Oracle Designer, Form Builder, Report Builder, SQL*PLUS, JDEVELOPER), MS SQL Server Visual Studio (BIDS) for SSIS/SSAS/SSRS, MS SQL Server Management Studio, Eclipse, PVCS, CVS, AUTOSYS, FTP, Tortoise Subversion(SVN)/CVS, MKS Integrity, Lotus Notes, Stat, Putty, Lotus Notes, Test Director, JDeveloperStudio10g, IBM Rational Application Developer7, Crystal Report, WINSCP, WINCVS, Cygwin, Microsoft Office Suite

Languages: SQL, PL/SQL, T-SQL, JAVA EE, Visual Basic, ASP.net, C, C++, HTML, XML, Web Services (SOAP, REST), WSDL, Java Script, UML, UNIX Shell scripting

Platforms: Oracle, SQL Server, DB2 UDB, Apache Tomcat, Oracle Application Server, WebLogic, MS IIS, WebSphere, Oracle Internet Directory, LDAP/Active Directory, UNIX, LINUX, Windows XP/7

PROFESSIONAL EXPERIENCE

INFORMATICA ETL Developer

Confidential

Responsibilities:

• Actively interacted with end users to gather business requirements and developed technical solutions.
• Participated in the high level and detailed design & development activities of Logical and Physical Data Models including indexes, table partitions, table constraints, views, and relationships, etc.
• Designed and developed diverse transformations, mappings, sessions, and workflows; used parameter files and variables to define mapping variables, workflow variables and relational connections, used shared folders and shortcuts to reuse metadata; and integrated data from multiple sources into targets.
• Implemented business rules and designed and developed database objects like procedures & functions & triggers.
• Managed data quality issues and performed data cleansing.
• Used debugger tool, log files, error tables, and Workflow Monitor to troubleshooting problems and took corrective actions.
• Designed and developed automated processes to control data movement.
• Contributed to database and application tuning to optimize performance.
• Maintained, debugged, and modified existing ETL PL/SQL scripts.
• Migrated and integrated code to production environment.
• Created and updated all necessary documentation for the Project.
• Supported production enhancements and implementation.

Environment: Informatica9.5/9.1, ERWin7, TOAD9.0, SQL Server12/08, Oracle11g, PVCS, UNIX

INFORMATICA ETL Developer

Confidential

Responsibilities:

• Effectively communicated with business analysts to analyzing and profiling data.
• Coordinated with the data architect team to design and develop data models for the data warehouse BI applications.
• Developed SQL*Loader scripts to load flat files into staging database tables.
• Performed data integration from heterogeneous sources (including flat files and RDBMS tables) into Data Warehouse and Data Marts, and implemented Slowly Changing Dimensions (SCD type 1&2 &3) using INFORMATICA Power Center.
• Used various transformations like Joiner, Expression, Router, Update Strategy, Filter, Connected / Unconnected Lookup, Aggregator, Sequence, etc. in the Mapping Designer.
• Used reusable transformation objects like MAPPLETS to avoid duplication of metadata and reduce development time.
• Created fact and dimension tables based on the technical specification. Created new and modified existing database objects like views, materialized views, and procedures and functions.
• Conducted tests to make sure all issues resolved.
• Updated technical documents as needed.

Environment: Informatica9.1/8.6, ERWIN, TOAD, PL/SQL Developer, Oracle11g, SQL Server08, AUTOSYS, PVCS, UNIX

INFORMATICA ETL Developer

Confidential

Responsibilities:

• Conducted interview with business analysts and business users to identify business requirements.
• Participated in building of the Data Warehouse and Data Marts using Star/Snowflake Schema designs.
• Performed Extract, Transform, and Load (ETL) to move data from various sources into target tables using INFORMATICA POWER CENTER.
• Conducted troubleshooting and performance tuning at source, transformations, and targets.
• Used the INFORMATICA command line utilities like PMCMD to execute workflows scripts.
• Used UNIX CRON utility to schedule and automate ETL jobs.
• Provided production support for any production issues that may arise.
• Designed, developed, tested, and maintained BI solutions including various reports with drill-through / drill-up /drill-down capability and master-detail relationship using COGNOS Report Studio, and contributed to plans and schedules for BI solution deliverables.

Environment: Informatica9.x/8.x, CognosSuite10/8, TOAD, Oracle10g, SQL Server08/05, UNIX

JAVA Developer

Confidential, Boston, MA

Responsibilities:

• Interacted with business users to identify business requirements.
• Designed and developed reports using Crystal Report.
• Provided database data security analysis to assisting managers in strategic decision making.
• Verified business logic, designed and developed Java application and implemented various change requests.
• Demonstrated abilities for changing demands and priorities.

Environment: Oracle10g, TOAD9, Crystal Report11, TortoiseSVN1.5, Websphere7, IBM Rational Application Developer7, stat5.4

JAVA Developer

Confidential, Lanham, MD

Responsibilities:

• Analyzed business requirements and translated requirements into high level functional model.
• Designed and developed PL/SQL packages to improve operation efficiency.
• Participated in the design and development of a multi-tiered J2EE web application.
• Reactively and proactively worked with the business and IT teams to resolve various issues.
• Participated in the design and development of test plans, test cases, and UAT tests.

Environment: Oracle10g, Oracle Application Server, TOAD9, PL/SQL Developer, Oracle Developer Suite, JDeveloperStudio10g

JAVA Developer

Confidential, Fairfax, VA

Responsibilities:

• Developed front & back end components for a multi-lingual J2EE web application.
• Developed and deployed shell scripts and tested module components.
• Diagnosed problems, fixed bugs, and resolved issues to already existing application.
• Conducted application performance tests and completed test reports.

Environment: DB2 UDB, Solaris8, WebLogic8.1, IPlanet6.0, Eclipse3.0, Putty, MS Visio, CVS, PVCS, BMC Patrol

JAVA Developer

Confidential, Fairfax, VA

Responsibilities:

• Gathered and identified business requirements.
• Developed and tested an online sales J2EE application.
• Participated in the development and tests of an ASP.NET application.

Environment: Oracle8i, Solaris8, WebLogic6.1, Eclipse2.1, WINSCP, WINCVS, CVS, Putty, MS Visio, Cygwin, MS IIS