SUMMARY:

• Over 9 years of Experience in SQL, Python, R, designing, Administration, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web - based Applications and Databases.
• Expertise and experience in SQL, Python, R, ETL, SAS and Relational databases. Deep understanding & exposure of Data mining
• Excellent knowledge in Normalization (1NF, 2NF, 3NF and BCNF) and De-normalization techniques for improved database performance in OLTP, OLAP and Data Warehouse/Data Mart
• Strong background in various Data Modeling tools using ERWIN, ER/Studio and Power Designer.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm (3NF) and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions)
• Good Experience in database design using PL/SQL, SQL, ETL, T-SQL to write Stored Procedures, Functions, Triggers, Views
• Extensive experience in Data Modeling, Data Analysis and design of OLTP and OLTP systems.
• Expertise 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
• Expertise in transforming business requirements into analytical models, designing algorithms, building models, developing data mining and reporting solutions that scales across massive volume of Structured and Unstructured Data
• Experience in all the Latest BI Tools Tableau, Qlikview Dashboard Design and SAS
• Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/Budget Management
• Expertise in Project Management, Analysis, Estimation, with a unique mix of managerial functional, domain, technical and client handling skills
• Expertise in managing entire data science project life cycle and actively involved in all the phases of project life cycle including data acquisition, data cleaning, data engineering, features scaling, features engineering, creating dashboards, analyzing generated reports using data visualization
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data
• Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons), Reports/Dashboards for all the functional areas including, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain, and Transportation, Sales/Marketing, Variable Objects with formulas
• Extensive experience in Text Analytics, Data Mining solutions to various business problems and generating data visualizations using SAS and creating dashboards using tools like Tableau

SKILL:

Languages: SQL, R, SAS, Python, Hadoop, Pig, Hive, MATLAB, HTML, PHP, Linux, Java, C, CPP

Tools: WEKA, SPSS, Tableau, ETL, MS Excel, MS Power Point, MySQL, GitHub, Matlab/Octave, MS SSIS, MS SSRS

Databases: Oracle, Teradata, SQL Server, MySQL, DB2

Reporting Tools: Tableau, SPSS

Data Modeling Tools: Erwin 9.x, ER/Studio, MS Visio

BI Tools: Tableau, Tableau server, Tableau Reader, QlikView

Other Tools: MS-Office suite (Word, Excel, MS Project and Outlook)

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, VA

Data Analyst

Responsibilities:

• Gathered and documented the requirements that are critical to the business mission and translate business requirements into report visualization specification design documents
• Designing and creation of tables and stored procedures, views, triggers, user - defined functions
• Data Modelling (Physical and Logical) using Erwin for the new system to be introduced in the process
• Created and maintained various databases for development and testing environment
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel, csv, text documents, pdf, and Flat file to MS SQL Server
• Involved in writing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively
• Created Triggers to enforce data and Referential Integrity
• Designing and developing database management systems using ETL (SSIS) and maintain the database using stored procedures (SQL, PL/SQL) to fulfill the technical and business requirements of clients
• Actively designed the database to fasten certain daily jobs, stored procedures
• Writing T- SQL statements for retrieval of data and Involved in performance tuning of T- SQL Queries and Stored Procedures
• Use Confidential and DML for writing triggers, stored procedures, and data manipulation
• Developed various dashboards for Income Statements, financial reports in Tableau
• Generated Interactive dashboards with filters, Parameters and Actions to handle views more efficiently
• Published reports/dashboards on Tableau server and created & managed Tableau server groups and permissions
• Created aggregate data extracts for larger tables and configured schedulers on the server to refresh the data
• Utilized Alteryx for blending data from multiple databases to create a single Data source
• Provided insights of Time series forecasting data analysis of weekly sales for regions and retail users using R and Tableau
• Worked with SQL and extracted data using Alteryx and developed POCs (Proof of Concepts) by building reports and dashboards using Tableau 8.1 to demonstrate quick wins
• Good Experience in database design using PL/SQL, SQL, ETL, T-SQL to write Stored Procedures, Functions, Triggers, Views
• Proactively anticipated client needs and ascertain the means to improve satisfaction and monitor levels
• Improved the delivery process through continuous integration

Environment: Tableau Desktop 10.X/9.X, Tableau Server, SQL Server Management Studio (SSMS), MS SQL Server, Oracle 11g, R Programming, Erwin, MS Office Suite (Word, Excel, PowerPoint)

Confidential, Baltimore, MD

Data Analyst

Responsibilities:

• 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 within Tableau Desktop
• Assisted with annual budget process, reporting and analysis of performance against historical, budgeted, and forecasted data
• Created Stored procedures to extract data based on specific time frame from bank reconciliation file to create new data file
• Reviewed existing T - SQL functions based on changes in data format
• Updated and refined process for accounting unit requests
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data updated the worksheets
• Published worksheets and related data sources to server
• Created Data Mapping and wrote the transformation rules for every field
• Extensively used Normalization techniques (upto3NF)
• Designing and developing database management systems using ETL (SSIS) and maintain the database using stored procedures (SQL, PL/SQL) to fulfill the technical and business requirements of clients
• Design and implementation of Data layouts of star schema using the requirements provided by the client
• Automated the roll out process
• Good Experience in database design using PL/SQL, SQL, ETL, T-SQL to write Stored Procedures, Functions, Triggers, Views
• Participated in meetings, reviews, and user group discussions as well as communicated with stakeholders

Environment: Tableau Desktop 8.x/9.x, Erwin, Tableau Server, MS Office Suite (Word, Excel, and PowerPoint), Oracle 11g, and MS SQL Server.

Confidential, New York City, NY

Data Analyst

Responsibilities:

• Plan, design, and implement application database code objects such as stored procedures and views
• Provided database coding to support business applications using T - SQL
• Performed quality assurance and testing of SQL server environment
• Developed new processes to facilitate import and normalization, including data files
• Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment
• Interacted with report owners to establish/clarify their requirements and developed report specifications
• Developed SQL Queries, Python, R programs, to fetch complex data from different tables in remote databases using joins, database links and Bulk collects
• Wrote TSQL like Indexes, Views, Stored Procedures and Triggers
• Involved in Database migrations from legacy systems, SQL server to Oracle
• Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP and OLAP systems
• Generated Confidential scripts using Forward Engineering technique to create objects and deploy them into the databases
• Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows by using SQL Developer and PL/SQL Developer
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems
• Worked on Data warehouse concepts like Data Warehouse Architecture, Star schema, Snowflake schema, and Data Marts, Dimension and Fact table

Environment: Microsoft, Linux, Oracle 10g / 9i / 8i / 7.x, DB2 7.x / 8.x, SQL Server 2005/2000, MS Access 2000

Confidential, Boston, MA

Data Analyst

Responsibilities:

• Worked with SQL, Python, R, QL PLUS, Oracle PL/SQL Stored Procedures, Triggers, SQL queries and loading data into Data Warehouse/Data Marts
• Worked with DBA group to create Best - Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin
• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects
• Involved in creating Logical and Physical data models with Star and Snowflake schema techniques using Erwin in Data warehouse as well as in Data Mart
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle 8i/9i.
• Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical Data Models
• Designed data model, analyzed data for online transactional processing (OLTP) and Online Analytical Processing (OLAP) systems

Environment: Windows XP, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL-PLU, Java