We provide IT Staff Augmentation Services!

Technology Architect Resume

SUMMARY:

  • 11.5+ years of extensive IT experience in the field of Data Governance & Management, Business Intelligence & Data Warehousing technologies.
  • Currently working in the capacity of Technology Architect and specializes in end to end Data Archival architectural/design solutions including application retirement and data archival using Informatica ILM Data Archive tool, Informatica DVO, Informatica PowerExchange and various accelerators.
  • Proficient in creating industry standard architecture and design patterns for building technology solutions that are customized for client specific needs.
  • Primarily focused on Business Value adds by analyzing the day to day challenges and providing robust solutions for the same.
  • 10 years of rich experience in Banking and Financial domain
  • In his carrier, has played key roles in Team leading, Data analyst, Solution architect, Designer, Developer, and Quality analyst for the simple to complex ETL data transformation projects.
  • Proficient in creating ETL (Extraction, Transformation and Load) designs that are robust, scalable and cater to various technical & functional requirements related to data integrity, data quality, audit & controls, data standardization, data archiving, and data governance.
  • Experience in improving the productivity of the medium to complex data projects using reusable component, identifying solution framework for simple to complex data requirements, code review checklist, performance tuning of ETL jobs and databases when handling huge volume of data.
  • Has worked extensively on Waterfall and Agile models and have in depth knowledge of various Project Management tools such as Project Budgeting, Allocation, Billing Invoices, Order Management, Integrated Project Management, Ciara, etc.
  • Implemented excellent Software quality standards and practices and maintained the project at CMM Level 5
  • Developed reusable components for data extract and fast load into Teradata. Developed mapplet, medium to complex reusable transformations and sessions with partitioning in Informatica PowerCenter.
  • Designed and implemented an automated testing tool (Data Reconciliation) framework in the data migration projects
  • Contributed towards estimations, planning, solution proposal and other presales activities and won many key proposals for the business growth.
  • Experience in working with multiple vendors in client locations and geographically distributed teams, and in managing changing expectations.
  • Dynamic, self - motivator, fast learner and a good team player with good work ethics.
  • Possess excellent communication and interpersonal skills
  • Highly passionate about working with end users to automate their business data analytics.

KEY DOMAIN AND TECHNICAL KNOWLEDGE:

Domain: Banking and Financial domain

Technical: Informatica Information Lifecycle Management (ILM Data Archive6.x), Informatica PowerCenter7.1/8.1/9.1,Informatica Power Exchange, Informatica DVO, Informatica Data Discovery, Informatica Master Data Management (MDM), Oracle Warehouse Builder 9i / 10g (10.1) and good hands-on in Oracle 9i / 10g, MS SQL Server, Teradata databases. Also, very good knowledge in BI reporting tools - Siebel Business Analytics 7.8.2, Oracle Discoverer 4.1/10g, Cognos Power Play Transformer 7, MicroStrategy 7.5.3

PROFESSIONAL EXPERIENCE:

Confidential

Technology Architect

Responsibilities:

  • For structured source data sets, Proposed to build a ILM Solutions that consists of a set of components and processes that seamlessly integrate and enable archival/retirement of Legacy applications
  • As a single point of contact at offshore, responsible for preparing knowledge base, extrapolation of ingestion time, end to end solution design, build review and quality management
  • Analyze metadata version changes over past 11 years and the in-scope MTI data objects and its volume(Terabytes of historical data) in order to classify them under various logical “Entity” and group the entities under various iterations for subsequent design and development.
  • Develop technical architecture and design solution, prioritize and resolve design issues with team and assess customization needs
  • Developed Application module and mined the metadata from structured source data sets using EDM and tested the application retirement through PoC (Proof of Concept) for various complex data sources.
  • Design of ideal archival folder, entity design and scheduling and automation approach for implementing parallelism
  • Determine historical data extract rate and ingestion rate with the provided infrastructure and recommend the performance improvement factors in the design.
  • Design and create Retirement jobs using Informatica ILM workbench - wizard based interface
  • Utilize the tools advanced features - Information Lifecycle Management (Informatica ILM - Data Archive), Confidential ’ Information Platform and Confidential ’ Data Reconciliation for designing complex data archival requirements optimally
  • Discover the reusable components/accelerators and design the solution framework including automation and scheduling.
  • Perform end to end application retirement design review and conduct design review sessions with business partners and impacted teams
  • Participates in meetings / discussion / interviews with business and technology stakeholders to understand, demonstrate and review the functional and non-functional MTI data retention requirements for the complex engagement
  • Preparation of Technical Design documents, review and obtain sign-off from stakeholders.
  • Set the relevant Degree of Parallelism attribute in the extract layer and archival layer of Application Retirement jobs
  • Preparation of Source Code Structure and Code Review Checklist and Define Coding Standards
  • Oversee build activity and aid in resolution of build issues in project
  • Maintaining high quality standards in the client deliverables as per the defined organization norms.
  • Effort estimation and staffing plan as per the SMC estimation tool
  • Defining project related tasks & their allocation to the team members
  • Document data archival project key design challenges, decisions, dependencies, risks, issues.
  • Aid user acceptance testing with business and obtain necessary approvals for phase completion and Prepare test exit criteria for implementation

Confidential

Technology Architect

