PROFESSIONAL SUMMARY:

• Hands - on experience of around 5 years as a Data Analyst developing Performance Dashboards, Prompts, Drills and Reports/Dashboards for all the functional areas including Finance/Business and Banking domains with strong knowledge of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, ETL and Strong Business Analysis experience on Data Analysis, Data Migration Documents, Gap Analysis, Data Cleansing, Data Transformations & Impact Analysis.
• Expertise in data cleansing for analysis, perform data quality testing for gaps, Data Verification, identifying data mismatch and liaising with data origination teams.
• Expertise in designing and creating various analytical reports and Dashboards to help users and facilitate strategic planning in the organization.
• Experience in design, development and implementation as a Python, DJANGO, Java and client server technology-based applications.
• Expertise in ETL Tools like Matillion, Informatica.
• Extensive knowledge and Experience in dealing with RDBMS (e.g.: MySQL, SQL Server, Oracle) including Normalization, Web forms, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Excellent knowledge of the design and implementation of the Data Warehouse life cycle and familiarity with entity-relationship/multidimensional modeling Star schema, Snowflake schema.
• Have good experience in writing complex and business centric stored procedures, analytics queries and good command over UDF's, Cursors, triggers and views in SQL.
• Well versed in designing databases with normalization, writing and optimizing SQL queries in Oracle11g, SQL Server 2008 and Teradata.
• Expertise in generating reports using SQL Server Reporting Services, Business Objects, Crystal Reports and MS Excel spreadsheets.
• Experience with Shell scripting, Perl Scripting and programming languages like JAVA, Python.
• Used IDE's like NetBeans and PyCharm for programming using Python.
• Used Boto3 to integrate Python application with AWS services like S3, EC2 and Dynamo DB.
• Hands-on engineering experience with AWS S3, Redshift, EMR, RDS, Elastic Beanstalk, EC2, and Lambda Services
• Proficient using ETL tool for Amazon Redshift to transfer and load data from Teradata
• Used Redshift Spectrum that is included in Amazon Redshift to run SQL queries against unstructured data and structured data using sophisticated query optimization.
• Extensive experience in creating rich visualizations in dashboards using Tableau Dashboard using relational and aggregate data sources and created compelling dashboards to deliver actionable insights.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Expertise in Performance tuning and improved Reports performance in Tableau using extracts and context filters and custom SQL.
• Experience in using Tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Proficient in creating different types of interactive dashboards and reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using SSRS.
• Strong understanding of Hadoop architecture and components such as HDFS, Task Tracker, Map Reduce Programming Paradigm and Data Node.
• Experience integrating Hadoop services such as Solr
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, ETL, Fact and Dimensional Tables.
• Hands on experience in working with various Version Control Systems, mostly GIT, CVS and subversion SVN.
• Experience in developing test scripts, batch scripts using Windows, Linux environments.
• Participated in all the phases of Software Development Life Cycle (SDLC) and used Jira for tracking the tasks
• Strong ability to understand and analyze the client requirements with Excellent Communication, Analytical and Problem-solving skills.
• Strong interpersonal skills and able to work effectively within a delivery-centric organization, focused on delivering quality solutions

TECHNICAL SKILLS:

Programming Languages: JAVA, PYTHON, SQL, PL/SQL, PostgreSQL, UNIX Shell Scripting, VB Script, LINUX shell scripting.

Web technologies: HTML5, CSS, XML.

Scripting Languages: Tableau, Matillion, Informatica, Spotfire, QlikView, SAS.

Database: SQL, My SQL, DB2, Oracle 11g/10g/9i/8i/7.x, Teradata AWS Redshift

Frameworks: Djangos

Web/Application server: Tomcat Web Server, JBoss, WebSphere.

IDE/Version control Tools: Eclipse, PyCharm, NetBeans, GitHub, Bit Bucket, SVN

Operating Systems: Windows XP/7/8, UNIX, Linux, Mac OS

Cloud Platforms: AWS, Azure, Docker SQL, PL/SQL, PostgreSQL, Python, UNIX Shell Scripting, VB Script, LINUX shell scripting

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Data Analyst/Engineer

Responsibilities:

