We provide IT Staff Augmentation Services!

Data Analyst Resume

Dallas, TX

SUMMARY

  • Over 9 years of experience in IT, as SQL Server Developer in Healthcare, retail and banking sector.
  • Created logical and physical Database Design, data structures, Data Modelling, Schema Design
  • Highly proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from heterogeneous data sources such as Oracle, DB2, Sybase, Excel, MS Access, CSV, Oracle and flat files.
  • Proficient in creating, configuring and fine - tuning ETL workflows designed in DTS and SSIS.
  • Experience in creating jobs, alerts, SQL Mail Agent and schedule SSIS Packages.
  • Experience in C# and VB Dot Net Script for further automation.
  • Good knowledge on Server Side and User Side scripting.
  • Good knowledge in Star Schema and Snowflake Schema in Data Warehouse Dimensional Modeling.
  • Extensive experience creating SSAS cube, processing cube and deploying cube to production.
  • Strong experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
  • Expert in designing complex reports using Cascading parameters, Drill-Through, Parameterized, Sub-Report models and ad hoc reports and also deploying SSRS reports on the portal for user accessibility.
  • Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
  • Extensive experience in creating SSRS reports like BAR and PIE Charts, Linked reports, Dashboard, Scorecard reports.
  • Very good concept of Python data analysis knowledge series and Data frames.
  • Plot lines, bar charts, horizontal bar charts, pie charts, Plot histograms, scatter plots and scatter matrix with color map, box-plot, Know the keywords (legend, subplots, cmap, etc) in Pandas plot.
  • Write anonymous (lambda) functions.
  • Analyze one variable statistics by row or column in an array.
  • Use sum, count, and mean functions on a set of data.
  • Use the describe function to generate commonly used statistics.
  • Calculate the correlation coefficient of two data sets and boxplot and adjust display setting of a boxplot. Remove outliers from a boxplot display.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003/2008,XP,7,LinuxLanguages Programming R, Python, C#, VB

RDBMS: SQL Server 2000/2005/2008 R2/2012/2014

Modeling: ER Diagram, Visio

Other Tool: TOAD, SSMS, SSDT, Visual Studio, SVN

Other Application: MS Office Suite, Informetica Power Center, UC4, JIRA, TimeCamp

Reporting Tools: SSRS, Crystal Report, Oracle Report

BI Tools: Toad, Microstrategy, Power BI, QlikView

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Data Analyst

Responsibilities:

  • Built multifunction readmission reports usingpython pandas
  • Worked on Python OpenStack APIs and used NumPy for Numerical analysis.
  • Interpret data, analyze results using statistical techniques and provide ongoing reports
  • Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
  • Worked on development of SQL and stored procedures on MYSQL
  • Acquire data from primary or secondary data sources and maintain databases/data systems
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems
  • Work with management to prioritize business and information needs
  • Locate and define new process improvement opportunities
  • Created an aggregated report daily for the client to make investment decisions and help analyze market trends.
  • Built an internal visualization platform for the clients to view historic data, make comparisons between various issuers, analytics for different bonds and market.
  • The model collects, merges daily data from market providers and applies different cleaning techniques to eliminate bad data points.
  • The model merges the daily data with the historical data and applies various quantitative algorithms to check the best fit for the day.
  • Captures the changes for each market to create a daily email alert to the client to help make better investment decisions.
  • Built the model on Azure platform using Python and Spark for the model development and Dash by plot for visualizations.
  • Built REST APIs to easily add new analytics or issuers into the model.

Confidential, San Antonio, TX

BI Analyst

Responsibilities:

  • Accumulate BSA’s requirement.
  • Review and validate Data warehousing data as it is collected.
  • Oversee the deployment of data to the Data Warehouse.
  • Create different view for using validation in procedure.
  • Develop policies and procedures for the collection and analysis of data.
  • Create SSIS Packages for extracting data from source table to BSA database table.
  • Create unit test for each Procedure after ALTER it.
  • Create Technical Document for each Release or Change request.
  • Deploy the change into SVN with BACKOUT copies of each change/new release
  • Cooperate with our Admin Section deploy software and hardware upgrades that make it possible for us to leverage big data use cases
  • Monitor analytics and metrics results
  • Hire a Data Architect to initiate and maintain data deployment
  • Implement new data analysis methodologies
  • Review customer files to ensure integrity of data collection and utilization
  • Perform data profiling to identify and understand anomalies

Confidential, Richardson, TX

BI and Database Developer

Responsibilities:

  • Data Mapping with OMS table with AS/400 table using SAP Business Object and MS Excel.
  • Create SQL Queries and using business logic from multiple tables to one table data extract.
  • Create database tables and view as per client’s design.
  • Develop database diagram in SQL Server 2014.
  • Create Procedure and function for loading data into staging tables.
  • Developed database batch process to move reference data of the stage to the target System.
  • Create Procedure for checking in stage database data.
  • Create Procedure for any changing in staging database in reflect to
  • Create SSIS packages for loading data from Stage to Production.
  • Created alerts for successful or unsuccessful completion of scheduled jobs.
  • Developed ad-hoc queries for end users
  • Created tabular, matrix, cascading, sub reports and drill through and drill down reports using SSRS 2014 on the new database
  • Created pie and bar graphs for Spending, Income, Assets and Debts modules
  • Deployed reports online and scheduled them to email as requested by some of the users. Scheduled the monthly/weekly/daily reports to run automatically
  • Responsible for efficient design and usage of various attribute dimensions like Customer, Product, Payment, Geographic and Time dimensions, and integrating them into reports displaying forecasting metrics.
  • Act as the primary interface to the architecture team and influence architectural decisions based on their platforms needs and the usage of tools to support the Business Intelligence architecture.
  • Provide governance to the review processes and effectively communicate out project status.
  • Created Special technically directed documents for better acceptance of the reports.
  • Create Integration services Catalog for deploy SSIS packages.
  • Deploy SSIS Packages in SSMS deployment.

