Sr. Sql Developer/data Analyst Resume
Santa Fe, NM
SUMMARY
- 7+years of experience in design, development, maintenance and administration of large relational databases SQL Server 2000/2005/2008 and Oracle 10g/11g
- 7+ years working experience with Data warehousing and data mining using Business Intelligence Development Studio (BIDS) and its components (SQL Server Integration services, Reporting Service, and Analysis Services)
- 7+ years programming experience with SQL, SQL/T, SQL/PL, C#, VB, VBA and .NET (SQL Server Management Studio, Oracle SQL Developer, Toad, and Visual Studio 2010)
- 7+years of statistical programming experience with SAS and SPSS
- 9+ years working experience with Microsoft Office (Word, Excel, Access, Power point, and Visio)
- Excellent reporting skills with Crystal Reports, SQL Report Builder, SAS Gplot, and Excel pivot tables
- Extensive experience in writing T - SQL Stored Procedures, Triggers and Functions
- Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, and brainstorming sessions
- Experience in organizing meetings with different clients, database administrators, programmers and research teams.
- SQL server (2000,2005,2008 R2) and Oracle 11g database administrative level skills
- Ability to program data driven web forms and web applications in visual studio 2010 using ASP.NET, VB.NET and C#
- Data Warehousing and data mining experience with BDIS (SSIS,SSAS, and SSRS)
- Expert level Microsoft office product skills (Access, Excel macros, Excel pivot tables, SharePoint, Word, PowerPoint, and Visio)
- Proficiency in statistical analysis using SAS (arrays, loops, and macros) and SPSS
- Proficiency with Windows and Linux operating systems
- Reviewing Literature
- Excellent Interpersonal Skills
- Excellent presentation and report writing skills
- Teaching and Communication Skills
- Capable of managing deadlines and working simultaneously on a variety of tasks
- Strong organizational and problem solving skills
TECHNICAL SKILLS
Microsoft Office: Excel, Access, SharePoint, Word, PowerPoint, Visio
Programming Languages: SQL, SQL/T, SQL/PL, Visual Basics, .net
Database administrative Applications: SQL server 2008 R2 (SQL server Management Studio), Oracle database 11g (Oracle SQL developer, Toad)
Data mining and reporting tools: Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (Report Builder), Crystal Reports, Excel power pivots, SharePoint
Web development languages: ASP.NET (SQL Web Developer), VB.NET, C#, and HTML
Statistical Analysis Applications: SAS, SPSS
Networking: Windows server 2008 networking basics
Adobe Applications: Acrobat X, Photoshop CS5, and After Effects
PROFESSIONAL EXPERIENCE
Confidential, Santa Fe, NM
Sr. SQL Developer/Data Analyst
Responsibilities:
- Captured business requirements by organizing joint sessions to include various Business units including Program area, Research team, Assessment Development (AD) etc
- Extract, transform and load packages (ETL) between different databases using SSIS and perform data validation and data mining tasks
- Designs and implements reports utilizing Microsoft SQL Server Reporting Services. Create views and stored procedures using T-SQL for maintaining and reporting from databases. Determine how the data should be delivered based on user requests. Integrate queries and reports into the company’s Association Management System. Perform Quality Assurance checks for accuracy on data being delivered.
- Bulk import data into existing databases
- OLAP architectural design, multidimensional data modeling, and SSAS cube implementation
- Using Key Performance Indicators (KPI) in SSAS to Check the trends in Vaccination rates
- Conducting statistical analysis to measure rates among different regions and races using SAS
- Building front end applications for the databases using VB.NET, C# and ASP.NET
- Created TSQL queries, Views, Triggers and user defined functions for transaction processing.
- Tuned the TSQL Queries and Stored procedures for better Performance
- Extensively used Joins and sub-queries for complex queries involving multiple tables for Reporting purpose
- Created multiple reports for end users using crystal reports, SQL Report Builder and Excel pivot charts
- Involved in production support scripting the necessary queries
- Involved in migrating Data from Oracle to SQL Server
- Managed the Security creating Users, Groups and Roles in SQL Server 2000
Environment: T-SQL, PL-SQL, SQL server 2008, Oracle 11g, SSIS, SSAS, SSRS, Crystal reports, SAS, ASP.NET, VB.NET, C#.
Confidential, Westlake Village, CA
SQL Server Developer/Project Coordinator
Responsibilities:
- Coordinating with other team members and clients
- Data modeling and design of databases, tables and all objects.
- Converting the Microsoft Access database into SQL Server database. Written several T-SQL programs for the same.
- Performance tuning of the database which includes indexes and optimizing SQL statements, monitoring the server.
- Involved in managing the replication environment.
- Defined and processed the facts, dimensions
- Based on the business user requirement created the facts, dimensions and measures.
- Created various types of reports includes pie charts, Cross tab, 3D, etc.
- Extensively created drill down and drill up reports using Business Objects.
- Extensively utilized the slicing and dicing feature of Business Objects.
- Responsible for running and maintaining business processes on daily / weekly / monthly basis.
Environment: T-SQL, PL-SQL, SQL server 2008, Oracle 11g, SSIS, SSAS, SSRS, Crystal reports, SAS, ASP.NET, VB.NET, C#.
Confidential, Parsippany, NJ
Business/SQL Data Analyst
Responsibilities:
- Perform customer requirements gathering, requirements analysis, design, development, testing, end user acceptance presentations, implementation and post production support of business intelligence report projects
- Responsible for data migration; extract, transfer, load data to/from multiple data sources
- Create technical and functional specifications, including relational database design, using business and system use cases and Visio diagrams.
- Work with back-end Database Administrators to provide requirements for necessary back-end tables.
- Identify methods for process optimization; establish efficiency workflows for testing and validating data, document database schemas and data mapping
- Extensively work in both Ad-hoc and standard reporting environments and will be involved in creating reports scalable to large volumes of data.
- Manage projects through the entire Systems Development Life Cycle, including creating timely/thorough status reports and leading status meetings.
- Support the Sales team with data requested and interpretation as necessary
Environment: SQL, SQL server 2005, SSIS, SSAS, SSRS, Crystal reports, SAS, SPSS
Confidential, Fort Lauderdale, FL
Sr. Data Analyst
Responsibilities:
- Receive and interpret requests for data extracts, analyses, and reports from internal customers and external entities at all levels.
- Participate in the development, validation, deployment, implementation, and maintenance of SQL queries for the successful extraction of appropriate data.
- Discussing business intelligence needs/information with external clients and internal staff.
- Integrate and automate data processes and reporting; promote the transition of reports to an electronic format.
- Analyzing data with standard statistical methods, interpreting the results, and providing written summary and reporting of data analysis.
- Develop automated reporting module and ad-hoc reports via Crystal Reports and related reporting tools.
- Prepare reports for internal and external customers for ongoing execution and distribution.
- Aid in the development and implementation of systems whereby once developed, key users can access repetitively run reports, data and queries independent of analyst.
- Develop and maintain documentation and libraries on key processes.
- Ensure result set accuracy (QA) to maintain the high quality and integrity of databases.
Environment: SQL, SQL server 2005, SSIS, SSAS, SSRS, Crystal reports, ASP.NET, VB.NET, C#, Visual Studio 2005.
Confidential
Data Analyst
Responsibilities:
- Performing Data Management and Analysis
- Importing, cleaning, transforming, validating and modelling data with the purpose of understanding or making conclusions from the data for decision making purposes
- Presenting data in charts, graphs, tables; designing and developing relational databases for collecting data; building or designing data input or data collection screens
- Improving data quality for designing and presenting conclusions gained from analysing data using statistical tools like Microsoft Excel, SAS, SPSS and others
- Creating, maintaining and updating data collection template (s)
- Creating and maintaining a database in Microsoft Access, SQL, Oracle and other databases
- Presenting reports to management, analysing report output and making business recommendations based on the reports
Environment: SQL, SQL server 2005, MS Access, MS Excel, Crystal reports, SAS
Confidential
Analyst
Responsibilities:
- Analyze samples using the laboratory’s established methods.
- Analyze data for quantitative and qualitative accuracy.
- Uploading completed data into a laboratory’s information management data system.
- Creating reports using excel tables graphs and charts
- Statistical analysis of pharmaceutical compounds in samples
- Formats files for proper reporting and distribute to appropriate departments
- Responsible for the quality of all data that comes through the department for each program and ensure all deadlines are met on time
Environment: MS Access, MS Excel, MS Word, MS PowerPoint, SAS, Gplots.