We provide IT Staff Augmentation Services!

Application Architect And Lead Resume

Bridgewater, NJ

SUMMARY:

  • 16+ years of experience in complete Software Development Life Cycle (SDLC).
  • Extensive experience in Data Warehousing, ETL, Data Modeling, and Physical and Logical Database designing for Insurance, Pharmaceutical and Financial Industries.
  • Experience in Data warehousing ETL using Informatica Power Center 9.1/7.1.2/6.2/5.1, Informatica Power Mart 6.2/5.1, Informatica Data Quality 8.5, DB2 - AIX64 9.5.2, Oracle 9.x/8i/8.0/7.x, MS SQL Server 2008 R2, OLTP, OLAP, Data Reports and Erwin.
  • Expert database development skills using DB2, Oracle PL/SQL to write stored procedures, stored functions, packages and triggers.
  • ETL experience. With Design, Development of Complex Mappings with multiple data sources.
  • Experience in managing large teams and working with distributed team members (Onsite and Offshore). Managed a team members various MNC companies like (IBM, TCS, NTT, HCL & Cognizant).
  • Experience in Informatica implementation and administration.
  • Implemented performance tuning with the Transformations, Sessions and on the Source Databases.
  • Upgraded Informatica 5.1/6.2 to Informatica 7.1.3 companywide and completed project ahead of schedule.
  • Provide 24x7 operational supports to all production practices.
  • Managed troubleshooting, data cleansing and data integrity and extensively worked on bug fixes and enhancements.
  • Wrote UNIX scripts for automating data transfer and batch scheduling.
  • Worked with global resources to control design and lead development activities.
  • Managed troubleshooting and querying existing data to identify problems and come up with solutions for data integrity problems.
  • Worked closely with Client Analytics and Marketing users to understand informational needs and business challenges.
  • Ability to manage multiple, competing priorities simultaneously.
  • Knowledge of Monitoring and alerting of production and corporate servers/storage using AWS Cloud watch.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.6/9.1/8.5/7.1.3/6.2/5.1, Informatica Data Quality 9.6/8.5, Power mart 6.2/5.1/4.7, ETL, Data mart, OLAP, OLTP.

RDBMS: Oracle 9.i/8.x/7.x, DB2-AIX 64 9.5.2/8.0, Teradata 7.0/8.1, SQL Server 2008 R2/2008/2005, MS Access 2010, Sybase 3.0/4.9

Utilities: TOAD 7.3/7.2, SQL Navigator 3.1/4.5, MS Visio, MSOffice, Erwin4.0, Rapid SQL 7.3.3, DBArtisian 8.1.5, Microsoft SQL Server Management Studio.

Reporting Tools: Business Objects 5.0/4.1, Crystal Report 8.5, Cognos 7.3/8.1, Report Net.

Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl, C, C++, Visual Basic 5.0, Java, HTML.

Operating Systems: Sun Solaris 2.6/2.7, HP-UX and IBM AIX 4.2/4.3, Win 3.x/95/98/NT 4.0, SCO UNIX, Red Hat Linux.

Modeling Technologies: Unified Modeling Language (UML), ER diagrams, Data Modeling.

PROFESSIONAL EXPERIENCE:

Confidential

Application Architect and Lead

Environment: Informatica Power Center 9.6.1, DB2 10.1, SQL Server 2008, UNIX AIX 5.3, Toad 3.2, Windows 7 Enterprise, Autosys PA8, Oracle SQL developer 2.1, Windows Server Enterprise, JIRA Portal tracking systems, CVS.

Responsibilities:

  • Worked in Maintained, enhancements and bug fixes with Capital Batch, Credit Batch and Trades Reference data Batch.
  • Design Informatica Interfaces, Primarily responsible for ETL design, coding and testing strategy.
  • Created deployment documents, artifacts, and Run book.
  • Perform detailed documentation of design, development, testing and deployment activities necessary to ensure team knowledge sharing
  • Wrote Production deployment documents, Informatica deployment documents and mapping documents.
  • Scheduling the Batch jobs on Autosys PRODUCTION and TEST Servers Using Unix Perl scripting and JIL (JOB INFORMATION LANGUAGE)
  • Performing the tasks on the Batch jobs like FORCE START, ON HOLD, OFF HOLD, OFF ICE, CHANGE STATUS, KILL, TERMINATE etc.
  • Interacting with Production Support team, how to schedule new jobs enhanced the production jobs for better performance of the batch.
  • Providing support, guidance in the deployment of the solution in various environments such as integration, QA, and production.
  • Testing the Batch jobs on the TEST server and deploying them in PRODUCTION Server.
  • Finding the root cause of the issues in concern and following the documented procedure to resolve the issues by contacting the right group of people.
  • Inserting, updating and deleting the job from autosys database using JIL, Autosys GUI was used for monitoring the autosys batch jobs.
  • Interact with and guide with Informatica Developers with data transformations and data mappings.
  • Conduct impact assessment and determine size of effort based on requirements.
  • Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture.

