PROFESSIONAL SUMMARY:

• Over 8 years of extensive experience in database analysis, design, development and database administration in SQL 2012/2008/2005 in various SDLC environments.
• Extensive ETL, Analytics and Reporting experience using various technologies (SSIS/SSRS from Microsoft) and Crystal Reports (from Crystal)
• Worked with diversified Industry domains like Power & Utility, HealthCare, Supply chain and Talent Hub.
• Worked on creating dashboards/websites in C# andASP.NETwith ETL uploader and downloader facility for the end client. The dashboard includes fancy SSRS and SSAS charts and pivot view for the end user to view and access data thus obtained after ETL transformation
• Excellent command of writing ad - hoc queries utilizing Dynamic SQL and SQLCMD command line utility.
• Experienced in migrating databases from SQL 20005-2012, Oracle to SQL.
• Excellent hands on experience in creating groups and measures, KPIs.
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity. Expertise in using data modeling tools like MS Visio.
• Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Command
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS, Bulk Insert, creating mappings/workflows to extract data from Oracle, DB2,SQLServer, Excel and Flat File sources and load into various Business Entities.
• Expertise in Developing and Extending MS SQL Server Analysis Services 2012 (SSAS) Cubes, Deploying and Processing SSAS objects, and creating tabular models.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Experience in building, deploying and managing applications on Microsoft Azure Cloud Computing platform.
• Experienced in using visualization tools like Tableau, and Power BI.
• Good experience in developing Power BI dashboard using Share point.
• Good experience in designing and developing web based and windows based applications usingASP.NET, C#.NET, HTML5, Bootstrap, Angular JS, JAVA Script, TYPE Script, Web Services, VB.NET.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, efficient in handling multiple projects, hardworking and a versatile team player.

TECHNICAL SKILLS:

Databases: MS SQL Server 2013/2012/2008/2005, Oracle 10g/9i/8i, My SQL 5.0/4.1, MS - Access 12.0/11.0/10.0/9.0

Database Tools: Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Database Engine Tuning Advisor, SQL Server Dashboard, Business Intelligence Development Studio (BIDS)

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 12/9, Tableau 9.3, Org Publisher, Microsoft Share Point

Data Modeling: Fact and Dimensional Data Modeling, UML, Logical data modeling and Physical data modeling

ETL Tools: SQL Server Integration Services (SSIS), IBM Data Stage 7.5

Languages: C, C++, C#.net, Asp.net T-SQL, PL/SQL, MDX, HTML, XML

Operating System: Windows 98/XP/ 2000/2003/7/8/8.1, Linux CentOS 7, Solaris 11, Windows Server 2008 R2

Designing Tools: Rational Rose, MS Visio

Web Technologies: JavaScript 1.8.5, XML 1.1, HTML 5.1, CSS 3, Angular JS

Applications / IDE: Visual Studio 2013/12/10, Adobe Photoshop, Adobe Dream viewer MS-Office, MS-Project

WORK EXPERIENCE:

Confidential

SSRS Report Writer

Responsibilities:

• Design and develop a complex SSRS report that pull billions of Title issue data and is used by 88 county users.
• Analyze user needs and system requirements to Improve report performance and maintainability of the reporting architecture by optimizing report design and database queries and recommending changes to the overall reporting architecture.
• Interact with various business and functional team heads to finalize the data requirements.
• Design, implement and maintain database objects (tables, views, indexes, etc.) and database security in SQL
• Participate in the full SDLC process (including coding) of ATPS || system in ASP.NET Windows application.
• Improve report performance and maintainability of the reporting architecture by optimizing report design and database queries and recommending changes to the overall reporting architecture.
• Develop and execute test cases for SSRS reports thus created.
• Work with ODPS staff to update, patch, and repair the ATPS application software components in the development, test, and QA environments, and develop software changes for promotion to production following best practice and standards as defined by ODPS.

Environment: SQL server 2012, SSRS, Report Builder, Microsoft Team Foundation Sever (TFS), Visual Studio, ASP.NET, C#.NET, Power BI

Confidential, OH

BI Developer

Responsibilities:

• Work with various customers and prospects, understands and translates business use cases and/or requirements into data models, analytics reports and scenario models.
• Facilitate information gathering sessions and provides data analysis and data mapping.
• Interact with various business and functional team heads to finalize the data requirements.
• Identifying all use cases on base.
• Design and develop SSRS reports based on the business requirement thus obtained.
• Developed variety of SSRS reports like parameterized, drilldown, drill through, sub reports and ad hoc reports.
• Created SSIS Packages to bulk load test data.
• Worked on several complex report features including Calendar reports, multi and select all parameter features.
• Design, implement and maintain database objects (tables, views, indexes, etc.) and database security in SQL
• Developed and executing test cases for SSRS reports thus created.

Environment: SQL server 2012, DB2 8.1, SSIS, SSRS, Report Builder, Microsoft Team Foundation Sever (TFS), Visual Studio, Oracle 12

Confidential, Cleveland, OH

