We provide IT Staff Augmentation Services!

Data Analyst/sql Developer Resume

Boston, MA

PROFESSIONAL SUMMARY:

  • Overall 7 years of IT experience in complete Software Development Life Cycle and Agile Methodologies including Requirement Analysis, Design, Development, testing, Implementation.
  • Have strong technical foundation with in - depth knowledge in Data reporting, Data Design, Data Analysis, Data governance, Data integration and Data quality.
  • Experience in Database Development, Data Warehousing, Data analysis, Data excavation.
  • Strong Expertise in SQL Server 2005/2008/2012 components such as SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), Power BI
  • Experienced in SSAS (SQL Server Analysis Services).
  • Involved in working with various environments like UNIX, LINUX and Windows.
  • Worked on Relational (MySQL, Oracle) and NOSQL (Mongo DB) databases.
  • Adept at interfacing with end users to gather requirements and produce functional requirements, Ample knowledge of Relational Database Management Systems (RDBMS) & Entity Relationship Diagram (ERD).
  • Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data
  • Experienced in Power BI to create visualizations and reports for requested projects.
  • Experienced in Power BI to create dashboards and maintain the schedules for refresh the data.
  • Experienced on subscriptions, report snapshot and report cache.
  • Expert in Extracting and Transforming data using SSIS in SQL Server 2005/2008/2012 , SQL Server Import Export Wizard, Bulk Insert Task and Bulk Copy Program (BCP).
  • Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file.
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012 ) generated drill down reports, parameterized reports, linked reports, sub reports in SSRS 2005/2008/2012 using Tabular format.
  • Experienced in DAX programming language used in Power BI. And having knowledge of AZURE services.
  • Experienced in automating the system by using Notification service and creating alerts, jobs and maintenance plans.
  • Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
  • Expert in customizing SSIS Script Task and Script component using c#.net
  • Will work "hands-on" when required but understands the value and importance of delegating work and responsibilities.
  • Proficient in High Level Design of ETL DTS Package for integrating data from heterogeneous sources.
  • Good knowledge of Data Marts, Data warehousing, OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
  • Experience on high performance data integration solutions- including extraction, transformation, and load (ETL) packages for Data Warehousing and Data Marts.
  • Quick learner, excellent communication skills and good performer both in team and independent job environments.
  • Having extensive experience with reporting tools SSRS, Report Builder and Power BI
  • Developing report dashboards using Microsoft SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and Microsoft Excel.
  • Experience working with Erwin
  • Implemented machine learning algorithm Linear Regression using Python.
  • Analyzing data using advance Excel functions such as Pivot Table, Charts and Graphs.
  • Developed various use cases, class diagrams and sequence diagrams using UML (Unified Modelling Language).

TECHNICAL SKILLS:

Programming languages: Python, Java, C, SQL (T-sql, pl/sql)

Web Technologies: HTML5, CSS, JavaScript, AWS, XML, JSON

Operating Systems: Linux, UNIX, Windows

Database: MySQL, SQL, SQL server, oracle, MS SQL Server 2005/2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, Visual Studio, SSMS, Bulk Copy program (BCP), SQL Server Data Tools

IDE: PyCharm, Jupyter notebook, SSMS, visual studio .Net

Python libraries/modules: Pandas, NumPy, Matplotlib, Seaborn

Reporting Tools: MSBI tools (SSRS, SSIS, SSAS), Tableau

Source Version Control: GIT

PROFESSIONAL EXPERINCE:

Confidential, Boston, MA

Data Analyst/SQL developer

Responsibilities:

  • Extensively involved in creating SSIS Packages to migrate data from various sources and loading them into SQL Server Database.
  • Played major role on production support (operations) running and scheduling jobs, backups and so on.
  • Involved in SSIS Package creation from package design documents to package build.
  • Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.
  • Performance tuning of stored procedure, SSIS Packages and reports.
  • Wrote complex Join queries using T-SQL.
  • Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
  • Created Test packages to validate the SSIS packages build.
  • Created and modified Stored Procedures, Functions, and Indexes.
  • Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
  • Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.
  • Performed data extraction from MySQL data base to the Jupyter notebook.
  • Worked on SQL Queries, Stored procedures, created tables, views to pull data from database.
  • Performed data cleaning and data analysis using python.
  • Worked with python libraries like pandas and NumPy for data analysis and data cleaning.
  • Automated recurring reports using SQL and Python and visualized them on BI platform like Tableau.
  • Perform data wrangling operations to clean data from different sources and experimenting with predictive models and explanatory analysis to discover meaningful patterns.
  • Implemented machine learning algorithm Linear Regression using Python.
  • Developed sophisticated data models to support automated reporting and analytics.
  • Visualized data effectively using matplotlib and created dashboards using Tableau.
  • Designed Tableau Bar Graphs, Scatter Plots and Geographical maps to create detailed level summary reports and dashboards.
  • Prepared scripts to ensure proper data access, manipulation and reporting functions with R languages.

Environment: SQL Server 2012, TFS, Microsoft Visual Studio 2012, T-SQL, SSIS, SSRS, Python, MySQL, Jupyter Notebook, Tableau, MS Excel, R.

Confidential

Data Analyst /SQL developer

Responsibilities:

  • Implemented triggers and stored procedures and enforced business rules via checks and constraints.
  • Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
  • Worked on querying data and creating on-demand reports in SSRS reports and send the reports via email.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Created Parameterized, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
  • Worked on SQL Server Upgrade from 2008R2 to 2012.
  • Migrated SSRS reports from 2008 to SSRS 2012.
  • Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.
  • Scheduled the SSIS packages and Jobs
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
  • Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS).
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Performed data transfers using BCP and BULK INSERT utilities.
  • Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as .
  • Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Environment: SQL Server 2008 R2, SQL Server 2012, Microsoft Visual Studio 2008/ SQL Server Data Tools, T-SQL, SSIS, SSRS

Confidential

Data analyst

Responsibilities:

  • Extensively involved in designing the integration part to flow the data form one system to another by interacting with the business users from multiple systems.
  • Extensively involved in design of AWS servers of test and UAT environment and designed the ETL data model based on the existing database table structures.
  • Coding of SSIS Packages to migrate data from various sources and loading them into SQL Server Database.
  • Performed Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.
  • Designed and developed the Power Bi solution for reporting and dashboard creation.
  • Performance tuning of stored procedure, SSIS Packages and reports and Wrote complex join queries using T-SQL.
  • Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
  • Created and modified Stored Procedures, Functions, and Indexes.
  • Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes and scheduled.
  • Design and developed the Power Bi solution to create reports, visualizations and dashboards as per the business requirements and published enterprise.
  • Scheduled the data refresh for dashboards and reports to show the live data.

Environment: SQL Server 2012, TFS, Microsoft Visual Studio 2012, T-SQL, SSIS, SSRS, Power BI

Hire Now