We provide IT Staff Augmentation Services!

Data Analyst/data Analyst Lead/business Analyst Resume

NC

SUMMARY

  • Over 5 years of IT Experience in Data Analysis, Business Analysis, Development, Business Intelligence, Testing, Compliance, administration, support and migration of Microsoft SQL Server database.
  • Expertise in all phases of Software Development Life Cycle including analysis, physical and logical design, resource planning, code development, testing, validation, implementation and maintenance.
  • Expertise in working with executives, managers, and business stakeholders to determine their business requirements and processes.
  • Experience in Requirement gathering, Functional, Technical specifications, System analysis, Design, Development, Testing and Implementation of client/server and web - based applications.
  • Experienced in Technical writing to create Business Requirement Documents (BRD), Functional Specification Document (FSD) and use cases specifications.
  • Good Knowledge on process modelling using UML (Use cases, Sequence Diagrams, Activity Diagrams, etc.)
  • Excellent Team player to work with multiple teams at same time like with testers (QA), developers, and other team members in validation and testing of complex scenarios and maintenance of quality standards of the projects.
  • Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server.
  • Exceptional T-SQL scripting for creating various database objects like Stored Procedures, Functions, Triggers, and Views.
  • Expert in creating SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Expertise in creating and managing Event Handlers, Package Configurations, Error Handling, Logging, System and User-defined Variables for SSIS Packages.
  • Experience in developing and deploying complex Drill-Down reports, parameterized reports, Cascaded reports, Dynamic Reports using SQL Server Reporting Services ( SSRS).
  • Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
  • Proficiency in creating different types of reports such as Parameterized, Cross-Tab, Linked, Drillthrough, Drilldown reports, Top N, Sub reports, and formatting them using SSRS
  • Deployed the SSIS Packages from development server to production server.
  • In addition to excellent technical abilities possesses strong oral and written communication skills, analytical and interpersonal skills.
  • Energetic, quick learner, multi-task ability with exceptional problem solving and attention to detail.
  • Self-motivated, organized and attention to time and deadline management.

TECHNICAL SKILLS

Databases: MS SQL Server 2014, 2012, 2008 R2/2005 Oracle 9i/10g, MS-Access - 2007

ETL Tools: SQL Server Integration Services (SSIS) (2005/2008/2012/2014 ), Data Stage, DTS, SQL Server Analysis Services (SSAS).

Operating Systems: Windows 2012R2/2008/2003 Advanced Server, Windows NT 4.0 / 3.51, and have necessary knowledge of Linux operating system.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 8/10, Excel Pivot.

Programming Languages: T-SQL, C, C++, C #.Net, VB.NET, Visual Basic for Applications (VBA), XML, and MDX.

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Profiler Database Engine Tuning Advisor DTA).

Other: Microsoft Office, MS Project, MS Visio, MS LYNC, SQL Loader, DB visualize, TFS, Quick Test Professional (QTP) and Quality Center (QC).

Internet languages: Java script, XML, HTML, SOAP, Rest, XSL, XSLT.

PROFESSIONAL EXPERIENCE

Confidential, NC

Data Analyst/Data Analyst Lead/Business Analyst

Responsibilities:

  • Worked as a team lead along with 8 others for a team of ~125associates.
  • Worked closely with Senior leadership team members, managers and developers.
  • Handled many tasks to enhance the process and special projects.
  • Extensively worked and completed archiving process (task to analyze and decision files that can be archived from share drive to web storage) by coordinating 45 associates to learn and work on it.
  • Advised on process improvements and “best practices”
  • Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
  • Created new reports based on requirements.
  • Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
  • Re-wrote numerous procedures to conform to documentation standards as well as for clarity.
  • Created numerous procedures from scratch (including extensive screenshots).
  • Re-wrote SQL code for efficiency and changes
  • Created SQL queries for tests from scratch
  • Worked with SQL Queries using joins to facilitate the use of huge tables for processing several records in the database.
  • Experienced in writing and using Stored Procedures, Stored Functions, Database Triggers, and Packages using SQL.
  • Extensively used SQL for accessing and manipulating database systems.
  • Worked on modifying and executing many codes to pull required data from Teradata warehouse.
  • Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents.
  • Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
  • Experience with various ETL, data warehousing tools and concepts.
  • Responsible for creation of SSIS Packages for Data Population into Staging and Dimension area
  • Worked on ETL Automation Testing Tools through SSIS on the Side lines to easy the Testing of Data Population for our Testing.
  • Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
  • Worked with Technical Experts to Improve Report Performance and performed System testing.
  • Worked with the developers during coding and while doing the remediation of the test.
  • Maintained a close and strong working relationship with teammates and management staff to achieve expected results for the project.

