SUMMARY:

• Over fifteen years of experience in IT in the areas of Business Intelligence, Data Architecture and Data Warehouse, and Big Data Architecture and data modeling.
• Experience in design and implementation of large data warehouses.
• Experience in implementation with Big Data Technologies like Hadoop, NOSql and Netezza
• Created conceptual, logical and physical Data models, Dimensional models, Star Schema and Snowflake Schema.
• Extensive experience creating advanced analytic systems using data warehousing technologies with a focus in the last few years on processing large data sets using technologies such as Hadoop.
• Designed client's Reference Architecture, Data Governance, Fit - Gap Analysis, and BI Roadmap and Strategy, Operations and Support models leading for best in class and robust BI solutions and systems.
• Worked with ETL and BI teams and walkthrough the data models.
• Advised organizations about big data, a big data strategy, the implementation of big data, which technologies best fit the needs of the organization and even implements the selected big data solution
• Worked on Confidential BDW data warehouse and implementation.
• Experience in data architecture, data quality, data profiling, reference data administration and management of very complex, high volume and high performance system.
• Set up Data Governance and Standards processes in data architecture
• Worked with data scientists to extract actionable insights from huge amount of data on the Hadoop cluster
• Experience in working on Unix Shell scripting, Hive and sql scripts
• Experience in working on database performance tuning and optimization.
• Diverse experience and knowledge of several BI tools like Qlikview, Web Focus, Tableau, SAS, and Business Objects etc.
• Extensive experience in Waterfall and Agile Data Warehouse development methodologies. Ability to quickly and effectively, develop key relationships with a range of project participants including executives, directors, managers, vendors, client stakeholders, and developers. Strong conceptual and analytical skills.
• Experience participating in at least two successful Agile initiatives as a Scrum Master from inception to production launch

TECHNICAL SKILLS:

Modeling Tools: ERWIN, POWER DESIGNER and ER STUDIO

Hadoop: HDP 2.2.3, Hive, PIG, SQOOP, KAFKA,STORM, MONGODB

ETL: SAS 9.1.3, BODI 11.7, AB INITIO, INFORMATICA 8.X, TALEND 5.4

Database: NETEZZA, TERADATA,UDB, ORACLE 11g, SYBASE, ASE 12.5, SYBASE, IQMS SQL SERVER 2008,nosql

Reporting Tools: BUSINESS OBJECTS/CRYSTAL REPORTS, SAS

Languages: JAVA, C++,SQL, PL/SQL, UML, XML.

Project Management: MS OFFICE, VISIO

IT Methodology: AGILE, RUP and CMMI

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Involved in the design of the Conceptual, Logical and Physical Data Models.
• Translate business requirements into data architecture and align with enterprise standards.
• Experience designing and implementing reporting and visualization for unstructured and structured data sets
• Responsibilities include defining systems strategy, developing system requirements, designing, prototyping, and testing custom technology solutions, and supporting system implementation.
• Perform architecture gap analysis, evaluate open source/build options, and articulate choices to stakeholders
• Identify data model issues and recommend options for resolutions.
• Experience designing and developing data cleansing routines
• Worked on the Creation, maintenance and communication of the Data warehouse and big data roadmaps
• Involved in the POC efforts to architect and integrate data warehouse with aml hub.
• Worked on the implementation of the data model and architecture patterns.

Environment: Oracle, DB2,Business objects, Erwin,ER Studio

Confidential, Hicksville, NY

Data Architect

Responsibilities:

• Involved in the design, development and implementation of the Systems Data Warehouse centralized repository.
• Designed Hadoop and data warehouse integration platform for data warehouse offloading, preprocessing, data archival and Data analytics.
• Designed and developed Hive processes in Hadoop and integrated them with the Data warehouse.
• Worked on the big data use cases like data archiving on hadoop and data warehouse augmentation
• Participated in development meetings and Agiledevelopment sprints.
• Facilitated daily stand up meetings with Scrum teams.
• Designed Logical and Physical Data Models (Star schema) for Systems Data Warehouse.
• Designed Datamarts and Dimensional models for Data Warehouse and implemented Change Data capture.
• Involved in the Design of the ETL and ELT Netezza Interfaces for Data extraction and processing.
• Designed the Operational Data Stores (ODS) for Network operations reporting.
• Worked on the source to target mappings,business rule transformations and data
• Implemented the Data Governance and Data standards for the Data models.

Technologies: Netezza, Hortonworks Hadoop HDP 2.1.3, SAS, Mysql, Web Focus, Oracle, Erwin, Pig, Hive, SqoopP, MongoDB, Kafka,Storm

Confidential, Warren, NJ

Data architect

Responsibilities:

• Involved in the design of data warehouse logical and physical data models for global data warehouse.
• Worked in Netezza implementation for enterprise contracts and position global data warehouse
• Hands on with the ETL/data modeling architecture and Netezza data structures compatibility.
• Worked on the data architecture framework implementation for Netezza ELT environment.
• Worked on the Erwin data modeling tool and data modeling framework process.
• Worked on Erwin data modeling tool and Netezza template creation.
• Designed the Netezza data structures for ETL error and exception handling.
• Designed reference data models for party and securities, derivative product related subject areas.
• Worked on the data architecture on creating data modeling processes, modeling framework and standards.
• Worked on the design of the Operational data stores (ODS) for risk reconciliation and reporting.
• Created data modeling Standards and practices.
• Involved in the data analysis of the source files, data profiling and transformation rules.
• Involved in the design data model for Data marts.
• Designed data mapping rules, documents and process
• Worked with ETL team and architecture team to model exception handling and error handling.
• Worked on the metadata capture and the documentation
• Documented mapping rules
• Worked with the testing team to resolve the data quality issues.

