PROFESSIONAL SUMMARY:

• 14+ years of experience in IT industry with 12 + years of specialized practical experience in clarifying business requirements through Business Analysis, Data Modeling, Dimensional Modeling, Data Analytics, Data Quality, Design process and system improvements to increase productivity and reduce costs.
• Excellent Analytical skills to understand the Business Process and Functionality. Developing Functional Specifications for business process refinement and automation, Data Modeling, system architecture, and conducting feasibility studies.
• Proven experience in relational and dimensional data modeling, data management, data warehousing, data transformation, metadata and master data ( data) management and business intelligence tools.
• Knowledge of Advance SQL keywords and concepts.
• 12+ years of Dimensional Data Modeling experience using Data modeling, Relational Data modeling, ER/Studio, Erwin, Sybase Power Designer, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logical data modeling.
• Experience in computing platforms that allow analytics to combine structured, complex data and build processing and analytical applications across data sources and types;
• Advanced information management and new data processing techniques may be applied to extract the value locked up in this data called Hadoop (HDFS) along with processing large data sets in parallel across a Hadoop cluster and the utilization of Hadoop MapReduce framework.
• Additionally experienced in NameNode where Hadoop stores all the file location information in HDFS and tracks the file data across the cluster or multiple machines.
• Predicting market trends or identifying market shifts or in other words, allowing the businesses to look through the windshield for what is coming.
• Some know of SITE CATALYST TAGGING. For example s.props, s eVars or s.events. Initiates and builds an image request for a 1x1 pixel image, also called a web beacon that concatenates a query string of name/value pairs of analytics data to send to the Adobe Data Collection Layer.
• Knowledge of JIRA which is a workflow management system tool that lets track work in any scenario.
• Highly skilled in the usage of ETL tools for DataStage (Talend, Informatica, SSIS, SSRS) developing features of Teradata PDE, Amp, Bynet, PE, vDisk and Virtual storage system (VSS). Knowledge of MultiLoad, TPUMP and BTEQ utility which is a general - purpose, command-based tool for Teradata.
• Work on Background process in oracle Architecture. Also drill down to the lowest levels of systems design and construction.
• As a Architect UML models and leverage the advanced executable code generators to target different domains.
• Determine the physical architecture of oracle ( Datafiles”*.dbf”, Controlfiles “ *.ctl”) est.
• Experienced in Businesses Analytics, to provide comprehensive predictive analytic, financial performance and strategy management, to improve business performance and predict future outcomes.
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirement gathering and analysis.
• Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Strongly capable of handling VLRDB (Very Large Relational Data Bases) of about 5TB with expert level working knowledge of the architecture involved.
• Experience in back-end programming including schema and table design, stored procedures, Triggers, Views and Indexes.
• Expertise in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Semantic (SDM), Logical and Physical Data Modeling until 3NormalForm (3NF) and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions). Complete knowledge of data warehouse methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Knowledge of DBA performs all activities related to maintain a successful database environment. I always keep myself abreast of emerging technologies and new design approaches i.e. designing, implementing the database system.
• Expert in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non-relational databases.
• Experience in leading the offshore team, supporting team effort through sharing of technical knowledge to turnaround deliverables to meet aggressive deadlines.
• 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.
• Consolidate and audit metadata from disparate tools and sources, including business intelligence (BI), extract, transform, and load (ETL), relational databases, modeling tools, and third-party metadata into a single repository.
• Expert level understanding of using IBM Cognos SPSS, Cognos TM1 and Business Analytics family software.
• Expert level understanding of using different databases in combinations for Data extraction and loading, joining data extracted from different databases and loading to a specific database.
• Excellent understanding of an Approach to MDM to creating a data dictionary, Using Informatica or other tools to do mapping from sources to the Target MDM Data Model.
• Excellent understanding of Hub Architecture Style for MDM hubs the registry, repository and hybrid approach.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE and Waterfall Methodologies.
• Excellent knowledge in the ETL (Extract, Transform and Load) of data into a data warehouse/Date Mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Well versed with client server environment and tools like SQL*Loader, UNIX shell scripts and TOAD.
• Used NetCDF Java library is an implementation of the CDM which can read many file formats besides NetCDF
• Common Data Model (CDM) for the scientific Datasets which merges the NetCDF, OPeNDAP, and HDF5 data models
• Excellent team member with interpersonal and communication skills and trouble-shooting capabilities, highly motivated, result oriented with strong analytical, organizational, presentation and problem solving skills.
• Expert in developing effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
• Excellent knowledge for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Have in AWS cloud databases (Amazon RDS) and using Amazon virtual private cloud (VPC) which supported two EC2 platforms (VPC and Classic). Create new option group and assign it to the DB instance such as Oracle TDE. Create Amazon RDS MySQL DB instance such as MySQL versions, storage engine security.
• Build, format, and customize Oracle Business Intelligence (BI) analyses, and how to create and update dashboards in Oracle BI EE 12c
• Using Erwin to connective to the SQL Server database and read & write Model Mart Database. In Erwin migrates the model from the Erwin Model Manager R8.x to New Erwin Model Mart R9.x (Each model is upgraded during the migration to new Model Mart)
• Using a text editor such as Notepad to open the MVS file.
• Managing on shore and offshore team.

