SUMMARY

• 8 years of experience in the IT industry with expertise in OLTP, OLAP Databases and SQL Server 2000/2005/2008 development.
• Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Optimized code and improved efficiency in databases including re - indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Good understanding in designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Profound knowledge in writing 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 and built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
• Extensive experience in administration tasks such as data loading, running batch jobs, configuring IIS, uploading data, performing backup & recovery, mirroring Database, shipping Logs, managing user and application table, performing upgrades and creating such as database partitions, databases/file groups/files/transaction logs.
• Designed, developed and tested the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems
• Excellent understanding of data mining, high performance and optimal algorithms.
• Collected data from various sources and used multiple transformations in SSIS to meet the business requirements
• Used SQL Server Integration Services (SSIS) to extract data from various formats such as text files, Excel spreadsheets to SQL Server databases to overcome the transformation constraints.
• Experience in providing Logs, Error handling using Event Handler, and Performance Tuning in SSIS packages using Row, Block and Unblock Transformations.
• Used SQL Server Agent to create jobs, SQL Mail, Alerts and SSIS Packages schedule
• Experience in Dimensional and ER Modeling, Star/Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Excellent Knowledge in analyzing Data warehouse and building cubes using SQL Server Analysis Services (SSAS).
• Developed cubes using Partitions, KPI’s, Perspectives and slow changing dimensions (SCD). Created various user roles (SSAS).
• Experience in Microsoft Reporting Service (SSRS) with expertise in Report authoring, Report management, Report delivery and Report security.
• Experience in developing reports such as Custom, Tabular, Matrix, Adhoc reoprts.
• Used SQL Server Reporting service (SSRS) in Business Intelligence development studio to distribute reports in multiple formats.
• Expert in creating parameterized, Drill down, Drill through, sub, Linked, Snapshot, Cached, Adhoc reports using SSRS.

TECHNICAL SKILLS

Languages: SQL, T- SQL, HTML, XML, C, C#

Databases: SQL Server 2008R 2/2008/2005/2000/7.0 , MS Access, Oracle10/11g

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Cognos, Power play transformer

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Informatica

Testing: Unit Testing, Performance Testing, Integration Testing, Stress Testing

Other Software: MS Office- 2007/2003/2000 , Rally, JIRA, TFS, PPM

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Austin, Texas

Sr. SQL Server/BI - Developer/Analyst

Responsibilities:

• Provided L2 and L3 level on call support (24/7)for Confidential Technology Inc client's in house Central Data Warehouse (CDW)
• Communicated new requirements to off shore team and provided guidance on development effort and handling of on-call Support.
• Provided on call support by debugging and solving issues in production
• Coordinated Database and Application outages and maintenance to end users.
• Analyzed business requirements to understand the data flow from source systems such as SAP, Agile to destination systems .
• Provided status and communicated risks associated with the project in our Sprint meetings
• Wrote and updated user stories in Jira tool in conjunction with updating required documents in WIKI confluence tool.
• Played lead role by helping Team with development tasks, mentoring other developers and project planning in an agile environment
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2008 and Flat files.
• Configured the batch jobs in Active batch (scheduler) to load the data into the various destination systems as per client requirements.
• Used SQL Server Integration Services (SSIS) 2008 to trouble shoot any issues or errors that may have occurred during Batch run process.
• Involved in complete life cycle of SSIS such as creating, building, deploying and executing the packages in all the environments.
• Used Data Flow, Control Flow, For Loop container, Fuzzy Lookups etc., to build SSIS packages.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Used Slowly Changing Dimension Wizard to configured the data loading into slowly changing dimension. Implemented checksum SCD method to load the data into data warehouse.
• Performed Dimensional modeling by identifying the fact and dimension tables as per the client's reporting requirements.
• Wrote complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic.
• Also created clustered and non-clustered indexes.
• Provided advise to Database Administrators on optimizing Queries for better tuning of the databases by looking at the Execution Plan.
• Coordinated with users for implementing logic in stored procedures and functions.
• Involved in upgrade of SQL Server 2008 to SQL Server 2012.
• Monitored Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) etc.,.
• Developed a High level dashboard using SSRS 2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Created snapshots and provided subscriptions to the users for the reports using SSRS 2008.
• DesignedParameterized Reports and Report Modelsfor generatingAd-Hocreports
• Created and applied row level security filters for report model.
• Defined Key Performance Indicator metrics to create scorecards.

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

Confidential, Carmel, IN

Sr. SQL Server/BI Developer

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse from heterogeneous databases/data sources.
• Created SSIS packages using transformations like conditional split, data conversion, derived column, lookup, join, merge join, sort, union all, multicast, slowly changing dimension, in SSIS as per the clients Requirement.
• 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.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and to data marts
• Implemented database standards and naming convention for the database objects and documented the processes for 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.
• Performed Normalization and De-Normalization of existing tables for faster query retrieval.
• Built dimensional cubes with SQL Server Analysis Services (SSAS) and queried the data with MDX script.
• Managed existing indexes in ROLAP to optimize the performance of reports accessing it as well as all other BI applications.
• Defined MDX scripts for querying the data from MOLAP cubes (SSAS) and build reports on top of cubes.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

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

Confidential, LA, CA

Sr. SQL Server/BI Developer

Responsibilities:

• 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.
• Actively involved inPerformancetuning usingSQL ProfilerandTuning Advisor.
• Responsible forQuery OptimizationusingExplain Plan.
• Created SQL Server Agent job for daily load of data.
• Created Various Triggers and Alerts for successful or unsuccessful completion of scheduled Jobs
• 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.
• Created packages to convert flat file to XML file.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.
• Configured mail tasks to know the job status of SSIS packages.

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

Confidential, Charlotte, NC

SQL Server/BI Developer

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• 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.
• 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.
• 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 ad hoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.

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

Confidential, Christiansburg, VA

SQL Server/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.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Deployed SSIS packages and Reports to Production Servers.
• 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, Pleasanton, CA

SQL Server/BI Developer

Responsibilities:

• Managed Enterprise and Distributed Data Warehouses in Development and Production Environments using SQL 2005.
• Good Experience in Tuning and Optimization of T- SQL stored procedures.
• Build and maintain complex SQL queries using T-SQL for data analysis, data mining and data manipulation.
• Organize analytical data; ensure data quality and aggregate data for strategic reporting and performance optimization on database solutions.
• Extensively used Execution Plan, SQL Optimizers, Partitioning Tables and Gather Statistics to analyze and improve the performance of the Queries.
• Involved in Implementation of the application at the client site. During this tenure involved actively in BUG fixing of the modules that are being implemented.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Extensively used the SSIS package to write the data from the flat files, MS Excel, Oracle and DB2 into SQL Server tables.
• Optimizing the current ETL process, identifying and eliminating bottle necks and decreasing data latency.
• Created synchronized mechanism for data management in SQL Server. Set the job dependencies of SQL jobs using MSDB objects.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages.
• Created reports using SQL Server Reporting Services according to user requirements.
• Standardized company reports by implementing SQL Server Reporting Services (SSRS).
• Created Snapshots and Subscriptions to deliver large reports on schedule basis.
• Created Ad Hoc Reporting frame work created to reduce time and large pool of reports design.
• Wrote MDX queries and involved in OLAP Designing.
• Develop documentation of database architecture, system processes and procedures.
• Create, review and produce migration scripts of database objects from development to production environments.

Environment: Windows 2003 Server, MS SQL Server 2005/2000, SSRS, SSIS, SSAS, T-SQL.