SUMMARY

• 15 years of total experience in Information Technology industry with excellent client exposure in different IT application systems, architecting enterprise scale data solutions, leading teh requirement, analysis, design and implementation of large data warehouse, business intelligence and data analytic solutions in different ETL and Business Intelligence technologies.
• Developed teh technical vision, strategy and architecture for teh business capabilities related to data management and analytics
• Ensured dat data architecture meets business and enterprise technology strategy and architecture requirements
• Analyzed business and report requirements and translated those into functional and technical design specifications and implementation plans
• Excellent noledge in data Analysis, data profiling, data Validation, data cleansing, data mining, data verification, data integration, data visualization and identifying data mismatch on large and complex data set using SQL
• Creating and maintaining, conceptual, logical and physical data models, defining data architecture and information requirements for management and business intelligence purposes
• Performed impact assessment and deep - dive analysis in collaboration with stakeholders to ensure data integrity, consistency, usability, and completeness across multiple source
• Analyzed unstructured data in XML, MS Excel source, documenting data flow among various systems, creating source to target mapping specification for data support for business processes across multiple sources and ETL in Hadoop and Informatica Cloud
• Worked for data stewardship and data governance to define new data elements, its integrity across teh systems, finalize teh data model and maintaining data dictionary
• Thoroughly worked with relational and dimensional databases
• Worked closely with Quality Assurance team to define and finalize test strategy
• Extensively worked with Informatica Power center as ETL and Business Intelligence tools like Crystal Reports, Cognos
• Very well versed with tracking tools like HP Application Lifecycle Management to maintain teh traceability metrics
• Prepared relevant project documentation, tracking and reporting regularly on teh status of projects to all project stakeholders and ensured quality by following organization defined standards
• Exceptional ability to work in a multi-cultural team environment and Onshore / Offshore delivery model
• Worked in different business domains like Insurance, Banking, Healthcare, Retail, Travel and Hospitality with a broad noledge of insurance and financial services products and benefits, teh insurance industry, related legislation, and business operation procedures and practices

HIGHLIGHTS

• Data Warehouse/ETL
• Data Governance
• SQL
• Data/System Analysis
• Data Stewardship
• Business Intelligence
• Data Profiling/Data Mining
• Data Modeling/Data Mapping
• Requirement Gathering
• Data Integration
• Data Visualization
• Business Analysis

PROFESSIONAL EXPERIENCE

Confidential, New York, USA

Lead Technical Systems Analyst

Responsibilities:

• Coordinate with teh business community and application development to analyze business requirements and develop technical and functional requirements for new systems, enhancements to existing systems and integrations between systems
• Develop solid understanding of teh various source data sets and assist in laying out teh overall data design solutions and architecture
• Promotes data modeling standardization, defines and drives adoption of teh standards
• Coordinate data models, data dictionaries, and other database documentation across multiple applications
• supporting teh design and development of Integrated Business Systems, multi-tiered client/server application and distributed applications
• Partner with DBAs to transform logical data models into physical database designs while optimizing teh performance and maintainability of teh physical database
• Work with Data Management to establish governance processes around metadata to ensure an integrated definition of data for enterprise information, and to ensure teh accuracy, validity, and reusability of metadata
• Analyzing complex data (Structured and Unstructured) across multiple sources, data integration mapping, data migration and strong understanding in Data Extraction, Transformation, and Load (ETL) Processes
• Ensuring teh system design fits teh needs of teh users
• Writing complex SQL queries to aid in data analysis and reporting
• Conduct change impact analysis to assess teh potential implications of changes and provide solution
• Partner with development and QA teams to communicate teh business rules, data models and ensure test cases target teh quality and integrity of teh data model
• Work with Data Management to establish governance processes around metadata to ensure an integrated definition of data for enterprise information, and to ensure teh accuracy, validity, and reusability of metadata
• Facilitate and execute system integration and user acceptance testing
• Responsible of effort estimation and defining technical scope
• Weekly and monthly status reporting to all project stake holders
• Provide implementation assistance for IT developed and vendor applications
• Engage and build strong working relationships with IT, Business and Sourcing partners

Confidential

Lead Data Analyst & Data Architect

Responsibilities:

• Worked as Lead Data Analyst/Architect, Leading teh Functional Design team in Business Requirement Analysis, Creating Functional Design document
• Worked with end users to gain an understanding of information and core data concepts behind their business
• Interaction with teh Business Users/SME / Business Analyst in analyzing teh Data Requirements and creating Data Requirement Document
• Detailed analysis of Data models & Data Structures of both Source and Target architecture
• Actively involved in analyzing teh different source systems like OLTP, Sales Force and preparing teh source to target ETL mapping document for Hadoop and Informatica Cloud
• Analyzing unstructured data in XML, MS Excel source and create source to target mapping
• Responsible for Creating teh overall logical & physical data model for ODS, Data Warehouse and Data Mart
• Deep Dive Data Analysis and Data Profiling to build Technical Transformation details specification for Application Development and Testing
• Worked closely with Data Stewardship and Data Governance team to define teh new data elements, its integrity across teh LOBs and finalize teh logical data model
• Responsible for creating functional and technical specification document
• Actively involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues
• Closely worked with teh QA team for reviewing and finalizing teh test strategy
• Writing complex SQL queries for ad-hoc reporting
• Creating Report specification for Cognos Framework
• Ensure teh quality of deliverables by following defined standards
• Responsible for Analysis and Design effort estimation and defining technical scope
• Responsible for daily and weekly status reporting to different project stakeholders
• Supporting teh Development and QA team for any design clarifications or any implementation challenges they are facing
• Leading offshore design and development team and proactively mentor team members
• Travelled to onshore for noledge transition from teh Customer’s application support team
• Ensure teh quality of deliverables by following defined standards
• Actively involved in teh noledge transition from customer at onsite
• Actively involved in Requirement gathering, ETL designing, Data profiling, Test case preparation
• Actively involved in analyzing teh source system and preparing teh source to target mapping spec
• Actively involved in ETL design and development
• Worked in effort estimation jointly with teh project manager
• Helped teh team member for any clarifications or any implementation challenges they are facing

Confidential

ETL Solution Architect

Responsibilities:

• Co-ordinate with teh Business Users to gather teh requirements
• Analysis of teh requirements specification provided by Business User
• Design and Develop teh Physical and Logical Data Model
• Design and Develop ETL using Informatica Power Center
• Design teh Job Net for Control M
• Preparation of Unit Test Case and execution of teh same
• Building and Deployment of SDSS Package using Generic Staging 6.4
• Day to day status reporting to teh client
• Ensure quality of deliverables by pre-defined standards and templates
• Interacted with teh business team at onsite for requirement gathering
• Played teh role of Offshore Team Lead, Data Architect, responsible for database design, development and Performance Tuning
• Was responsible to ensure errorless execution of offshore project works starting from database design, development, unit testing to delivery and implementation of developed software maintaining quality standard
• Direct interaction with teh client for requirement gathering
• Design and Develop Physical and Logical Data Model using Erwin, MS VISIO
• Enhance teh Oracle Stored Procedure to implement teh changes specified by client
• Understanding of business and domain noledge
• Train team members in required technologies and grooming them
• Day to day status reporting and interaction with Onsite team
• Providing support to build up Quality Compliance documents e.g., Knowledge Transition documents, preparing matrices, maintaining issue tracking etc.