SUMMARY

• Over 8 years of experience in the IT domain focused on Microsoft SQL Server 2000/2005/2008 R2, SSIS/SSRS/SSAS, OLTP and OLAP.
• Over 6 years of experience as BI Developer and utilizing Microsoft SQL Server BI stack (T - SQL, SSAS, SSIS, SSRS) transformed data to intelligence and intelligence to value.
• Experience working with Very Large Databases(VLDB) such as 2 TB and over 5billion Records.
• Experience in designing and developing high level ETL Packages to extract, transform and load data from flat files to OLTP and OLTP to Data warehouse tables.
• Experience with SSIS performance tuning using counters, error handling, event handler, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Experience in designing Dynamic SSIS Packages using variables,expressions, containers.
• Expert in Package Management like Saving, Encryption, Logging, and Auditing.
• Experience with SSAS,MDX, Reports,ETL Architeure.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables
• Expert in creating Data Source Views(DSV),Dimesions,Hierarchies,Cubes, Partitions.
• Expert in creating calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in designing KPI’s,Perspectives,Actions using Microsoft sql Server 2005/2008 Analysis Services.
• Worked with MOLAP,OLAP,ROLAP storage modes.
• Good experience in Designing Aggregations and pre-calculated measures, groups and measures.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Experience in generating, adhoc, Parameterized, Drill through, Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008/R2.
• Experience in creating excutive level Dashboards,Charts using SSRS,Powerpivot and Excel.
• Expertize knowledge in SSRS using SharePoint Integration Mode.
• Solid Experience in writing complex T-SQL queries like Aggregate Queries, GROUP BY, HAVING Clauses, Subqueries, CTEs, Derived Tables, JOINs, UNIONs.
• Experience in writing Stored procedures, Indexes, Views, Synonyms and user defined functions.
• Experience with Fragmentation and Query analyzer for SQL Server 2005/2008 and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
• Experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
• Provided 24 X 7 Production support for the database and application issues.
• Worked directly with Director of Data warehouse and Vice Presidents of the Company.
• Experience in translating user & business requirements into functional and technical requirements.
• Team Player,worked Independently and also as team lead.

TECHNICAL SKILLS

Languages: SQL, Transact SQL, PL/SQL, Embedded SQL, C, Java, J2EE, VBScript, .Net, JavaScript, ASP, Visual Basic 6.0/5.0/4.0, HTML 4.0, DHTML,XML

Databases: SQL Server 2008R 2/2008/2005/2000/7.0 , Oracle 9i/8.x, DB2 MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Other Software: MS Office- 2010/2007/2003/2000 , Powe Pivot,Adobe Professional.

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

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

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SQL BI Developer

Responsibilities:

• Overall management of Project and responsible for requirmenet gathering,ETL desin,Development and implementation of SSAS Cube containing the necessary CRM data to facilitate the construction and delivery of the defined reports.
• Sourcing of CRM data from differenct sources into MSAS cube on a monthly basis.
• Worked closely with CADO Field reporting,SCG Business owner to review and approve the requirmenets and took the directions/guidance to complete the job.
• Identified data requirements and report formats for the SCG CRM Analytics deliverables.
• Worked with SSIS/Informatica Tools for sourcing the data.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Developed and Imlemented SSAS cube.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes. to generate various Drill-through reports, parameterized reports, sub reports data grouping.
• Created Physical Tables and Indexes. designed KPI’s,Perspectives,Actions using Microsoft sql Server 2005/2008 Analysis Services.
• Worked with MOLAP,OLAP,ROLAP storage modes.

Environment: SQL Server 2012, T-SQL, .net, VB, ASP, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Performance Point Server 2007.

Confidential, Philadelphia, PA

SQL BI Developer

Responsibilities:

• Extracted data from FTP files and from RDBS sources like Oracle and SQL Server using SSIS.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS)
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes
• Created reports by dragging data from cube and wrote mdx scripts.
• Worked on Stored Procedures and views to generate various Drill-through reports, parameterized reports, sub reports data grouping.
• Rendered reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions
• Documented all kinds of reports and and SSIS packages.
• Optimized the performance of queries with modifications in T-SQL queries,removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Worked on SQL Server 2012 Master Data Services(MDS).
• Created Models,Entites,Attribues and Business Rules.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.

Environment: SQL Server 2008/2008R2/2012, T-SQL, .net, VB, ASP, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services,SQL Server Integration Services, Performance Point Server 2007.