• Worked with Business Analyst to understand the user requirements, layout, and look of the interactive dashboard to be developed in tableau.
• Involved in Manipulating, cleansing & processing data using Excel, Access and SQL and responsible for loading, extracting and validation of client data.
• Used Python programs for data manipulation, automation process of generating reports of multiple data sources or dashboards
• Knowledge in design and implementation of the Data Warehouse life cycle and entity-relationship/multidimensional modeling star schema, snowflake schema
• Involved extensively in creating Tableau Extracts, Tableau Worksheet, Actions, Tableau Functions, Tableau Connectors (Live and Extract) including drill down and drill up capabilities and Dashboard color coding, formatting and report operations (sorting, filtering, Top-N Analysis, hierarchies).
• Data blending of patient information from different sources and for research using Tableau and Python.
• Used Boto3 to integrate Python application with various databased AWS Redshift, Teradata and S3.
• Utilized various Python frameworks and libraries Pandas, Numpy and scipy for analyzing data from data sources AWS Redshift and Teradata and data manipulation
• Developed Python programs and batch scripts on various environments windows, Linux and Unix for automation of ETL processes to AWS Redshift
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Created sheet selector to accommodate multiple chart types (Pie, Bar, Line etc) in a single dashboard by using parameters.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Worked on SAS Visual Analytics & SAS Web Report Studio for data presentation and reporting.
• Extensively used SAS/Macros to parameterize the reports so that the user could choose the summary and sub-setting variables to be used from the web application.
• Created Teradata External loader connections such as MLoad, Upsert, Update, and Fastload while loading data into the target tables in Teradata Database.
• Resolved the data related issues such as: assessing data quality, testing dashboards, evaluating existing data sources.
• Created DDL scripts for implementing Data Modeling changes, reviewed SQL queries and involved in Database Design and implementing RDBMS specific features.
• Expertise in implementing Data modeling, Erwin, Dimensional Modeling, Datamarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Involved in all phases of SDLC and participated in daily scrum meetings with cross teams

Environment: Tableau Server 9.3, Tableau Desktop 9.3, Matillion, AWS Redshift, Teradata, Python, Oracle 11g, SQL, PostgreSQL, Linux, Teradata SQL Assistant, EC2, S3, Microsoft SQL Server, Windows, Unix

Confidential

Data Engineer

Responsibilities:

• Worked with the analysis teams and management teams and supported them based on their requirements.
• Involved in extraction, transformation and loading of data directly from different source systems (flat files/Excel/Oracle/SQL/Teradata) using SAS/SQL, SAS/macros.
• Generated PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
• Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages, Functions and Triggers using SQL and PL/SQL.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base.
• Developed live reports in a drill down mode to facilitate usability and enhance user interaction
• Extensively worked on Shell scripts for running SAS programs in batch mode on UNIX.
• Wrote Python scripts to parse XML documents and load the data in database.
• Used Python to extract weekly information from XML files.
• Developed Python scripts to clean the raw data
• Used Boto3 to integrate Python applications with Amazon web services worked on AWS CLI to aggregate clean files in Amazon S3 and also on Amazon EC2 Clusters to deploy files into Buckets.
• Used AWS CLI with IAM roles to load data to Redshift cluster
• Validated regulatory finance data and created automated adjustments using advanced SAS Macros, PROC SQL, UNIX (Korn Shell) and various reporting procedures.
• Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging different sources.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created Dashboards style of reports using Qlikview components like Listbox Slider, Buttons, Charts and Bookmarks.

Environment: Windows 8, UNIX, SAS v9.4, SAS/EG, Python, Boto3, Netbeans, SAS/Macro, SAS/SQL, SAS/Graph, MS SQL Server, Oracle, Teradata, MS-Excel, AWS Redshift, AWS S3, AWS EC2, Tableau 8.2, Qlikview 9.0 SR2.

Confidential

Data Analyst

Responsibilities:

• Utilized SQL to develop stored procedures, views to create result sets to meet varying reporting requirements.
• Used Visual Studio report builder to design report of varying complexity and maintain system design documents.
• Involved in Data analysis, reporting using Tableau and SSRS.
• Built and supported the transformation of various data inputs into the companies Data Warehouse.
• Analyzed and designed solutions, created technical integration and interacted with QA team on their tasks related to the imports and extracts.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database to meet business requirements and for Testing Purposes.
• Field mapping work involved establishing relationships between the databases Tables, filter criteria, formulas etc., needed for the reports.
• Involved in performance tuning of queries by working intensively over indexes.
• Processed data received from vendors and loading them into database on a weekly basis. The extracted data had to be checked for integrity.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
• Created different source definitions to extract data from flat files and relational tables for Data mart.
• Documented data cleansing and data profiling and tested cleansed data for integrity and uniqueness.
• Designing the ETL process using Informatica to populate the Data Mart using the flat files to Oracle database
• Designed and developed Insurance, Claims and Financial Reports Using SSRS.
• Coordinated between the Business users and development team in resolving issues.
• Performed testing and QA role: Developed Test Plan, Test Scenarios and wrote SQL plus Test Scripts for execution on converted data to ensure correct ETL data transformations and controls.

Environment: Flat files, MS Excel Files, MS Access, SSRS, Oracle 9i/10g, Power Designer, MS SQL Server 2005/2000, PL/SQL, Teradata V2R5, Tableau, PerlUNIX scripting, Windows NT, SQL, Business Objects