SUMMARY:

• Over 11 years of extensive experience in Data Analysis, Data Modeling, System Analysis, Data Architecture
• and Development, Testing and Deployment of business applications
• Experience in credit risk management & modeling (CCAR/DFAST & Basel II/III), data analytics, quantitative
• research, project lifecycle management, business consulting & team management in wholesale, retail &
• investment banking
• 4 + Years of expertise on ETL, ELT - ODI (Oracle Data Integrator), Oracle DB, SQL, PL/SQL
• Extensive Experience Tidal administration, quality assurance, and security. Applies clear direction
• Expertise in Design and Maintenance of the Subversion/GIT Repositories, Views, and the Access Control
• Strategies
• Depth knowledge in Data Warehousing concepts with emphasis on ETL and ELT
• Have a very good experience in Designs and implements data warehouse, data marts and data stores, while
• ensuring high level of data availability
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Experience designing security at both the schema level and the accessibility level in conjunction with the
• DBAs
• Experience in Designing and implementing data structures and commonly used data business intelligence
• tools for data analysis.
• Expert in building Enterprise Data Warehouse or Data warehouse appliances from Scratch using both Kimball
• and Inmon Approach.
• Experience in working with Excel Pivot and VBA macros for various business scenarios.
• Strong experience in Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data
• Export.
• Experience working with data modeling tools like Erwin, Power Designer and ER Studio.
• Experience in developing Map Reduce Programs using Apache Hadoop for analyzing the big data as per
• the requirement.
• Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems
• (RDBMS) and from RDBMS to HDFS.
• Experience in data analysis using Hive, Pig Latin, Impala.
• Well versed in Normalization / De-normalization techniques for optimum performance in relational and
• dimensional database environments.
• Experience in various Teradata utilities like Fastload, Multiload, BTEQ, and Teradata SQL Assistant.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server and Teradata.
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies,
• disciplines, tasks, resources and scheduling.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data
• mismatch.
• Experience in designing error and exception handling procedures to identify, record and report errors.
• Experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
• Excellent experience in writing SQL queries to validate data movement between different layers in data
• warehouse environment.
• Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data
• store models.

TECHNICAL SKILLS:

Databases: Oracle, Teradata R13/14/15, DB2, MS SQL Server 2015/2014, MS Access2007/2005, Big Data.

Testing and defect tracking Tools: HP/Mercury, MS Visio & Visual Source Safe, Salesforce.

Operating System: Windows 8/7/Xp, Dos, Linux, Unix

Big Data: Hadoop, HDFS 2, Hive, Pig, H Base, Sqoop, Flume.

ETL/Datawarehouse Tools: SAP Business Objects XIR3.1/XIR2, Web Intelligence

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot

Tools & Softwares: TOAD,VSS, MS Office, BTEQ, Teradata SQL Assistant

WORK EXPERIENCE:

Confidential

Sr. Data Analyst/Data Modeler

Stamford, CT

Responsibilities:

• Created logical data model from the conceptual model using  based on requirements analysis and
• validated the model with response to questionnaire from business analyst and its conversion into the physical
• data base design.
• Built new data models to support the credit risk calculation for Wholesale banking division
• Worked on designing, implementing and deploying into production an enterprise data warehouse
• Created and maintained jobs, job groups and calendars in Tidal Enterprise scheduler
• Managed GIT, GIT Stash and SVN as Source Control Systems
• Responsible for design and development of various reports using OBIEE
• Responsible for data profiling and data quality checks to suffice the report requirements gathered above and
• provide an ETL Mapping
• Responsible of designing the whole datawarehouse system including ODS, DWH and data marts.
• Conducted JAD sessions with management, vendors, users and other stakeholders for open and pending
• issues to develop specifications.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Involved in Big Data Analytics and Massively Parallel Processing (MPP) architectures Green Plum
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data
• from Teradata database.
• Involved with data profiling for multiple sources and answered complex business questions by providing data
• to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many
• sources.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data
• Cleansing.
• Worked with DBAs and the security coordinators to get access to the team members.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and
• snowflake Schemas.
• Wrote and executed unit, system, integration and UAT scripts in a Data Warehouse projects.
• Able to guide directors for architecting solutions for the Bigdata Organization
• Created and enhanced OOTB/Share Point Designer Workflows.
• Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas, Snowflake
• Schemas, SCD & Dimensional Modeling.
• Created queries using BI Reporting variables, navigational attributes and Filters.
• Created UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Collaborated with other data modeling team members to ensure design consistency and integrity
• Participated in the development and maintenance of overall data architecture, data management standards
• and conventions, data dictionaries and data element naming standards and conventions for multiple computing
• environments to support data warehousing.
• Perform data reconciliation between integrated systems.
• Knowledge on ETL process like using MS Access to pull the data from various data bases and integrate
• the data.
• Managed and created and altered Databases, Tables, Views, Indexes and Constraints with business rules.
• Assisted in the oversight for compliance to the Enterprise Data Standards, data governance and data quality

Environment: PL/SQL, Tableau, Teradata R15, Teradata SQL Assistant 15.0, Data Flux, Oracle 12c, Quality

Sr. Data Architect/Data Modeler

Teaneck, NJ 

Responsibilities:

