PROFESSIONAL SUMMARY:

• Over 8 years of IT Experience as MS SQL Server Developer, and involved in Design, Development and Support of MSSQL Server 2005/2008/2008 R2/2012 for various business domains like Pharmaceuticals, Constructions, financial services and Health Care.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.Experience in SDLC and Agile environments of project including requirement gathering, creating technical specifications, development and testing of end product.
• Involved in Migrating MYSQL to SQL Server 2008 databases.
• Experience in installing and configuring SQL Server 2014/2012/2008 R 2/2008/2005/2000 SQL Server versions.
• Experienced in writing complex SQL queries which involves multiple tables’ joins, common table expressions (CTEs), user defined functions, indexed views, cursors and DDL/DML triggers for data consistency and data manipulation according to the business and configuration prerequisites utilizing T - SQL.
• Experience in advanced T-SQL features like Merge, Try-Catch, sequence objects and Column stored indexes.
• Experience in performance tuning using Index strategies, Data profiling and analyzing execution plans.
• Hands on experience in using SSIS transformations like Aggregate, Row Count, Data Conversion, Lookup, Merge, Union all, Derived Column, Multi Cast, OLEDB Command and Conditional Split in different scenarios.
• Tested the changes for the front end screens in FACETS related to following modules, test the FACETS batches.
• Experience in using features like logging, event handlers, configuration files and deployment of SSIS packages.
• Experience in Data Migration processing including data loading from flat files to the database tables using SQL Loader.
• Proficient in SQL programming, physical database design, and SQL Performance tuning, replication.
• Used Erwin modeling tool for designing database objects.
• Development of Automated notification when SQL Server Backups and schedule maintained jobs.
• Created Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets. Developed several SSRS reports including Drill Down, Drill through cascading parametric reports.
• Over a year of experience in developing and customizing enterprise applications with Microsoft SharePoint 2013 and Office 365 with SharePoint online. Deployed and administered SSRS reports from report server.
• Develop list, cross tab, and chart reports in report studio using frame work manager package, pl-sql.
• Designed and developed complex drill through master detail and burst reports using Cognos 10.1.1 functionality and Spotfire.
• Operational knowledge of classic ASP programming and JAVA script programming.
• Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Tableau and Spotfire.
• Strong Experience in MicroStrategy Report Services.
• Created several Custom tables, Views, Aggregations and Macros for developing reports used in MicroStrategy environment.
• Experience in data warehousing dimensional modeling to define dimensions and fact tables using Star schema and Snowflake schema design based on the requirements.
• Expertise in What-If Analysis using Excel, Power Pivot Reports and Drill through Dashboards using Warehouses and OLTP Connections.
• Hands on experience in understanding the database design and their relational integrity, along with Constraints, OLAP, OLTP, Cubes and normalizations.
• Well experienced in ETL methodology for designing and developing Extraction, Transformation and Load processes in dynamic and high volume data environments using various tools such as SQL Server Integration Services.
• Experience in Classic ASP/SQL Server web apps developing C# ASP.NET skills and SOAP/XML.
• Excellent experience in developing Reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Implementing efficient Database Design principles including Partitions and Compression techniques, Functions, Triggers, and Distributed Queries.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
• Testing methodologies and tools - Automation and Performance testing.
• Expertise in integration of data from diverse data sources like Oracle, Excel, MS Access, and DB2 to MS SQL Server by using Import Export Wizard, DTS, and SSIS.
• Extensively worked on developing and debugging Informatica mappings, sessions and workflows.
• Validation of Informatica mappings for source compatibility due to version changes at the source.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in data modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Strong conceptual, analytical, and design skills with leadership qualities and hard working with a mission and having passion to learn new technologies.

TECHNICAL SKILLS:

BI & DW Tools: SSIS, SSAS, SSRS, Data tools, Tableau 8.2/9, Google Analytics, Business Objects, lite speed, SharePoint 2013, Cognos, SAS Enterprise Guide, Microsoft CRM 4.0., Microsoft cloud, VB macros, qilkview, IBM Data Mirror, Spotfire, MicroStrategy 8x, PowerBI, PowerShell, crystal reports.

ERP: MS Dynamics Axapta 2009 - Financials (Microsoft Certified)

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SSAS