Confidential, Plano TX

Project Lead

Responsibilities:

  • Created SQL server 2014 database for their sales application Business Logic.
  • Converted Access database logic into SQL Server 2008 R2, 2012 and 2014 using SSMS (SQL Server Management Studio).
  • Created data models using MS Visio and ERwin
  • Created tabular, matrix, cascading, sub reports and drill through and drill down reports using SSRS 2008 R2 on the new database for budgets, expenses, categories and cash flow modules.
  • Created pie and bar graphs for Spending, Income, Assets and Debts modules
  • Deployed reports online and scheduled them to email as requested by some of the users.
  • Used SSIS 2008 R2 to create process flows of various Account portfolios.
  • Managed and tuned the SQL Server 2008 R2 database.
  • Created and maintained new stored procedures, functions & views according to user requirements.
  • Scheduled the monthly/weekly/daily reports to run automatically onto the dashboard.
  • Used Visual Source Safe to manage & monitor any changes made to reports created in SSRS.
  • Fine-tuned SQL queries for maximum efficiency and performance.
  • Provided documentation for all kinds of reports and SSIS packages. Designed and implemented stored procedures and triggers for automating tasks.
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages. Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
  • Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop )
  • Developed Master Child Package by using Execute Package Task and Parent Package Variable Configuration.
  • Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.

Confidential, Lewisville, TX

SQL/SSIS/SSRS Developer

Responsibilities:

  • Created SQL server 2012 database for their sales application Business Logic.
  • Converted Access database logic into SQL Server 2008 R2, 2012 and 2014 using SSMS (SQL Server Management Studio).
  • Created data models using MS Visio and ERwin
  • Created tabular, matrix, cascading, sub reports and drill through and drill down reports using SSRS 2008 R2 on the new database for budgets, expenses, categories and cash flow modules.
  • Created pie and bar graphs for Spending, Income, Assets and Debts modules
  • Deployed reports online and scheduled them to email as requested by some of the users.
  • Used SSIS 2008 R2 to create process flows of various Account portfolios.
  • Managed and tuned the SQL Server 2008 R2 database.
  • Created and maintained new stored procedures, functions & views according to user requirements.
  • Scheduled the monthly/weekly/daily reports to run automatically onto the dashboard.
  • Used Visual Source Safe to manage & monitor any changes made to reports created in SSRS.
  • Fine-tuned SQL queries for maximum efficiency and performance.
  • Provided documentation for all kinds of reports and SSIS packages. Designed and implemented stored procedures and triggers for automating tasks.
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages. Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
  • Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop )
  • Developed Master Child Package by using Execute Package Task and Parent Package Variable Configuration.
  • Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.

Confidential, Corinth, TX

Database Developer

Responsibilities:

  • Created complex Stored Procedures, triggers, cursors, views, user-defined functions, SQL Server Traces using SQL Server Management Studio for mission critical application: CIS (Customer Information Systems).
  • Reduced the search timing of work order queries from 10 minutes to 15 seconds by creating indexes on tables for iWATS application (Work Order Management System).
  • Support Quality Assurance Professionals by creating queries for testing.
  • Extensively worked with Business users to understand their requirements and create Reports using SSRS.
  • Analyzed business rules and report specifications that were defined by Communications team and built in MS Excel and data sources.
  • Created and scheduled SQL jobs to run SSIS packages on a daily basis and scheduled jobs to transfer reports to MS Excel.
  • Developed SSIS packages to extract data from OLTP to OLAP systems and created alerts for successful and unsuccessful completion of Scheduled Jobs for the ERP software used by accounting team.
  • Performed data conversions from SQL server to MS Access using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
  • Created SSIS Framework based on ETL requirement to addressing best practices like Configuration, Logging and checkpoint.
  • Created numerous SSIS packages (ETL) to migrate data from different server locations and heterogeneous sources like Excel, CSV, flat file, XML and Text format.
  • Designed new report specifications to support the end user requirements. Created day to day transaction reports.
  • Created SSIS package to generate Excel report directly from database. Formatted Excel report using C# in SSIS to maintain report standards.
  • Designed and developed code for standard Tabular type reports, including Drill Down and Drill through functionality and graphical presentations such as Pie and Bar Charts and dashboard type metrics for effective analysis.
  • Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing of the reports.
  • Responsible for project management activities like project planning, resource planning, team building, project tracking, migration, SCR & SCM management, and quality control.

Confidential

Project Lead

Responsibilities:

  • Managed a team of 15 members
  • Interacting with the client to understand the project and finalize its scope.
  • Estimation, design and development of various modules.
  • Bug fixing and maintenance of the product.
  • Mentoring junior members in the team.
  • Coordinating with other teams working on the same project.
  • Co-coordinating with the testing team for fixing bugs.
  • Ensuring smooth delivery of the project.
  • Leading the technical team.
  • Modifying Procedures, functions, Triggers, views.
  • Building prototype of forms
  • Developing technical document for each modules
  • Version controlling
  • Creating Gantt Chart for the project (Module)
  • Assign to develop user manual and technical documents
  • Arranging training to the users
  • Created complex reports and charts to produce the amount of repossessions using Crystal Report.
  • Created reports that contained information detailed information on loan and lease accounts.
  • Created a report containing loan, lease and combined account information by inserting 8 sub reports to display the information in one report.