SUMMARY

• 7+ years of experience as a MS SQL Server BI Developer with extensive background in requirements gathering, analysis, development, testing and maintenance of Databases.
• Adept in T - SQL Querying and Created Stored Procedures, Triggers, Functions, Dynamic Queries and Views in Microsoft SQL Server 2012/2008 R2.
• Experience in extracting and transforming data using DTS Import Export Data, DTS Packages, SSIS and in using BCP for Bulk copy operation and Bulk Insert
• Experience in developing reports using SQL Server 2012/2 Reporting Services (SSRS).
• Experience in tuning the queries for better performance using SQL Server tools like SQL Profiler to monitor the performance and improve the same.
• Extensive experience in creating several reports such asdrill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reportsusingSQL Server Reporting Services.
• Excellent inrendering reports, managing subscriptions,creating reports with report builder, report snapshot and report cache.
• Active participation inSoftware Development Life Cycle (SDLC)specifically waterfall and Agile Scrum methodology.
• Hands on experience withDimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Created and ConfiguredData Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s and MDX Queriesusing SQL Server Analysis Services.
• Experience in migrating data from SAP system to SQL Server Databases.
• Good experience in user management for Databases, maintaining of databases, and providing SQL Server security by assigning Logins and Server permissions.
• Created maintenance plans to perform Index Defragmentation, Re-indexing and update the Index Statistics and also creating Columnstore Indexes.
• Involved in automation of administrative tasks like creating Jobs, Schedules, Alerts using SQL Server Agent and monitoring and troubleshooting jobs, event notifications using Database Mail feature.
• Experience using Red Gate SQL Backup Pro tool for taking regular compressed backup of databases.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Expert in using tools like MS SQL Profiler, Query Execution Plan, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins.
• Strong attitude towards learning new technologies and sharing ideas

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Configuration Manager, SQL Profiler, Quest Spotlight, Redgate tools (SQL Backup Pro), SSAS, SSIS, SSRS

Languages: Java, ASP.Net, VBA, VB script, Shell Script, SQL, T-SQL, PL/SQL

Web Technologies: HTML, XML, JavaScript, CSS

Operating Systems: Windows Server 2008/2003/2000/ XP/NT, DOS, AIX, Linux

Databases: MS SQL Server 2014/2012/2008/2005/2000 , DB2, Oracle 10g/11g

ETL Tools: Microsoft SQL Server Integration Services (SSIS), Data Transformation Services

Reporting Tools: MS SQL Server Reporting Services (SSRS), Crystal Reports

DB Modeling: Erwin, MS-Visio, SQL Diagrams

Other Tools: MS Visual Studio 2012/2010/2008 , QNXT, Tableau, SAP Integration Kit, MS Project Server 2007, ProClarity, SQL Doctor, Ignite, VSS/ TFS Source Control, EC2, Power BI

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

MS SQL Server SSIS Developer

Responsibilities:

• Identified process improvements for database performance, reliability and stability.
• Responsible for migrating data from SAP to SQL Server Database. Designed the logical and physical data models, provided data flow diagrams, transformation logic, source to target data mapping spreadsheets, data dictionary etc.
• Identified slow performing queries with the help of Dynamic Management Views & SQL Execution Plan and tuned them.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Creating Reports as per user requirements using MS Reporting Services 2008R2
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS using Global Variables, Expressions and Functions
• Developed MDX queries and Data Mining Expression (DMX) queries for SSAS 2008 and SSRS 2008.
• Enable auditing of package and underlying expensive tasks into a database table to help in performance tuning.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Create various file and database validation rules like schema validation, null file validation, invalid file format validation, duplicate file validation and database connection check validation.
• Create document ETL framework and a template package to help developers understand ETL development strategies.
• Used MDS (Master Data services) to create golden records for customer.
• Used DQS (Data Quality Services) to create knowledge base of data.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join.
• Created many table-valued functions and scalar valued functions as per requirement and eliminated redundancy using these functions.
• Implemented Full text search feature on required tables by creating Full-text Index.
• Developed SSIS Packages using SQL Server Integration Services (SSIS) for extracting data from flat files, transforming the data by replacing empty values with nulls and loading into database tables.
• Pull the data from SAP ECC 6.0 to SQL Server 2012. Data is available in ECC tables.
• Developed SQL Jobs through SQL Server Agent for scheduling the SSIS packages to be executed periodically.
• Evaluating existing database by using third party tool SQL Doctor and recommend improvements for performance efficiency.

