We provide IT Staff Augmentation Services!

Database Developer/analyst Resume

Newtown, PA

SUMMARY:

  • Overall 5+ years of experience as a developer.
  • 3+ years of experience as a database developer with MS SQL.
  • Experienced in creating stored procedures using T - SQL and error handling blocks.
  • Designing database Schemas from scratch to building one. Analyzing and structuring huge data sets.
  • Designed ER diagrams and mapped the data into database objects and involved in the normalization of the database in OLAP.
  • Automated efficient scripts for ETL using various scripting languages like Python, SQL Server, Batch, SFTP, SSIS which is later used for interactive dashboards, the storyline on the web.
  • Generated various Yearly, Monthly, and Weekly reports by different types of reports using SSRS and Power BI.
  • Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema.
  • Coordinated with business users regularly for enhancing dashboard formats and built the pipeline for refreshing dashboards at one go.
  • Automated the ETL processes using SSIS, Advanced SQL, batch files and using scheduling tools like JaSFTP, WinSCP and CloudBerry.
  • Experienced with AWS CLI and Networking to automate the upload and download files from AWS S3.
  • Experienced on writing stored procedures, views, materialized views, etc. on Snowflake warehouse.
  • Worked with AutoKrypt software to encrypt and decrypt the PHI data files.

SKILL:

Python (NumPy, SciPy), Data loading (SSIS) Data visualization (SSRS, Power BI), Databases (SQL server, MySQL, Oracle 11g/12c), C, C++, Java, Bootstrap, PHP, JavaScript, JQuery, Ajax, JSON, Linux.

EXPERIENCE:

Confidential, Newtown, PA

Database developer/Analyst

Responsibilities:

  • At ground level, I collaborate with sales and marketing teams, reps and manufacturing teams on deciding factors responsible for driving sales. Provide timely technical support and troubleshooting to business users on hardware, software, network and doing a quality check daily.
  • Built pipeline for preprocessing the unstructured data and applying ETL to refresh the dashboard every week with changes as per the business using SQL server and Python.
  • Built structure of SQL databases at back-end as well as queries, improved efficiency by error-checking modules and optimizing querying process.
  • Handled missing data with imputation, developed Feature selection using PCA (Average Square projection error and total variation in data) and scaling the features using standard scaler, Min Max scaler and Normalizer.
  • Create and maintain monthly and weekly department reports.
  • Experience in creating number of stored procedures and complex SQL queries.
  • Created Automation process to import raw data and processed it.
  • Familiar with JIRA and Scrummage tool.
  • Built Automation process to load raw data from different sources like email, SFTP, AWS cloud, etc. using SSIS and applying ETL for transferring and loading data.
  • Automated the ETL processes using SSIS, Advanced SQL, batch files and using scheduling tools like JaSFTP, WinSCP and CloudBerry.
  • Experienced with AWS CLI and Networking to automate the upload and download files from AWS S3.
  • Experienced on writing stored procedures, views, materialized views, etc. on Snowflake warehouse.
  • Generated various Yearly, Monthly, and Weekly reports by different types of reports using SSRS and Power BI.
  • Worked with AutoKrypt software to encrypt and decrypt the PHI data files.
  • Interpret data, analyze results using statistical techniques and provide ongoing reports.
  • Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
  • Acquire data from primary or secondary data sources and maintain databases/data systems.
  • Identify, analyze, and interpret trends or patterns in complex data sets.
  • Work closely with management to prioritize business and information needs.
  • Developed new report management system that increased productivity 25%.

Confidential

Full Stack Developer

Responsibilities:

  • Joomla version 1.5 migration to version 2.5.
  • Collaborated with staff and teams to develop Virtual Tech Team
  • Designing the database for Confidential and Co-ordinate with other programmers to solve specific tasks.
  • Designed the flow of Virtual Tech Team.
  • Estimated the Work Break Down Structure for the system.
  • Interaction and Daily updates to the client.

Confidential

Full Stack Developer

Responsibilities:

  • Designing flow chart, database tables and UML diagrams.
  • Documenting daily work status.

Hire Now