We provide IT Staff Augmentation Services!

Sr. Data Analyst Resume

3.00/5 (Submit Your Rating)

Long Beach, CA

PROFESSIONAL SUMMARY:

  • 6+ years of experience in system analysis, design, development using Netezza, SQL Server 2012/ 2008R 2/2008/2005/2000 in DEV and QA environments with various domains like Accounts, Insurance and Health Care.
  • Strong Experience in MS SQL Server 2012/2008R 2/2008/2005/2000 with BI in SSIS/SSAS/SSRS, OLTP & OLAP.
  • Experience in T - SQL (DDL, DML), Complex Queries, Tables, Views, Stored Procedures, Indexes, User Defined Functions and Triggers.
  • Experience in Netezza with Developed and Maintained Stored Procedures, Views, Sequences, Synonyms
  • Experience in Built ETL Code using custom Netezza SQL scripts and Data Stage to pull data from the source systems
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, MS Access, Oracle to MS SQL Server by using DTS/SSIS services.
  • Experience in Built new and update existing DataStage Jobs.
  • Experience in writing SSIS Template Package using - Configuration, Logging, Error Reporting and Variables in SQL Server Integration Services to make package portable which Deployment and Troubleshooting.
  • Designed and developed OLAP Cubes with star schema and Dimensions using SSAS. Querying and manipulating multidimensional cube data through MDX Scripting .
  • Experience in performing Data Conversion, Data Scrubbing, and Data Transformations with SSIS Packages and stored Procedures.
  • Hands on experience with Data Mapping and Data Dictionary.
  • Work extensively with Business Owners in defining and publishing data dictionary.
  • Experience in creating Mapping document for ETL process.
  • Experience in creating Data Lineage.
  • 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 and worked with Normalization and De-Normalization techniques for both OLTP and OLAP systems.
  • Experience in design and implement processes for Deploying and Extracting data for reporting using SQL Server Objects.
  • Experience in generating reports using Crystal Reports, SSRS (SQL Server Reporting Service) and Excel spreadsheet.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
  • Experience in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, merge, Merge join, union all, and slowly changing dimension.
  • Experience in data normalization and data modeling using Erwin and Visio.
  • Created Chart, Gauge, Drill Down, Drill Through, Sub Report, parameterized reports using SSRS (SQL Server Reporting Services)
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Highly organized with the ability to manage multiple projects and meet deadlines.
  • A team player with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS:

SQL, IBM Server Tools: Netezza, DataStage, MS SQL Server 2012, 2008R2, 2008, 2005, 2000, Management Studio, Business Intelligence Development Studio, DDL, DML, Stored Procedures, UDF, Triggers, DTS, SSIS, SSAS, SSRS.

Operating Systems: Windows Server 2008/2007/2003/2000, Windows XP/98/95.

Data Migration: SSIS, BCP, Data Migration, Import/Export Wizard.

Languages/IDEs: C, C++, C#, T-SQL

Data Modeling: Erwin 4.x, r9, MS Visio 2003/2007.

Web Technologies: ADO.NET, HTML, XML, Web Services, Visual Studio 2008/2016

Reporting Tools: SQL Server 2016/2008R2/2008/2005 Reporting Services

Office Suite: / Tools MS Office 2007/2003

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Analyst

Responsibilities:

  • Involved in gathering business requirement with Developers, Database architect and business users.
  • Support development and implementation of Warehouse. Extracting relevant data for exterminations and Inspections.
  • Responsible for working with source data and leading the mapping documentation of all source data elements.
  • Created Stored Procedures, functions, views, tables for tracking the package execution process.
  • Created SSIS packages for Incremental Load. Using Merge statements/stored procedure.
  • Created data Warehouse packages to load slowly changing dimensions (SCD1 and SCD2).
  • Implemented all types of control flow and data flow transformations in packages to handle different logics.
  • Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard
  • Created Reports using SSRS Dashboard - Parameterized, Drill Through, Drill Down, Link, Chart, Gauge report based on parameter and scheduled Monthly, Quarterly, Daily, and Yearly reports.
  • Provided Production Support for Live code running in production and implemented necessary changes trough release management team.
  • Developed Reports for business end users using Report Builder with updating Statistics.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS
  • Scheduled and managed daily/weekly/monthly operational reports based on the business requirements.
  • Advise proper SSRS standards and created documentation on standard set forth for report formatting
  • Created documents for UAT and test cases to insure all business requirements.
  • Used Microsoft Visual Source Safe to check in and checkout projects.
  • Written Technical documents for each object created on Database and SSIS.

Environment: MS SQL Server, T-SQL, SSIS, SSRS, Visio, MS Excel, MS Word, Visual Studio (BIDS)

Confidential, Long beach, CA

Sr. Data Analyst

