SUMMARY

• Around 7 years of experience as a Sr. Data Architect/Data Analyst and Data Modeler with high proficiency in requirement gathering and data modeling.
• Designing the architecture of the data warehouse after understanding and analyzing the legacy databases.
• Hands on experience in Normalization and De - Normalization techniques for optimum performance in relational and dimensional database environments.
• Good understanding and hands on experience in setting up and maintaining NoSQL Databases like Cassandra, Mongo DB, and HBase.
• Sound knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Extensive knowledge of Big data, Hadoop, MapReduce, Hive, NoSQL Databases and other emerging technologies.
• Very good experience and knowledge on Amazon Web Services: AWS Redshift, AWS S3 and AWS EMR.
• Excellent Knowledge of Ralph Kimball and Bill Inmon's approaches to Data Warehousing.
• Experience in working on Distributed storage for analysis and processing of large data sets using Apache Hadoop.
• Strong experience in using MS 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 working with Agile and Waterfall data modeling methodologies.
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Teradata, BTEQ and MDM.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL, PL/SQL.
• Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing.
• Expertise on Relational Data modeling (3NF) and Dimensional data modeling.
• Extensive experience on usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Efficient in implementing Normalization to 3NF/ De-normalization techniques for optimum performance in relational and dimensional database environment
• Proficient in data mart design using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Proficient in Software Development Life Cycle (SDLC), Project Management methodologies, and Microsoft SQL Server database management.
• Experience in data analysis, data migration and data modeling activities.
• Hands on experience with modeling using Erwin in both forward and reverse engineering processes.
• Solid understanding of Data Governance, Meta Data, Data Management and control; Adept in Data warehouse and Data mart architecture.
• Strong background in data processing, data analysis with hands on experience in MS Excel, MS Access, Unix and Windows Servers.

TECHNICAL SKILLS

Data Modeling Tools: Erwin Data Modeler 9.7, Erwin Model Manager, ER Studio v17, and Power Designer.

Programming Languages: SQL, PL/SQL, HTML5, C++ and XML.

Reporting Tools: SSRS, Power BI, Tableau, SSAS, MS-Excel, SAS BI Platform.

OLAP Tools: Tableau 10.5, SAP BO, SSAS, Business Objects, and Crystal Reports

Cloud Platform: AWS, MS Azure, Google Cloud, Cloud Stack/Open Stack

Databases: Oracle 12c/11g, Teradata R15/R14, MS SQL Server 2016/2014, DB2.

Operating System: Windows, Unix, Sun Solaris

Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Agile, Waterfall Model.

AWS tools: Amazon Web Services, EC2, S3 Bucket, AMI, RDS, Amazon Redshift.

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

Data Architect

Responsibilities:

• Massively involved in Data Architect role to review business requirement and compose source to target data mapping documents.
• Analyzed business requirements, system requirements, and data mapping specification requirements.
• Review and analysis of business requirements for identification of data sources and target systems.
• Analyzed data using Hadoop components Hive and Pig and created tables in hive for the end users.
• Queried SQL Server for data validation along with developing validation worksheets in Excel to validate.
• Applied Data Governance rules (primary qualifier, Class words and valid abbreviation in Table name and Column names).
• Included migration of existing applications and development of new applications using AWS cloud services.
• Developed test strategies and plans for Unit, Integration, System and User Acceptance Testing.
• Defined and Created OLAP Schema's - star schemas for use in building Cubes, based on Multiple Data Stores for use SSRS Reports.
• Experienced with a variety of statistical and database programs (e.g., STATA, SAS, R and/or SQL)
• Pipelined (ingest/clean/munge/transform) data for feature extraction toward downstream classification.
• Analyze source systems for data acquisition architect data feathering logic across different source systems.
• Designed logical and physical data models using Power Designer tool in medium to high complexity, according to company standards.
• Communicated strategies and process around data modeling and data architecture to cross functional groups.
• Specifies overall Data Architecture for all areas and domains of the enterprise, including Data Acquisition, ODS, MDM, Data Warehouse, Data Provisioning, ETL and BI.
• Created reports with Crystal Reports and scheduled to run daily basis.
• Done data migration from an RDBMS to a NoSQL database, and gives the whole picture for data deployed in various data systems.
• Coordinated with Data Architects and Data Modelers to create new schemas to improve reports execution time, worked on creating optimized Data Mart reports.
• Used the Agile Scrum methodology to build the different phases of Software development life cycle.
• Driven the technical design of AWS solutions by working with customers to understand their needs.
• Designed and architecting AWS Cloud solutions for data and analytical workloads such as warehouses, Big Data, data lakes, real-time streams and advanced analytics.
• Gathered and analyzed existing physical data models for in scope applications and proposed the changes to the data models according to the requirements.
• Used Informatica tool for profiling the tables as it helps us understand content, structure, relationships, etc. about the data in the data source we are analyzing.
• Was using in-house tool for profiling the tables using Spark.