Confidential, Fairfax, VA

SQL BI Developer

Responsibilities:

• Overall maintenance of the Analysis Services cube for reporting needs.
• Interacted with business and technical teams, with clients, technical architects, project managers, requirements analysts.
• Created new Lynx ADS Fields and updated current Brand/Generic Fields in Lynx ADS/ DS and Current Lynx DS reports to reflect Brand/Generic updates.
• Making changes to several metrics in the cube, adding partitions, adding aggregations, performance tuning and processing the cube.
• Made changes to Data Source View, added new named calculations and developed MDX expressions for cube calculations and KPIs.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Created indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers, using T-SQL to facilitate efficient data manipulation and data integrity and better performance.
• Improved the performance of production reports by analyzing the underlying query and report objectives.
• Involved in building Data Integration & Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SSIS. Experience in extracting and transforming data using SSIS Import/Export Data, Bulk Insert, BCP and DTS Packages
• Excellent command on subscriptions, report snapshot and report cache.
• Designed, developed, modified and enhanced the database structures and database objects.
• Designed and developed Star and Snow Flake Schema .
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: SQL Server 2008/2008R2, SSRS,SSIS SSAS, MS Offcie 2003/2007/2010 , Windows 7/VISTA/ XP / NT / 2000/2003,Business Intelligence Studio/Visual Studio 2008/2008R2

Confidential, St. Louis, MO

SQL BI Developer

Responsibilities:

• Created and optimized enterprise level data cubes and hands in MDX Queries, Calculated Members, and KPI’s
• Worked on Stored Procedures and views to generate various Drill-through reports, parameterized reports, sub reports data grouping.
• Worked with SSAS storage and partitions, and Aggregations and involved in scheduling the backups for cubes
• Created and optimized complicated Executive level reports using SQLServer 2008R2.
• Worked with and drilldown reports.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Installed and configured Sharepoint for powerpivot and worked with pivot tables.
• Installed and configured Master Data Servcices and worked with Powerpivot and Master Data Services for Excel add-in’s.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database .
• Worked on T-SQL queries,Stored Procedures,Functions,Triggers etc..
• Worked with administrative jobs like Backup, data loading and unloading .

Environment: SQL Server 2008/2008R2, T-SQL, .net, VB, ASP, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services,SQL Server Integration Services, Performance Point Server 2007.

Confidential, Glendale, Arizona

SQL Server BI Developer

Responsibilities:

• Created Tablix Reports, Matrix Reports, Parameterized Reports and Subreports using SQL Server Reporting Services 2008.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports
• Worked on row and Column Grouping.
• Converted Confidential ’s complex FOCUSCODE to T-SQL code and generated Reports as per the User requirements
• Transformed data using various SSIS transformations.
• Configured IIS web srvices and troubleshooted bugs.
• Involved in performance tuning of the some of the Confidential ’s complext Reports.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Experience of 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 creating Indexes, Constraints on database objects.
• Worked with SSAS storage and partitions, and Aggregations.
• Worked on backups scheduling.
• Worked on Planning and Monitoring reports in Performance Point Server.
• Experience in Reviewing Cube with End user and changing the cube and documentation according to their requirements.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Oracle 9i, Performance Point Server 2007.

Confidential, San Francisco, California

SQL Server BI Developer

Responsibilities:

• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Involved in writing complex MDX Queries as per the user requirements.
• Developed complex stored procedures using T-SQL to generate reports using SSRS 2008
• Involved in data warehouse development environment using Microsoft DTS, SSIS, SSAS technologies and developing system Entity Relational (ER) diagrams.
• Involved in creating Tablix Reports, Matrix Reports, Parameterized Reports and using SQL Server Reporting Services 2008 and 2008R2.
• Improved performance for excel summery reprts.
• Involved in performance tuning of cubes using partitions.
• Involved in creation of data modeling techniques.
• Involved in designing Data marts.
• Analyzed complex queries and tune the same to optimize application and system performance
• To set up SQL Server configuration settings.
• Hands in Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Invlolved in Administration tasks, Database Design, Performance Analysis, and Production Support for complex Databases upto 1 Terabytes.
• Monitored and modified Performance using execution plans and Index tuning.
• Used log shipping for synchronization of database.
• Maintaining the database consistency with DBCC at regular intervals.

Environment: SQL Server 2008/2008R2, T-SQL, .net, VB, ASP, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services,SQL Server Integration Services, Performance Point Server 2007.