Technologies: Erwin 8.0, Netezza, Teradata, Oracle, Ab Initio, Confidential BDW data model

Confidential

Data Architect

Responsibilities:

• Created conceptual and logical data models for collateral program.
• Created logical data model for the client on boarding,contracts security and pricing reference data.
• Designed dimensional models for collateral data marts.
• Worked on the design of the data quality .data profiling templates to record the findings of the data profiling.
• Involved in Data augmentation and data transformation to identify the different anomalies and proposed the solutions for cleansing.
• Involved in the data mapping of source to target from legacy to data warehouse
• Generating DDLs from Erwin and deployment of new schemas.
• Worked on Gap analysis and gap resolution between the legacy and new application.
• Worked on the source to target mapping of legacy data structures to the target data model.
• Worked on the Data quality plan to deliver the clean data to the target integration database.
• Designed GCE data integration specification documents for the ETL team.
• Designed the client faced reports and architecture and source mechanism for ETL.
• Worked on the capacity planning requirements for the implementation of the new schemas.
• Worked on the Metadata management using Erwin and integration of Erwin metadata to informatica.

Technologies: Oracle 11g,Informatica 8.x,DB2,Erwin 7.2, webservices.

Confidential, Bridgeport, CT

Data Modeler

Responsibilities:

• Involved in the logical and Physical data mapping between Confidential ’ Confidential Legacy system and New Core Banking system.
• Prepared the detailed Data mapping specification documents between the source and target data structures.
• Involved in the designing of the ETL mappings from source to target and extensive data analysis.
• Designed new transactions datamart for Confidential ’s Bank Online Trading System.
• Designed daily and monthly snapshot of Customer transactions.
• Designed the daily nightly batch extracts for Data staging and Data warehouse.
• Facilitated the requirements gathering sessions to define the reporting requirements.
• WroteETL specification documents including data cleansing and transformation.
• Designed aggregate and summarized reports using SQL.
• Wrote SQL scripts for adhoc queries and providing the reports to the management
• Used SQL PROC for extracting the data into the data staging and data warehouse area.
• Worked on report generation and reported to the Business team.
• Used SQL PROCEDURES for Data conversion process.
• Involved in the problem solving and resolution of error handling of reports.
• Estimated the space and storage requirements for the database for the project enhancements.
• Documented the data transformations, Data metrics, and data scrubbing processes necessary for ETL process to provide a place to cleanse, transform, integrate, derive, and summarize data.
• Created the data naming conventions and standards and implemented them.

Technologies: Oracle 10g, Erwin, UML, System architect, Business Objects XI, SAS 9.1.3,Data Integrator, Sybase IQ 12.5

Confidential, Des Moines, IA

Data Modeler

Responsibilities:

• Designed, maintained and built conceptual, logical and physical database models.
• Involved in the design and the development of Logical and Physical models for the Mortgage Origination system for Confidential Bank Project.
• Reviewed the vendor logical data model. Enhanced the vendor data model to suit the needs of the client.
• Participated in day to day meetings with the PMO and update the project status.
• Mapped and matched of interface and data requirements from the old system to the new system.
• Developed data migration rules such as source to target mappings for the Enterprise Data warehouse Financial and Capital Market Data store.
• Performed in-depth data analysis on existing SAS reports and optimizing the report functionality.
• Designed new reports using SAS enhancing the corporate reports.
• Designed the Centralized data Hub for all the Operational data stores for Confidential Mortgage and Financials and Servicing systems reporting.
• Facilitated modeling sessions and design walkthroughs with DBA and Application development team members.
• Used SQL for adhoc query reporting and tuned the existing SAS reports.
• Involved in the data mapping, data analysis and Gap analysis between the Legacy systems and the Vendor Packages.
• Involved in the design of the web services for the Mortgage /Financial Applications and Credit Cards on the Servicing systems.
• Analyzed business requirements and gathered data requirements to build moderately complex logical data or class models that include attributive entities, subtype and super-type entities, and recursive relationships.
• Reverse engineered the existing systems and vendor models and transformed to logical models.

Technologies: Oracle 9i, SAP R/3, SAS 8.X, UML Diagrams,Erwin 4.1 and Power Designer 12.1,DB2,Web Methods.

Confidential, Overland Park, KS

Data Modeler

Responsibilities:

• Created and delivered data structures via logical and physical designs for IT Project teams based on a thorough understanding of application requirements, business requirements and database constraints.
• Created logical and physical database design for small and complex application across multiple projects and applications.
• Worked on the consolidation data of the call center specific for all the call center applications
• Developed the Customer Global data stores to share among the different applications across the company which focus on the customer specific data.
• Reviewed the Vendor Data Model and ensured that vendors fulfill deliverables for the ticket management system.
• Identified and negotiated the corporate wide technologies to purchase, deploy, and implementation.
• Used SQL for clarify data manipulation in the custom application.
• Reviewed test cases for accuracy. Validated User Acceptance results confirm to requirements.
• Managed project plans and the deliverables including all artifacts for SDLC.
• Used Power Designer 9.5 and Erwin 4.1 to create these models.
• Involved in the creation of the Crud matrix.
• Worked directly with System Analysts, Application Analysts and Database administrators to ensure data efficiency and integrity.
• Captured and documented detailed data requirements for the strategic initiatives and projects.
• Facilitated the model walk thru sessions for the business and application users.

Technologies: Oracle 8.1.7, Erwin 4.1, Power Designer 9.5,UML,Clarify E-Front Office suite, Siebel.