SUMMARY

• 8+ years of extensive experience in SQL Server Development.
• SQL Server Integration Services (SSIS) and SQL Server Reporting Services(SSRS) with good knowledge on SQL Server Analysis Services(SSAS).
• Experience in Enterprise - Level Data Warehouse solutions with strong skills and proficiency with Business Intelligence/Reporting methodologies (including like OLAP tools, Reporting systems, Data Warehouse/ETL).
• Expertise in using DataMart schema techniques like Star Schema and Snowflake Schema in developing Data Warehouses and dimensional DataMart.
• Worked on developing objects like tables, views, materialized views, indexed views, complex stored procedures, user defined functions and writing dynamic SQL, T-SQL.
• Worked on creating and updating Clustered and Non-Clustered Indexes for fast retrieval.
• Expert in using Microsoft command line utilities of SQL Server 2012 like osql, sqlcmd, dtutil, Dtexec, DTSWizard.
• Developed, monitored DTS /SSIS Packages, Import/Export wizard and Bulk Insert, Bulk Copy Program (BCP).
• Worked on Control Flow Containers such as For Loop, For Each Loop and sequence and Data Flow Transformations such as Merge and Merge join, Conditional split, Data conversion, Multicast, Derived Column Transformations.
• Worked on creating package configuration files using property expressions, variables and script tasks to customize data processing.
• Expertise in moving packages and configuration files across different environments.
• Experience in import and export data to Office 365/ SharePoint 2007/2010.
• Experience in maintaining audits/logging for SSIS packages on task level and package level, configuring error handling, notifications, restart ability (using in built checkpoints and user defined logic) in various business-facing database and tools.
• Worked alone and in collaboration with teams in creating YTD, MTD and WTD sales and inventory reports on store level for user accessibility.
• Expert in developing, designing complex reports using Drill-Though, charts, cascading parameters, matrix, sorting the data, sub-reports and Ad-Hoc reports using SQL Server Reporting Services(SSRS)2014/20012
• Expert in developing report models to give users flexibility to create dashboards of their own choice.
• Hands on experience in building reports on SSAS cubes and importing KPI’s.
• Experience in configuring data driven subscriptions for executive summary reports.
• Created reports dat are compatible in mobile devices (iPhone) using Responsive Web Design.
• Hands on experience in building financial, inventory and merchandise cubes.
• Created partitions for sales and item ledger data for faster processing of cubes and to achieve better performance.
• Hands on experience in designing aggregations both manually and Usage based aggregations.
• Expert in creating relations and attribute hierarchies in cube.
• Experience in implementing cell level security, writing Scopes using MDX expressions, MDX queries for query retrieval from cubes.
• Experience in creating sub cubes, calculated members, named sets, actions and KPIs to implement business logic.
• Experience in creating dimensions and Member Sets in Performance point server using Planning Business Modeler.
• Expert in writing MDX queries to implement currency conversion logic to support multiple regions (Countries).
• Solid experience in writing T-SQL, PL/SQL programming artifacts such as stored procedures, Triggers, Indexes, Views, Cursors, UDF using SQL server and Oracle Databases.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers(DDL&DML), User Defined Data types and Functions(UDF).
• Extensive experience in SQL Query Tuning/Query Optimization in improving the performance of the databases and improving indexes.
• Expertise in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle DB and DB2.
• Excellent debugging skills and the ability to solve complex problems.
• Expertise in using Try Catch block introduced in SQL Server 2008.
• Experience in some basic development of coding in VB.NET, C# while working with SSIS.

TECHNICAL SKILLS

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

RDBMS/Databases: MS SQL Server 2000/2005/2008/2008 R2/2012/2014, Oracle 10g/11g, Access 97/2000/2003, Teradata:

SQL Server Tools: Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard:

ETL Tools: DTS, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS):

Reporting Tools: SQL Server Reporting Services (SSRS):

Development Skills: Transact SQL (T-SQL), PL/SQL:

Languages/IDEs: Visual Basic (VB), HTML, C, C#, HTML, XML:

Data Modeling Tools: ERwin 4.x/7.x, MS Visio 2000/2003:

Application Packages: MS Office 2000/2003/2007/2010/2013:

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

SQL Server Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Extracting, Transforming and Loading (ETL) data from Flat file, excel (spread sheet), MS SQL and oracle to MS SQL Server database by using SSIS services, BCP utility.
• Worked on ETL implementation using SQL Server Integration Services (SSIS), applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Used different transformation controls like Look up, Conditional split, data conversion, unpivot Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments. Maintaining existing ETL processes and trouble shoot issues as they arise.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files. Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Used various Transformations in SSIS Dataflow, Control Flow using For Loop Containers and Fuzzy Lookups, etc.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, InfoPath files, text files and Excel files.
• Created SSIS packages for data conversion using Data Conversion Transformation.
• Created package configurations for dynamic connection string to enhance the ease of package deployment. Implemented Event Handlers and Error Handling in SSIS packages.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements.
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
• Developed Drill Down, Drill through, Cross tab reports, Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Defined Key Performance Indicator metrics to create scorecards.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Interlocked with different stake holders (SCM & CRM) and Project Managers to finalize scope of deliverables.
• Interlocked with Project Managers and business stake holders to get the business buy in, to use HP ALM (Application Life Cycle Management) for better SDLC management.
• Followed the Agile development methodology for incremental development process. Helped PMs to better the sprint considering priority, complexity and parallel development factors. Hosted scrum meetings at regular intervals for updates on progress, risk and show process.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Used Team Foundation Server(TFS) for version control.
• Optimized queries by using Execution Plan for better tuning of the database.

