SUMMARY:

• Around 10+ years of Experience in Database Design, Development and Support of Microsoft SQL Server 2008/2012/2014/2016 in Development, Test and Production Environments with various business domains like Financial, Manufacturing, Healthcare and RMS - enabled applications.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Worked Extensively on ETL processes using SSIS packages.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Good expertise in designing reports using SSRS and Excel PowerPivot table based on OLAP cubes. Also, involved in Migration of SSRS reports.
• Extensive experience of package and solution implementation and deployment for large companies in various domains such as Insurance and Retail.
• Proficient in SQL. With proven experience on T-SQL: stored procedures, User-defined Functions(UDFs), triggers, indexes, constraints, transactions, views, CTEs.
• Expertise in monitoring and analyzing query performance with SQL Server Profiler andExecution Plan. Tuning performance via Database Engine Tuning Advisor, query restructuring, indexes, and Horizontal Table Partitioning etc.
• Skilled in creating, documenting, and deploying ETL packages (project-wise or package-wise) withSQL Server Integration Service(SSIS).
• Well versed in data scrubbing and data cleansing, data validation checks during staging, before loading the data into the Data Warehouse.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012/2012/2014.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Hands on experience in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Expertise in solving dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technology of the analysis services.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008 R2.
• Created and maintained several Tableau dashboards that allowed client to monitor vendor performance.
• Used various tools of Tableau including calculated fields, parameters, bins, blended data sets, several visualization types, mapping, and action filters to produce complex Tableau visualizations.
• Experience in Visual Studio Team Foundation Server, Visio.
• Data Warehouse and ODS (Operational data store) usage to create reports.
• Extensive experience in SQL 2005 Partitioning of Tables and Indexes, for Performance, scalability and manageability of Very large databases (VLDB).
• Good Knowledge of SQL Server Clustering, Replication, Data Mirroring, Linked Servers and Log Shipping.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Profiler, Sybase 12.5 ASE

IBM Tools: IBM DB2.

Languages: C, C++, SQL, T-SQL, PL/SQL, Visual Basic 6.0, C#. NET, My SQL, VB.NET, HTML, CSS, AJAX, XML

Operating Systems: Windows 95/2000/2003/ XP/VISTA/7/8/8.1,UNIX, LINUX

MS: SQL Server 2012/2008 R 2/2008/2005/2000, MS-Access 2007/2010

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), dashboards tools, web tools.

Scripting: HTML, DHTML, XML, Shell Scripting, Power Shell 2.0.

Reporting Tools: SSRS, SSAS, Crystal Reports, Business objects, Report Builder 3.0.

DB Utilities and design tools: SQL Server Management Utility, SSAS Cubes, Query Analyzer, MDX scripting.

Application Software: Visual Studio, SQL dialect, MS Office.

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Clearwater, FL

Senior BI Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Designed database after analysis of the business requirement.
• Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.
• Worked with an offshore development team, communicating on a daily basis with the team.
• Designed the complete flow of the file processing.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Performed T-SQL tuning and optimized stored procedures using SQL Profiler, DBCC Commands and by analyzing Execution Plans.
• Prepared Documentation for the Stored Procedures consuming the greatest amount of CPU resources, taking the longest time to run and which performs the most physical and logical I/O operations using Dynamic Management Views and Functions.
• Data migration (Import & Export using BCP) from text to SQL Server 2008.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SQL Server Integration Services (SSIS).
• Created SSIS packages and scheduled the jobs to run automatically to process the cube, load data.
• Deployed SSIS packages with a simple one-click deployment to the integration server.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports.
• Generated parameterized queries in SSRS 2008 R2 using data from SSAS Cubes and various heterogeneous data sources.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize the report execution time and to limit the no of records required.
• Experience in Report Builder in SSRS 2005 and 2008.
• Created the SQL server users and file server users with required permissions by including them in the scripts. Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.
• Implemented the SQL agent jobs creation while deploying the database instance itself by adding them on to the post deployment scripts.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Created complex expressions using the MDX scripting to solve complex designs.
• BI reporting using Excel with Power Pivot.
• Performed transactional-level process using Micro Strategy’s relational OLAP (ROLAP) architecture.

Environment: SQL Server 2012 Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), MDS, Netezza database, DQS, DTS, C#, .Net, T-SQL, XML, XD, MS Excel, MS Access, MS visual Studio, BIDS, MS Power Point 2012.

Confidential, Spencer, MA