TECHNICAL SKILLS:

Data Modeling Gears: Erwin r9.6.01/r9.5/7x/6x/5x, ER/Studio 9.7/9.0/8.0/7. x, Toad 9.7.2/7.4/7.3.

BI Tools: SAS, IBM Cognos, Birst, IBM Cognos TM1, Jaspersoft, Pentoho, Sisense, MicroStrategg, Tableau, Targit, Talend, Data Stage, OBIEE, Excel, SSRS

Databases: Oracle 11g/10g/9i/8i/7.x, Teradata, HP ALM, DB2 UDB 8.x/7.x, DB2 Z/OS 9.x/8.2, SQL Server 2012R2, 2008/2005/2000 , MySQL, MS- Access, Flat Files, XML files.

Programming Skills: SQL, PL/SQL, Unix Shell Scripting, JavaScript, Java( Good Knowledge of Java )

Operating Systems: Win 95/NT/98/2000/XP, LINUX, Sun Solaris 2.X/5/7/8, IBM AIX 5.3/4.2, HP-UX, MS-DOS

Scheduling Tools: Autosys, Maestro (Tivoli), JIRY

DataWarehousing/Big DataWarehousing Platforms: Informatica PowerCenter, Informatica V 9.5.1 Hot fix, SheriPint, IBM InfoSphere Data, Apache, Taland Open Studio Hadoop 2.6.0, Birst, NoSQL, MapReduce, Jaspersoft BI Suite, SQL Server Integration Services, SAS, SQL-SERVER Integrated Services, Oracle Data Integrator.

Other Tools: Teradata, SQL Assistant, Oracle ATG, DB Visualizer 6.0, SAS, Microsoft Office, Microsoft Visio, Microsoft Excel, Microsoft Project, SQL Server 2005, 2008, 2008R2 and 2012R2, (SSIS), SSRS, SSAS. EMC PX12-450R Network Storage Array.

PROFESSIONAL EXPERIENCE:

Confidential, Woonsocket RI

Data Architect / Data Analysis

Responsibilities:

• Also design a process for Problematic for SQL for Prod and AWR report as a Data Architect work on AWR and New Defects, identifies the priority. Share SQL ID from AWR with Prod Architect to determine if there are pre-existing defects. Once the defect fixed and promoted in production.

Tool: ; Oracle 11g, 12c, Oracle SQL Developer, Oracle client 11.2, Oracle Web logic 12.1.2 SharePoint, PL/SQL, SQL Server 2008, and 2008 R2 Excel, OBIEE, MS 0ffice 2007, Visio 2010. Citrix web Interface, Java Developer, Eclipse Java EE 4.4, File Zilla 3.3, CA Clarity PMP, Open logic Tortoise 1.9.2, Putty.

Confidential, West Creek Richmond, VA

Technical Business Analysis / Data Architect

Responsibilities:

• Functions and processes.
• Enterprise architecture
• Process architecture
• Technology architecture
• Organization architecture

Tool: Adobe SiteCatalyst, Oracle11g, 12b, 13g, Erwin 9.6.01,7.5.2, NoSQL, Hadoop, IBM Cognos, Tableau, SharePoint, SSIS, SSAS, SSRS XML, PL/SQL, SQL Server 2005, 2008, and 2008 R2 Excel, OBIEE, Access, Visio.