Environment: SQL Server 2014/2012/2008/2008 R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Sharepoint Server, XML, MS Visual Source Safe.

Confidential, San Diego, CA

SQL Server Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Gatheird requirement and designed technical document to implement the application.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Extensively used the dataflow task to transfer data from AS400 to SQL.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, trouble shooting process issues and errors.
• Used various Control Flow tasks in SSIS like For Each loop Containers, Sequence container etc and data flow tasks like derived column, lookup, Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Created several Staging Databases.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end.
• Created Ad-Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder.
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters (multi value, hidden, default etc...) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Worked on creating new reports from the scratch for new requirements and modified some of the existing reports using SSRS.
• Provided documentation of reports and the development process in order to support the system.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Prepared the technical design documents for database development, ETL development, report development and other programming module like MapReduce in java, Pig Latin etc.
• Responsible for code/design review of different programming and front end elements to make sure best practices TEMPhas been followed.
• Created Sales, inventory and finance cubes in SSAS and designed dashboards on cubes to give users valuable information about business.
• Created partitions, aggregations on measure groups in SSAS for better performance.
• Configured cell level security in SSAS by creating roles and writing MDX expressions in SSAS.
• Created calculated members, named sets and scopes to implement business logic in SSAS cube.
• Created Scorecards based on Key Performance Indicators(KPI’s), and generate KPI Score-card dashboard and pivot tables/charts for decision making, data mining
• Worked on creating and debugging data connections, data sources and Data Source Views.
• Suggested query optimization technique for SQL/PLSQL, to have better response time.

Environment: SQL Server 2008 R2 Enterprise Edition,.NET Framework, XMLT-SQL, SSIS 2008, SSRS, SSAS,VisualStudio.NET IDE, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access. Visual Studio 2005

Confidential, Atlanta, GA

SQL Server Developer(SSRS/SSAS/SSIS)

Responsibilities:

• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Extensively used T-SQL for data retrieval and data manipulation.
• Wrote stored procedures using T-SQL for data retrieval and data manipulation.
• Developed DTS packages to extract, transform and load into the campaign database from OLTP database using SQL Server 2005 Integration services (SSIS)
• Worked on creating and scheduling of maintaining plans (database and log backups and cleanups), DTS to SSIS package conversations. Business Intelligence package design. Created tables and performed data imports and restores for successful migration.
• Installed patch sets and upgraded Teradata and performed database health checks and tuned the databases using Teradata Manager.
• Developed SSIS packages to build data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Integrate SQL Server 2005 reporting services with Microsoft Share Point portal server to deliver automatically generated reports to the share point portal.
• Experience in Creating Report Templates, Tabular and Matrix reports using SQL Server Reporting Services (SSRS).
• Applied security to web server and database server dat TEMPeffects report server installation. Managed role-based security to reports and reporting resources.
• Used SQLserver reporting services (SSRS) delivering enterprise, web-enabled reporting to create reports dat draw content from a variety of data sources.
• Created Tabular and Matrix reports using SSRS.
• Provided Documentation support on SSRS 2005 as assigned.
• Wrote VB scripts to properly format the Crystal Report extract into Excel.
• Defined data warehouse (star and snowflake), fact table, cubes, dimensions, measures and ETL structure using MS-DTS.
• Designed Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: MS SQL Server 2008, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services 2008, Oracle, C#, VB.NET, OLAP, DTS/SSIS, BIDS

Confidential, OH

SQL/BI Consultant

Responsibilities:

• Designed SSIS packages to load Trading data from different sources Text file, Excel to staging and staging to Data warehouse.
• Applied different transformations, control, lookups, SCD, Derived column to easily migrate SSIS package from one server to another.
• Designed and developed various complex Profit and Loss reports using SSRS Along with Dundas chart.
• Created charts, tabular and matrix reports using SSRS and Crystal Reports with/without Drill down.
• Designed Analysis Service Cube in Data warehouse using Visual studio in Star schema.
• Designed MDX queries for the querying data from Data Warehouse.
• Worked with the team in building the daily dollar, summary, objective and adjustments reports.
• Designed and implemented various Parameterized and cascading parameterized reports.
• Modified DTS to SSIS packages to accomplish critical business logic
• Involved in writing views, cursors and triggers.
• Created and integrated User defined functions and stored procedures for reporting purposes.
• Generated reports dat can handle dynamic grouping and dynamic sorting.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Responsible for maintaining the accuracy and quality of the data.
• Reduced the overall ETL Time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.
• Created Backups for databases and automated the process. Executed DBCC commands like CHECKDB before backing up the databases.

Environment: MS SQL Server 2008, Crystal Reports 10/XI, SSRS, SSAS, T-SQL, DTS, SSIS, and Windows 2003 Server.

Confidential

SQL Server Developer

Responsibilities:

• Determined the MS SQL Server 2000 installation options. Installed SQL Server Management tools using SQL server setup program. Tested the installation of SQL Server and implemented different security modes.
• Extensively used SDLC methodologies for project analysis and implementation.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed stored procedures, Triggers, Tables, Views.
• Worked on migrating data, tables, stored procedures and other objects from SQL Server 7.0 to 2000.
• Worked on resolving any dead lock issues with the databases/servers on a real- time basis and created Indexes and involved in Performance tuning.
• Used custom user controls for reusability and monitored failed and long running MS SQL Server jobs.
• Maintaining user account administration for different domains.

Environment: MS SQL Server 2003/2000/7.0T-SQL, DTS