SUMMARY

• 8+ years of professional experience in Data Modeling, Data architecture, Business Data Analysis and design of OLTP and OLAP systems.
• Strong Knowledge of Data Warehousing, ETL and Business Intelligence Reporting Architecture.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin 7.0/4/0, Power Designer, Embarcadero E - R Studio and Microsoft Visio.
• Exposure to Microsoft AZURE AD, Analysis Services.
• Well versed in Normalization and DeNormalization techniques for optimum performance in relational and dimensional database environments.
• Strong experience working with conceptual, logical and physical data modeling considering metadata standards.
• Experience in administering and managing the data and reporting services related to salesforce.com
• Very good exposure of public cloud in general and deep knowledge on next generation Cloud services like PaaS, IaaS, SaaS, application portability.
• Perform data migration from on premises environments into Amazon Web Services(AWS).
• Over 5 years of extensive massaging & analyzing data using MS Excel, Pivot Tables & Charts and VBA.
• Experience working with Agile and Waterfall data modeling methodologies.
• Experience working with Zachman framework, also well versed in both Ralph Kimball and Inmon approaches.
• Experience in designing a canonical model.
• Work with distributed teams to design and develop frameworks, solution accelerators, proofs of concept, and external customer facing products
• Experience in OA Framework personalization for Self Service Web pages.
• Extensive experience analyzing and documenting business requirements and system functional specifications including use cases facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams.
• Involved in the critical design review of the finalized database model.
• Worked extensively with XML schema designing and XML data.
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using Rational Rose and MS-Visio.
• Worked with various RDBMS like Oracle 9i/10g/11g, SQL Server 2005/2008, DB2 UDB, Teradata.
• Extensive experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Experienced in Data loading using PL\SQL Scripts and SQL Server Integration Services packages (SSIS 2005/2008).
• Experience with DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.
• Performed extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.
• Very Good exposure to ETL tools like Informatica, Micro Strategy and IBM Data Stage and SSIS 2008/ 2005.
• Building reports using SQL SERVER Reporting Services (SSRS 2005/2008), Crystal Reports, Micro strategy,Power BI,Business Objects and Cognos.
• Experience in using and maintaining Metadata Management Tools for maintaining Business and Technical Metadata.
• Excellent communication skills, self-starter with ability to work with minimal guidance.

TECHNICAL SKILLS

Data Modeling Tools: Erwin 4/5/6/7/8/9,System Architect 11.3, Rational Rose 2000, MS Visio 2000/2007/2010 , ER Studio

Databases & Database Tools: MS & SQL servers, Oracle 9g/10g/11g,Hadoop,Cassandra,Greenplum, MS Access 2003/2007/2010 , Teradata, DB2,TOAD 9, Data Stage XE 390, Queryman 5/6, Informatica 8, SQL*Plus,TD SQL Assistant.

Reporting Tools: Cognos 8, VBA, Tableu, Business Objects XI, Crystal Reports 2008, Actuate Reports 10,Power BI,OBIEE.

Programming Languages: UML, XML, XSD, XSLT, HTML, JavaScript, .NET 2.0/3.0/4.0 based C# and VB, ASP .NET, C,C++, PYTHON,MATLAB.

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Analyzed and reviewed functional specifications and requirements to determine best data design approach and translate business requirements into data models.
• Created models for various schemas and created the metadata in order to deploy the models into micro strategy to be able to reuse the definitions enterprise wide.
• Performed data Ingestion for the incoming web feeds into the Data lake store which includes both structured and unstructured data.
• Create the architectural artifacts for the Enterprise Data Warehouse and the Operational Dashboard, such as Entity Relationship Diagrams (ERD), the DDL scripts, the Conceptual Data Model, and technical as well as business documents.
• Conducted data profiling to insure that the available data could support business needs. Worked with the developers on resolving the reported bugs and various technical issues.
• Involved in requirements gathering activities analyze, and document business processes and fundamentals, and strategic data needs.
• Created data source views from MYSQL and HADOOP data sources.
• Migrated our retired systems to leverage new systems and customized according to the business requirement.
• Enforced database naming standards and maintained user domains.
• Supported data conversion activities and coordinated the resolution of conversion and data migration issues.
• Created and maintained Data Dictionary and pursued to reach consensus.
• Created data lineages and mappings for Data Lake schemas.
• Ensured Error logs and audit tables are generated and populated properly.
• Involved in troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Tracking and reporting the issues to project team and management.
• Created mapping for horizontal data lineages for various systems.
• Contribute in the development of knowledge transfer documentation.
• Managed change requests by following change request management process for the project.
• Involved in preparing a simple and detailed user guide and training manual for the application and for an intended novice user.

Environment: Erwin 9.64, MS Access, Micro strategy, MySql, Erwin, Oracle10g, HeidiSql, Hadoop, Toad 12.5,MS Visio, SVN

Confidential, Golden Valley, MN

Data Analyst/SSIS Developer

Responsibilities:

• Gather the various reporting requirement from the business.
• Participated in migration of data sources to sales force apps from legacy CRMs.
• Reverse Engineering the reports and identified the data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with the appropriate data Mart at the lowest level of grain for each of the Dimensions involved.
• Suggested database modifications and prepared training materials for end users.
• Documented all test scenarios, data and results.
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values,codes, business rules, glossary terms, etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases,business object model, and system object model as they evolve and change.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Created ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server using SSIS.
• Created Technical specification documents and conducted many requirement gathering session with business as SSIS developer in order to build the store procedures and create SSIS packages accordingly.
• Create and load Staging and Dimensional databases using SSIS.
• Employed naming standard editor for defining new naming standards for the entities, attributes, domains, columns and tables that applied consistently all over the enterprise.
• Implemented slowly changing dimensions Type2 and Type3 for accessing history of reference data changes.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.

Environment: SQL Server 2008, Azure,SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Windows 2000,, ERwin,CSV files,XML files, MS PowerPoint, Tableu,Power BI, SalesForce, MS Access,Business Objects.

Confidential, Golden Valley, MN

Data Modeler/Analyst

Responsibilities:

• Communicated with users and business analysts to gather requirements.
• Involved in business process modeling using UML through Rational Rose.
• Involved in preparing Logical Data Models/Physical Data Models.
• Migrated our retired systems to leverage Salesforce.com and customized according to the business requirement.
• Interacted with ETL developers for making them understand the movement of required data.
• Organized architectural artifacts using Zachman’s framework.
• Defined the calculations based on the reporting needs and the source data available.
• Ensure the business metadata definitions of all data attributes and entities in a given data model are documented to meet standards.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Developed data mapping documents between Legacy and User Interface Systems.
• Wrote PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
• Developed mappings in Informatica to load the data from various sources includes SQL server, DB2, Oracle, Flat files into the Data Warehouse, using different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation,Rank Transformations, Expressions, Aggregator, Sequence Generator.
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
• Prepared the documentation of Data Acquisition and Interface System Design.

Environment: SalesForce, Teradata V2R5,Rational Requisite Pro, VBA reporting, Excel,Erwin, Data Stage,Rational Rose,DB2 UDB, SQL Server, Sybase, Windows NT, Linux, Sun Solaris, T-SQL.