SUMMARY

• 8 years of experience as Microsoft SQL Server BI Developer with extensive background in information gathering and administration, analysis, development, testing and maintenance of Databases.
• Adept in T - SQL Querying and implementing 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.
• Extensive experience in MS SQL Server 2000/2005/2008 , Business Intelligence in MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS).
• Experience in SQLServer Analysis Services (SSAS) for designing OLAP Cubes.
• 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 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.
• 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, SQL, T-SQL, PL/SQL

Web Technologies: HTML, XML, JavaScript, CSS

Operating Systems: Windows Server 2008, Windows XP/NT/2000, DOS, Windows Server 2003, IBM 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: Microsoft SQL Server Reporting Services (SSRS), Crystal Reports

DB Modeling: Erwin, MS-Visio, SQL Diagrams

Other Tools: Microsoft Visual Studio 2012/2010/2008 , SAP Integration Kit, Microsoft Project Server 2007, ProClarity, SQL Doctor, Ignite, Visual Source Safe, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

MS SQL Server BI ETL Developer (SSRS, SSIS)

Responsibilities:

• Identifying process improvements for database performance, reliability and stability.
• Responsible for migration of data from SAP system 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 and tuning the performance of such queries.
• Identified missing indexes using SQL Execution plans and created the required indexes.
• Enable error handling strategy i.e. transaction isolation to help rollback of transaction when package fails.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports
• Creating Reports as per user requirements using MS Reporting Services 2008/2008R2
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS.
• 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.
• Use Master Data services (MDS) to create golden records for customer.
• Use DQS (data quality services) to create knowledge base of data.
• Use TFS (Team foundation server) source control tool to check in all of the codes in daily basis.
• Use waterfall SDLC process.
• Created the SSIS and scheduled them using SQL Server agent.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, reports using SSRS 2012/2008.
• Worked on improving performance of the various bad performing Stored Procedures by eliminating any inline queries and also using query hints.
• 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 many Reports and using SQL Server Reporting Services (SSRS).
• 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
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Developed SQL Jobs through SQL Server Agent for scheduling the SSIS packages to be executed periodically.
• Created partitions on the tables using partition scheme and partition function to improve the performance of the queries.
• Evaluating existing database by using third party tool SQL Doctor and recommend improvements for performance efficiency.
• Extensively used JIRA for bug tracking and Project Management.

Confidential, Houston, TX

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Maintenance of jobs to backup cubes
• Create\document ETL framework and a template package to help developers understand ETL development strategies.
• Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.
• Document the process flow and logic to move data from staging to data warehouse.
• Create packages using multithreading enabling the parallel processing property of SSIS.
• Create cubes having multiple fact tables and dimension tables and create calculated columns using named query and named calculation property of SSAS.
• Create parameterized reports to accommodate business required.
• Creating 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.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Deploying and scheduling SSIS Packages using SQL server Agent, windows scheduler, batch files, .dtsx utility to generate data as per current status.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• UsedSSISto createETLpackages to validate, extract, transform and load data into database.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.
• Developed various operationalDrill-throughandDrill-downreports usingSSRS.
• Use of agile SDLC approach to complete and track tasks on time.
• Facilitate move of running project from waterfall to Agile for better productivity.
• Strong Experience in Creating, Configuring, Deploying and Testing SSRS and SSIS Packages.
• 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.
• Involved in multiple projects at same time to accommodate resource shortage.
• Limited time build manager role to facilitate build of template packages, cubes and reports to meet company 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 interpreting execution plan and SQL profiler
• Created Clustered and Non Clustered Indexes on tables to improve performance of reports.
• Developed the T-SQL queries and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created automated stored procedures for day end operations using SQL Server Agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Implemented failure alerts using Send Email task in SSIS.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Created and used extended stored procedure in SSAS.
• Snapshot Replication was been used to synchronize the data between their 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.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• 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, Chicago, IL

Sr. BI developer

Responsibilities:

• Maintain two existing cubes for Online Reporting and Customer Relationship (ORCR) to function as per business requirement.
• Create aggregations on cube partitions, partitioned per month so as to have increased performance.
• Create algorithm to disable and rebuild indexes during update process of cube.
• Help in decentralization of source box so as to have an independent feed.
• Construct packages to cleanse data and store it into data warehouse.
• Used libraries such as HTML agility pack to be added as reference to format XML data.
• Update packages to accommodate business needs so that required data is available readily.
• Debug performance issue pertaining to unused indexes memory overload and poor script.
• Work on SGML and XML data to parse it using Xpath language.
• Debug Ad-hoc reporting issues.
• Develop PCM to facilitate move of logic from development to QA and production environment.
• Replace hardcoded variables values in packages with expression to help in move from on server environment to other.
• Excellent command on subscriptions, report snapshot and report cache.
• Create unit test in C# to test for logic before move to QA environment.
• Debug any production issue pertaining to license and also discrepancies arising from transfer of logic from dev to production.
• Used third party SSIS transformation tools like cozy Rocs to replace slow SSIS transformation with a more effective and performance boosting transformations.
• Use SCOM alerts when package fails and have an event handler to send emails.
• Attend daily standups as a part of agile environment and provide an in site into progress and difficulties faced in a particular story.

Confidential

MS SQL Server / SSRS / SSIS Developer

Responsibilities:

• Gathered and clarified the functional requirements from Team and Business by referring to low level design documents and designed High Level Requirement Document.
• Responsible for creating 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).
• Migration of huge volume of data from existing systems to the new Normalized Databases using SSIS Packages. All the existing loan data and historical reports are being migrated through 6 intensive 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.
• Responsible for developing and maintaining ODS run book.
• Involved with performance tuning and improving of response times for databases.
• Extensively used Visual Source Safe (VSS) as source control.
• Managed Database files, transaction log and estimated space requirements.
• Planned and scheduled backup strategy to ensure reliable backup.