We provide IT Staff Augmentation Services!

Data Analyst/ Sql Developer Resume

NY

SUMMARY

  • Highly motivated SQL Server/BI Developer with 6 years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server 2014/2016/2008 , SSRS, Tableau and SSIS.
  • Practical understanding of Dimensional and Relational data models and concepts like Star, Snowflake, Fact and Dimension tables. Good knowledge in normalization/de - normalization, data extraction, cleansing and data manipulation.
  • Experienced in Project-based analytics including Customer Segmentation and Market Basket analysis.
  • Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.
  • Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key, Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
  • Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS) MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS) and Tableau.
  • Experience in creating different visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables.
  • Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
  • Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
  • Hands-on experience with SQL scripts like stored procedures and data validation.
  • Experienced in creating Universe Designer in development process created classes, objects, measures, join conditions, Filters, checking cardinalities, defined hierarchies, checking the integrity of the universes. Used contexts, aliases, shortcut for resolving loops of the Universes and exported the universe to repository
  • Reported KPI's to internal and external account managers, directors, vice-presidents and senior management on a daily, weekly and monthly basis.
  • Extensively worked on Web Intelligence used advanced reporting functionalities such as Master Detail, Cross-Tab, Drill, Filters, Ranking, Graphs, Breaks, Alerts, filters, Prompts, Variables, Formulas, calculation Contexts in building reports, multi-tab report and Scheduling of the reports etc.
  • Worked on OLAP (online analytical processing) and OLTP (online transaction processing)
  • Experienced on Remedy Incident Management, Change Management, Problem Management, Asset Management, SLA and Advanced Health & Care for Business Objects reporting
  • Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

TECHNICAL SKILLS

BI Tools: SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integrating Services(SSIS), Power BI

Databases: SQL server 2008/2008R 2/2012/2014/2016 , MySQL

Languages: MS-SQL, MySQL, Python, Matlab

OS: Windows XP/03/07/10, OS X, Linux/Unix

Front-End Tools: Microsoft Project, Microsoft Office, Microsoft Excel

PROFESSIONAL EXPERIENCE

Confidential, NY

Data Analyst/ SQL Developer

Responsibilities:

  • Analyze users’ transactions and categorizing the data as per their area of interest in expenditures.
  • Implement data cleanup processes and analyzed data integrity problems.
  • Studying user’s transaction and calculating pre and post classification variable like transportation, peak time, population of interests, etc.
  • Classifying transactions to various categories so that meaning Transactional Analysis can be performed
  • Design & analyzes business data to support strategic and tactical decision-making, to assist in long-range business planning, to evaluate the effectiveness of different organizational initiatives, and to support effective, targeted communications.
  • Reviewing data and classifying the tables/measures functions by using multiple queries, views, and procedures.
  • Defining the suitable methodology to undertake the project with the available inputs for the requisite output.
  • Aiding with data trends identification using Excel and other visualization tools.
  • Creating triggers for cascading update and delete operations to maintain data integrity.
  • Building and maintaining SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.
  • Preparing claim data for risk adjustment by extracting, cleaning, and merging from different tables using MySQL.
  • Performing peer review of code and testing to detect and minimize application problems.
  • Finalizing technical / functional specifications as well as analyzing, designing, developing, testing, troubleshooting and debugging of the queries.
  • Assisted managers and business analysts in developing reports, presentations, and analysis for upper management.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs, database design solutions in collaboration with programming team.
  • Leads cross-functional initiatives, with deliverables and meets quality standards, on time
  • Creates Application and System Design Documents
  • Creating complex stored procedures and objects, performance tuning by using SQL Server Advanced T-SQL
  • Creating Metadata view and dynamic view by using advance T SQL
  • Troubleshooting and resolving problems related to database integrity, performance, deadlocking and blocking
  • Developed and implemented BI solutions utilizing Tableau and MySQL
  • Diagnosing and resolving performance problems and opportunities
  • Created and Developed Power BI Reports of companies Hotfix pipeline
  • Designing relational schemas
  • Implementing data security
  • Develops Applications / Reports / Systems / Enterprise Solutions
  • Designs, Develops and Implements Complex Business Rules
  • Responsible for fulfilling end-user requests
  • Provides on call support as required