Environment: Hadoop, Hive, MDM, PL/SQL, Sql Server 2015, Nosql, MS Office (Word, Power Point, Access, Excel, Outlook), SAP Power Designer, MS Visio, Crystal Reports.

Confidential - Phoenix, AZ

Sr. Data Analyst

Responsibilities:

• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Extracted data from different sources like Oracle and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.
• Experienced in developing business reports by writing complex SQL queries using views, volatile tables.
• Extensively use SAS procedures like means, frequency and other statistical calculations for Data validation.
• Performed Data Analysis and extensive Data validation by writing several complex SQL queries.
• Involved in design and development of standard and ad-hoc reporting using SQL/SSRS
• Identified source databases and created the dimensional tables and checked for data quality using complex SQL queries.
• Responsible for data lineage, maintaining data dictionary, naming standards and data quality.
• Developed SAS macros for data cleaning, reporting and to support routing processing.
• Created SQL scripts to find Data quality issues and to identify keys, Data anomalies, and Data validation issues.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirement.
• Used MS Visio for business flow diagrams and defined the workflow.
• Performed Data analysis for the existing Data warehouse and changed the internal schema for performance.
• Performed Data analysis and Data profiling using complex SQL on various sources systems.
• Wrote SQL Stored Procedures and Views, and coordinate and perform in-depth testing of new and existing systems.
• Performed Data Manipulation using MS Excel Pivot Sheets and produced various charts for creating the mock reports.
• Used SQL Server and MS Excel on daily basis to manipulate the data for business intelligence reporting needs.

Environment: Oracle 10g, SQL, SAS, SSRS, T-SQL, MS Excel, MS Visio

Confidential

Data Analyst

Responsibilities:

• Worked as Data Analyst for requirements gathering, business analysis and project coordination.
• Worked with the Data Analysis team to gathering the Data Profiling information
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Performed Data Analysis and Data validation by writing SQL queries using SQL assistant.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Gathered business requirements through interviews, surveys with users and Business analysts.
• Worked on Data Mining and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Developed SQL Queries to fetch complex data from different tables in databases using joins, database links.
• Involved in designing and developing SQL server objects such as Tables, Views, Indexes (Clustered and Non-Clustered), Stored Procedures and Functions in Transact-SQL.
• Participated in JAD sessions, gathered information from Business Analysts, end users and other stakeholders to determine the requirements.
• Performed Data analysis of existing data base to understand the data flow and business rules applied to Different data bases using SQL.
• Performed data analysis and data profiling using complex SQL on various sources systems and answered complex business questions by providing data to business users.
• Performed the detail data analysis, Identify the key facts and dimensions necessary to support the business requirements.
• Generated Data dictionary reports for publishing on the internal site and giving access to different users.
• Used MS Visio and Rational Rose to represent system under development in a graphical form by defining use case diagrams, activity and workflow diagrams.
• Wrote a complex SQL, PL/SQL, Procedures, Functions, and Packages to validate data and testing process.
• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Worked in data management performing data analysis, gap analysis, and data mapping.
• Established a business analysis methodology around the RUP (Rational Unified Process).
• Developed stored procedures in SQL Server to standardize DML transactions such as insert, update and delete from the database.
• Created SSIS package to load data from Flat files, Excel and Access to SQL server using connection manager.
• Develop all the required stored procedures, user defined functions and triggers using T-SQL and SQL.
• Produced report using SQL Server Reporting Services (SSRS) and creating various types of reports.

Environment: SQL, SQL server, PL/SQL, MS Visio, Rational Rose, SSIS, T-SQL, SSRS