Sr. Sql /application Developer, Business Intelligence Resume
Dallas, TX
SUMMARY
- Over 7+ years of IT industry experience with Microsoft SQL Server 2000/20 R2/2012, SSIS/SSRS/SSAS, and OLAP as SQL Developer.
- Project experience in major domains: Banking, Healthcare, Insurance with focus on the Software Development Life Cycle (SDLC), testing, deployment and support of large scale projects in controlled development, test and production environments.
- Strong foundation in designing and executing Transact - SQL (T-SQL) Query statements with implementing experience in both syntax and logical structure such as: DDL/DML/DCL commands, Joins, UDF (User-Defined Functions), Stored Procedures, Triggers, Views, Indexes using SSMS (SQL Server Management Studio).
- Excellent experience in Data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
- Expert in developing and modifying multi-dimensional cubes using MS SQL Server Analysis Services (SSAS).
- Exceptional at generating Analytic Reports with SQL Server Reporting Services (SSRS) in SQL Server 2012/2008R2/2008/2005 on SQL Server Data Tools and BIDS.
- Expert in designing Enterprise Reports using SQL Server Reporting Services and Excel Pivot table based on OLAP Cubes which make use of multiple value selection in Parameters Pick List, Cascading Prompts, Matrix Dynamics Reports and other features of Reporting Service.
- Specialized in the use of Performance Monitor and SQL Profiler to optimize queries and enhance the performance of Database Servers.
- Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
- Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
- Strong inclination for finishing job before the project deadline.
TECHNICAL SKILLS
RDBMS: MS SQL Server 2000/20 /2014 , MySQL, Oracle 9i/10gOperating System Windows, Linux, HP-UNIX
Programming Languages: C, C++, Java, VB.NET, ASP.NET, C#, SQL, TSQL, PL/SQL, MDX
Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SSRS, SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL Agents, SQL Alerts, SQL Jobs, Replication tools, Data visualization (Composite tool).
Web Technologies: HTML, DHTML, CSS, Java Script, AJAX, VB Script, XML, SOAP, IIS
Database Access Technology: ADO.NET, DTS
Markup Languages: XML, HTML
Design and Development: Visual Studio 2008/2005/2003 , Visual Studio 6.0
Reports: SSRS, Crystal Reports, Cognos Reporting tool, Business Objects.
PROFESSIONAL EXPERIENCE
Confidential - Dallas, TX
Sr. SQL /Application Developer, Business Intelligence
Responsibilities:
- Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
- Designed and created Report Templates, Bar Graphs and Pie Charts based on the financial data.
- Generated Parameterized Reports, Sub Reports and Tabular Reports using SSRS 2008.
- Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
- Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
- Developed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
- Automated and enhanced daily administrative tasks including Database Backup and Recovery.
- Created SQL Server 2012 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
- Involved in designing the Data Warehouse and Core Database for the system including Tables, Stored Procedures, Indexes, UDF and Triggers.
- Configured SQL Mail agent for sending automated alerts/email.
- Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
Environment: Microsoft SQL Server 2012, SQL Server 2008R2, SSMS, SSIS, SSRS, SSAS, BIDS, Microsoft Visual studio 2008.
Confidential - Dallas, TX
Sr.SQL /Application Developer / BI Consultant
Responsibilities:
- Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
- Performed operations such as Fine-tuning Queries and Stored Procedures and providing consultation to other developers.
- Developed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
- Performed activities like analyzing and improving the architecture of Databases, Creation & Indexing of the Tables.
- Automated and enhanced daily administrative tasks including Database Backup and Recovery.
- Implemented SSIS (ETL) to Extract and Transform data from RDBMS and Flat files/CSV, SQL Server 2012/2008R2 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
- Involved in designing the Data Warehouse and Core Database for the system including Tables, Stored Procedures, Indexes, UDF and Triggers.
- Configured SQL Mail agent for sending automated alerts/email.
- Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
- Generated Parameterized Reports, Sub Reports, Tabular Reports using SSRS 2012.
- Generated SQL Server Drill Down, Drill through, Adhoc, Cross Tab Report using SSRS to fit business requirements.
- Designed and created Report Templates, Bar Graphs and Pie Charts based on the financial data.
Environment: Microsoft SQL Server 2012/2008R2/2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, SSAS, BIDS, Microsoft Visual studio 2010, C#.NET, .NET Framework 3.0/3.5/4.0.
Confidential, Philadelphia, PASQL Server Developer
Responsibilities:
- Involved in Database Design, Schemas, Tables, Views and Indexes.
- Backend database development in MS SQL Server, writing complex Ad-Hoc Queries, Stored Procedures, Views, Triggers, Cursors and UDFs.
- Performed Database code Migration from SQL Server in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all Triggers, Views under Unit Testing for validating data Insert, Update and Delete.
- Experience in SQL Joins, Sub Queries, Tracing and Performance Tuning.
- Extensive use of Triggers to implement business logic and for auditing changes to critical Tables in the Database.
- Involved in development of Extracting, Transforming and Loading (ETL), maintain and support the enterprise Data Warehouse system and corresponding Datamarts.
- Experience with SSIS performance tuning using Counters, Error Handling, Event Handling, re-running of failed SSIS packages using Checkpoints and Scripting with Active-X and VB.NET in SSIS.
- Experience in SSIS script task, look up transformations and data flow tasks using T-SQL and Visual Basic (VB) scripts.
- Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
Environment: MS SQL Server 2000/2008, T-SQL, Windows XP 2000, MS Visio, MS Projects.
Confidential, Gainesville, FL
Sr. SQL / BI Developer/DBA
Responsibilities:
- Interaction with clients for business requirements during design & implementation phases.
- Migrated databases from SQL Server 2005 & various other sources into SQL Server 2008.
- Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, and Connections Managers & Import/Export Wizard while developing packages.
- Design, develop & test the ETL processes according to industries best practices using SSIS.
- All data were migrated to the staging server and then that data were later populated to the OLAP (Online Analytical Processing) Server to use with SSAS for analysis purpose.
- Involved in implementing different types of Reports & schedule them for reporting purposes using SSRS.
- Generating On-Demand, Ad-Hoc, Custom Reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
- Involved in writing T-SQL, Stored Procedures, Views, Triggers, Used Indexes, Constraints & Business Rules wherever applicable.
- Used SQL Profiler for performance Tuning & Debugging issue whenever necessary.
Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition,.NET, Visual Studio, SQL, T-SQL, MS Access, MS Excel, & Windows 2003 server, Business Intelligent technologies like SSIS,SSRS,SSAS.
Confidential, NYC, NY
MS SQL Server / SSRS Developer
Responsibilities:
- Extensive use of SSRS 2005 to initiate, design, develops, and deploys reports that project performance metrics.
- Created simple and Complex Tabular, Matrix, Drill-Down, Drill-Through, Sub and Chart Reports.
- Reports were deployed and managed on the Report Server using the Report Manager.
- Configured Email subscriptions to deliver reports as an email attachment as well as a URL.
- Managed Security on all three levels of Reporting Server for different authorization levels.
- Configured IIS (Internet Information Server) for web-based browsing of Reports.
- Used Report Builder 2.0 to prove Ad-hoc reporting to managers.
- Visual Source Safe 2005 was used for file-version control between team members.
Environment: MS SQL Server 2005, SQL Server BIDS: Reporting Services (SSRS), T-SQL, Windows 7/XP, XML, MS Excel, Adobe PDF, Visual Source Safe 2005, Report Builder 2.0.
Confidential
Database Developer
Responsibilities:
- Implemented a well-planned Backup and Restore strategy that protects databases against data loss.
- Responsible for design, development and implementation of mappings/transformations based in source-to-target specifications, defining ETL(extract transform, load).
- Developed complex SQL queries, stored procedures and DTS Packages.
- Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
- Involved in designing and writing Stored Procedures, Functions and Packages using T-SQL for SQL Server 2000.
- Used DBCC utilities to fix data corruption in application databases
- Development of Business Rules implemented as Constraints, Triggers and Stored Procedures
- Developed reports using Crystal reports.
Environment: SQL Server 2000 Enterprise, Windows Enterprise Server 2003, Erwin, Microsoft Visio, DTS, SQL Profiler, Query Analyzer.