Solution Architect Resume
Eden Prairie, MN
SUMMARY
- Having 15+ years of experience in IT industry focused on Data warehouse Architecture, Analysis, Design, Development and Big data technologies
- Experience with solution architecture and solution experience across multiple architecture domain, such as business, data, integration and application
- ETL Architect with multiple successful DW Design and Implementations. Strong track record of Planning, Architecting and Implementing custom and packaged
- Data warehouse & Business Intelligence solutions with high performance and extensibility
- Have good understanding and knowledge in Healthcare domain, Retail and Insurance domains.
- Strong Knowledge on Software Development Life Cycle (SDLC) with architecture, design, planning, estimation, modeling, development, testing, implementation.
- Experience in Database Design, Dimension Modeling, and Star & Snowflake schema
- Hands on experience in dimensional modeling like conceptual data model, logical data model, and physical data model using Erwin
- Hands - on experience in enterprise data architecture strategy, methodology and standards that delivers enterprise data model, associated Meta model, common business vocabulary and taxonomies
- Provide technical insight and assistance to the data modeler in building new design adhering to existing Data warehouse architecture and review the data model and suggest improvement ideas
- Interact with the business and various source systems technical architects to understand the requirements
- Hands on experience in the requirement mapping and gap analysis
- Experience in utilizing the best practices of Informatica Data Quality (IDQ) by streamlining the Cleanse process in the discovery, documentation and resolution of data quality issues
- Provide guidance in developing components to comply data compliance and data governance
- Worked intensively on understanding the data pattern and structure of the data, there by identifying the strength and weakness of the data
- Worked in MDM, IMS to collect, standardize, harmonize and share master data to provide more accurate, complete, and consistent data across the enterprise MDM (Master data management)
- Extensively worked Teradata utilities BTEQS, MLOAD, FAST EXPORT, FAST LOAD
- Worked extensively in Informatica Power center, Datastage and MDM Solutions, PL SQL and UNIX and well versed with RDBMS like Teradata, Oracle, and DB2 and OS concepts
- Ability to develop a technical work plan and assign work and coordinate across multiple developers and projects
TECHNICAL SKILLS
ETL Tools: Informatica Power Center 9.5.1/9/8.6.1/8.5/8.1/7. x (Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager) and IBM MS InfoSphere DataStage and QualityStage 11.3.1 FP1, IBM MDM
Data Modeling: E-R Modeling, Dimensional Data Modeling, Snow Flake Modeling, Fact and Dimensions Tables, physical and Logical Data Modeling, Erwin 7.3, Microsoft Visio2007
Databases: Oracle 11g, 10g/8i/9i, IBM DB2, MS Access 2000/1997, Teradata 13.1
Languages: C, C++, Java/J2EE, JSP, JDBC, JavaScript, Servlets, SQL, SQL*Plus, PL/SQL.
Tools: & Utilities: Toad, Maestro Job Scheduling Console 8.4, Autosys, Serena Dimension
Operating Systems: Windows 2003 server, Windows 95/98/NT 4.0/2000, XP, MS DOS, Sun Solaris 5.1,UNIX AIX 6.1.
Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word)
OLAP: Cognos Impromptu
GUI: Developer 2000 (FORMS 4.5, 6i, Reports 6i)
Certifications: Informatica 8.6.1 Administrator, INS 101, INS 102, MS 101, Step Plus, Lean
PROFESSIONAL EXPERIENCE
Confidential, New York, NY
Data Warehouse/ETL Lead/Architect
Responsibilities:
- Lead ETL architecture and design as well as data flow diagramming
- Define, build and implement ETL development standards & procedures
- Ensure ETL quality through code reviews and throughout inspection & knowledge sharing
- Responsible for Architecting and Implementing ETL framework design
- Architect end to end solutions from Application and infrastructure point of view
- Worked closely with business engagement lead and business users to understand the business needs and developing technology solutions;
- Collaborate with key business and technical stake holders in defining the ETL architecture, strategic roadmaps and business technical solutions and align with Enterprise architecture goals.
- Evaluate business requirements, understanding of business process flow and business requirements and translated it into a technology solution leveraging ETL and analytic tools
- Define the conceptual, logical and implementation architecture for the project
- Solutions Option for offloading legacy system to Big data platform
- Review technical team deliverables for data governance, compliance with architecture standards and guidelines
Environment: Informatica 9.6.1/10.1.1, UNIX Sun Solaris 10.1, Oracle 11.5, Autosys.
Confidential, Eden Prairie, MN
Solution Architect
Responsibilities:
- Lead ETL architecture and design as well as data flow diagramming
- Define, build and implement ETL development standards & procedures
- Ensure ETL quality through code reviews and throughout inspection & knowledge sharing
- Responsible for Architecting and Implementing ETL framework design
- Architect end to end solutions from Application and infrastructure point of view
- Worked closely with business engagement lead and business users to understand the business needs and developing technology solutions;
- Collaborate with key business and technical stake holders in defining the ETL architecture, strategic roadmaps and business technical solutions and align with Enterprise architecture goals.
- Evaluate business requirements, understanding of business process flow and business requirements and translated it into a technology solution leveraging ETL and analytic tools
- Define the conceptual, logical and implementation architecture for the project
- Solutions Option for offloading legacy system to Big data platform
- Review technical team deliverables for data governance, compliance with architecture standards and guidelines
Environment: Informatica 9.5.1, Unix AIX 6.1, Teradata 13.10, TWS Maestro scheduling tool.
Confidential
Responsibilities:
- Provide architectural solutions and services for data acquisition, integration and enrichment Meta data, data quality and data security
- Lead ETL architecture and design as well as data flow diagramming
- Define, build and implement ETL development standards & procedures
- Ensure ETL quality through code reviews and throughout inspection & knowledge sharing
- Worked closely with business engagement lead and business users to understand the business needs and developing technology solutions;
- Collaborate with key business and technical stake holders in defining the architecture, strategic roadmaps and business technical solutions and align with Enterprise architecture goals.
- Evaluate business requirements, understanding of business process flow and business requirements and translated it into a technology solution leveraging ETL strategy
- Define the conceptual, logical and implementation architecture for the project
- Solutions Option for offloading legacy system to Big data platform
- Review technical team deliverables for data governance, compliance with architecture standards and guidelines
Environment: Informatica 9.5.1, Unix AIX 6.1, Oracle 11g,Teradata 13.10, TWS Maestro scheduling tool.
Confidential, Richardson, TX
Data Warehouse/ETL Architect
Responsibilities:
- Preparation of Data model which includes conceptual, logical and physical model for specialty and solution design document
- Involved in requirements analysis and design and also source system analysis to derive the business logic, validation of data mappings
- Involved in project discovery, preparation of estimation (BUG/BEG) and Project plan.
- Analyzing the existing legacy data model. Interacted with business functional specialists for Requirement gatherings
- Involved and interacted with Business SME’ Confidential on requirement gathering, understanding the business and functional requirements.
- Hands on impact Analysis and gap analysis for the changes made in source system and providing necessary solution approaches required for changes in target DW environment.
- Involved in the Performance Tuning & and resolving if any issues in transformations and mappings.
- Preparing the technical specification and application architecture design documents.
- Hands on experience in Master data management (MDM) design and solutions approach for specialty prescribers, patients and products.
- Conducting reviews with Business SME’ Confidential for the design and with the clients on the solution approach.
- Involved in performance tuning and error handling and debugging of PL SQL programs.
Environment: Erwin 7.3.11, Informatica 9.5.1, Unix AIX 6.1, Oracle 11g,Teradata 13.10, JSC Maestro scheduling tool.
Confidential
Responsibilities:
- Preparation of Data model which includes conceptual, logical and physical model for Pharmacy Advisor program and solution design document.
- Involved in requirements analysis and design and also source system analysis to derive the business logic, validation of data mappings.
- Involved and interacted with Business SME’ Confidential on requirement gathering, understanding the business and functional requirements.
- Hands on impact Analysis and gap analysis for the changes made in source system and providing necessary solution approaches required for changes in target DW environment.
- Communicate with and/or interview users to plan, develop, improve, and maintain moderately complex components of the logical/physical corporate model.
- Work closely with BSA, business, and IT team members to clarify and refine functional data requirement specifications.
- Master data management (MDM) design and solutions approach for claims, prescribers, patients and products.
- Involved in the data analysis, data quality and data profiling using IDQ.
- Conducting reviews with Business SME’ Confidential for the design and with the clients on the solution approach.
- Involved in the Performance Tuning & and resolving if any issues in transformations and mappings.
Environment: Erwin 7.3.11, Informatica 9.5.1, Unix AIX 6.1, Oracle 11g, Teradata 13.10, JSC Maestro scheduling tool.
Confidential
Responsibilities:
- Preparation of Data model which includes conceptual, logical and physical model for Medical data integration and solution design document.
- Synchronize and leverage data across multiple data sources& perform efficient data matching of any provided list & analyze the data to derive usable and manageable information that helps identify overlays & trends of provided data.
- Hands on experience in Data Extraction, Data Mining, Analysis and make presentation/recommendations based on analysis results.
- Applying logics to sanitize the data and ensure only clean data is maintained.
- Focus on solutions, dive deep into projects, identify and report all key metrics, important identifiers, and drivers in the data.
- Master data management (MDM) design and solutions approach for medical claims, prescribers.
- Involved in the data analysis, data quality and data profiling using IDQ.
- Worked intensively on understanding the data pattern and structure of the data, there by identifying the strength and weakness of the data.
- Created data quality projects, folders and data objects for the Cleansing, scrubbing, standardizing the data by defining the rules for the same.
- Create logical data object, reusable transformation, physical data object.
- Develop mapping using reusable transformation, input and output transformation in the Model repository to validate the rules and export and import as XML in the Power Center.
- Apply various data analytics tools and techniques to identify trends and present the data as required for the business and operations
Environment: Informatica 9.5.1, IDQ, UNIX AIX 6.1 SunOS 5.1, Oracle 11g, Teradata 13.10, Maestro
Confidential
Responsibilities:
- Analyzing the existing legacy data model. Interacted with business functional specialists for Requirement gatherings
- Interaction with Business SME’ Confidential on requirement gathering, understanding the business and functional requirements.
- Preparing the technical specification and design documents.
- Conducting reviews with Business SME’ Confidential for the design, Code, Unit Test Plan and cases.
- Creating Teradata Bteq, MLoad, and Fast Load Scripts for data loads.
- Creating and modifying existing workflows in Informatica for new requirements.
- Involved in the Performance Tuning & and resolving if any issues in transformations and mappings.
- Involved in requirements analysis and design and also source system analysis to derive the business logic, validation of data mappings for enhancement releases.
- Involved in the data analysis, data quality and data profiling using IDQ.
- Involved in the SQL server Data quality services for cleansing, matching and profiling.
- Carrying impact Analysis for the changes made in source system and implementing the required changes in target DW environment
- Designed Informatica mappings, bteq scripts and mload scripts to load data from Oracle systems to Teradata MDM database.
Environment: Informatica 9.5.1, IDQ, DQS, SSIS, UNIX AIX 6.1 SunOS 5.1, Oracle 11g, Teradata 13.10, and Maestro
Confidential - Schaumburg, IL
Technical Lead/ ETL Lead
Responsibilities:
- Detailed analysis of the source system providing accurate and appropriate interpretation of data.
- Involved in requirements analysis and design and also source system analysis to derive the business logic, validation of data mappings for enhancement releases.
- Discussed the Business Intelligence information and appropriate method for collecting and analyzing the data.
- Performed data validation to ensure accuracy and quality of data and initial assessment on the problems with the data structures and other qualitative measure.
- Involved in data profiling and provided the analytics on the data quality and consistency. Prepared Low Design documents for the ETL development.
- Review of ETL design documents and ETL mappings. Review of Test case and Test case results. Identifying the root cause of the production issues and provided the resolution for the same.
- Involved in the production implementation of ETL mappings and Autosys jobs. Created PL SQL Procedures, Functions, Packages and Triggers.
- Worked on creating Ref cursors, explicit cursors, and Global Temporary Table PL SQL collections for accessing complex data.
- Involved in the Informatica administration activities for the release management team.
- Involved in performance tuning and error handling and debugging of PL SQL programs.
- Creating and modifying existing workflows in Informatica for new requirements.
- Carrying impact Analysis for the changes made in source system and implementing the required changes in target DW environment
Environment: Informatica 8.6.1, UNIX, Oracle, Teradata, Netezza, DB2 9.5
Confidential
Technical Lead
Responsibilities:
- Active involvement in requirement gathering, source system analysis, data analysis, preparing mapping document, building conceptual/logical/physical data model for data elements across various subject areas etc.
- Participate in test planning, execution, and production implementation of projects. Preparation of Test Plan, Test Strategy & Test Cases for the mappings developed.
- Coordinating Onsite/Offshore with Release, Configuration & Environment Management members, SME’ Confidential, IT Vendor teams, Testing teams, other teams.
- Receives general input from business team and translates this direction into appropriate operational items to drive the project towards completion
- Involved in the Informatica administration activities for the release management team.
Environment: Informatica 8.6.1, UNIX, DB2 9.5, Autosys.
Confidential
Technical Lead
Responsibilities:
- Client interaction through one to one SME sessions
- Gathering requirements from the client
- Preparing the technical specification and design documents
- Interacting with offshore team for the deliverables
- Involvement in the ETL design and development for the project using PL/SQL
- Involvement in unit testing and integration testing
Environment: Data Stage, Informatica 8.6.1, Unix, Bteq, Teradata.
Confidential
Technical Lead
Responsibilities:
- Interacting with the client
- Studying and understanding the technical specification.
- Developing code using Informatica, Oracle as per the specifications
- Design and development of complex business rules using Informatica.
- Perform unit testing and document the test results
Environment: Informatica 8.6.1, Oracle 9i, UNIX
Confidential
ETL Developer
Responsibilities:
- Enhancement of the Application and Gathering the requirements from the business users.
- Analyzing the Data Preparing the Project Plan, Estimations, Test Plan
- Developing or modifying the Oracle stored procedures as per the business requirement. Developing the Reports
- Executing the process to do Month End invoicing.
Environment: Informatica 7.1, Oracle, PL/SQL, UNIX.
Confidential
Responsibilities:
- Involved in ETL developing, Creating the mappings and transformations using Informatica.
- Scheduling ETL process on daily basis to Extract, transform and load the data into stage area and data warehouse.
- Resolving if any issues in transformations and mappings, Scheduling the sessions& Workflows to load the data into the target.
- Handling Slowly Changing Dimensions to maintain complete history.
Environment: Informatica 7.1, Oracle, UNIX
Confidential
Responsibilities:
- Analyze the Business Requirements Documents. Coding and Unit testing of the components.
- Preparation of exhaustive unit test cases. Involved in ETL developing, Creating the mappings and transformations using Informatica.
- Scheduling ETL process on daily basis to Extract, transform and load the data into stage area and data warehouse.
- Resolving if any issues in transformations and mappings
- Scheduling the sessions &Workflows to load the data into the target.
- Handling Slowly Changing Dimensions to maintain complete history.
Environment: Informatica 7.1, Oracle, UNIX
Confidential
Developer
Responsibilities:
- Analyze the Requirements Documents
- Develop the GIS mapping based on the requirements defined.