SUMMARY:

• Over 7 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Worked Extensively on ETL process using SSIS package.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Knowledge Worked on reporting tools (i.e. OBIEE, Hyperion, Data Analyzer, Crystal Reports, Access, Cognos, Business Objects, etc.)
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Sub reports, and formatting them.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in Creation and deployment of cubes on SSAS.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Worked with different versions of SQL - 2005, 2008, 2008R2, 2012, 2014.
• Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
• Experience in Working on extracting the logs from Cosmos using Scope.
• Experience in using the above query results from Cosmos, creating reports in PowerBI, Adspulse to show the metrics by server and procedure name, by server etc.
• Experience in writing complex SQL queries involving multiple tables with inner and outer joins, stored procedures.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Involved in DBA activities such as backups and restores.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

TECHNICAL SKILLS:

Databases: SQL Server 2014/2 R2/2005, Oracle 8i/9i/10g/11g, MYSQL, Cosmos

Database Tools: SQL Server Management Studio, Performance Monitor, OBIEE, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.

Languages: T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, C# .NET, ASP.NET, UML, XML, XMLA

OLAP: SQL Server Reporting Services (SSRS), SSIS, Crystal Reports 9.0/8.5,OLAP, Erwin, Tableau

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003/2008/2012 , MS DOS, Unix, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. SQL Developer

Responsibilities:

• Responsible for the analysis and reporting of customers channel behavior across all touch points from multiple databases
• Involved in scorecard and KPI Reporting
• Receive reporting and data requests, clarify the need and desired outcomes with business partners and develop reporting which meets the business need and responsible for creating ETL packages and updating dashboard reports
• Support the database manager in day-to-day database administration.
• Worked on reporting tools (i.e. OBIEE, Hyperion, Data Analyzer, Crystal Reports, Access, Cognos, Business Objects, etc.)
• Designed and developed packages to extract, transform and load data using SSIS (extensively worked on each loop, sequence containers, loop up transformation, derived columns, data conversions, row count transformation, event handlers)
• Worked on successfully resourcing the existing projects from DAISY to SSDM
• Developed and maintenance of parameterized reports, chart reports, drill down, drill thru reports on SSRS report manager production support on weekends
• Resolving production issues, Hosted service requests and PAC tickets
• Involved in migration of SQL server environment from
• Install and configure SQL server Troubleshooting performance issues and database issues
• Created SSIS packages to extract data from OLTP sources like MS SQL server 2012, Text files, Excel and Access to OLAP systems
• Created documentation for steps that need to be taken while upgrading the SQL server 2008 to SQL server 2012
• Design and develop SSIS packages using different control flow tasks, data flow task and data transformation
• Create and maintain Transactional and Merge Replication environments
• Implement database Mirroring, Configured principle, Witness and mirror on the 2008R2 SQL servers.
• Design and implement comprehensive Backup plan and Disaster Recovery strategies
• Extensively worked on setting up always on Availability groups on a Multi-subnet failover network. Worked with the windows team to configure Windows failover cluster on which the Always-On setup was done.
• Working on extracting the logs from Cosmos using Scope.
• Using the above query results from Cosmos, creating reports in PowerBI, Adspulse to show the metrics by server and procedure name, by server etc.
• Implementation Migration and Upgrade on MS SQL servers, applied service packs
• Implement Asynchronous mode for Database mirroring in Staging Environment.
• Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implemented partitioning for both tables and Indexes
• Used Online Indexing and online Restoring in SQL Server 2008.
• Applied changes on Production through Change management after thoroughly testing on development servers.

Environment: SQL Server 2014/2012, OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012,2014,COSMOS, PowerBI, Windows Server 2008, VS 2010/2012, C#, T-SQL, and Excel.

Confidential, Louisville,Kentucky

SQL BI Developer/SSAS/SSRS/SSIS/COSMOS

Responsibilities:

• Involved in migration of SQL Server /2014.
• SQL Server 2008 Reports Writer and performed complex SQL report writing and design.
• Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
• Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, Grids using Sql Server Reporting Services 2012.
• Design the ETL for the data load.
• Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created reports using crystal reports.
• Worked on reporting tools (i.e. OBIEE, Hyperion, Data Analyzer, Crystal Reports, Access, Cognos, Business Objects, etc.)
• Create Master Package to run different other ETL in one Master package.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• Created stored procedures using Common Table Expression (CTE) and various types of UDF functions
• Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for designing SSIS packages.
• Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Working on extracting the logs from Cosmos using Scope.
• Using the above query results from Cosmos, creating reports in PowerBI, Adspulse to show the metrics by server and procedure name, by server etc.
• Worked in an agile scrum methodology.

Environment: Microsoft SQL Server 2008/2008 R2, Microsoft Visual Studio, Windows Server 2003, T-SQL, XML,MS Word, MS Excel, MS Visio, C#, VB.NET, MS Business intelligence (BIDS) SSIS/SSAS/SSRS.

Confidential, Detroit, MI .

SQL BI Developer/SSAS/SSRS/SSIS/COSMOS

Responsibilities:

• Highly expert in translating Business System Design document into technical design document. Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Proficient in Creating business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance. Scheduling the jobs to run for ETL using SQL Server Agent.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Highly expert in translating Business System Design document into technical design document.
• Using the above query results from Cosmos, creating reports in PowerBI, Adspulse to show the metrics by server and procedure name, by server etc.
• In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Extensively worked with DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.
• Excellent experience in SSIS, SSAS and SSRS of MS SQL Server .
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
• Perform T-SQL tuning and optimizing queries for and SSIS packages.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created numerous simple to complex queries involving self joins, correlated sub queries, CTE's for diverse business requirements.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
• Scheduling SSRS jobs and production support.
• Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS

Environment: SQL Server 2014/2012/2008 R2/2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.