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:

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, VBScript, PERL, AWK, SED

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/Data warehouse Tools: SAP Business Objects XIR3.1/XIR2, Web Intelligence

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. Data Architect/Data Modeler

Responsibilities:

• Created logical data model from the conceptual model using Erwin 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 data warehouse 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 Big data 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 Center 8.2, SQL, TOAD, PL/SQL, Flat Files.

Confidential, Teaneck, NJ

Sr. Data Architect/ Data Modeler

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 data warehouse 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 operational 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.

Confidential, Cherry Hill, NJ

Sr. Data Analyst/ Data Modeler

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.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.

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

Confidential, Kansas City, MO

Sr. Data Analyst/ Data Modeler

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

Confidential, Memphis, TN

Data Analyst/Data Modeler

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