PROFESSIONAL SUMMARY:

• Highly motivated and passionate Data Analyst and Programmer with demonstrated history of working in IT and marketing industry having around 6+ years in experience. Strong business development professional with a master’s degree in Information Systems from the Stratford University Richmond, VA. I love the challenges that each new project brings and have a passion for current emerging technologies like Data Analysis, Data Conversion, Data Validation, Data Profiling and Report Creation and working experience in Tableau, Teradata, AWS Redshift, AWS S3, Python, Unix.
• Good experience in Developing Teradata SQL queries and using Utilities such As BTEQ.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Over to improve the query performance while pulling the data from large tables.
• Experience in data analysis using Python (Pandas, NumPy).
• Worked on standard Python libraries include boto3 to connect to AWS.
• Experience in moving data to cloud platform like AWS (S3) and manipulate data using Redshift.
• Worked on performance tuning and optimization to improve the efficiency in script executions.
• Good working experience loading Data Files in AWS Environment and Performed SQL.
• Testing on AWS redshift databases.
• Exceptional ability to research, analyze and convey complex technical information to diverse end - users at all levels. Solutions-driven strategist who consistently improves efficiency, productivity and the bottom line.
• Recognized for partnering with business leaders and technical teams to plan, integrate, document and execute complex project plans on time and on budget.

TECHNICAL SKILLS:

BI Tools: Tableau, MicroStrategy10.2

ETL Tools: Informatica, SSIS, Alteryx Designer

Requirements Management: Microsoft Office (Word & Excel)

Database Technologies: Teradata, Oracle, SQL Server, DB2, Snowflake, AWS, Redshift, Databricks

Scripting Languages: C, C++, HTML, SQL, PL/SQL, Python C++, C, JAVA, Python, SQL, PL/SQL, UNIX, LINUX.

Agile: Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Data Analyst

Responsibilities:

• Worked in the Tech Risk as a Data Analyst. Facilitating data needs for various Risk assessments using various tools and technologies like Snowflake, Data bricks, AWS and Redshift.
• Interacting with the Business users and understand and analyze their requirements and providing advanced analytical support for business operations.
• Utilized spark SQL to load data from AWS S3 to snowflake tables using data bricks.
• Converted extract transform and load jobs in Alteryx to Python.
• Created SQL scripts in Snowflake database to ingest data and migrate data from User Schema to user Collaboration Space.
• Conducting requirement gathering sessions with senior associate understand business needs and help contribute the daily stories.
• Worked with development teams to analyze, develop and solve issues.
• Worked with development team to develop dashboards, coding standards, and quality policies and procedures.
• Participated in the continuous improvement efforts in enhancing dashboard performance and providing increased functionality.

Environment: Snowflake, Python, Microsoft Office (Word, Access, Excel, Outlook), Data Bricks, AWS S3

Confidential, McLean, VA

Data Analyst

Responsibilities:

• Worked in the Enterprise Data Management (EDM) and Risk Team as a Senior Data Analyst.
• Day-to-day responsibilities included strategizing key metrics around Data Governance and exploring the potential risks in the Enterprise Data setup across all the Lines of Business (LOB’S).
• Communicated with the first line of defense / business and Data Management Advisors to mitigate potential risks.
• Created customized dashboards using Tableau to track Data Lineage and Metadata for the business and technical datasets across second line of business.
• Used Python scripts to load S3 and Snowflake (Tables, Views) metadata catalogued information to EDM reporting mart (Redshift) for Tableau reporting.
• Created Tableau dashboards to show Data Quality for different metrics across Enterprise and Line of Business.
• Created Bar graphs, Line graphs and heat maps in Tableau to show the percentage of Data Quality checks in each division/ Enterprise for Snowflake and AWS S3 datasets.
• Created SQL and Python scripts to perform Data validations across different metrics in Redshift checked against metadata registrations (Nebula).
• Created GitHub webpages for documentation using Sphinx.

Environment: AWS Redshift, Tableau, Snowflake, Python, Microsoft Office (Word, Access, Excel, Outlook)

Confidential, Richmond, VA

Data Analyst

Responsibilities:

• Built a framework using UNIX and PYTHON to validate data migrated from TERADATA to SNOWFLAKE.
• Managed report to identify load delays in daily updated production tables.
• Maintained reports to identify data issues between SNOWFLAKE and TERADATA and automated to produce daily, weekly reports or support teams.
• Created, deployed and gave accessibility to databases on SQL servers.
• Wrote optimized SQL queries to pull required data for further reporting.
• Validated production data in Snowflake platform during activity of shifting operations from AWS East to server to AWS West in order to ensure compliance with government policies is met.
• Involved in spinning up EC2 instances and adherence to rehydration policies/maintenance.
• Co-ordinated with off-shore Support teams to report data inconsistencies.
• Performed data manipulations and data validations for build reporting structure.
• Contributed as first-hand responder to data quality issues slack channels and platforms.
• Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.
• Designed and Developed various analytical reports from multiple data sources using Tableau Desktop.
• Developed dashboards on Tableau to share insights on how delays affect performance and recommendations on customer.
• Built a drill down Tableau dashboard to give a brief and detailed over view of card tables to customers.
• Used VLOOKUP and pivot table functions in EXCEL.
• Proficient working in loading data into staging tables via views.
• Designed and developed weekly, monthly reports related to the financial partnership using Teradata SQL.

Environment: Teradata, Snowflake, Tableau, AWS, Python, Microsoft Office (Word, Access, Excel, Outlook)

Confidential, Washington, DC

Data Analyst

Responsibilities:

• Gathered Business Requirements from stake holders, interacted with the Users, Project Manager and IT teams to get a better understanding of the project goals.
• Performed gap analysis of the data and reviewing the requirements.
• Involved in defining the whole project life cycle, following agile methodology. Analyzed business requirements and segregated them into high level and low-level priorities.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Analyzed requirements for various reports, dashboards, scorecards and created the same using Tableau desktop server.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Responsible for the interactive experience of the site.
• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• Designed and developed various SQL scripts as part of automation of manual monthly reporting to third party consumer.
• Performed Targeted user research to analyze customer requirements together with Product Management.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Proficient working in loading data into staging tables via views.
• Designed and developed weekly, monthly reports related to the marketing and financial departments using

Environment: Teradata SQL Assistant, Tableau, Microsoft Office (Word, Access, Excel, Outlook)

Confidential

Data Analyst

Responsibilities:

• Worked with leadership teams to implement tracking and reporting of operations metrics across global programs.
• Worked with large data sets, automate data extraction, built monitoring/reporting dashboards and high-value, automated Business Intelligence solutions (data warehousing and visualization).
• Gathered Business Requirements, interacted with Users and SMEs to get a better understanding of the data.
• Performed Data entry, data auditing, creating data reports & monitoring all data for accuracy.
• Designed, developed and modified various Reports.
• Created and presented dashboards to provide analytical insights into data to the client.
• Translated requirement changes, analyzing, providing data driven insights into their impact on existing database structure as well as existing user data.
• Worked primarily on SQL Server, creating Store Procedures, Functions, Triggers, Indexes and Views using T-SQL.

Environment: My Sql, SQL Server, MS Office Suite