Sql Server Data
Resume:
SUDHAKAR
MSBI Developer
*************@*****.***
PROFESSIONAL SUMMARY:
●Over 5+ years of professional experience in development, implementation and administration of database systems using MS-SQL Server 2008/2008R2/2012/2014 for both OLTP & Data Warehousing Systems applications.
●Well-developed skills in SQL Server Integration Services 2008/2012/2014 for data extraction, transformation and loading using different heterogeneous source systems like flat files, Excel, SQL Server.
●Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
●Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
●Extensively used SSIS, SSAS & SSRS for various BI requirements.
●Expert in designing elevated level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
●Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server and SQL Server Integration Services (SSIS) in MS SQL Server with .NET, Import/Export data, Bulk insert and BCP.
●Expert in SSIS script transformations and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
●Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
●Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
●Hands of experience in execution of Parent and Child Package execution.
●Possess detailed knowledge of aggregation using OLAP analysis services cube.
●Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.
●Valuable experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008/2012/2014.
●Created List, Cross Tab Reports with Quick filters, Summarized Filters.
●Knowledge of developing cubes in SSAS and Analyzing Dimensions and Measures.
●Valuable experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008/2012/2014.
●Worked on SharePoint development and scheduling reports using it.
●Expert in automation of creating jobs, error reporting using Alerts, SQL Mail Agent.
●Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out.
●Ability to quickly adapt to unique environment and work with variety of people at various levels.
●Ability to work in environments with fluctuating priorities and deadlines, foresight to handle upcoming issues and dedication to solve complex problems with experience and research.
●Excellent communication skills, bridging Client Interaction and Team player.
●Organized professional with excellent oral and written communication skills, excellent presentation and interpersonal skills, problem solving skills, and a fast learner who also adapts quickly to modern technologies with the ability to take new roles in minimum time with little training.
TECHNICAL SKILLSET:
RDBMS
SQL Server 2008/2008R2/2012, MS Access
Tools
MS SQL Server 2008/2008R2/2012/2014, MSSQL Server Reporting Services2008/2008R2/2012/2014 (SSRS), MSSQL Server Analysis Services 2008/2008R2/2012/2014 (SSAS), MSSQL Server Integration Services 2008/2008R2/2012/2014 (SSIS), Data Transformation Services(DTS), ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), Web Services.
Programming Languages
C, C#, VB, T-SQL, HTML, SQL Server
Databases
MS SQL Server, 2008/2008R2/2012/2014, MS Access.
Platforms
Windows, Mac OS.
WORK EXPERIENCE:
Client: Molina HealthCare, Long Beach, CA
Role: SQL BI Developer/SSIS/SSRS Developer Feb’17–Present
Responsibilities:
Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2005, and SQL 2008).
Created Configurations to make package portable and created Event handlers for handling package error.
Create and edit alerts on Reports, as per User request.
Worked with users and helped Build a Tabular Data Model and published it to Share Point
Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV, generate reports with parameters, sub reports, cross tabs, charts using SSRS.
Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
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.
Created and modified various Stored Procedures used in the application using T-SQL.
Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
Worked with MDX to query cube's data.
Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
Worked with users and helped Build a Tabular Data Model and published it to Share Point
Involved in dimensional modeling with Star &Snowflake schemas and created the Data Source Views Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
Developed yearly and quarterly company expense reports.
Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
Tuning SQL query for better performance using SQL Profiler.
Actively supported business users for change requests.
Environment: SQL Server 2008/2012, Enterprise Edition, SQL, Enterprise manager, SSRS 2012, SSIS 2012, Spotlight, MS SharePoint, MS Access 2012 & Windows platform.
Client: Scottrade
Role: Business Intelligence Developer Jan’16-Jan’17
Description:
Working in Business Intelligence team helping several Business units across the organization to provide ETL and Analytics using SSIS, T-SQL, SSRS. Worked on critical projects that include Anti-Money Laundering, International Customer Data mapping, Marketing Campaign, Security Encryption, Upgrading SQL Server, Upgrading SSIS packages, Implementing Operational Data Store, New Back Office Source Data, etc. Providing support after hours to handle critical issues. Role of TFS Build Coordinator helping team members keeping multiple projects consistent without overlap. Ownership for multiple Data Objects within organization and team resource for business units like Compliance, Bank and Marketing.
Responsibilities:
Responsible for full lifecycle Business Intelligence (BI) development within the organization.
Worked on creating and maintaining SSIS packages in both SQL Server 2008 and 2014.
Used Control Flow tasks like SFTP task, For Loop Container, For Each Loop Container, Sequence Container, Bulk Insert Task, Script Task, File System Task, Execute Package task, Execute SQL task etc.
Extensively used Data Flow transformations like Slowly Changing Dimension, Conditional Split, Data Conversion, Derived Column, Merge, Multicast, Row Count, etc.
Used Flat File as both source and destination in Data Flow.
Worked on developing SSIS package to export result set to destination folder within Server, different server and emailing to target user base.
Worked on doing ELT.
Handled connections using variables and Package configurations.
Solely responsible for upgrading SSIS packages owned by Business Intelligence team from version SQL Server 2008 to SQL Server 2014. Coordinating with DBA team and Application Support team to ensure zero impact on all the dependent services. Communication with users to explain the upgrade process.
Experience with Visual Studio 2012 and 2015.
Built SSRS reports in SQL Server Version 2005 and 2008 R2.
Enabling http logging for SSRS to track usage of reports.
Worked on creating and maintain T-SQL scripts, stored procedures, views, SQL agent jobs, user defined functions.
Improve performance of the server by optimizing query performance, usage of clustered and non-clustered indexes, column store index, etc.
Implemented Bulk Insert and loading multiple tables in parallel with help of Sequence Container in SSIS.
Build and design Scorecards and KPIs to present the current snapshot of business’ statistics.
Implemented partitioning on large tables.
Worked on merging international customer data into Enterprise Data which involved gathering requirements, creating new SSIS packages and updating existing packages to map with existing fields. Building new definitions to filter international customers from Domestic customers. Providing SSRS reports which focus on International customers profiles.
In Encryptions project worked with DBA team in identifying security critical fields and work on encrypting fields along with implementing decryption of fields for reports.
Marketing Campaign project to identify target customer base using key metrics and providing transparency to Marketing team with respect to the data availability in the data warehouse.
Worked on Back office source data change project. Worked with database development team, DBA team, Application support team and Business Users in identifying high priority reports, changing fields, updating field definitions in relevance to time of transition of source, ensuring smooth transition of data flow.
Worked on Online Apply project which involved loading data through SOAP.
Subject matter expert with thorough grasp of industry.
Utilizing data warehouse and data modeling tools and techniques for performance tuning.
Environment:
Microsoft SQL Server 2012, T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), Visual Studio 2010, SQL Server Agent, Windows server 2008, SQL Profiler, Microsoft SharePoint 2010.
Client: ICICI Bank, Hyderabad, India
Role: MS SQL Developer June ‘14–Nov ‘15
Responsibilities:
Responsible for creating the reports based on the requirements using SSRS 2005.
Identified the database tables for defining the queries for the reports.
Monitored performance and optimize SQL queries for maximum efficiency.
Defined report layouts.
Identified and defined the Datasets for report generation.
Wrote queries for drill down reports.
Identified and included report parameters.
Created scripts for tables, stored procedures, and DTS and SSIS, writing T-SQL statements for retrieval of data and Involved in performance tuning of TSQL.
Formatted the reports using Global variables and expressions.
Deployed generated reports on to the server.
Maintained data integrity by performing validation checks.
Optimized queries tuned and monitored server performance.
Created T- SQL queries for data retrieval.
Fine-tuned the database objects and server to ensure efficient data retrieval.
Created views as per design needs.
Created and modified stored procedures.
Created other database objects like tables, views and indexes.
Environment: MS SQL Server, MS SQL Reporting Services, MS SQL Server Analysis Services, MS SQL Server Integration Services.
Client: Tachyon Technologies, Hyderabad, India
Role: SQL Developer Nov, ‘12 – May ‘14
Responsibilities:
Actively involved in Normalization & De-normalization of database.
Installed and Configured SQL Server 2005 on servers for designing and testing. Designed DDL and DML for MS SQL Server 2000/2005.
Actively designed the database to fasten certain daily jobs, stored procedures.
Optimized query performance by creating indexes.
Involved in writing SQL batch scripts.
Created scripts for tables, stored procedures, and DTS and SSIS, writing T-SQL statements for retrieval of data and Involved in performance tuning of TSQL.
Involved in merging existing databases and designed new data models to meet the requirements.
Create joins and sub-queries for complex queries involving multiple tables.
Used DML for writing triggers, stored procedures, and data manipulation.
Taking Database Full Backup, Transaction log backup & differential backup in daily routine.
Monitor production Server Activity.
Worked with DTS packages to load the massaged data into Data warehousing system. Tuned the SQL queries using SQL profiler and involved in tuning the database.
Very pro-actively identifying the problems before user complaints.
Environment: SSAS, SSRS, MDX, SSIS, SQL Server 2008.
Client: SandyPrati Software Technologies Pvt. Ltd., Hyderabad, India
Role: Junior SQL Developer Oct, ‘11 – Oct ‘12
Responsibilities:
Implemented physical database changes, performance tuning, capacity and architecture planning, index tuning, event and job monitoring.
Created a lot of complex stored procedures, triggers, functions, indexes, views with T-SQL statements in SQL Server Management Studio 2008(SSMS).
Involved in designing and managing schema objects such as Tables, Views, indexes, Stored Procedures, Triggers and maintained referential integrity using SQL Server Management Studio.
Processed ETL to transfer data from remote data center to local data center using SSIS. Cleansing, messaging of the data is done on local data base.
Designed ETL strategy to transfer data from source to landing, staging and destination in the data warehouse using SSIS and DTS (Data Transformation Service).
Developed SSIS packages to export data from Excel/Access to SQL Server, automated all the SSIS packages and monitored errors using SQL Server Agent Job.
Environment: SSIS, SQL Server 2008.
EDUCATION:
BACHELOR OF ENGINEERING IN COMPUTER SCIENCE
Pondicherry University, India.
Contact this candidate