RDBMS: SQL Server 2000, 2005/2008/2012, MS-Access, Teradata, DB2

Programming: SQL, T-SQL, Visual Basic, Visual C++, MY-SQL, java script, UI, classic ASP,Asp.net, .Net frame work, Power Builder

Web Technologies: Html, CSS

Operating System: Windows 2000/XP/Vista/8, Ubuntu, Linux, Mac OSX

Data Modelling tool: Visual Studio, Adobe Photoshop, MS Office Suite, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential - San Ramon, CA

Senior SQL BI Developer

Responsibilities:

• Actively participated in interacting with users, team lead, DBA’s and technical manager to fully understand the Application/System and Business requirements.
• Assist data modelers in designing of dimensional model for Star schema.
• Worked on the Reports module of the project as a developer on MS SQL Server 2012/2008R2 (using T-SQL, scripts, stored procedures and views).
• Create Views, Constraints and Triggers to implement business rules.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Created Tables, Macros in Teradata SQL Assistant 7.1 and generating the sample reports using Excel 2007.
• Extensively used triggers, transaction in stored procedures which involves complex joins and Sub-Queries to simplify complex queries involving multiple tables.
• Involved in performance tuning of slowly performing stored procedures and queries.
• Develop ETL packages using SSIS to load fact and dimension tables for EDW.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• In order to Export a data from SQL to Csv file we use PowerShell export csv cmdlet which is an alternative methodology for SSIS
• By using Microsoft azure using PowerShell 2015 we generating query results from SQL server
• Microsoft Azure is used as a backup in order to generating PowerShell scripting to avoid errors and also used to generate SSRS.
• Used PowerShell script for SQL Server Maintenance activities.
• Developed mappings, sessions and workflows in Informatica power center.
• Developed various charts and graphs like Bar chart (side-by-side, stacked), line graphs, Gantt Chart etc. by using Chart Expert using Crystal Reports XI.
• Analyzed SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
• Created SSIS packages using complex data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and For-Each loop container in SSIS
• Deploy and scheduled the SSIS packages for incremental load of Data warehouse.
• Develop applications using C#, design patterns, OO methods, stored procedures, and TSQL.
• Created sub reports, bar charts and matrix reports using SSRS.
• Working with Tableau, Spotfire, Qilkview, Logi XML tools for reporting.
• Using SQL server reporting services (SSRS) and Web-enabled reporting to create reports that draw content from a variety of data sources.
• Generated periodic reports based on the statistical analysis of the data using SQL Server 0Reporting Services (SSRS).
• Used SharePoint Designer 2010 to work with the consistent look and feel of the site and also to created workflows
• Migrates large SharePoint 2010 sites to SharePoint 2013 including custom solutions.
• Design and developed custom Business object crystal reports.

Environment: MS SQL Server 2012/2008R2, Windows 7/XP, SSIS, SSRS, T-SQL,SQL server Data tools, TFS, ERWin, Informatica Power center, 2010,MS-Office 2010, Excel 2010, Facets 4.61, Crystal Reports, MS Office Access 2010 and Microsoft Visual Studio 2010.

Confidential - Scranton, PA

SSIS/SSRS/ Data warehouse Developer.

Responsibilities:

• Gathered business requirements, created specification documents, data mapping, data quality analysis, working in conjunction with the data warehouse team on the development of logical data models.
• Worked as a developer in creating complex stored procedures, triggers, and user defined functions.
• Managed index statistics, tables, views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Monitored and modified Performance using execution plans with query hints and Index tuning.
• Performance tuning to optimize SQL queries to improve data retrieval using query analyzer and DMV.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Performance Monitoring of MS SQL Server 2005/2008.
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Tested to optimize the procedures and triggers to be used in production.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions, handled dead lock scenarios.
• Creation of new database, planning the location of data, index, and transaction log files on the disks
• Involved in Capacity Planning, data modeling and Logical/Physical database Design
• Provided support to the application developers on the application databases
• Extensively used SSIS import/export wizard, for performing the ETL operations.
• Design and Implement Database Schema, Disease data and build stored procedures on SQL Azure.
• Build Data Sync job on Windows Azure to synchronize schools data from SQL 2012 databases to SQL Azure.
• Design and Implement WCF services layer hosted on Windows Azure. This layer is the middle tier between SQL Azure and SharePoint online external content.
• Working on Client/Server tools like SSMS, SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Administered MicroStrategy business development environment and maintained the security access for various users and groups.
• Installed, configured MicroStrategy I server and Enterprise manager environment.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Create SSIS template complete with event handlers and logging to audit SSIS package used to load warehouse.
• Worked on PowerShell 2007 which used as a export from SSRS to CSV which modify the scripting
• Microsoft Azure is the latest version which is used to generating scripts for PowerShell and modify any changes in the SSRS without any errors in it
• Worked on the design and development of Web Forms using C# using MVC framework. Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for automation of maintenance jobs, locks and indexes configurations.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition, Microsoft Visual studio, SSIS, SSRS, Windows server 2003, Internet Information Server (IIS), MS Excel 2007, MicroStrategy, Microsoft Azure Using PowerShell 2007.

