Business Intelligence /sql Resume
St Louis, MO
Professional Summary:
Around 6 years of IT experience in SQL Server Suite of products (OLTP and OLAP) and involved in all phases of Software Development life cycle from gathering requirement, development, implementation, testing and support.
- Experience in creating Tables, Views, and Indexes, writing Stored Procedures, Triggers using T-SQL as well as analyzing and debugging existing complex stored procedures.
- Strong experience working with SQL Server Management Studio and Business Intelligence Development studio.
- Extensive experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
- Used Performance Monitor/Profiler to solve dead locks/long running queries.
- Have worked on Distributed Queries.
- Involved in developing SSIS packages with .NET C#, ASP.net
- Build (C#) .NET application services to export/import data from/to database
- Extensive experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS), ASP.NET and C#.
- Experience in bulk transfer of data using SSIS, BcP, Bulk Insert, Insert From, OPENROWSET.
- Extensively used tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
- Experience with Database Backup, Recovery and Disaster recovery procedures.
- Experience with database mirroring, Log Shipping, replication.
- Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
- Expertise in generating tabula, matrix reports using SSRS.
- Expert in handling parameterized reports in SSRS and formatting reports.
- Expert in deployment and Subscription of reports in SSRS.
- Experience in creating Drill down, Sorting and cross tab reportusing various reporting tools like SSRS.
- Self-motivated, diligent with the ability to quickly adapt to new environments and changes.
- Capable of forming and maintaining positive and productive working relationships in internal, external and team environments.
- Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
Technical Skills:
Databases
RDBMS, Hierarchical Database, Object Databases
Database Tools
MS SQL Server 2000/2005/2008, 2008R2 MS-Access, SQL Server Integration Services, SQL Server Analysis Services, OLAP(Online Analytical Processing), Multi-dimensional Cubes and Business Intelligence & Development Studio
Development skills
T-SQL, SQL,SSIS/SSRS/SSAS
Languages
T-SQL, ASP.NET, C, C++, C# .
ETL Tools
BI SSIS, SSRS and SSAS.
Reporting Packages
SQL Server Reporting Services
Professional Experience: Client: Charles Lewis Pumps/Weirs Minerals, St Louis, MO May 2011- Present SQL Developer/SSRS/SSIS Developer WeirMinerals are specialists in delivering and supporting slurry equipment solutions including pumps, hydro cyclones, valves, screen machines and screen media, rubberand wear resistant linings for global mining and mineral processing, the power sector and general industry. They are the leading providers in slur pumps. I am involved in their IT Department as a SQL Developer to maintain their databases.Responsibilities:
- Responsible for developing various SSRS reports in Visual Studio.
- Created matrix reports, tabular reports.
- Modification of reports using extensive formulae as expressions.
- Created complex stored procedures with and without parameters.
- Created SSIS packages for transferring of data to SQL database from different sources like Excel, CSV files etc.
- Creating tables, functions, views, stored Procedures in database.
- Creating Drill down, Sorting and cross tab reportusing various reporting tools like SSRS
- Helped DBA in performance monitoring of database. Also involved in Database back up and recovery.
- Scheduled various jobs in SQL using SQL Server Agent.
- Deployed, Subscribed and scheduled reports to manager and other IT Team using SSRS.
- Help the manager in solving various issues related to performance.
- Involved in projectteam while developing SSIS packages.
- I am also involved in normalization of database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
- Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.
- Created Indexes, Constraints and Rules on database objects.
Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, SQL Profiler, DTA, SQL Server Integration services , SQL Server Reporting services, Microsoft-Office 2003/2007, MS-Excel 2003/2007.
Client: Confidential, Decatur, IL June 2010- Feb 2011
Business Intelligence Developer/SQL Developer
Archer Daniels Midland Company is one of the largest agricultural processors in the world. Serving as a vital link between farmers and consumers, ADM take crops and process them to make food ingredients, animal feed ingredients, renewable fuels and naturally derived alternatives to industrial chemicals, create products that help satisfy global nutrition needs, such as low-cost quality protein isolates. ADM ethanol production reduces emissions as well as reliance on petroleum-based fuels. ADM also makes the food we all enjoy more available and affordable, enhancing the quality of life.
Responsibilities:
- Involved in analysis, design, development and enhancement of the application that applies business rules on the Transportation and Sales Data.
- Created SSIS package to get data from different sources, consolidate and merge into one single source.
- Extracted data from various sources like SQL Server 2005, .CSV; Excel and Text file from Client servers and through FTP and import it to database using Bcp, Bulk Insert, SSIS.
- Implemented Error handling and utilized Event handlers for automated notifications using SSIS.
- Designed data warehouse using SSIS
- Implemented various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
- Have done ETL transformations in SSIS packages
- Have done optimization of queries, improving the performance and maintaining the database consistency with SQL Profiler, DTA, System Monitor, DMV and DMF.
- Got experience in Database Mirroring, Log Shipping, Replication, Back up, Recovery.
- Tuned the performance by making use of clustered and non-clustered indexes.
- Involved in developing SSIS packages using C# .NET application services to export/import data from/to database.
- Created the linked reports to get more detailed reports from the parent report.
- Created audit scripts for tracking and logging events.
- Created Mail Tasks with the error file attachments using package Variable.
- Used Event Handlers for tracking the success or failure of the package in the audit table.
- Used For Each Loop Containers for loading more than one Flat File at a time in to the Target Table.
- Created Script for Error log and redirected to a specified path using Package Variable.
- Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.
- Created Indexes, Constraints and Rules on database objects.
- Involved in end to end documentation of all the processes including aggregation, metrics and all the relevant customizations made in the system
Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, SQL Profiler, DTA, SQL Server Integration services , SQL Server Reporting services, Microsoft-Office 2003/2007, MS-Excel 2003/2007.
Confidential, New Brunswick, NJ Feb 2009 - Jan 2010
SQL/SSIS/SSRS Developer
The institutional research workflow solution delivers the critical information and analytical tools to help research analysts make informed recommendations and produce effective research reports. It streamlines your entire workflow-from monitoring stocks and researching companies to analyzing qualitative and quantitative information, publishing your research and selecting stocks.
- Responsible for developing various reports like Drilldown, Tabular reports.
- Modify the existing stored procedures and modify the existing reports , generating new reports
- Building parameterized reports and returning subsets of the data with query parameters, mapping report parameters to query parameters.
- Revealing report details with drill down
- Hide dimension attributes/hierarchy in one cube, but leave them visible in other
- Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
- Did bulk transfer of data using SSIS, BcP, Bulk Insert.
- Created packages with ETL transformations
- Involved in projectteam while developing SSIS packages using C# .NET, ASP.NET
- Placing all measure groups into single cube or split them between cubes
- Placing all measure groups into single cube or split them between cubes
- Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
- Utilized SSIS to design Datawarehouse.
- Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
- Developed, monitored and deployed SSIS packages.
- Used Performance Monitor/Profiler to solve dead locks/long running queries.
- Did Query Analysis(QA) using tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
Environment: SQL Server 2005/2000, SSRS, SSIS, SSAS.
Confidential, West Haven CT Jan 2007 - Dec 2007
SQL Server Developer/DBAConfidential, is a global leader in pharmaceuticals, consumer health care products, and animal health care products. It has a pipeline of rich research going on in clinical trials .Bayer assists its customers to moderate the cost and enhance the quality of prescription drug benefits provided to members nationwide. The data from the individual departments is collected daily and stored in the central database.
Responsibilities:
- Involved in the Design and development of database infrastructure.
- Involved in the development of databases for the individual departments of the hospital and the central database, which contains information about all the departments
- Normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
- Written Complex and Extended Stored Procedures for application developers and some User Defined Functions.
- Created After and Instead of Triggers to enforce data consistency and referential integrity.
- Involved in creating Views, Parameterized Views, Partitioned Views and Indexed Views.
- Created Clustered and Non Clustered Indexes on tables, views, and columns
- Performed data conversions from flat files into a normalized database structure.
- Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs
- Generated reports by using Repots using SSRS.
- Redesign/ Deploy reports using Report Services 2005.
- Used Performance monitor/Profiler in Query Analysis (QA).
Environment: SQL Server 2005/2000, SSRS, SSIS, SSAS.
Confidential, Philadelphia, PA Jan 2005 - Nov 2006
SQL Developer
Confidential, is a market leader in developing insurance solutions for high net-worth individuals and business owners; Lincoln Life offers a range of insurance products including variable universal life, universal life, whole life and term life insurance. Lincoln Financial is a leading provider of fixed and variable annuities designed to meet the financial needs of individuals and organizations, Lincoln also offers innovative income accumulation and wealth transfer solutions for individuals, small- to mid-size businesses and non-profit and government agencies.
Responsibilities:
- Involved in the modification and normalization of existing procedures tables
- Involved in the design and development of client specific distributed and portioned views.
- Involved in the optimization of SQL queries using Query Analyzer for efficiency and provided queries and procedures for the front-end application.
- Involved in creating and maintenance of database, tables, users, logins, views, indexes.
- Created Triggers to enforce data and referential integrity.
- Involved in database backup, recovery and restoration to support development team.
- Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
Environment:MS SQL Server 7.0, Windows 2000, SQL Enterprise Manager, Query Analyzer, SQL Profiler.
Confidential, Bangalore, India July 2004- Nov 2005.
SQL Server Developer
The project was based on improving and creating SQL server queries, views, indexes and store procedures according to users' demands. I am one of the 4 SQL developers in a team that also consists of an application database manager and a team lead reporting to the site manager.
Responsibilities:
- Involved in gathering user requirements, analyzing and design of software and database solutions.
- Involved in updating functional specifications and technical design documents.
- Design database objects, normalize data base objects.
- Develop stored procedures, functions and triggers.
- Develop scripts to move data from the flat files into the tables.
- Created views as per design needs.
- Tuning procedure and database objects.
Environment: MS SQL Server 2000, MS Access, SQL Query Analyzer, SQL Developer.
Education:
Master's in Computer Science
Bachelor's in Computer Engineering
Certifications:
MCTS: Earned Microsoft Certified Professional Certification on
- Microsoft - SQL Server 2005-Implementation and Maintenance (Exam -70-431, MCP ID#709828).
- Microsoft - .NET Framework - Application Development Foundation (Exam - 70-536, MCP ID# 7709828).
References:
Available on request.