• Conducting the meetings with business users to gather data warehouse requirements.
• Worked on managing Source control System on GIT.
• Worked on designing the whole datawarehouse architecture from scratch, from ODS to data marts
• Conducted team meetings and Joint Application Design (JAD) session
• Gathered requirements and created use case diagrams as part of requirements analysis.
• Developed 3NFnormalized Logical and Physical data base models to design OLTP system
• Developed Staging jobs where in using data from different sources like flat files, excel files, Oracle database
• Created dimensional model for the reporting system by identifying required dimensions and facts using ER
• Studio 9.5.
• Produced functional decomposition diagrams and defined logical data model.
• Implemented Referential Integrity using primary key and foreign key relationships in Teradata.
• Worked with the Business Analyst, QA team in their testing and DBA for deployment of databases in the
• correct Teradata Environment, business analysis, testing and project coordination.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from
• legacy Oracle and SQL Server database systems.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Exhaustively collected business and technical Metadata and maintained naming standards
• Good Knowledge on using ER Studio for reverse engineering to connect to existing database to create
• graphical representation in the form of Entity Relationships and elicit more information.
• Created physical data models for Teradata for data model deployment.
• Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.
• Worked with ETL teams to create source and target definition, design mappings, create repositories and
• establish users, groups and their privileges, using Informatica Designer, Workflow and Repository Manager.
• Used Teradata for OLTP systems by generating models to support Revenue Management Applications that
• connect to SAS.
• Created the data model for the Subject Area in the Enterprise Data Warehouse(EDW).
• Consulted with client management and staff to identify and document business needs and objectives, current
• perational procedures for creating the logical data model.
• Participated in performance management and tuning for stored procedures, tables and database servers.
• Worked in Agile Environment using tolls like JIRA and Version One.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Responsible in integrated the work tasks with relevant teams for smooth transition from testing to
• implementation phase.
• Also worked closely with Web Application Developers working in environments like Angular/ Spring/ Jenkins.

Environment: ER Studio 9.5, SQL Server 2014, Teradata 14.0, Oracle 11g, Informatica, SAS, JIRA, Version One.

Sr. Data Analyst/Data Modeler

Cherry Hill, NJ

Responsibilities:

• Participated in all phases including Analysis, Design, Coding, Testing and Documentation.
• Gathered Requirements and performed Business Analysis.
• Extensively used SQL for Data Analysis.
• Done Reverse engineering on existing data model to understand the data flow and business flows.
• Also Reverse engineering the existing Stored Procedures and write Mapping Documents for them.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical
• database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Created Schema objects like Indexes, Views, and Sequences
• Worked on Gap Analysis.
• Data analysis of existing data base to understand the data flow and business rule applied to Different data
• bases by SQL
• Facilitated meetings with the business and technical team to gather necessary analytical data requirements.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data
• Cleansing
• Creating Mappings, Mapplets, Sessions and Workflows using Informatica to replace the existing Stored
• Procedures
• Pre populate the static tables in the Data warehouse using PL/SQL procedures and SQL Loader.
• Written maps for daily data loads.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was
• standardized to store various Business Units in tables.
• Worked on defining deadlines and helped team to meet the deadlines.
• Extensively worked on documentation of Data Model, Mapping Transformation and Scheduling jobs.
• Worked extensively with Business Objects XI Report Developers in solving critical issues of defining
• hierarchy, loops and Contexts.
• Designed Mapping Documents and Mapping Templates for ETL developers.
• Deployed naming standard to the Data Model and followed company standard for Project Documentation.

Environment: Pl-SQL, Oracle 10g, SAP BO, MS Excel, MS Visio

Sr. Data Analyst/Data Modeler

Kansas City, MO

Responsibilities:

• Analyzed data sources and requirements and business rules to perform logical and physical data modeling.
• Analyzed and designed best fit logical and physical data models and relational database definitions using
• DB2. Generated reports of data definitions.
• Conducted source data analysis of various data sources and develop source-to-target mappings with
• business rules.
• Maintained existing ETL procedures, fixed bugs and restored software to production environment.
• Worked with Data Warehouse Extract and load developers to design mappings for Data Capture, Staging,
• Cleansing, Loading, and Auditing.
• Developed enterprise data model management process to manage multiple data models developed by
• different groups
• Designed and created Data Marts as part of a data warehouse.
• Effectively used triggers and stored procedures necessary to meet specific application's requirements.
• Created SQL scripts for database modification and performed multiple data modeling tasks at the same time
• under tight schedules.
• Reviewed new data development and ensured that it is consistent and well integrated with existing structures.
• Wrote complex SQL queries for validating the data against different kinds of reports generated by Business
• Objects XIR2.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for
• design, development, testing, and production rollover of reporting and analysis projects.
• Document and publish test results, troubleshoot and escalate issues
• Worked on SAS and IDQ for Data Analysis.
• Using Erwin modeling tool, publishing of a data dictionary, review of the model and dictionary with subject
• matter experts and generation of data definition language.

Environment: Erwin 7.5, Oracle 10g Application Server, Oracle Developer Suite, PL/SQL, T-SQL, DB2, SQL Plus, Microsoft SQL Server 2005 

Data Analyst/Data Modeler

Memphis, TN 

Responsibilities:

• Worked on interviewing business users to gather requirements and documenting the requirements.
• Used Erwin to create Conceptual, Logical and Physical data models.
• Designed the Data Model/Data exchange Metadata Model for All Interfaces and Data Exchanges
• Designed and Maintained Data Model for OLTP systems and OLAP systems, ODS and Data Marts using
• 3NF and Dimensional Design
• Worked on Physical design for both SMP and MPP RDBMS, with understanding of RDMBS scaling features
• Managed full SDLC processes involving requirements management, workflow analysis, source data analysis,
• data mapping, metadata management, data quality, testing strategy and maintenance of the model.
• Helped the BI, ETL Developers in understanding the Data Model, data flow and the expected output for each
• model created
• Created and executed test cases for ETL jobs to upload master data to repository.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements
• mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Wrote complex SQL queries for validating the data against different kinds of reports generated by Business
• Objects XIR2.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing,
• in a complex EDW using Informatica.
• Analysis on Mainframe data to generate reports for business users.

Environment: Erwin 4.0, SQL Server 2005, Ms Access 2000, Informatica 6.x