Confidential, Pittsburgh, PA

Information Architecture & Modeling

Responsibilities:

• Work with EDW Modeling team: Teradata DBAs
• With EDW team share Model on SheriPint
• Create Dimensional Model
• Create Erwin subject area for the changes.
• Name subject are
• DB work item Quote
• Update Service Manager phase to In work
• Completing model changes, Save reports
• New Model Mart creates.
• Upgrade During the migration to the new Model Mart.
• Create a Physical Data Model report named: DB work item PDM.pdf
• Create a Data Dictionary report named: DB work item DD.pdf
• Send notification that model change is ready for review
• Turn over model to DBAs upon customer approval
• Save model on LAN in ToDBA folder
• Update Service Manger phase: DBA Analysis
• Save reports to Published folder
• Email to requester and CC Team
• Created table for Oracle 13.1 and DB2 8.1
• Create Entity-Relational Model
• Modify and add Column in Model

Environment: Oracle, 8 and 11g, DB2, Mainframe, Teradata, Erwin 8.0 and 9.3, SharePoint, SSIS, SSAS, SSRS XML, PL/SQL, SQL Server 2005, 2008, 2008 R2 and 2012 R2, Excel, Access, Visio.

Confidential, Shawnee Mission, KS

Data Analyst

Responsibilities:

• Proactively monitor and cleanse data across the enterprise
• Review approach definition and identify potential solutions
• Ensure quality standards, criteria and targets are documented in the quality plain
• Remove process and role ambit
• Script table as inset to new Query edit
• Enable business and IT collaboration in the governance of data
• MSD SDLC Phase
• Achieve better business outcomes and maximize your return on data
• Repository / Domain Details
• Connect IDQ Developer environment
• Stage environment to migration and test
• Work on subject Area
• LDG Data Review
• Spec Assigned
• MDM Reviewed
• Source to Target Matrix

Environment: Oracle12g, IBM Cognos TM1, Erwin 8.0, NoSQL, Hadoop, IBM Cognos, Talend, SSIS, SSAS, SSRS XML, PL/SQL, SQL Server 2005, 2008, 2008 R2, 2012 R2 Excel, Access, Visio.

Confidential, Hoffman Estate, IL

Senior Data Modeler / Data Architect

Responsibilities:

• Planning meeting and Analysis.
• The requirements documentation and the project scope statement.
• Validate scope.
• Perform quantitative risk Analysis.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Focus on integration overlap and Informatica’s newer commitment to MDM with the acquisition of Identity Systems.
• Review the change to understand how it affects scope, cost, time, quality, risk and costumers satisfaction.
• Observe and solve the issue of MDM.
• As Architect implement MDM hub to provide clean, consistent data for a SOA implementation.
• Using Erwin to customize report display and export reports to HTML.
• With Erwin Tools generate graphical diagrams that drill-into to view detailed metadata.
• In Erwin DM creating Logical and Physical Model.
• Used BTEQ script to create a sample tables. Redefine the partitioning of a populated table.
• Use RDBMSs to implement simple CRUD (Create, Read, Update, and Delete) functionality.
• In Teradata use cursor logic to generate a sequence of dynamic SQL statements.
• Developed complex mapping to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications and Teradata.
• Use Birst’s ready data store sits on top of all data and combines different sources of corporate data. Optimized ROLAP-style analytics, providing a Kimball style star-schema with a multi-dimensional view of all data.
• Involved in gathering user requirements and specifications.
• Involved in stored procedures, functions, and database triggers and maintained referential integrity and implemented complex business logic.
• Created Dimension types such as Standard dimension, Parent-Child dimension and Role Play dimension in SSAS.
• Designed and created views for security purposes. Implemented rules, defaults, and user-defined data types. Tested queries to optimize procedures and triggers to be used in production.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Created SSIS packages for different data loading operations for many applications.
• Performed Data modeling for existing Databases using Toad Data Modeler and ER Studio.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.

Environment: Oracle 11g, OBIEE, IBM infoSphere, IBM Cognos, IBM Cognos TM1, Erwin r9.5, ER/Studio 9.7, IBM InfoSphere Data, HP Hadoop, Data Stage, Windows 7 XML, Excel, Access, Visio, SSIS, SSRS, MySQL, RazorSQL, SQL Server 2005, 2008, 2008 R2 and 2012, EMC PX12-450R Network Storage Array.

