We provide IT Staff Augmentation Services!

Data Analyst Resume

Sunnyvale, Ca

SUMMARY:

  • 4 years of experience in Analysis, Design, Implementation of Business Applications using SQL Server, Oracle Relational Databases Management systems.
  • Extensive working experience in Normalization and De - Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default) and indexes.
  • Participated actively in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, Go live and Post Go Live Support.
  • Experience with various databases like Oracle, SQL Server, Teradata and DB2.
  • Strong experience in Data Analysis, Data Profiling, Data Cleansing & Quality, Data Migration, Data Integration.
  • Good knowledge about the Teradata Architecture and Concepts.
  • Extensive experience in Stored Procedures, Triggers, Functions, Cursors, Views, Materialize Views and Analytical Functions.
  • Experience in data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and UNIX/Mainframes environments.
  • Good knowledge in SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse.
  • Involved in SSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
  • Created SQL queries to validate data transformation and ETL Loading.
  • Experience in metadata clean-up and processing at regular intervals for better quality of data.
  • Good knowledge on Pivot Table reports in Microsoft Excel.
  • Experience in Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Experience in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
  • Involved in generating Drill down, Drill through reports using Local and Global Variables, Expressions and Filters in SSRS.
  • Experience in creating the reports basing on the requirements using SSRS
  • Good knowledge in SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
  • Good understanding of Relational Database Design, OLAP concepts and methodologies.
  • Involved in complete Administration tasks on UNIX (SUN Solaris, Red Hat Linux, and AIX) and documentation for the projects executed.
  • Installation and support of 3rd party software systems on UNIX like Web Servers, Application Servers, Middleware and Databases.
  • Experience in programming for generating graphs, data listings and tables using data steps, procedures, SQL.

TECHNICAL SKILLS:

Programming Languages: - R, Python, Java, C#.

Databases: - MySQL, T-SQL, NoSQL(MongoDB), MS Access.

Operating Systems: - Linux, Windows, MacOS, Unix.

Tools: - Pentaho, Informatica, MS SQL Server, Tableau, Eclipse, AWS - EC2, MS Visio, Optimizely.

Web Technologies: - HTML, CSS, JavaScript, JQuery, AJAX, Bootstrap.

Functional Skills: - SDLC, Methodologies - Agile,Waterfall, Critical thinking, Team Management.

Concepts: -Data Visualization, Data warehouse, Data mining, ETL, OLAP and OLAP Cubes, Semantic Web, RDF, SPARQL, Configuration Management (SVN, GIT, ant, maven), MapReduce, Hive, Hadoop, Salesforce, SPSS, SAS, SSIS, SSRS, SSAS, Ontologies, Design Patterns, Data Structures and Algorithms, Statistics, Machine learning, Microsoft Office Suite (Word, Excel, Access, PowerPoint, Outlook, VLOOKUP, Macros, Pivot Tables),Presentation and Survey Design.

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Data Analyst

Responsibilities:

  • Analyze all the business strategies, rules and file formats to design maps and transformations in Informatica.
  • Collected and documented business requests and effectively converted into implementable solutions.
  • Developed and published well-organized, accurate, and insightful Tableau reports/dashboards/Storyline with different charts and advanced functions to support strategic decisions.
  • Maintained Tableau dashboards and data sources on the Tableau server.
  • Accurately and effectively analyzed data, patterns, and trends with Tableau and Excel.
  • Developed and optimized complex SQL queries and ensured optimal performance using joins, grouping, aggregation, sub queries, and views to retrieve data from relational databases.
  • Developed logical and physical models in the relational database.
  • Managed the integrity, structure, and organization of data to maximize its value and accuracy with queries.
  • Extracted data from various data sources, and transformed, cleaned, validated, and loaded data into Oracle databases, flat files, spread sheets, Salesforce, and other destinations.
  • Tracked and documented data issues in the systems and coordinated with clients to resolve the issues.
  • Translation of business requirements and technical designs into test specifications and test cases.
  • Worked on continuously updating the information in the Avature of the university relations team.
  • Conducted data analysis to research root cause for data gaps, discrepancies and derive insights using analysis.

Environment: Teradata, Tableau, MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, UNICA 6.4, Erwin Tool, Informatica, Salesforce.

Confidential, Milpitas, CA

Data Analyst

Responsibilities:

  • Clustered customers with R & defined improvement projects as redistributed resources and saved 11% of the company’s budget and Participate in requirement gathering and analysis.
  • Work with users to identify the most appropriate source of record and profile the data required for sales and service.
  • Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
  • Involved in defining the business/transformation rules applied for sales and service data.
  • Define the list codes and code conversions between the source systems and the data mart.
  • Worked with internal architects and, assisting in the development of current and target state data architectures.
  • Involved in defining the source to target data mappings, business rules, business and data definitions.
  • Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
  • Responsible for defining the key identifiers for each mapping/interface.
  • Responsible for defining the functional requirement documents for each source to target interface.
  • Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
  • Coordinated meetings with vendors to define requirements and system interaction agreement documentation between client and vendor system.
  • Created SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse.
  • ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
  • Deliver reports and ad-hoc analysis focused in the area of client behavior and profiling using SAS, SQL and Excel.
  • Designed SSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
  • Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.

Environment: Teradata, Tableau, MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, UNICA 6.4, Erwin Tool, SSIS & SSRS.

Confidential, Somerset, NJ

Data Analyst