Responsibilities:

  • Involved in Netezza EDW Architecture and Implementation, Data Migration to Warehouse.
  • Involved in remediate SSRS reports SQL to Netezza in order to start the EDW platform for existing business functions and allowing the replacement of QNXT copy infrastrucure.
  • Interacting with Health plans to obtain reports and mapping documents to support Reintegration efforts.
  • Worked With offshore reintegration teams to obtain timelines in order to sync with overall HP.
  • Involved gathering .sql scripts remediate to Netezza and reintegrate in to SSRS reports in order to get the same result from Netezza database.
  • Created drill down, drill through, multi parameterized reports, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
  • Interacting with client and collecting the requirements.
  • Create and Define remediation process and Netezza training for all the HP.
  • Involved Creating remediation process and providing solution to 3rd party vendor for remediation. Performed the ETL operations to support the data loads and transformations using SSIS.
  • Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system.
  • Involved in the upgrading SSIS packages process from 2008R2 to 2014.
  • Complete remediation of defined active reports for Business (Health Plans and Corporate) and for IT.
  • Define decommission strategy for QNXT copies, including schedule.
  • Retire QNXT Report Copy infrastrucure.
  • Capturing business process requirements.
  • Ensuring that all the business needs are well captured.
  • Understanding business requirements and providing appropriate solutions to clients.
  • Studying the existing system and conducting reviews.
  • Writing queries to pull analytical data for reporting purposes.
  • Analyzing the data in the backend system and providing data mining solutions, pinpointing the trouble areas and providing the business users data in a summarized format.

Environment: Netezza, Datastage, Aginity Workbench for Netezza, WinSQL, Windows Script Files (.wsf), Visual Studio 2010 TFS, MSSQL 2008 R2, SSIS, SSRS, Microsoft Office 2010.

Confidential, Mountlake Terrace, WA

SQL\ Netezza Developer

Responsibilities:

  • Involved in gathering business requirements and build design specs for ETL packages and reports.
  • ICD 10 remediation for Diagnostic and procedural codes.
  • Built ETL Code using custom Netezza SQL scripts and Data Stage to pull data from the source systems (FACETS) to a 3NF.
  • Integrated Relational Database ( Corporate Data Warehouse).
  • Actively involved in writing T-SQL Programming for implementing Tables, Stored Procedures, Views, Joins, Triggers, User Defined Functions and Stored Procedures for different tasks.
  • Created Clustered and Non Clustered Indexes on tables
  • Created data Warehouse packages to load slowly changing dimensions (SCD1 and SCD2).
  • Wrote complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
  • Performed the ETL operations to support the data loads and transformations using SSIS.
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server2005/2008
  • Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based the design data models.
  • Worked on various Sources and transformations like Data Flow Task, Execute Package Task, Conditional split, OLEDB Command, Row Count, Merge and Lookup while loading the data into Destination.
  • Scheduling the SSIS packages and Jobs.
  • Designed Dynamic SSIS Packages by Configuration to transfer data across different platforms.
  • Developed and Maintained SQL Queries and Stored Procedures, Sequences, Synonyms (Netezza).
  • Built ETL Code using custom Netezza SQL scripts to pull data from 3NF Integrated Relational Database to a star schema Data Mart.
  • Experience in loading data into Netezza using NZLAOD utility.
  • Experience in loading data between Netezza tables using NZSQL utility.
  • Built new and update existing Datastage Jobs.
  • Built WSF script to run the ETL Code.
  • Create detail design documentation for SQL scripts and Data stage jobs.
  • Used TFS as source control system to check in code.
  • Used TFS for PBI and Release tracking.
  • Created deployment script for DDL and DML code.
  • Used Final Builder to deploy code from one environment to another.
  • Built Unit Testing (SDLC) SQL Scripts and documents.
  • Used of Agile and Scrum methodologies.

Environment: Netezza, DataStage, ERwin Data Modeler, Aginity Workbench for Netezza, WinSQL, Windows Script Files (.wsf), Visual Studio 2010 TFS, MSSQL 2008 R2, SSIS, Microsoft Office 2010.

Confidential, Long Island City, NY

Associate

Responsibilities:

  • Participated in database logical and physical design to fit new business requirement, and implemented new design in SQL Server 2008
  • Responsible for defining and establishing standards of proper data mapping of all source data elements.
  • Took lead on defining a Document Library that contained Data Dictionary to be used by corporate to fundamentally understand what each data element is used for and the Business Owner that is responsible for the data element.
  • Normalized the database by applying rules of Normalization, defined Check Constraint and applied Business Rules.
  • Actively involved in writing T-SQL Programming for implementing Tables, Stored Procedures, Views, Joins, Triggers, User Defined Functions and Stored Procedures for different tasks.
  • Created Clustered and Non Clustered Indexes on tables
  • Performed the ETL operations to support the data loads and transformations using SSIS.
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server2005/2008
  • Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based the design data models.
  • Worked on various Sources and transformations like Data Flow Task, Execute Package Task, Conditional split, OLEDB Command, Row Count, Merge and Lookup while loading the data into Destination
  • Scheduling the SSIS packages and Jobs
  • Designed Dynamic SSIS Packages by Configuration to transfer data across different platforms.
  • Wrote complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements
  • Created views to facilitate easy user interface implementation, and Triggers on them to facilitate consistent data entry into the database.
  • Developed different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SQL Server 2008 Reporting Services.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
  • Documentation of all the processes involved in maintaining the database for future reference.
  • Develop documentation that sufficiently describes technical deliverable as required for internal controls and maintaining documentation of the database for future reference.
  • Created ER diagrams (logical design) by ERWIN tool and mapped the data into database objects
  • Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
  • Created Views for specific columns on a table to maintain privacy of a customer data
  • Created and tuned Indexes to get the high level performance.
  • Performed the ETL operations to support the data loads and transformations using SSIS.

We'd love your feedback!