BI Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Developed a website and a windows application with an installer that enable EY professionals to have issue based discussions with their clients. Roles include designing the website and Win form application in .net framework 4.5 using LINQ queries. Also, involved in writing SQL Queries, functions, views and Stored Procedures using SQL Server 2012 for backend development.
• Created numerous complex SSIS packages with bulk data load functionality and to automate other ETL process like transformation and data validation using proper control and data flow elements with error handling and enhancing and deploying the SSIS packages from development server to production server and performed documentation for all kinds of reports and DTS and SSIS packages.
• Created complex Store procedures, Views and functions to validate and transform data as per the business requirements.
• Creating and schedulingSQLserver agent jobs and alerts, scheduled reports for daily, weekly, monthly
• Configure SQL Mail agent for sending automated alerts/email.
• Developed a Queue Manager solution in C#.NET that enables automated queuing and generating of SSRS reports.
• Designed and developed SSRS, Tableau and Power BI reports.
• Built Tabular model and Star Schema cubes using SSAS and creating different dimensions, measures and fact tables.
• Developed a HTML5 and Angular JS dashboard with SSAS power pivot view, SSRS Reports, KPI’s, Uploader, Downloader and user administration.
• Optimizing Database Queries for performance enhancements and Writing T-SQL and dynamic SQL Views and triggers.
• Involved in the engagement economics by providing estimates, keeping track of budgets, and estimating time to completion.
• Lead a team of four to enhance the dashboard for better usability for 2 OTH Clients.
• Performed Code Reviews, worked closely with team members for customization and maintaining code across applications using TFS.
• Responsible for release of code into QA and production.
• Identifying and developing test cases and test scripts to perform load tests for Performance and regression testing.
• Work extensively with cross functional teams in an Agile Scrum environment to achieve the tasks within the given sprint deadline.

Environment: SQL server 2012, SSIS, SSRS, SSAS Tabular model, Windows 2012 Server, Microsoft Team Foundation Sever (TFS), Visual Studio, Data Profiler, Microsoft Share Point, C#.NET, ASP.NET, Angular JS, CSS, Java Script, Excel Macros, Tableau, Oracle 11g.

Confidential

Data Analyst/ BI Developer

Responsibilities:

• Actively involved in the gathering requirements and analysis of the requirements related to the project.
• Detailed analysis on existing logs and coming up with a detailed list of analysis and reports to be generated.
• Extensively worked Design and develop SSIS (ETL) packages to validate, extract, transform and load data from different Sources like Oracle, Excel files, flat files to the Data warehouse using different task and transformations like Derived Columns, ExecuteSQLTask and Send Mail task.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations such as ExecuteSQLTask, Mapping, Data Flow Task, Data Conversion, For each Loop Container.
• Created data sources, data source views, dimensions, measures, measure groups, key performance indicators (KPI), perspectives, partition aggregations. And deployment and processing SSAS objects.
• As part of Business Intelligence and Reporting team, played a key role in Development and Maintenance of SSRS Reporting Environment.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports, Created Charts and Drill Down reports using Complex SSRS.
• Was actively worked in all phases of development cycle of SSRS report conversion project. This conversion project was replacing the existing crystal reports and received accolades for rapid report development and deployment.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and trigger.
• Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.

Environment: MicrosoftSQLServer 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, Crystal Reports XI Release, ASP.Net, c#, Microsoft TFS, Visual Studio.

Confidential, Kenilworth, NJ

MS SQL Server Developer SSIS/SSAS/SSRS

Responsibilities:

• Actively participated in interaction with Users, DBA's and Business analysts to fully understand the requirements of the system.
• Migrating Existing code objects from SQL Server
• Reviewed database design and integration of systems and made recommendations on enhancements and participated in moving legacy data to the data warehouse using ETL.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star and Snow flake schema with Fact and Dimension tables.
• Designed ETL architecture for complete data transfer from OLTP to OLAP using SSIS.
• Performed data conversion from flat file into a normalized database structure and used FTP/SFTP tasks to get Data and Checksum files and upload them back to secured sites based on business requirements.
• Imported data from files usingSQLBULK INSERT in user specified format to database tables.
• Exported the data in/out ofSQLdatabases quickly using BCP Command.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes using SSIS
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers and published Reports to SharePoint site.
• Used Execution Plan,SQLServer Profiler to trace the slow running queries and tried to Optimize SQLqueries for improved performance and availability and CreatedSQLscripts for tuning and scheduling.
• Actively participated in troubleshooting data issues validated result sets and implemented process improvements also Written Complex T-SQLQueries, Sub queries, Co-related sub queries, Dynamic SQLqueries, Procedures, Functions, Triggers and other database objects usingSQL
• Having knowledge of Normalization and De-Normalization techniques
• Worked in data modeling using MS Visio.

Environment: SQLServer 2008, Visual studio 2008, MS Visio 2007, C#.net, XML,SQLServer Management Studio,SQLProfiler, Database Tuning Advisor, Business Intelligence Development Studio, MS Excel,SQLData Generator.

Confidential

SQL Developer

Responsibilities:

• Installed SQL Server on Windows 2008 Server.
• Involved in the Analysis and Design
• 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.
• Responsible for General Database Administration, Query Performance tuning.
• Backup recovery schedules, Backup scripts.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Trouble shooting Problems by using SQL server profiler. Very Pro-actively identifying the problems before user complaints.

Environment: SQLServer 2008, T-SQL, DTS, Windows 2008, Query Analyzer, SQLServer Management Studio, SSIS