PROFESSIONAL SUMMARY:

• Detail Oriented, Self - motivated performance driven IT professional with more than 11 years of extensive IT experience, especially in the area of Data Modeling, Data Architecture, Data Warehousing and Data Analysis using different techniques of SDLC - who continue to grow in technology, knowledge and leadership, excel in new innovative technologies and concepts, interact effectively with team members and share the knowledge with colleagues. Strive to provide the best solutions in real life challenges.
• Hands-on Modeling experience in Amazon Cloud services like Redshift, RDS (Aurora, PostgreSQL etc.)
• Completed Certification on AWS - Solution Architect Associate in November 2017 in the first attempt.
• Experience in Dimensional Modeling in Big Data, Amazon AWS Database Services.
• Data Modeling using ER-Studio Data Architect 9.5 and ER Studio 2016, CA-Erwin 8.x,
• SMAC Certified from International Scrum Institute.
• Data Analysis using Aginity workbench for Netezza, Toad for Hadoop, SQL Workbench etc.
• 3 years of Experience in Secondary Mortgage Market.
• 8+ years of extensive experience in Cards and Payments Domain.
• Proficient in Microsoft Office applications.
• Experience in Mainframe tools and technologies.
• Familiar with Teradata and Hadoop (Big Data) concepts.
• Familiar with in-memory data processing using Spark.
• Proficient Team Leadership with strong work ethics.
• Creative problem solving.

PROFESSIONAL EXPERIENCE

Data-Modeler & BI Architect

Confidential, Reston, VA

Responsibilities:

• Discuss various aspects of the Database and its performance with the Enterprise Architect to come up with the Best Architecting solutions for the Data Needs.
• Source system data analysis to understand different source data structures and their relationships.
• Identifying any conformed dimensions that can be used across different Subject Areas Enterprise wide.
• Understanding the business requirements from the Client/other Stakeholders by conducting managing the meetings and convert them in Technical specifications.
• Designing Logical data model from various Business/Report requirements using ER-Studio Data Architect 2016.
• Work with Database Architect to help them understand the complex scenarios critical dimensional Data Modelling concepts like Conformed Dimensions and Facts, Family of stars, Slowly Changing Dimensions, Fact less facts etc.
• Work with various teams to understand the business specifications of various fields, help preparing the Source to Target Mapping of the fields to be stored into the database and will be used for various internal/external reporting.
• Follow Agile Scrum Methodology to perform step by step Data Sourcing and provide solutions based on the current state of Data availability. Also provide guidance for refactoring for the Future State of Data Sourcing.
• Work with Scrum Master and Product Owner to plan the sprints, drive various initiatives for best practices among the Scrum Teams.
• Work with Client/Product Owner for end to end validations of Sprint deliverables and on the Demo to the Business Users.
• Interacting with DBAs for schema creation, alterations and various performance tuning activities.
• Review test plans, test strategy documents for planning and help the testing team in designing the test to be conducted.
• Identification and resolution of defects by coordinating with various project teams. Mark the completion of the testing process by providing test sign off documents.
• Designing integrated solutions for various functional and business critical systems.

Data-Modeler

Confidential, Atlanta, GA

Responsibilities:

• Understanding the business requirements from the Client/other Stakeholders by conducting managing the meetings and convert them in Technical specifications.
• Analyze the incoming data in different platforms using Toad (for Oracle Database), Aginity (for Netezza) and Mainframe (Z/os) tools and create Logical/Physical Data Models using tool such as CA-Erwin.
• Work with Database Architect to help them understand the complex scenarios critical dimensional Data Modelling concepts like Conformed Dimensions and facts, family of stars, Slowly Changing Dimensions, Fact less facts etc.
• Work with various teams to understand the business specifications of various fields, prepare the Mapping of the fields to be stored into the database and will be used for various internal/external reporting.
• Work with offshore development team to make them aware of the business requirements and help them in design and mapping.
• Follow Agile Scrum Methodology to perform step by step Data mining.
• Work with Scrum Master and Product Owner to plan the sprints, drive various initiatives for best practices among the Scrum Teams.
• Conduct and Manage Sprint meetings with the development team.
• Work with Client/Product Owner for end to end validations of Sprint deliverables.
• Review test plans, test strategy documents for planning and help the testing team in designing the test to be conducted.
• Identification and resolution of defects by coordinating with various project teams. Mark the completion of the testing process by providing test sign off documents.

Data Analyst/Modeler, BI designer

Confidential

Responsibilities:

• Source system analysis to identify fitment of data in ‘to be state’ data model.
• Understanding the requirements for each release from downstream consumption teams like decision support systems and Intranet applications
• Design logical data model using CA-Erwin.
• Modelling of different dimensions and facts for Enterprise presentation layer.
• Preparing High Level ETL Design and data mapping documents.
• Feasibility analysis and technical review of Functional specifications.
• Deriving the Physical data model after doing technical feasibility analysis
• Creating and updating enterprise data domains, classification schemes and naming standards.
• Managing the Erwin model for each milestone/release
• Creating DDLs and sending to DBAs for applying in schema
• Created Source to Target mapping document in excel spread sheet which contains the transformation logic and worked closely with ETL Team and developed various transformations
• Involved in creating data dictionary and data standards to ensure data quality and consistency.
• Managed a team of 10+ members to ensure delivery SLAs.

Mainframe Developer

Confidential

Responsibilities:

• Providing critical production support and maintenance of the Repository Management System in confidencial.
• He was also involved in minor and major enhancements like implementing new functionalities or enhancing the existing functionalities.
• He was acting as a second line application lead. His role was to get the requirement from my onsite counterpart, create roadmaps for executing the projects, planning tracking of the project, designing the process to implement the requirement, development, testing, review of all deliverables by his peers.
• He has played an important role in transitioning technical and application knowledge to persons new to this project.
• He was also involved in the quality processes as per Cognizant organizational standards and confidencial  standard and satisfies all internal or external Audit rules.