Confidential

Senior Informatica consultant

Environment: Informatica Power Center 9.6.1, DB2 10.1, Oracle 11g, SQL Server 2008, UNIX AIX 5.3, Toad 3.2, Windows 7 Enterprise, Tidal Scheduler 5.3.1, Oracle SQL developer 2.1, Windows Server Enterprise, Windows 7 Enterprise.

Responsibilities:

  • Worked in implementing different projects, Liquidity Risk Management project (LRMS), Regulatory reporting project, OFSAA feeds and Treasure Data Mart.
  • Analyzing the data for defects and fixing the defects.
  • Understand system flow and process flow to fix the production issues.
  • Participated in troubleshooting and facilitated transition to system test, UAT and production phases.
  • Created and Schedules jobs in Tidal.
  • Provided production support after rolling application out and provided complete production support.
  • Involved high level architecture and design of database components.
  • Design and build new database components (stored routines, triggers) to meet the requirements.
  • Interact with business analysts to understand the business requirements.
  • Developed Informatica mappings and re-usable transformations.
  • Created Migration Documentation and Process Flow for mappings and sessions.
  • Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
  • Worked on Informatica Partitioning when dealing with huge volumes of data.

Confidential, Bridgewater NJ

Project lead

Environment: Informatica Power Center 9.5.1, IDQ 9.5, MDM Hub, Oracle 11g, Sybase 12.5.3, UNIX AIX 5.3, Oracle SQL developer 2.1, Toad, Windows Server Enterprise, Windows 7 Enterprise.

Responsibilities:

  • Designed and Developed Technical Billing Data Mart for reports.
  • Lead and guide development of an Informatica based ETL architecture. Lead offshore development team.
  • Designed Product data model, developed process to bring the data in EDW for Data Mart Reports and Executive Dash Board Reports.
  • Worked as Informatica Administration. Created users, folders, folder migration, taking Repository backup.
  • Interact with and guide Informatica developers with data transformations and data mappings.
  • Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times.
  • Involved in implementing the customer/product Data Set into Informatica MDM from various source systems.
  • Configured match rule set property by enabling search by rules in MDM according to Business Rules.
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM
  • Design and review high level architecture and design of database components.
  • Analyze Business Requirements from BRD, created conceptual, logical and physical database design and created Technical Design Documents.
  • Installed Informatica clients and servers, setup connectivity’s, set up process including parameter files.
  • Providing support, guidance in the deployment of the solution in various environments such as integration, QA, and production.
  • Interact with and guide with Informatica Developers with data transformations and data mappings.

Confidential, Newark NJ

Lead ETL and Architect

Environment: Informatica Power Center 9.1, DB2-AIX64 9.5.2, UNIX AIX 5.3, DBArtisian 8.1.5, Sybase 11, Oracle 11g, Toad, Windows 2008.

Responsibilities:

  • Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations, Union Transformations etc.
  • Analyze Business Requirements from BRD, created conceptual, logical and physical database design and created Technical Design Documents.
  • Leaded maintenance and development offshore teams. Managed a team of 10members.
  • Directed the ETL design and development efforts of two senior developers and two junior developers and provided mentoring to prepare them for taking on more responsibility at the end of the project.
  • Create High level and low level detailed technical Design documents from BRDs
  • Ran scripts through UNIX shell programs for batch scheduling.
  • Developed and enhanced UNIX, SQL scripts for metadata management.
  • Created PL/SQL stored procedures for various needs of the transformations while loading the data.
  • Did Complete Production support, flexible with work schedules depending upon production issue.
  • Analyzing the data for defects and fixing the defects.
  • Used Informatica Data Quality for data validation. Oversaw troubleshooting, data cleansing and data integrity.
  • Used SQL scripts to extract data and load into DB2 database. Extensively worked in DB2 stored procedures.
  • Maintained multiple databases and customized reports based on user requirement.
  • Helped in developing best practices for the GI data warehouse.
  • Participated in troubleshooting and facilitated transition to system test, UAT and production phases.
  • Planned, organized and supervised team activities.
  • Participated in most of the user sessions regarding the requirements and design of the system especially about specification of the reports.
  • Designed and developed preprocessors for the incoming data from various sources.
  • Provided DBA and database support to the team through production rollout.

Confidential

Senior ETL Developer

Environment: Informatica Power Center 7.1.2, Oracle 9.1.2, SQL Server 2008, SQL Navigator 4.5, UNIX, DB2, ERWIN, Microsoft SQL server Management Studio.