Confidential

SQL Developer/Data Analyst

Responsibilities:

  • Assist in Daily, weekly and monthly running jobs which must be run manually using SQL server agent scheduler.
  • As part of trouble shooting, has worked on migrating DTS packages to SSIS packages. Developing a replica of data flow process using SQL stored procedures and SSIS.
  • Developing SQL Stored procedures with parameters and User defined functions.
  • Worked heavily on sub-queries, CTE’s, window functions, set operators and Programmable objects in T-SQL.
  • Execution Plans and analyzing them to improve performance of the query.
  • Indexes and Statistics to optimize stored procedures for batch processing.
  • Optimized DTS, stored procedures and jobs into SQL Server to increase overall performance and time/server use of daily functions.
  • Data analysis and data extraction to the sample files to analyze the data between periods of times.
  • Data import and export wizard to load data into database.
  • Time fields, calendars and relative time tables in data warehouse.
  • Identified fact tables and dimension tables, and created data marts for various subject areas as required.
  • Created varies complex cubes per analytical requirements and manage the performance of cubes by modifying measures and dimensions using SSAS.
  • Worked with SSAS on reporting and rectified some errors while pushing data from data warehouse to Reporting.
  • Performance tuning of reports. Monitoring and tuning report performance by analyzing the execution plan of the report.
  • Created Dashboards and shared them using Power BI by creating complex data models in Power Pivot.
  • Created various reports like parameterized reports, cascading reports, ad-hoc reports and dynamic reports using SQL Server Reporting Services (SSRS) and Tableau.
  • Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS and Tableau.
  • Added new facts and dimensions to the data warehouse.
  • Reviewed cube changes and documented according to the requirement based on product valuation and revenue opportunities.
  • Developed cubes by defining data sources and data source views and using SQL Server Analysis Services (SSAS).
  • Develop Tableau reports & effective dashboards after gathering and translating end user requirements.

Confidential

SQL Developer

Responsibilities:

  • Responsible for end to end development of monthly portfolio report required for organization's business performance check.
  • Preparing a claim data for risk adjustment by extracting, cleaning, and merging from different tables using MySQL.
  • Reviewing data and classifying the tables/measures functions by using multiple queries, views, and procedures.
  • Defining the suitable methodology to undertake the project with the available inputs for the requisite output.
  • Formatting the report layout for the requirement of the end users and deploying the developed reports on to the server for the end users.
  • Creating triggers for cascading update and delete operations to maintain data integrity.
  • Building and maintaining SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.
  • Performing peer review of code and testing to detect and minimize application problems.
  • Finalizing technical / functional specifications as well as analyzing, designing, developing, testing, troubleshooting and debugging of the queries.
  • Assisted managers and business analysts in developing reports, presentations, and analysis for upper management. Analyzing and Establishing security features in SQL Server Reporting 2016 Environment.
  • Analyzing already existing reports and increasing the performance on these reports.
  • Worked on Migrating the Reports from SQL Server 2012 environment to 2016 environment.
  • Developing reports using SQL Server Reporting Services in SSRS 2016. Creating various value section in Parameters list, designing cascading parameters, matrix dynamics and more features in Reporting Service.
  • Worked on SQL Profiler, Tuning Advisor in SQL 2016 to increase the performance of the reports.
  • Worked with shared Data source and shared data sets for multiple reports. Deployed the reports from Team Foundation Server to Development Report Manager. Provided Full Reporting Life Cycle support using SSRS.
  • Worked with report subscriptions in SSRS 2016 to send the weekly run automated reports to end users.
  • Worked with Report Snapshots.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Develop SSIS package for implement Slowly Changing Dimension, Fact Load and Dimension Load with Incremental Lookup.

Hire Now