SUMMARY

• Over 7 years of experience as MS - SQL Server Developer & Analyst in data modeling, data design, database programming, Development and support of SQL Server 2005/20 for OLTP/OLAP environments.
• Extensive noledge in software development life cycle (SDLC) and project management methodologies.
• Experience in Extraction & Migration of Data from heterogeneous data sourceslike Excel, MS Access, Oracle and DB2 to MS SQL Server by usingImport Export Wizard, DTS SSIS,and BCP & Bulk Insertutilities.
• Excellent noledge increating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, IndexesusingT-SQL.
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
• Experience in building tabular cubes using Power BI and implementing DAX expressions with in Power Pivot.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created Power BI Dashboards with interactive views, trends and drill downs along with user level security.
• Strong Experience with Qlikview application design and development.
• Outlined new features of Qlikview for clients.
• Extensively used various features of SSIS Packages (Control Flow tasks, Data Flow tasks, Transformations, Migration tasks).
• Extensive use of SSIS/DTS packages and BCP/Bulk Insert utilities including extensive noledge of exporting and importing data to and from SQL Server to any OLEDB and ODBC provider.
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Expertise in handling Errors by usingEvent Handlerand can provide Logging, Custom Logging forSSISPackages.
• Used Power Pivot (Power BI) to create tabular cubes and deployed them in Analysis Services.
• Expertise skills in creatingOLAPcubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005/2008/2012 ) using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience with working on Performance Point Server to identify KPI ‘S, build score boards, reports and dash boards.
• Used excel connections to retrieve data from COSMOS to excel files and created adhoc reports based on them.
• Extracted data using Cosmos scripts from several virtual clusters and created adhoc reports.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services). and calculate the metrics dat were revealed in the functional analysis
• Expert in creating SSAS 2005/2008/2012 cubes, MDX queries, working with facts, dimensions, hierarchies, Perspectives and various storage settings(ROLAP/MOLAP/HOLAP).
• Developing reports on SSAS & SSRS on SQL Server (2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2005/2008/2012 across various environments
• Created stored procedure for generating reports usingSQL Server Reporting Services (SSRS).
• Expertise in generating reports using linked reports, sub reports and filters, chart in SQL server reporting services.
• Experience in configuring automation reports using various delivery mechanisms like Email Links, PDF attachments and Excel attachments.
• Worked closely with various IT Groups, Upstream, downstream customers, Managers, developers and end users.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C#, ASP, .Net, VB, C, C++, Unix, XML, UML, COSMOS, Power Query.

RDBMS: MS SQL Server 2014/2012/2008/2005, Oracle 11i/10g/9i/8, MS-Access 2005/2000, IBM-DB2, Sybase ASE 15.0.

Web Tools: MS-Front Page, Internet Information Server (IIS), FTP, TCP/IP, SMTP, LAN, MS-Outlook Express.

Operating Systems: Windows XP/7/8/8.1/10, Enterprise Server, Windows NT 5.0 /4.0 /3.5, Windows 9.x/3.x, Linux, MS DOS, Ubuntu.

SQL Server BI Tools: SSIS, SSRS, SSAS, SSMS, SharePoint Server (MOSS). SQL Profiler, DTA/Index Tuning Wizard Analyzer, SQL Server Management Studio, DTS.

Design/Reporting Tools: Erwin, ProClarity, Performance Point Server (PPS 2007), Congo’s Impromptu, Crystal Reports, Power BI, Tableau, QlikView

PROFESSIONAL EXPERIENCE

Confidential, WA

SQL BI Developer/Analyst

Responsibilities:

• Studied existing OLTP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Updated functional specification and technical design documents.
• Wrote complex stored procedures, queries, triggers, functions and cursors for the OLTP batch and online processes.
• Created indexes, Constraints, and rules on database objects.
• Responsible for identifying and defining Data Source and Data Source views mappings for ETL
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Migrated data from various data sources like Oracle, Flat files, upstream systems into Staging, ODS and DWH areas using DTS/SSIS.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Designed various Scope Scripts in COSMOS to fetch data from structured streams and log files.
• Imported data from COSMOS streams to SQL using SANGAM jobs and DDL method.
• Responsible for Dimensional modeling. Defined relationships between Dimensions and Measure groups.
• Created SSAS cubes and loaded dimensions and facts. Defined attribute properties in a Parent Child Dimensions.
• Created the data source views and defined granularity with in a measure group and drill through actions.
• Reviewed cubes, changed the cubes and documentation per the requirement based on evaluation and revenue opportunities using SSAS.
• Worked with installation, configuration and deployment of SQL Server Reporting Services (SSRS), developed various enterprise reports, drill thru reports, drill down reports and multi-valued parameter reports.
• Worked with SSRS Report Builder and allow customers to build their reports using Report Builder
• Perform reporting and included interactive drill down reports, report models and dashboard reports and security implementation for the reports.
• Created and maintained Roles and Database users.
• Big data aggregation using Cosmos scriptsand developed adhoc reports based on them.
• Involved in code reviews, code migration and deployments across all environments.

Environment: MSSQL Server 2012/2008, T-SQL, PL/SQL, Rapid SQL, SQL Server Reporting Services (SSRS 2012/2008), SQL Server Integration Services (SSIS 2012/2008), (BIDS), MS-Access, Power BI.

Confidential, NYC, NY

MS SQL BI (SSRS/SSIS/SSAS Developer)

Responsibilities:

• Worked as a SSRS 2008/2012 R2 Reports Developer and SQL Server /ETL Developer.
• Designed, developed, and tested stored procedures, views and complex queries which use complex joins, sub queries and SQL Server temporary tables.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
• Extensively involved in ETL Processes development, support and implementation.
• Worked with different data sources like Oracle, DB2, Sybase, SAP R/3 systems for ETL(SSIS) loads and created data dictionaries and data mappings to load into the ODS /Staging for the reporting sub system.
• Used Power Queries in Excel to extract and consolidate data from SharePoint sites.
• Created different tabular reports using Power BI features and enhanced them based on user requirements.
• Worked on various DAX expressions in Power Pivot based on the business requirement.
• Worked on Performance tuning and query tuning, working on execution plans using DMFs, DMVs, creating Indexes, archiving and purging data
• Used Reporting Services extensively for generating custom and ad-hoc reports.
• Developed various Service Management Reports using SSRS including sub-reports, charts and parameterized reports, conditional and dynamic reports.
• Built and performed user acceptance testing on new and modified reports.
• Modified and Deployed reports using dat are generated using reporting services.
• Created Expressions for various types of reports, created linked, unlinked and on-demand sub Reports.
• Identified and included report parameters (Single Valued/Multi Valued Parameters)
• Formatted the reports using Global variables and expressions and Deployed reports on the company’s remote report server.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created subscriptions in SSRS to provide a daily basis reports.
• Involved in developing/Deploying SSIS packages using BIDS for Data loads required for Reports.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Extensive usage of data Migration tools such as DTS Export/ Import, BCP & BULK INSERT which involves multimillion rows of data.
• Involved in Change Control Migration and Code reviews for migration schedules and deployments.

Environment: MS SQL Server 2012/2008R2/2005 SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Report Model, Report Builder, (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, VBScript, .Net (Asp .Net, C# .Net), Power BI.

Confidential, Johns Creek, GA

MS SQL BI (SSRS/SSIS/SSAS Developer)

Responsibilities:

• Involved in Designing/Developing/Implementing Enterprise Data warehouse (EDW) and Data Marts
• Worked with end users and Business Analyst for gathering various requirements.
• Developed TSQL queries based on business requirement which required lot of complex calculations.
• Created SSIS packages in such a way dat they can be dynamically deployed into Development, Testing and Production Environments.
• Involved in creating ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and tan loaded the data into destination tables by performing different kinds of transformations using SSIS packages
• Created SSIS packages in such a way dat they can be dynamically deployed into Development, Testing and Production Environments.
• Created ETL SSIS packages both design and code to process data to target databases.
• Expert level skills in understanding of Confidential Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in extracting data from EDI files and populating database.
• Worked on Data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc. and different data flow tasks.
• Supported the Director of Business Information in their interactions with key stakeholders to define, design and develop critical reporting needs using SQL Server Reporting Services 2008 R2.
• Migrated Packages from DTS to SSIS.
• Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard Viewer Web Part for web based access for multiple end users.
• Worked with BizTalk developers to convert EDI files into XML and to populate Database.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: Windows 2003/2008 R2 Server, MSSQL Server 2012/2008/2008/2005, SSIS 2012/2008, SSRS 2012/2008, SSAS, DB Artisan, Sybase, Oracle, Rapid SQL. TFS.

Confidential

MS SQL Server BI Developer

Responsibilities:

• Installation and configuration of SQL Server Reporting Services (SSRS) 2008
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
• Involved in designingParameterized Reportsand alsocascaded Parameterized Reports.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2008).
• Created multiple reports in Drill mode using tables, financial tables, crosses tabs and charts using Reporting Service (SSRS).
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Designed and implemented Parameterizedand Cascading Parameterized reports using SSRS.
• Designed and developedSSIS Packages to import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in writing complex SQL queries with multiple table inner and outer joins, temporary tables, table variables.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Worked on different kinds ofTransformationsinSSISas per the client’s Requirement.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise Manager, XML, MS PowerPoint, MS Project, MS Access & Windows Server 2003.

Confidential 

SQL Server Developer

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manager tools using SQL server setup programs.
• Created Indexes, Views & Triggers. Also involved in writing Stored Procedures reports for Online Banking, handling business logic and functionality of various modules.
• Involved in database normalization and de-normalization.
• Used SQL server agent for scheduling jobs and alerts
• Configured and monitored Database application.
• DevelopedReportstogeneratedaily,weekly,monthly,quarterly,yearlyReports using crystal Reports.
• Wrote Database triggers in T-SQL to check the referential integrity of the Database.
• Migration of data from one environment to another environment.
• Used reporting services extensively for generating custom and ad-hoc reports.
• Modified and deployed reports dat are generated using reporting services.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration / Reporting Services 2005/2008, SSAS, DTS, Crystal Reports, MS Visio.