Responsibilities:

  • Data Sources dealt with: FACTS (Field Activity & Tracking System), Proscape (vendor software to track presentations), and My Call Asset Management System.
  • Using Informatica Designer, Extract & Transform the data from various source systems by incorporating various business rules for different applications by using the different objects and functions which the tool supports.
  • Designed the weekly and daily batches with complex dependencies and scheduled them.
  • Extracting, staging and loading into the Stage and Core ODS tables, Field Sales Call information from Facts DB2 databases.
  • Designed Mapplets using Mapplet Designer and used those Mapplets for reusable business logic.
  • Wrote pre-session and post-session shell scripts to truncate and analyze tables
  • Extracting, staging and loading into the stage and Core ODS tables, My Call Asset Management Presentation and Screen reference data.
  • Created various Documents such as source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
  • Involved in different Team review meetings.
  • Developed joiner transformation for extracting data from multiple sources.
  • Created transformation like Lookup, Filters, Expressions, Joiners, Update Strategy and Stored Procedures etc to implement business logic and check constraint integrity.
  • Wrote pre-session shell scripts to truncate tables. Post-session shell scripts to Analyze tables and failure/success after completion of workflows.
  • Atomized workflows schedule using PMCMD and Unix Shell Scripts.

Confidential, Reston VA

ETL Administrator and Developer

Environment: Informatica Power Center 5.1/6.1.2/7.1.3, Oracle 8i/9i, Cognos 7.1.3, Report Net, UNIX

Responsibilities:

  • Helped in developing best practices for the enterprise wide data warehouse.
  • Tested all the business application rules with test & live data and automated, monitored the jobs using Informatica.
  • Upgrade Informatica 5.1/6.2 to Informatica 7.1.3.
  • Created project plan for Development, QA and Production Power Center upgrade.
  • Worked as Informatica Administrator throughout the project.
  • Implemented slowly changing dimensions methodology to keep track of historical data.
  • Developed Informatica mappings, re-usable transformations using aggregate, expression, lookup, update strategy, router, and rank transformation.
  • Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
  • Creating user, folders, folder migration, taking Repository backup in Informatica.
  • Facilitate end-user procedures development.
  • Developed ETL scripts to extract and cleanse data from SQL databases for loading into Cognos
  • Administered backups, tuning, configuration, and performance.
  • Wrote several queries against Informatica repository to create portable processes and batches and to create reports on the metadata.
  • Created Catalogs, Folders, User Classes and reports using Cognos Impromptu and Report.
  • Created standard filters, calculation prompts, and conditions.
  • Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, and metrics and project coordination.
  • Involved in the development of Data Mart and populating the data marts using Informatica.
  • Check and Tune the performance of application for giving the optimum system performance of the System.
  • Created and Scheduled Sessions and Batch Processes based on demand, run on time, run only once using Informatica Workflow Manager.

Confidential, MI

ETL Consultant

Environment: Informatica Power Center5.1, Oracle 8i, SQL Server 2000, MS access 2000, DB2, Erwin 4.0, Toad, Unix, Business Objects 5.0., Teradata 7.0, Rapid SQL 7.3.3

Responsibilities:

  • Involved in the design of the Star Schema and created Logical and Physical Data Models using Erwin 4.0 Involved in creation of Data Warehouse database (Physical Model, Logical Model) using ERWIN data modeling tool.
  • Using Informatica Repository Manager, maintained all the repositories of various applications, Created users, user groups, security access control,
  • Using Informatica Designer, Extract & Transform the data from various source systems by incorporating various business rules for different applications by using the different objects and functions which the tool supports
  • Tested all the business application rules with test & live data and automated, monitored the jobs using Informatica Server Manager.
  • Created various Documents such as Source-To-Target Data mapping Document, Backroom Services Document, Unit Test Cases and Data Migration Document.
  • Wrote pre-session shell scripts to check session enable/ disable before running/scheduling batches.
  • Wrote post-session shell scripts to check status of session like failure/success after completion of all batches.
  • Worked in Teradata utilities like Fast Load, Multi Load, Tpump, Fast Expert and Query man.
  • Involved in PL/SQL coding that includes Stored Procedures, Packages and Cursors.
  • Participated in design of infrastructure to support corporate wide Data Warehouse that includes several Sources and several Data Marts and a central database.
  • Extensively used ETL to load data from source systems like Flat Files, DB2, Excel Files, XML and CSV Files into staging tables and load the data into the target database MS SQL Server 2000.
  • Involved in designing and developing the Universes using BO designer and created many reports as per the client requirements.
  • Participated user meetings regarding the design of reports in the data mart.

Hire Now