SUMMARY

• 8+ years of strong experience with demonstrated success in the Database Design, development of SQL Server 2000/20 .
• Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Involved in optimizing code and improving efficiency in databases including re - indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
• Extensive experience in administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Experience with waterfall and Agile methodologies.
• Proficient in designing, modeling, creating and maintaining Oracle database.
• Expertise in using Oracle 8i/9i/10g databases.
• Experience in working with HealthCare Data in Confidential Client.
• Experience in data analysis in various projects.
• Experience on PL/SQL databases in various projects.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
• Excellent understanding of data mining algorithms, high performance and optimal algorithms.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• Also have the thorough knowledge in ASP .net using C#.
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc and created various user roles (SSAS).
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Adhoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SSRS.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005/2008 Analysis Services.

TECHNICAL SKILLS

SQL Server/BI Tools: SQL Profiler, Query Analyzer, BIDS, Export & Import (DTS), SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS)

Databases: MS SQL Server 2012/2008R 2/2008/2005/2000, MS Access

Languages: C, T-SQL, Visual Basic 6.0

Tools: Visual Studio 2005/2008/2010, Erwin 7.2

Application Packages: MS Office, MOSS 2007, PPS 2007

Operating Systems: Windows 2000/NT/XP, UNIX, Windows Server 2003

Architecture: RDBMS, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, TX

SQL BI Developer

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load (ETL) data from different sources to destinations.
• Deployed SSIS packages and Reports to Production Servers.
• Imported data from text files and excel spread sheets into SQL Server 2012 database using SSIS package.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

Environment: SQL Server 2008/2012, SQL, T-SQL, MS Access, PL/SQL

Confidential, TX

SQL BI Developer

Responsibilities:

• In depth knowledge of Hansen tables and architecture.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Good understanding of SSRS with Report authoring, created daily, weekly and monthly reports as per requirement using SSRS.
• Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS 2008/2012.
• Involved in Analyzing, designing, building and testing of OLAP cubes with SSAS 2008/2012 and in adding calculations using MDX.
• Worked on SSRS reports and fine-tuned SSRS MDX queries.
• Also worked as a part time BA in mappings of the reports.
• Also created an SSIS Packages for loading mappings into Tables.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created forms and reports to implement front-end interface for users using Forms 6i/10g and Reports 6i/10g.
• Performance tuned the existing SSAS cubes in order to minimize the processing time.
• Created and fine-tuned various fact tables and dimension tables supporting numerous cubes.
• Worked extensively on SSAS storage and partitions, aggregations and calculations.
• Used MDX to create calculation formulae to enhance the cube productivity.

Environment: SQL Server 2008/2012, SQL, T-SQL, MS Access, PL/SQL, MS Excel, Business Intelligent technologies like SSIS,SSRS,SSAS.

Confidential, TX

SQL Server Developer

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Implemented mechanisms to accelerate query performance, including aggregations, caching, and indexed data retrieval and optimizing the design of dimension attributes, cubes, and multidimensional expression (MDX) queries.
• Built MOLAP cubes for fast data retrieval and complex calculations.
• Designed SSAS Cube and developed MDX queries for Analysis.
• Modified complex chart reports to meet Business requirements using MDX query in Dundas Reporting Service.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.

Environment: SQL Server 2008R2 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, PL/SQL, Business Intelligent technologies like SSIS,SSRS,SSAS.

Confidential, MA

SQL Server BI Developer

Responsibilities:

• Developed complex programs in VB Script, which connects to SFTP server to get the initial data which is in CSV Format, with best execution plan.
• Performed data conversions from flat files into a normalized database structure.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Worked on the subject area of Finance, Billing, fixed assets etc.,
• Created packages to convert flat file to XML file.
• Created cubes and dimensions (SSAS) for the analysis of sales in specific areas.
• Developed Report Models for building Adhoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, and Packages.
• Configured mail tasks to know the job status of SSIS packages.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.

Environment: SQL server 2000/2005/2008, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i,Enterprise Manager, ERWIN Data Modeler, PL/SQL, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2008, MS Access, Crystal Reports.

Confidential, MD

SQL BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Experience in developing Database Schemas / Stored Procedures / Data Dictionary.
• Experience and knowledge in designing and developing data visualization strategies.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Developed PL/SQL-Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate the historic data.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools like PL/SQL Developer, SQL* Plus, Toad.
• Experience and advanced knowledge of Kimball Methodology for Data Warehousing.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Demonstrated experience in utilizing design tools, development tools, code management, regression testing and performance tuning.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
• Fundamental knowledge of .NET and application architecture and development principals.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using Sql Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.

Environment: MS SQL Server 2000/2005/2008, MS Access, Oracle 9i, Windows 2000/2003, PL/SQL, VB.NET, ERWIN, XML, SQL Profiler, UNIX and Crystal reports.

Confidential, Bartlesville, OK

SQL BI Developer

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Analysis of customer specifications and custom design of applications successfully implementing designs in new/existing application using PL/SQL.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provide high availability support.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Participated in Databases Architecture and data modeling design.
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Reviewed and developed data models and database designs with development teams
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed OLAP using MS SQL Server Analysis Services
• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2005

Environment: MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity, C#, ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Analysis, Design and Development.
• Database Administration, Production and Development Support.
• Created report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
• Created and developed the stored procedures, functions and triggers to handle complex business rules, history data and audit analysis.
• Created and maintained Roles and Database users.
• Provided assistance for development teams on tuning data, indexes and queries
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring, block, and dead lock
• Configured securities and accesses for production databases and database servers
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Environment: SQL Server 2000/2005, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Microsoft Office, Windows 2003/XP.