SUMMARY

• Over 8 years of Experience inanalyzing, designing, developing, installing, configuringanddeployingMS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008/2012 , SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services 2008/2
• Experience in maintaining one to many and many to one relationships while moving data between two databases.
• Expert in dimensional data modeling using SSAS and Erwin, cube partitioning, optimization, Creating aggregation.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in managing Control flow and Data flow Transformations for SSIS packages, Performance Tuning of SSIS packages using Synchronous and Asynchronous Transformations.
• Experience inimporting/exportingdata between different sources like Oracle/Access/Excel etc. using SSIS
• Audit SSRSreport usage, object modifications and access changes.
• Migrated all the databases, jobs, SSIS packages, SQL queries,SSRSreports and subscriptions, user permissions, and linked servers.
• Experience in writing complex Transact SQL (T - SQL) queries, Sub queries, Dynamic SQL to create database Objects - Stored procedures, Triggers, User-defined functions, Views, Indexes, Common table expressions (CTEs) and Implementing Constraints (Primary key, foreign key, unique key etc.).
• Experienced in Maintenance and Production support for all Data Warehouse, SQL Server and SQL SSRS packages enhancement and issues.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Knowledge inMicrosoft Visual C#in script component of SSIS.
• Expert in generating writingparameterized queries, drill through reports andformatted SQL server Reportsin SSRS 2005/ 2008/2012 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experience in masking the PII (Personal Identification information) by using encryption and decryption keys by using BTSEncryption .dll and voltage. Dll and c# script component
• Develop and support SQL Server Accounts Receivable reporting processes end to end from automating data feeds, loading staging and reporting tables, scheduling jobs, buildingSSRSreports and managing permissions.
• Extensive Experience in testing Extraction, Transformation and Loading (ETL) mechanism-using SSIS.
• Involved in thecreation and deploymentof the reports usingSSRSand configuring the SQL Server Reporting Server
• Wrotestored proceduresandUser Define scalar Functions (UDFs)to be used in the SSIS packages andSQL scripts.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Involved in designing cubes inSSASenvironment using Snowflake and Star Schemas.
• Performed some of theDBAactivities likeBackup, Restore, monitoring etc.
• RanSQLStatements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Experience in whole cycle of DTS/SQL server integration services (SSIS / 2008/2012/2015 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Created User groups with required access privileges, hidden the database access information and data source and datasets.
• Responsible for installation, configuration and complete administration of different versions ofSQL Server ( ).
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Created Shared Data Source, Shared Dataset and reports using SSRS Business Intelligence Development Studio.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• As a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team.

TECHNICAL SKILLS

Programming Languages: T-SQL,PL/SQL, Dynamic SQL, MDX, C#, XML

RDBMS: MS SQL Server 2016/2015/2014/2012/2008 R 2/2008/2005/2000 , MS Excel / MSWord / MS Access, DB2, Oracle 9i/10g.

SQL Server Tools: SSMS, Configuration Manager, Query Analyzer Profiler, DTS, Database Tuning Advisor, SQL* Plus, Erwin (Data Modeling).

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Data Transformation Services (DTS), Visual Studio, Business Intelligence Development Studio (BIDS), Data Tools

Operating System: Windows 2000/2003Advanced Server, Windows XP/7/8, Unix.

Application Packages: Microsoft Office Suite, Visual Source Safe, Team Foundation Server (TFS).

PROFESSIONAL EXPERIENCE

SQL BI SSIS ADMIN/DEVELOPER

Confidential, GREENSBORO, NC

Responsibilities:

• Extensively worked on decrypting and encrypting the data (PII) by using dll files and c# script component and was involved in testing the data which is decrypted and encrypted.
• Used scalar functions and SQL scripts to encrypt the sensitive data(PII)
• Extensively worked withSSIStool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split,Lookup, Aggregator,Multicastand Derived Column.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Wrotestored proceduresandUser Define scalar Functions (UDFs)to be used in the SSIS packages andSQL scripts.
• Designed and implementedData IntegrationandETLprocesses withSSISpackages to make data available for reporting purpose within a data warehouse.
• Create newSSISpackage to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2015/2016.
• Defined Check constraints, Business Rules, Indexes, and Views.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• DevelopedSSISTemplates which can be used to developSSISPackages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Involved in Deployment and Administration onSSISpackages with Business Intelligence development studio.
• Executing data validation stored procedures inSSISpackages in Business Intelligence Development Studio (BIDS).
• Performance tuning ofStored ProceduresandT-SQL Queries.
• Performeddata conversionfrom flat file into a normalized database structure.
• Involved in the deploymentof the reports usingSSRSand configuring the SQL Server Reporting Server
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Expertise knowledge in creatingcomplex Stored Procedures, DTS packages, triggers, cursors, tables, viewsand other SQL joins and statements for applications using SQL Server 2005.
• Managed large number of Meta Data Tables which are used in the process of ETL in SQL Server 2005.
• Good experience in working with higher environments like SIT, UAT and Production environments. Also experienced in creating DDL scripts like CREATE TABLE, ALTER TABLE, and DROP TABLE for Databases, SQL Jobs, and Linked Server when moved from lower environments to higher environments.
• ImplementedSQL Logins,Roles and AuthenticationModes as a part ofSecurity Policiesfor various Categories of users.
• Performed some of theDBAactivities likeBackup, Restore, monitoring etc.
• Communicated and Discussed with Developers about the status of each Data Quality Issues
• RanSQLStatements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases

Environment: WindowsServer/ 2008/2012/2015 , MSSQLServer/ 2008/2, Visual Studio 2008/2012/2015 , SSRS, SSIS, MS Office

SQL BI ADMIN/ DEVELOPER

Confidential, CHARLOTTE, NC

Responsibilities:

• Created User groups with required access privileges, hidden the database access information and data source and datasets.
• Created Shared Data Source, Shared Dataset and reports using SSRS Business Intelligence Development Studio.
• Build the project, deploy to the report server and access the reports using web.
• Responsible for installation, configuration and complete administration of different versions ofSQL Server ( ).
• Gathered requirements directly from the Executives and developed customized reports with interactive dashboards.
• Created tables and views using T-SQLto pull data for creating daily reports for interval level call data.
• Worked asBuild, ReleaseEngineer for Application build and Deployment using Anthill pro.
• Created and managed database users, login Ids usingSQLServer.
• Involved in deploying the reports, files in the required environments by drag and drop process.
• Kept up-to-date documentation for all developed applications.
• Supported and maintained current Crystal Reports.
• Assisted with deployments and documentation from Production, QA and Development environments.
• Building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing usingSQLServerIntegration Service (SSIS).
• Prepared Crystal Reports time estimates.
• Designing, developing, and delivering business intelligence solutions usingSQLServerIntegration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Configured report subscriptions.
• Knowledge on migration of reports from sql server 2012 to SQL server 2014.
• Assist teams with prioritization of tasks, and streamline work flow.
• Facilitate daily status meetings, planning and backlog grooming including estimation and deadline setting.
• Project coordination- used waterfall approach to work with clients to understand their needs and develop a project scope that compliments their goals and responsible a demonstration of the final product to the client and any resulting maintenance and ongoing customer service needs.
• Client care- first line support for client issues. Build and maintain personal client relationships with focus on client satisfaction.

Environment: WindowsServer/2008/2012, MSSQLServer/2008/2012, Visual Studio 2008/2, SSRS, SSIS, MS Office

SQL BI / ADMIN

Confidential, SOUTHFIELD, MI

Responsibilities:

• Demonstrated leader ship abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Collected business requirements from users and translated them as Business Requirement Document.
• Worked on design and development of a data warehouse and created new data models using MS Visio.
• Created Stored Procedures, Common table expressions (CTE’s), Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic.
• Install and patch SQL Server 2012 SSDS, SSIS andSSRS.
• Created Excel including pivot tables, macros, and lookup functions to format a data set from the various SQL sources.
• Support/Utilize Business Intelligence based Tools (SSIS, SSAS,and SSRS) for BI solutions.
• Involved in partitioning of databases to improve query performance and reduce downtime.
• Created ETL packages with different data sources (SQL Server, Teradata, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages, notified process results to various user communities and scheduled the SSIS jobs using SQL server agent.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Package Configuration files and deployment wizard.
• Generated multiple Enterprise reports (SSRS/Crystal Reports) 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, navigation reports (Hyperlink) etc.
• Deployed SSRS reports onto Microsoft Office SharePoint Server and SQL Server Report Server.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Created Snapshots to improve the performance of slow running reports in SSRS.
• Designed, developed, tested, and documented ETL processes to interface data from multiple internal and external systems from scratch.
• Documentation and general organization of ongoing tasks, including the ability to evaluate and question business rules.
• Providing support of maintenance plans (including DBCC), backup, recovery, and refresh of SQL Server database.
• Designed and developed existing reports using Crystal Reports 2008
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing SSAS Cubes.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities.

Environment: SQL Server 2008 R2/2012 Enterprise Edition,SSIS,SSRS, SSAS, SharePoint, PL/SQL, C#, Visual Studio 2010 & 2013, MS Visio 2007,DUNDAS Dashboards,Team Foundation Server (TFS)

SQL BI ADMIN/ DEVELOPER

Confidential, HARRISBURG, PA

Responsibilities:

• Responsible for Migration of SQL server 2005 to SQL server 2012 by writing Migration scripts and a clause that checks whether the migration script is valid for the version of the target database.
• Created database objects like Tables, Views, Stored procedures, Functions, Joins, Indexes and Triggers in T-SQL based upon the functional specifications.
• Implemented performance tuning of slow running queries and stored procedures using Sql Profiler and Execution plan.
• Experience in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012 )
• Performance tuning OLTP databases.
• Designed & created OLAP Cubes with Star schema using SSAS.
• Review all migration scripts for changes into production for all applicable applications, operating systems, and hardware to ensure departmental migration standards are followed.
• Working with development team in evaluating, writing, and debugging T-SQL, stored procedures, and Adhoc querying.
• Migrating approved database and executable changes into production for database applications.
• Monitor subject matter expert Internet sites relating to SQL server security vulnerability and good practices
• Identify and enforce enhanced logging and relevant security controls within Microsoft SQL Server.
• Review system and Microsoft SQL logs for unexpected entries and audit logging.
• Maintain user access administration and auditing.
• Comply with access control requirements and ensure that change control and line management are aware of changes that may impact sensitive information.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File and vice versa.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to Data warehouse databases, Data mart databases.
• Responsible for Gathering/Refining requirements from the customer for developing reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio.
• Developed and deployed different reports such as drill down, drill through, parameterized reports and implementing different visualization like bar chart, Pie charts, tabular presentation using SSRS.
• Performed Unit and system testing, Trouble shooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2008R2/2012, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), MS EXCEL, SQL Server Profiler, Team Foundation Server (TFS).

