SUMMARY:

• Around 8 Years of experience in IT as SQL Developer and Analyst, involved in requirement gathering, analysis, configuration, deployment and administration of Enterprise database applications
• Experienced in all the stages of Software Development Life Cycle and in the migration and up - gradation of databases.
• Experience in developing and modified SQL Server Views, Functions, Stored Procedures and Power BI, Crystal Reports for converting and implementing new companies into existing environment.
• Accommodated and facilitated Joint Application Development (JAD) session, documented, analyzed and synthesized the results as parts of business requirements.
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Actively involved in the enterprise Data Warehouse designing using Kimball design methodologies and following DW Design Best Practices.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization.
• Expert in creating SQL Queries, Packages, Functions, Stored procedures and Cursors.
• Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Monitored and tuned the performance of Complex T-SQL queries and stored procedures by analyzing the execution plan and using tools like SQL Server Profiler.
• Developed web pages for embedding deployed SSRS reports using ASP.NET
• Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-view according to the business criteria.
• Responsible for Database consistency checks using DBCC utilities, Performance Tuning and Query Optimization.
• Experience with SSIS performance tuning using counters, error handling, event handler, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Experience in designing Dynamic SSIS Packages using variables, expressions, containers.
• Experience in performing a Bulk Loads into SQL Server and Incremental updates with SSIS.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Worked on data import from different file systems including XML, text, and CSV and Excel files.
• Performed data cleansing using different transformations within SSIS packages to eliminate redundant data from the pre-staging database.
• Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings).
• Created package configurations to provide an easy solution to migrating packages from different business environments like development to testing or testing to production.
• Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.
• Responsible for designing test cases for testing the ETL packages.
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Optimized cubes by assigning appropriate storage modes to partitions and created usage-based optimizations for better query performance.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.

TECHNICAL SKILLS:

Languages: SQL, Transact SQL, PL/SQL, Embedded SQL .Net ASP.Net, Visual Basic HTML, DHTML, XML

Databases SQL Server 2016, Oracle 12c/11g, DB2, MS Access:

Reporting Tools SQL Server Reporting Service (SSRS), Crystal Reports, Power BI, Tableau, Qlik View:

ETL Tools SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP):

Database Tools SQL Query Analyzer, SQL Enterprise Manager, Management Studio, Visual Studio, Solution Explorer, Analysis Manager, Reporting Server:

Methodologies Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling, Agile:

PROFESSIONAL EXPERIENCE:

SQL Server

Confidential, Charlotte, NC

Responsibilities:

• Supported ROC (Risk Overview of Customer) and application which helps the bank in identifying the risk associated with the customer.
• Worked on PIRAT () which is a significant event such as customers being in the news and/or the requested Banks’s response to regulatory or law enforcement requests from such events and then summarize the relevant bank Secrecy Act/Anti-Money Laundering information for internal purposes
• Designing and developing high level ETL Packages to extract, transform and load data from flat files to OLTP and OLTP to Data warehouse tables.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Involved administrative tasks such as data loading, batch jobs, Backup, Recovery and scheduling the backups.
• Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users.
• Writing complex T-SQL queries like Aggregate Queries, GROUP BY, HAVING Clauses, Subqueries, CTEs, Derived Tables, JOINs, UNIONs
• Created Physical Tables and Indexes, Designed KPI’s, Perspectives, Actions using Microsoft Sql Server Analysis Services.
• Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Migrated legacy data from MS Access and Share point into SQL Server 2016 using SSIS Packages in SQL Server Data Tools.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Worked on SSIS performance tuning using counters, error handling, event handler, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Automated hundreds of manual processes with robust solutions having database connectivity, data input and validation, and formatted output
• Assisted in design, build, verification, implementation and maintenance of ETL code / jobs based on business needs
• Coordinated teams to clean large data sets to develop normalized databases for clients in various industries
• Created and served as head of Change Committee, established to allow employees' ideas to flow directly to the chief operating officer and other senior managers.
• Conducted extensive data mining for various databases using advanced SQL for both clients and internal purposes

Environment: MS SQL Server Management Studio 2016, SSIS, SSRS, T-SQL, TFS, Visual studio Data Tools 2017, PL/SQL, SVN, Crystal Reports, Share point .Net, C#, Visual Basic, HTML.

Albany, NY

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers and created documentation for the same.
• Created stored procedures with proper error handling, transactions and performance tuning features.
• Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Managing the Production Support, Development and Hyper care activities related to the application.
• Act as the Business Analyst for the Cost report and some other Kiewit Applications.
• Coordinating with the Functional Team for any Project requirements that come in solution design.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
• SQL-Developer for review and deploy DML/DDL scripts for the creation of tables, indexes and constraints, aggregate functions, and case statements. Oracle PL/SQL using cursors, for, next and open fetch loops, select into, raise application error, autonomous transactions, dynamic SQL and SQL Loader for loading flat files into oracle tables and validating loaded data.
• Created different schedules for report delivery to e-mails and shared directories, enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Used TFS (Team Foundation Server) for code check-in and check-out and manage different versions of complicated code and distribute them to different teams in the organization.
• Optimized cubes by assigning appropriate storage modes to partitions and created usage-based optimizations for better query performance.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
• Implemented Package configuration/parameters to make packages dynamic to modify the SSIS packages from a test /development environment to the production servers for day to day operation.
• Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Designed several scorecards and dashboards using Power Pivot to display information needs by other departments and upper management.

Environment: Microsoft SQL Server 2014/2016, MS Windows Server, SSIS, SSAS, SSRS, T-SQL, Crystal Reports, BI Publisher, C#.Net, SQL, PL/SQL, SharePoint, TFS.

Confidential, St louis, MO

Responsibilities:

• Actively involved in gathering system specification requirements for the project.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Designed indexes and indexed views to speed up query performance and used Database engine tuning advisor for further suggestions.
• Created complex stored procedures to perform Index maintenance, data profiling, for loading data marts and generating datasets for reports.
• Created staging database to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Experience in report generation using Server Reporting Services (SSRS) from relational databases and OLAP cubes.
• Used SSRS to create customized reports, on-demand reports, ad-hoc reports and was also involved in analyzing multi-dimensional reports
• Created intricate set of SQL tables to hold user login and user access information with constraints and access errors were logged in to error tables
• Designed and develop Views, Stored Procedures, Functions and Crystal Reports relating to converted database.
• Extracted data from various sources like Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Implemented Package configuration/parameters to make packages dynamic to modify the SSIS packages from a test /development environment to the production servers for day to day operation.
• Created SSISDB catalog with SQL Server 2015 to support SSIS package deployments in SSMS.
• Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI's & MDX Queries using SQL Server Analysis Services.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Designed several scorecards and dashboards using Power Pivot to display information needs by other departments and upper management.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Optimized reports by optimizing the embedded queries or optimized the stored procedures that generate them.

Environment: Microsoft SQL Server 2008R2/2012/2015, MS Windows Server 2008, SSIS, SSAS, SSRS, Erwin, T-SQL, PL/SQL, Crystal Reports, SharePoint, BI Publisher, C#.Net, SharePoint, Power Pivot, Power View, TFS

Confidential,

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers and created documentation for the same.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Prepared technical and functional designs in collaboration with teams and business users for Netezza
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Crosstab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server, T-SQL, SSIS, SSRS, TFS, Advanced Server, SSMS, ER win v7.2, ASP.Net, C#, SharePoint.