Confidential, Auburn Hills, MI

Business Analyst / Senior Data Modeler

Responsibilities:

• Created complex Stored Procedures for data retrieval.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc to import data into the data warehouse.
• Created user defined functions in SSRS using VB script.
• Responsible for creating OLAP cubes for deep through analysis using SSAS 2008.
• Use the power of Birst’s unified business model to join data from Birst’s user-ready data store with data queried in real-time from another source, cloud or on-premises.
• Used data profiling tool for automates the discovery process.
• Used data profiling automation to uncover the characteristics of the data and the relationships between data sources before any data-driven.
• Developed strategies for data warehouse implementations, data acquisitions, provided technical and strategic advice and guidance to senior managers and technical resources in the creation and implementation for data architecture and data modeling
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Use Sybase PowerDesiner support several types of model.
• Integrated crystal reports using Erwin Data Modeler.
• Us Erwin to support for Teradata 13.0 and SSL.
• Set in Erwin Diagram Parent to Child identifying relationships.
• Transformation and reverse engineering using Erwin tool.
• In Erwin DM creating Logical and Physical Model.
• Used BTEQ script to create a sample tables. Redefine the partitioning of a populated table.
• Using cursor logic to generate a sequence of dynamic SQL statements in Teradata.
• Use RDBMSs to implement simple CRUD (Create, Read, Update, and Delete) functionality.
• Developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications and Teradata.
• Defined corporate Metadata definitions for the enterprise data supported databases including operational source systems, data stores and data marts developed logical and physical data models and documented source data from multiple sources, internal systems, external source systems, and third party data.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups. Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML

Environment: Oracle11g, OBIEE, IBM Cognos TM1, Erwin 7.5.2, NoSQL, Hadoop, IBM Cognos, Talend, SSIS, SSAS, SSRS XML, PL/SQL, SQL Server 2005, 2008, and 2008 R2 Excel, Access, Visio, Windows XP.

Confidential, Parsippany, NJ

Data modeler / Business Data Analyst

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• In Erwin DM creating Logical and Physical Model.
• Creating a User-defined Function, To Verify a Date.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Used BTEQ script to create a sample tables. Redefine the partitioning of a populated table.
• Ensure compliance of Data Quality in MDM.
• Determine the Target in MDM.
• Specify the Mapping between Sources and Target in MDM.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted XL to SQL reporting.
• Designed and developed complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Use RDBMSs to implement simple CRUD (Create, Read, Update, and Delete) functionality.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors.
• Creating a Stored Procedure to Update Accrued Interest.

Environment: Oracle 10g, OBIEE, Data Stage, Erwin 7.5.2, HP ALM,, Talend, SQL Server 2005, 2008 and 2008 R2 Windows, IBM InfoSphere, SSIS, SSRS XML, Excel, Access, Visio.

Confidential, Raleigh, NC

Data Modeler / Business Data Analyst / Data Architect

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Used BTEQ script to create a sample tables. Redefine the partitioning of a populated table.
• Creating a User-defined Function To Verify a Date.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups. Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Designed and developed complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.

Environment: Oracle 10g, OBIEE, Erwin 7.5.2, SQL Server 2005 and 2008, Windows XP, XML, Talend, Excel, Access, Visio.

Confidential, Glen Allen, VA

Business data analyst / Data modeler

Responsibilities:

• Successfully created and managed a conversion testing effort which included a data quality review, two system test cycles, and user acceptance testing.
• Using Erwin to logical and Physical DM in SQL-SERVER.
• Set referential integrity roles and history options in Erwin Editor.
• Use RDBMSs to implement simple CRUD (Create, Read, Update, and Delete) functionality.
• In Erwin Diagram display Logical and Physical relationships.
• Set in Erwin Diagram Parent to Child identifying relationships.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
• Involved in writing SQL programming for implement Stored Procedures and Functions for different tasks.

Environment: Windows 2000, Oracle 8i, OBIEE, ATG Merchandising UI, Data Stage, MS Access, SQL Server 2005 and 2008, Erwin 3.