Confidential - Austin, TX

SQL MSBI Developer

Responsibilities:

• Worked with complex SQL statements using joins, sub queries and correlated sub queries for report generations using SSRS.
• Designed and developedmonthly, quarterly and yearly reports at branch and bank level.
• Involved in creation of data modeling techniques and set up SQL Server configuration settings.
• Analyzed complex queries and tune the same to optimize application and system performance.
• Coordinated with DBA in creating and managing tables, indexes, triggers etc.,
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Involved in converting all existing earlier versions of SQL Server DTS packages by using different SSIS tasks.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Worked with different methods of logging in SSIS.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Developed custom transformations with VB6 code to load data from Oracle to SQL Server.
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
• Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
• Defined and deployed new web applications on classic Asp.NET with help from other teams.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• For making any changes in the production server. Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Have deployed packages on different servers by configuring it.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Involved in Data migration, development and implementation of SSIS on an enterprise level.

Environment: SQL Server 2005/2008/2012, T-SQL, SQL Profiler, SSIS, SSRS, MS Visio, MS Excel, Enterprise Manager, SharePoint server 2007.

Confidential

SQL Database Engineer

Responsibilities:

• Assisted DBA in implementing Data and Database Security using various Default Database and Server roles and also by creating User-defined as well as Application roles.
• Experienced in creating/modifying Tables, Views, Stored Procedures, Functions and Triggers along with in- depth knowledge in query optimization & performance tuning.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Created Indexes based on requirements like Clustered index, Non-clustered to increase the query performance.
• Implemented the business logic and processing of the payment by developing stored procedures and scripts.
• Created Cursors to facilitate the users to scroll through the Queues to perform manual operations on the payment.
• Experience in using Data driven Subscription to prevent unforeseen circumstances.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping.
• Worked on legacy modules of the Java/J2EE and Power Builder and classical ASP.
• Extensively used XML documents to pass multiple parameters for Stored Procedures to read and write database table. Designed XML documents and generated XML documents from tables.
• Automated many operations by scheduling multiple DTS packages using jobs.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard.
• Performed daily tasks including backup and restore data by using SSMS tools like SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.

Environment: T-SQL, SQL Server Management Studio 2005/2008, SQL Server Profiler, ic ASP, SQL Server Agent

Confidential

SQL Server Database Developer

Responsibilities:

• Involved in the study of existing system.
• Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements
• Performed regular Database Maintenance task, checking the disk Defrag procedures in Development environment.
• Used SSRS to build health check reports & deploying the SSRS.
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes.
• Designed and developed the database from scratch, created clustered indexes, created and optimized the stored procedures and triggers and constraints.
• Maintained the production, test and development databases, tuned the database by improving relations, integrity constraints and written t-SQL procedures for transactions, created indexes for performance tuning.
• Responsible for understanding the customer requirements and database administration.
• Participated in meetings with the client and team members.
• Developed triggers and stored procedures to in corporate the business logic and process.
• Using the data transformation tasks like BCP, bulk inserts to import/export data.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used validation techniques and java script for user input validation.
• Supported front-end development team to resolve SQL related issues in active server pages design and develop user control for the application.
• Major role in documentation and maintenance.

Environment: SQL Server 2005/2000, MS Excel 2003/2007, MS Access 2003, Enterprise Manager, Management Studio, DTS, Visual Basic 6.0.