Responsibilities:

  • Designed and developed various analytical reports in Tableau Desktop, expert in quantitative problem solving.
  • Expert in Design, build and automate dashboards and custom reports.
  • Participated on the risk management teams to onboard tranche 1- 10 departments.
  • Responsible for data validation across the risk management systems.
  • Created requirements document with end-to-end traceability.
  • Generating responsiveness, turnaround time related metrics and performance dashboards to the management on a weekly basis.
  • Weekly project status reporting, tracking milestones, issues, risks and action items.
  • Experience in Data Modeling, Integration, Analysis, Reporting and Visualization.
  • Coordinated with team members to create impactful analyses and forward-thinking strategies.
  • Communicate with executives and managerial staff regarding data findings and potential new-technologies, data entry, data auditing, creating data reports & monitoring all data for accuracy.
  • Demonstrate exposure/experience in data profiling, cleansing and data wrangling techniques.
  • Excellence in data structures, programming and Demonstrated experience in understanding of complex data. Solid understanding of big data ecosystem and ability to acquire/ingest data.
  • Strong Analytical problem-solving skills and involved in SWOT analysis.
  • Involved in creating various documents such as Use case, Business and Functional Requirement Specifications. Well versed in Project Management skills like MS Project for project planning and scheduling. Able to process new data quickly and communicate it effectively to lay individuals.
  • Created SSIS packages to load data into Data Warehouse using tasks like Execute SQL Task, data flow task and expert in designing of ETL (Extract, Transform, and Load) flows.

Environment: Tableau 9.0, SQL Server 2012/2014, Windows XP, Microsoft Project 2000, HTML, R, Linear Regression, MS Excel, MS PowerPoint, MS Visio and MS Outlook.

Confidential, Somerset, NJ

Data Analyst

Responsibilities:

  • Developed and Tested web pages and also used visualization for Graphs, Charts, etc. and worked with SQL scripts, Map Reduce, query optimization and operated with data schemas to manipulate data for data loads and extracts.
  • Used MS Excel to maintain the research database and generated spreadsheets, pivot tables and dashboards, developed and initiated more efficient data collection procedures.
  • Built Databases, Stored Procedures, Packages, Table structures and Views, writing queries using SQL Server. Designed UML diagrams and work flow diagrams by using MS Visio.
  • Involved in creating database objects like tables, procedures, triggers and functions to maintain data efficiently. Participated and facilitated discussions through JAD sessions, conference calls and business workshops held to plan business strategy.
  • Hands on experience in using project management, modeling tools such as MS Project, MS Visio, Microsoft Office Suite.
  • Conducted research tests and performed analysis to determine best solutions to improve product quality.
  • Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop Down menu option and Parameters using Tableau.
  • Responsible for extracting, compiling and tracking data for making reports weekly & monthly basis.
  • Effectively identified errors and issues involving data flow discrepancies, improved effectively.

Environment: MS Excel, MS Office 2007, SQL Server 2012/2008R2, Visual Studio 2010, Tableau

Confidential

System Configuration Specialist

Responsibilities:

  • Code, test, debug, document and implement Informatica maps following ETL procedure.
  • Identified sources and performed data profiling on the identified sources.
  • Prepared specification documents (BRD / FRD), based on business rules given by Business.
  • Prepared Business Process and Data Process Models using MS Visio.
  • Involved in Data Migration between Teradata, MS SQL server, DB2 and Oracle.
  • Involved in data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and UNIX/Mainframes environments.
  • Extensive experience in Stored Procedures, Triggers, Functions, Cursors, Views, Materialize Views and Analytical Functions.
  • Knowledge in developing SAS Programs using SAS/Base, SAS/macro and SAS/SQL.
  • Involved in Installing Firmware Upgrades, kernel patches, systems configuration, performance tuning on Unix systems.
  • Involved in troubleshooting of UNIX technical problems received through e-mail and Clarify Ticketing Tool, Backup solutions according to the SOP & SLA. Generating reports, Preparing Quality Documentations & uploading to VSS tool.
  • Validated data in the report against the business data by running the SQL queries against the Teradata and Oracle.
  • Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
  • Experience in creating the reports basing on the requirements using SSRS.
  • Created Parameterized, Cascaded, Drill-down, and Drill-through reports using SSRS.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Participated in daily Scrum meetings to review the status of sprint backlogs and sprint review meetings to discuss the accomplishments and issues faced.
  • Worked on metadata clean-up and processing at regular intervals for better quality of data.
  • Extract, summarize and compile data for required external reporting, Including Weekly Metadata Reports for the Data Integrity.
  • Created a database of the frequently faced issues& launched troubleshooting webpage, reducing problem by 40%

Environment: Teradata15.10, PL/SQL, UNIX, MS SQL Server 2012, SSIS & SSRS, MS Office, SCRUM, Microsoft Visio, Erwin Tool, Tableau.

Confidential

Business Data Analyst

Responsibilities:

  • Clustered customers with R & defined improvement projects as redistributed resources and saved 11% of the company’s budget and Participate in requirement gathering and analysis.
  • Collaborate with clients to extract &transform the confidential projects data for firm’s analytical engines usage and automated the generation of data quality and reports using tableau, cutting down total analysis time by 75%.
  • Designed, developed, and maintained tables, views, and other SQL server database objects.
  • Performed ETL and maintained data quality against relational database.
  • Generated Tableau dashboards/reports with the medical and research data from various sources.
  • Troubleshot Tableau Server issues and explained Tableau Server functionality to users.
  • Successfully analyzed data with Excel, Power BI, and the statistical tool SAS.
  • Summarized and presented project updates/analytical findings/problem-solving proposals.
  • Trained new team members and new users.
  • Excellently used Salesforce for Nonprofits proficiency using Salesforce data uploads, Report creation, etc.
  • Used Hive data warehouse facilities reading, writing, and managing large datasets in distributed storage using SQL.

Environment: Teradata, Tableau, MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, UNICA 6.4, Erwin Tool, ETL(Informatica), SAS.

Hire Now