SUMMARY

• 8+ years of strong experience wif demonstrated success in teh Database Design, development of SQL Server 2000/20 .
• Expertise wif 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 wif 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 teh 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 wif waterfall and Agile methodologies.
• Proficient in designing, modeling, creating and maintaining Oracle database.
• Expertise in using Oracle 8i/9i/10g databases.
• Experience in working wif 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 teh ETL (Extract, Transformation and Load) strategy to populate teh insurance data from various source systems
• Excellent understanding of data mining algorithms, high performance and optimal algorithms.
• Used multiple transformations in SSIS to meet teh 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 teh 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 has teh 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) wif 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 wif extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experienced in working wif 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 wif 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 wif 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 teh 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 teh existing SSAS cubes in order to minimize teh 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 teh 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 teh data warehouse database from heterogeneous databases/data sources.
• Created packages wif 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 teh other using FTP task wif Master SSIS Package to run all other packages.
• Implemented database standards and naming convention for teh database objects and documentation of all teh processes involved in maintaining teh 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 teh 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 teh reports and fixed bugs in stored procedures and also tuned Reporting Services to teh T-SQL.
• Worked on Change Management Cases to resolve teh production change request issues based on teh 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 teh initial data which is in CSV Format, wif 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 teh 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 teh performance of teh databases.
• Worked on teh subject area of Finance, Billing, fixed assets etc.,
• Created packages to convert flat file to XML file.
• Created cubes and dimensions (SSAS) for teh 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 teh SSIS Import/Export, migrated teh 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 teh 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 teh OLTP to OLAP wif teh halp 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 teh 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 teh 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 teh SSIS packages and scheduling teh package through Jobs in all Tiers including Dev, INT, UAT and Production.
• Fundamental knowledge of .NET and application architecture and development principals.
• Worked wif 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 wif 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 wif 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 wif 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 wif development teams
• Generated test data and tested database to meet teh functionalities deliverables in teh 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 teh 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.