Responsibilities:

  • Provided accurate and realistic estimation to the clients using customized Confidential ’ SMC estimation tool kit
  • As a single point of contact at onsite, was responsible for coordination of daily project activities between the client and the offshore team.
  • Maintained high quality standards in the client deliverables as per the defined organization norms.
  • Defined project related tasks & their allocation to the team members.
  • Involved in designing the reconciliation framework ( Confidential Data Reconciliation tool) in the following modules - Preparation phase, Reconciliation phase and Housekeeping
  • Preparation of Technical Design Documents.
  • Managed the test data setup
  • Review the test reports and take necessary troubleshooting steps for data reconciliation.
  • Provided the technical solution to team.
  • Supervise and coordinate technical delivery with offshore and onshore team and is responsible to meet deliverables on time with adherence to schedule and quality mandates.
  • Handled the governance process in a matured way resulted in on-time implementations.

Confidential

Technology Architect

Responsibilities:

  • As a single point of contact at onsite client location, was responsible for coordination of daily project activities between the client and the offshore team.
  • Understand of business processes, to establish, modify or maintain data structures and associated components.
  • Created operational framework for data acquisition and overall management of the "Data Acquisition Service".
  • Evaluates multiple source systems, creation of viable specifications and acceptance criteria in preparation for the construction of information and systems.
  • Specification, design and maintenance of mechanisms for storage and access to both structured and unstructured information, in support of business information needs.
  • Test data preparation by sanitizing the production data using Informatica Data Masking transformation
  • Innovating ideas & potential solutions, demonstrating, installing and commissioning selected products.
  • Built reusable tools for extracting and loading data where standard tools were not available for data profiling in production sandpit area.
  • Supervise and coordinate technical delivery with offshore team and is responsible to meet deliverables on time with adherence to schedule and quality mandates.
  • Defined project related tasks & their allocation to the team members.
  • Preparation of Technical Design Documents.
  • Provided the technical solution to team.
  • Customized SMC based estimation tool kit for this requirement
  • Provided accurate and realistic estimation to the clients using SMC estimation tool kit
  • Involved every month invoices preparation, Billing and Cost were determined using project budgeting system ( Confidential PBS) proprietary tool efficiently.
  • Handling the governance process in a matured way resulted in on-time implementations.

Confidential

Software Engineer

Responsibilities:

  • Lead a team of 15 developers, task allocation to team members, preparing status reports, maintaining issue tracker, SMC effort estimation and helping the team to solve technical issues.
  • Co-ordination with the client to gather all the business and technical related Information for Project.
  • Analyzed the requirements based on the high level design provided by the client.
  • Involved in detailed level design, Informatica components development.
  • Developed mappings, sessions & workflows through Informatica Power center and shell scripts.
  • Deployment and Promotion of the code to QA and UAT environments.
  • Proposed the solution approach for better design and ETL data load performance Improvement
  • Checklist based code review tool were developed for efficient code review and quality deliverables
  • Independent unit testing and Integration testing
  • Maintained high quality standards in the client deliverables as per the defined organization norms.
  • Deployment of the code to QA and UAT environments.
  • Support and maintain the Production environments
  • Involved in deliverables review, Quality Assurance, performance and productivity improvement.

Confidential

Associate Consultant

Responsibilities:

  • Configured the OWB tool and its components in the AIX server and Windows Client systems at onshore location.
  • Analyzed the Basel requirements and designed the ETL solution for building the warehouse with Datamart available for generating the reports.
  • Developed the ETL mappings with the efficient method of handling the erroneous data, data quality check, data cleansing, data transformation and loading strategy.
  • Participated in project review meetings and Adhere to the client or project specific quality and documentation standards (Project Scope document, Requirement document, Mapping design document, Error handling document, Change Request document, Impact analysis document, Code deployment document, Unit Testing plan document, Issue log document and ETL operations guide) as part of project execution.
  • Configured the operators and mappings to improve the ETL load performance and optimize the mapping code.
  • Deployment and Promotion of the code to QA and UAT environments for user’s sign-off.

Confidential

Associate Consultant

Responsibilities:

  • Performed the detailed OLTP(source) system study and carry out a suitable dimensional data model for Data Mart
  • Prepared and maintained a consistent Logical and Physical Data Model document, mapping design document, Impact Analysis document, Test Scenarios document, Code Deployment document and Project status tracking document.
  • Designed the ETL mapping and configure the operators and mappings to improve the ETL load performance and optimize the mapping code.
  • Designed a set of reports using Siebel Analytics tool for various departments and business clients to help them analyze their work based on the Metrics of the reports.
  • Prepared the functional scenarios and SQL scripts to test the ETL logic, report data validation, Cosmetic validation and threshold validation.

Confidential

Software Engineer

Responsibilities:

  • Understanding the existing source system with functionality and gathering Business requirements.
  • Mapping their requirements to evolve a consistent Logical Data Model and Physical Data Model.
  • Data Quality Assurance during the ETL process.
  • Development of MicroStrategy project by reflecting the data mart.
  • Design of the reports, including the various metrics, attributes, hierarchy, etc., and enabling the users to analyze their wealth of information using MicroStrategy tool with all possible drill options.
  • Providing technical specifications and details to the client.

Confidential

Junior Programmer

Responsibilities:

  • Gathered requirements and System Study.
  • Played a key role as Software Analyst, Designer and Programmer.
  • Prepared System Requirement Specification.
  • Designed and developed the middle tier, front end screens and business logic layer.
  • Built and Generated reports using Crystal Reports
  • Responsible for manual testing, bug fixing and warranty support

Hire Now