Sr. Sql / Bi Developer Resume
Little Falls, NJ
PROFESSIONAL SUMMARY:
- Over 7 years of rich experience in information technology as Sr. SQL/BI developer.
- Conversant with all phases of SDLC, involving Requirement Analysis, Design, Development, Testing and Deployment, using Agile and Waterfall methodologies.
- Extensively worked on Business Intelligence technologies like SSIS, SSRS, and SSAS of MS SQL server 2005/2008.
- Experienced in data warehousing which includes ETL processes, OLAP methodologies and reporting tools.
- Extensively worked on SSIS packages/object to extract data from various data sources, transform it and load the data into destination like, OLAP server for further analysis.
- Experienced in creating OLAP cube using star and snowflakes schema.
- Proficient in creating different types of reports such as conditional drill down, sub reports, parameterized reports, interactive reports, ad - hoc reports, custom reports and formatting them using SSRS.
- Involved in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications. Also, used SQL profiler for debugging issue & performance tuning whenever necessary.
- Excellent communication skills, analytical skills, understand business requirements in various domains, self-learning ability and leadership quality.
TECHNICAL SKILLS:
Programming Languages: C, C++, Java
Query languages: T-SQL, PL/SQL, MDX
Web technologies: XML, HTML, DHTML
BI technologies: MS SQL SSIS, Data Transformation Services, MS SQL SSRSMS SQL SSAS (2005 and 2008)
IDEs: MS Visual Studio 2005/2008, SQL Server Business IntelligenceDevelopment Studio, SQL Server Management Studio
Databases: MS-SQL Server (2000/05/08), Oracle 9i/10g, MS Access
Application/Web Server: IIS, WebLogic, WebSphere v6.x, tomcat
Operating Systems: Windows 95/98/NT4.0/2000/XP, UNIX, LINUX
PROFESSIONAL EXPERIENCE:
Confidential, Little Falls, NJ
Sr. SQL / BI Developer
Responsibilities:
- Used SSIS to integrate/extract the data from different OLTP systems into OLAP system for further analysis.
- Interacted with sales and marketing reps to gather business requirements.
- Analyzed the data to, predict the trends, providing the news feeds, suggesting different medical products, based on specialty of the doctors who login to the website.
- Implemented different types of reports for sales & marketing team to increase the revenue of the website.
- Used SSRS to format and schedule interactive reports on daily/weekly & monthly basis.
- Involved in writing backend queries, stored procedures, triggers, functions.
- Involved in performance tuning by adding indexes, optimizing queries, using caching mechanism etc, to improve the site performance.
Environment: Windows XP, MS SQL Server 2008, MS SQL Server Integration Services 2008, MS SQL Server Analysis Services 2008, MS SQL Server Reporting Services 2008, Google Analytics, Excel, Acrobat Reader
Confidential, Jersey City, NJ
Sr. SQL/BI Developer
Responsibilities:
- Interaction with clients while business requirements, design & implementation phases.
- 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).
- Migrated databases from SQL Server 2005 & various other sources into SQL Server 2008.
- 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.
- Design, develop & test the ETL processes according to industries best practices using SSIS.
- Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/export wizard while developing packages.
- Involved in writing T-SQL, stored procedures, views, triggers, cursors. Used indexes, constraints & business rules wherever applicable.
- Used SQL profiler for performance tuning & debugging issue whenever necessary.
Environment: Windows XP, MS SQL Server 2008, MS SQL Server Integration Services 2008, MS SQL Server Analysis Services 2008, MS SQL Server Reporting Services 2008, Excel, Acrobat Reader.
Confidential, Gainesville, FL
Sr. SQL / BI Developer
Responsibilities:
- Analyzed business requirements and built logical data models that describe all the data and relationships between the data.
- Developed the reports using SQL Server reporting services (SSRS) based on the business logic by implementing efficient stored procedures.
- Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized the tables, established joins and created indexes whenever necessary.
- Designed Fact tables, Dimension tables and scheduled data transfer from real time database to data warehouse
- Performed Extraction, Transformation and Loading (ETL) using SSIS.
- Designed SSIS packages to migrate the data from various data sources.
- Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages.
Environment: MS SQL Server 2005/2000, SSIS, SSAS, SSRS, Oracle, Management Studio, Enterprise Manager, Mirroring, Replication, WINDOWS 2003, Excel Macro 2003.
Confidential, Iselin, NJ
SQL / BI Developer
Responsibilities:
- Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL.
- Involved in migrating the database from SQL Server 2000 to SQL Server 2005.
- Involved in designing ETL solutions to migrate data from flat files, excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert.
- Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
- Developed reports using SSRS and published as PDF, Excel, and CSV formats.
- Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using performance monitor, profiler, and index tuning wizard.
- Scheduling Jobs and Alerting using SQL Server Agent.
- Proactive and Reactive tuning of databases in every stage of the project.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Used performance monitor and SQL profiler to optimize queries and enhance the performance of database servers.
Environment: MS SQL Server 2000/2005, T-SQL, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), HTML, Windows XP.
Confidential, Chantilly, Virginia
SQL Server Developer
Responsibilities:
- Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
- Designed new SSIS packages and deployed them.
- Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.
- Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
- Writing Stored Procedures, Triggers, cursors and creating indexes.
- Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
- Checked Performance Tuning, Indexing, Query Optimization, Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
- Worked on Authoring Reports and managing reporting services.
- Logical and physical database design using Erwin Tool.
- Performing query plans and making sure each and every query is using appropriate indexes.
- Provided support for in-house and off-shore Development Team.
Environment: SQL Server 2000/2005 Enterprise Edition, SQL, Enterprise Manager, T-SQL, XML, MS PowerPoint, MS Project & Windows 2003 server.