Senior BI Developer

Responsibilities:

• Used SSIS script tasks, filesystem tasks, execute SQL task, etc., along with the data flow task to address the requirements. Used variables of various scopes to facilitate data communication between different components.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created Complex Stored procedures, user defined Functions, Schema Binding Views. Extensively used CTE's for complex coding.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS 2012.
• Created database objects such as views, stored procedures, triggers, functions etc., to increase the usability of the staging database.
• Wrote and executed T-SQL in SQL Server Management Studio (SSMS) to store data and to maintain the database efficiently.
• Set up parameters to make SSIS packages configurable in target environment.
• Worked with DBA on package deployment and scheduling.
• Implemented certain level of error handling, logging and prevention mechanism using event handler, transaction option, precedence constraint and SSIS built-in logging feature.
• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Creating Database Objects like Tables, Indexes, User defined functions, Triggers, Parameterized Stored Procedures, Constraints and Roles.
• 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.
• Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore and Indexes.
• Conducted performance monitoring and measurement including Tuning and executed DBCC Commands, Sizing Procedure cache, Sizing Data cache, configured locks and Transaction Isolation levels and Index Management.
• Experience in configuring package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• 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.
• Involved in creating SSIS packages with various transformations like Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Work on Generating dashboards in Tableau server using various data sources
• Migrated very complicated Bank Actuate reports into SSRS 2005 and SSRS 2008 R2 which are some not able to migrate but used many work around techniques to migrate this complicated reports.
• Designed and implemented group by, drilldowns, drill through, sub-reports, Parameterized and cascading parameterized reports using SSRS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.

Environment: MS SQL Server 2012/2014, SSAS, SSIS, SSRS, Tableau, Visual Studio 2012, SharePoint, Power BI, Erwin, Oracle, DB2, Excel, ETL, MDX, XML.

Confidential, Glenn Allen, VA

BI Developer

Responsibilities:

• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2012 and also have hand on experience in PVCS, EDI etc.
• Created packages in SSIS with error handling.
• Developed Drill Down, Cascading, and Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2012.
• Work closely with internal customers analyzing problems and to create and maintain reports, maintaining SSRS Reports and ad-hoc SQL scripts.
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Data migration (import & export/BCP) from Text to SQL Server.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
• Converted Non-Unicode data from different databases into Unicode data and move the data to staging databases.
• Involved in Query optimization and tuning stored procedures for better performance.
• Executed database backup task, check database integrity, rebuild indexes, update statistics task for maintenance.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Experience in Designing and Building the Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS 2012.
• Carry out creation of SDLC documentation for existing applications.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes specifically waterfall and Agile Scrum methodology including Analysis, Design, Programming, Testing and technical Documentation.

Confidential, Houston, Tx

SQL Server Developer

Responsibilities:

• Created many new reports according to the business user requirement with includes complicated expressions and tables with as many as 36 fields in the reports.
• Perform unit testing at various levels of the Reports.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Responsible for database security of the operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2008 R2.
• Written complex stored procedure according to the business requirements for reporting purpose.
• Designed & developed the various SSIS packages for the Weekly & Monthly Loads from business users in different locations in United States (Tampa. FL, Bridgewater. NJ, Morristown. NJ).
• Managed the ETL processes between various environments through scripts utilizing linked servers, DTS packages and SSIS.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules using T-SQL.
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application.
• Modified existing database to fit new business requirement by adding tables and relationships.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).

Environment: SQL Server 2008 R2/2012 (SSIS, SSAS, SSRS), MDX, T-SQL, Teradata, SQL Server Analysis Services, EDI, SQL Profiler, VSS, MS Excel 2010, MS Word 2010, Power point 2010, Netezza database, Crystal Reports.

Confidential, Alpharetta, GA

SQL Server Developer

Responsibilities:

• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, advanced queries, views, indices, and functions for databases.
• Maintained databases, performed software installations and upgrades, monitored database performance,performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Conducted Performance tuning/MS SQL server development - SQL Profiler, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.
• Extensively used Teradata SQL Assistant to extract data from Data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Made modifications and added new MDX queries to the cube.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS and designed reports using Crystal Reports.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2012 database and performed tuning and audit analysis on it.
• Migrated database from SQL server 2008 R2 to SQL server 2012 using utilities i.e. exp/imp and attach/detach for SQL servers 2012 futures.

Environment: Windows XP, MS SQL Server 2008R2, SSIS, Java, Quality Center.