OBJECTIVE

• As a well driven individual with great zeal - seeking to establish a competitive advantage for myself, align my career goals with organization goals which will help in the growth and betterment of the organization.
• Also work in a progressive and stimulating work environment/culture with the freedom to be creative, innovative and to excel in my area of work.

SUMMARY

• Experienced IT professional with more than 3 years in Data Analysis, Data Visualization, Data Migration, Data Cleansing, Data Transformation, Data Integration, Data Import, and Data Export using ETL tools.
• Proficient in creating database and database objects like tables, views, stored procedures, triggers, index etc.
• Extensive experience writing complex SQL queries reading data from Data warehouse tables in SQL.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server
• Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS
• Developed complex stored procedures and Queries for implementing business logic and process in backend for data extraction, reports and other client interfaces
• Interpret data, analyze results using statistical techniques and provide ongoing reports using Python.
• Identify trends and anomalies in the data collected to understand and resolve sources of data inaccuracies using Python.
• Tableau BI reporting experience using Tableau Desktop, Tableau Server, and Tableau Reader creating worksheets, Graphs, Maps, Charts and dashboards
• Extensive experience as Tableau Developer, data visualization, data analysis, report development and SQL developer
• Expertise in Microsoft Office: Word, Excel, Access, Outlook etc.
• Excellent communication and interpersonal skills
• Good team player and capable of working individually with little or no supervision
• Highly organized and disciplined with a passion for Information Technology.
• A positive, high energy team player with a passion for providing excellent customer service.

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst/Tableau (IT Support)

Responsibilities:

• Collaborate with Business Analyst and Data Engineer to gather business/data requirement and Extract data from different sources for Data process, Manipulation and Analysis
• Responsible for reviewing, analyzing, modifying and creating Business Objects reports and dashboard for investment systems and process (PAM for investments, PAM for Mortgages, Bloomberg and Market data feeds).
• Create visualizations that provide business insights for our global customers and deploying those visualizations to Tableau Server.
• Use excel sheet, flat files, CSV files to generated Tableau Ad-hoc reports
• Creating visualizations which communicate effectively Design, develop, and maintain reports and multi-level dashboards in Tableau.
• Identifying data anomalies and suggests data quality audits to improve data collection efforts.
• Perform data manipulation operations like import/export data from various external file formats using SQL
• Produce weekly, monthly, quarterly and annual reporting on operational metrics with minimal oversight.
• Conduct complex data analysis and visualization using both Python and Tableau.
• Conduct various preliminary data analyses for both internal and external stakeholders.
• Work with stakeholders to understand data consumers’ needs and develop solutions.
• Schedule and coordinate routine database maintenance tasks while supporting the database projects and users.
• Performance monitoring and capacity planning, database installation and configuration, database backup & recovery, patch upgrades, security compliance, Application upgrades, troubleshooting and monitoring.
• Participate in all aspects of a software development project.
• Produces ad hoc data requests as necessary.
• 1st level general technical support for windows, mobile, and hardware issues
• 2nd level technical support for the investment applications and processes
• Produces ad hoc data requests as necessary.

Environment: MS SQL Server 2014/2016, Python 3.7/ 3.8, MS Excel, MS Access, Data Warehouse, SSIS and Tableau 9/10/2020.1, SAP (Business Objectcs)

Confidential - Skokie, IL

Junior SQL Developer

Responsibilities:

• Participates in database design
• Communicate with product managers and business leads for requirements and functionality
• Participates in developing and enforcing standards and best practices
• Manage database design and development
• Creates tests and implements stored procedures and queries in SQL Server
• Creates database object triggers, tables, database, views and stored procedures to reduce complexity for end uses
• Migrates data from multiple data sources like flat files, excel into SQL Server using SSIS
• Involved in taking care of error handling and making the package dynamically work by implementing the checkpoint and breakpoints.
• Generates Excel reports from SQL Statements
• Creates business object reports using SSRS, Report Builder as well as Excel -reports
• Managing the Existing report to meet with requirement.
• Develops, modifies and executes ETL and SSIS packages for data migration
• Queries the database using T-SQL
• Expert in updating stock location and stock quantity and fix any discrepancy in the quantity.
• Identify WMS inbound and outbound processes.

Environment: MS SQL Server 2014, SSIS, SSRS, Report Builder, MS Excel 2014

Confidential

Credit Analyst/ Data Analyst

Responsibilities:

• Develop and analyze results and present insights and recommendations to our clients using Data analysis and Statistics methods
• Develop reports and deliverables for management and communicates with all levels of stakeholders
• Provides ad-hoc data analysis and reporting support to IT.
• Finding and safe keeping of credit documents related to credit portfolio
• Entering and maintaining data on client and application
• Maintenance of database and statistical information of the credit portfolio.
• Supervising, forecasting and analyzing researches and technical data.
• Analyzing client records and using the data to recommend payment plans.
• Conferring with credit associations and references to exchange credit information on clients.
• Evaluating financial status of clients by producing financial ratios through computer programs.
• Review deals and fields questions from junior credit analyst
• Assist the company and client audits.
• Ensuring amenities and courtesy orders are issued.
• Resolving guest problems quickly and efficiently.
• Creating and maintained good technical documentation.
• Performed other duties as assigned.

Environment: MS SQL Server 2008/2012, MS Excel, MS Access, Data Warehouse, SAS

Confidential, MA

Medical Record/Health Service Technician

Responsibilities:

• Function as administrative Technician delivered quality customer service for over 5000 beneficiaries.
• Manage conversion of over 3000 records from Physical records into electronic health records
• Prepare and administering medications, immunizations, venipuncture, basic Hematology, urinalysis, casting and splinting, visual acuity exams and vital signs.
• Support New England’s largest military installation records room.
• Processed over 6000 records for retirement/separation.
• Prepare laboratory specimens, performs electrocardiograms and pulmonary functions.
• Assists doctor with physical examinations, rooming of patients.
• Assists providers with minor procedures to include, Incision and Drainage of wounds, wart removal, circumcisions and minor laceration repairs.
• Schedules patients for follow up visits, coordinates inter-facility patient transfers, call patients with follow up lab results.

Environment: CHCS System, AHLTA System, MS Office 2016, Windows10