Confidential, Reston, VA

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Analyzed and interpret complex data on all target systems and analyze and provide resolutions to all data issues by coordinate with data analyst to validate all requirements.
• Created different types of (SSIS) SQL Server Integration Services Packages optimize and tune data flow task in SSIS using Profile and SSIS performance. Monthly Load Processing/Automation using SSIS.
• Created and Maintained of jobs to backup cubes having multiple fact tables and dimension tables
• I've been using at RedGate's SQL tools and Microsofts Visual Studio Team System Database Edition (formerly Data Dude) for use within a testing and continuous integration environment.
• Documented the process flow and logic to move data from staging to data warehouse.
• Created packages using multithreading enabling the parallel processing property of SSIS.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Responsible for creating and changing the visualizations inPower BI reports and Dashboards on client requests
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the reports with parameterized to accommodate business requirements.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.
• Developed various operationalDrill-throughandDrill-downreports usingSSRS.
• Used variousSSIStasks such as Conditional Split, Multicast and Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Played build manager role to facilitate build of Template Packages, Cubes and Reports to meet Organization Standards and Protocols.
• Develop and perform tests on all ETL codes for system data and analyze all data and design all Data Mapping Techniques for all data models in systems.

Confidential, GA

MS SQL Server BI Developer

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Used subqueries, joins, CTE’s and Analytical functions for data retrieval for reporting needs.
• Involved in Performance Tuning of queries by using Execution Plan and SQL profiler
• Identified and Improved performance of Stored Procedures & SQL Queries using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Created Clustered and Non Clustered Indexes on tables to improve performance of reports.
• Create Used Microsoft Dynamics CRM 3.0 to keep track of business leads and opportunities
• Used Microsoft CRM workflow functionalities to customize companies’ business needs.
• Coordinated with UI & Business team for implementing business logic in stored procedures and functions.
• Implemented eMail alert mechanism for failure tasks in SSIS.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Used Snapshot Replication to synchronize the data between various Different Stores.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
• Involved in SQL Server Mirroring and Database optimization.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Involved in Processing QNXT 837 Healthcare Claims (Institutional and Professional) in PORTAL with valid TPI.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Developed Query for generating drill down reports in SSRS 2008.
• Developed Ad Hoc reports through report builders.
• Created data driven subscriptions for different users using Report Manager.

Confidential

MS SQL Server / SSRS / SSIS Developer

Responsibilities:

• Gathered the functional requirements from Business users and created Low level/High Level design Documents.
• Created complex Store Procedures, Views, CTE's, Partition functions as per BRD and FRD's.
• Involved in creating SQL Scripts, DDL and DML commands which are responsible for migration of de normalized Loan tables into normalized Loan tables.
• Re-Writing the existing Stored Procedures on the new Normalized Databases to ensure that User Interface Reports remain intact.
• Created various Ad-hoc Reports through SQL Server Reporting Services needed for business and end users for loan processing.
• Developed Complex Parameterized, Cascading Parameterized and Drill Down reports using SQL Server Reporting Services (SSRS).
• Migrated huge volume of data from existing systems to the Normalized Databases using SSIS Packages.
• Involved in creating XML based Package configurations for deploying the SSIS Packages in various environments.
• Engaged in creating SQL Functions and Views required for Loan Balance and Loss
• Balance Calculations and Monthly, Weekly Loan Transactions based on Run dates.
• Redesigned and tuned Stored Procedures, Views, Indexes and was successfully able to increase the performance of the queries. SQL Profiler and Database Tuning Advisor are been used to analyze complex queries.
• Responsible for Scheduling the Stored Procedures, SSIS Migration Packages through SQL Server Agent Job on weekly and monthly basis.
• Involved in analysis and issue report of mapping elements between old and new databases created by System and Business analyst team.
• Understanding and doing the impact analysis on the migration of new business scenarios introduced along with the release of normalizing the databases.
• Offshore coordination and issue resolution with Database and QA team working at offshore development centers.

Confidential

MS SQL Server Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data from multiple flat files and source systems
• Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in MS SQL Server 2000 and maintained code scripts in Visual Source Safe (VSS)
• Created joins and sub-queries for complex queries involving multiple tables.
• Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form for highest performance.
• Validated change requests and Standardized the implementation of data with recommendations.
• Designed and developed dynamic SSIS packages to process dynamic queries and dynamically produce flat files at runtime.
• Migrated data to transfer database objects among servers using different SSIS packages in Business Intelligence Development Studio (BIDS).
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team for releases and quality assurance
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning for client databases and customer backend systems.
• Managed user access, security, logins and roles and also created and managed new security accounts.
• Involved with performance tuning and improving of response times for databases.
• Managed Database files, transaction log and estimated space requirements.
• Planned and scheduled backup strategy to ensure reliable backup.