SQL DEVELOPER

Confidential, ILLINOIS

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions (UDF), Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created a Template generator stored procedure for creating migration scripts and Unit Test scripts.
• Creating Indexes (Clustered/Non-Clustered) and partitioning of Very Large Data Bases for improving the Database performance.
• Troubleshooting DTS packages and migration to SSIS/BIDS/SSRS.
• Experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Report services configuration (SSRS) and installation.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Install, configure SQL server, SSIS,SSRS, memory allocation, recovery models
• Worked on SSIS performance tuning using counters, Error handling, Event handling, re-running of failed SSIS packages using Checkpoints.
• Designed high level ETL architecture for data transfer from the OLTP to OLAP with the help of SSIS.
• Worked on SSIS script task, Look up transformations, persistent lookups and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Analyzing and maintenance of complex code base ofSSRS/ RDL, SSIS, in-house .Net applications for Score Reports
• Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly and monthly reports.
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server Analysis Services (SSAS).
• Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance Monitor and tuning SQL Server performance.

Environment: SQL Server 2008, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), VB,MS Access, Visual Studio,T-SQL,Windows XP.

SQL DEVELOPER

Confidential

Responsibilities:

• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Constraints and Roles.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing Stored Procedures.
• Created Logical and Physical data models using ERWIN data modeling tool.
• Assisted in migrating de-normalized report Database into a Star Schema design.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
• Debugging &OptimizingSSRS/ SSIS environments to achieve maximum throughput and ease of scaling out
• Analyze to debug / enhance and support in-house custom authentication mechanism
• Perform in-house defined load test by way of test harness
• Performance tune the underlying SQL code for optimization
• Worked with various SSIS Data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc.
• Used various Control flow tasks like For Loop, Execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
• Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
• Responsible for ongoing maintenance and change management to existing reports and Optimize report performance in SSRS-2008.
• Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• CreatedSSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Created Linked Servers to connect OLE DB data sources and providers.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL, SSRS, SSIS, MS SharePoint, MS Access, Windows 2003 platform, VB.NET,ERWIN, SQL Server Management Studio, Visual Studio.

JR. SQL SERVER DEVELOPER

Confidential

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Implemented different types of constraints on tables. Designed and applied entity and attributes description and definition for the models.
• Used query optimizer to enhance the ETL architecture performance.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Used various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations in the SSIS Packages.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic package configuration in SSIS.
• Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS.
• Snapshot Replication was been used to synchronize the data between their Different Stores.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: SQL Server 2008, BIDS, SSIS, SSRS, Crystal Reports, Visual Studio, T-SQL, Windows XP.