Environment: MS SQL Server 2008/2012, T-SQL, Teradata SQL Assistant, Express Studios, Toad, SQL Server Integration Services, Management Studio, SQL Server Reporting services (SSRS), Statistics, SAS and Analytics, C#, .Net, OLE DB, SQL server Profiler, SharePoint & Windows.

Confidential, NY

SQL Developer/Data Analyst

Responsibilities:

  • Involved in requirement analysis and design.
  • Involved in data solutions in support of advanced data analytics enabling the transition from log management to broader analytics.
  • Extensively worked on ETL Load ( SSIS Package), report creation and data visualization including dashboards and reports leveraging charts (Pivot tables), gauges and drill-through.
  • Created SQL Agent Jobs to schedule jobs for extracting data from different source systems using SSIS packages. Stored Procedures are used within these packages to aggregate the data.
  • Created SQL Server Traces in SQL Server Profiler, to collects a variety of information about SQL Server connections, stored procedures and Transact-SQL statements.
  • Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
  • Create on demand Ad hoc reports, Parameterized reports, Linked reports, Snapshot reports, Drilldown reports and Sub reports using SSRS.
  • Created numerous SSIS packages (ETL) to migrate data from different server locations and heterogeneous sources like Excel, CSV, flat file, XML and Text Format Data.
  • Implementing custom analytics and reporting tools to assist clients in market analysis (SAS, Tableau).
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Migrated data from different source locations to Dev / QA environment using SQL 2008 SSIS packages.
  • Created SQL Server Traces in SQL Server Profiler, to collects a variety of information about SQL Server connections, stored procedures and Transact-SQL statements.
  • Created complex stored procedures, triggers, cursors, views, user-defined functions, SQL Server Traces in SQL Server Profiler to collect a variety of information about SQL Server transactions, server performances and Transact-SQL (T-SQL) statements.
  • Executed test scripts, documented defects and verified fixes using bug tracking system BI designer / development / production team.
  • Manually performed transcript data verification obtained from the client's database to validate the integrity of the application.

Environment: MS SQL Server 2008, T-SQL, SQL Server Integration Services, Management Studio, SQL Server Reporting services (SSRS), SQL Server Analysis Services ( SSAS), Statistics, SAS and Analytics, C#, .Net, OLE DB, SQL server Profiler, MOSS, SharePoint & Windows.

Confidential

SQL Developer/Data Analyst

Responsibilities:

  • Worked with Auditing and Error Handling for the SSIS Packages
  • Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
  • Created User defined functions and stored procedures to meet the requirement.
  • Created various Indexes on tables for better Query Performance.
  • Re-designed the File Naming Conventions according to the business user.
  • Used SQL Server Analysis Services (SSAS) to create cubes using data from data marts / data warehouse for deeper and faster data analysis.
  • Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
  • Wrote SQL Scripts for Script Tasks in SSIS Packages.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
  • Deployed the SSIS Packages and created jobs for efficient running of the packages.
  • Involved in performance tuning and monitoring of T-SQL blocks.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Identified and worked with Parameters for SSIS.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008 with .NET applications.

Environment: MS SQL Server 2008, DTS, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services ( SSAS), Business Intelligence Development Studio (BIDS) 2008/2005, MS-Visual Studio, C# and Windows XP.

Hire Now