SUMMARY

• Over 7 years of experience in IT as SQL Server Developer and strong work experience on Business Intelligence tools.
• Demonstrate professionalism, attention to details, collaborative nature and a quick learner. Strong communicator exhibited by working closely with users to identify and resolve problems. In addition to working well individually, an effective team player.
• Strong analytical and problem solving skills, Ability to work to deadlines, Results oriented Flexible, and Adaptable.
• Experience in data migration between homogenous and heterogeneous system using Data Integration tools on various RDMS environment like - SQL Server 2012/2008/2005 , and MS Access.
• Experience inNormalization and De-normalization
• Experience in creating complexSSISpackages for ETL purposes using various transformations inSSIS2008 and SSIS2012. Also transformed data from various data sources to SQL Server using BCP and SQL.
• Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports creating on demand and scheduled reports in SSRS 2008, SSRS 2012.
• Experience in Performance Tuning and Optimization of queries and stored procedures.
• Proficient in using SQL Profiler, Execution Plan and Performance Monitor. Skilled in performing Backups and Recovery, Replication, Security management, Jobs and working with Linked Servers.
• Experience in Database Design and development of applications with Business Intelligence using SQL Server 2012/2008/2005 (T-SQL), Integration Services (SSIS), Reporting Services 2005(SSRS).
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop SQL Objects and maintain Stored Procedures and User defined functions.
• Hands on experience in creating ETL packages using SQL Server Integration Services (SSIS 2005/2008/2012 ).
• Experience in migration of Data from various Data Sources such as Excel, Flat file, XML and SQL to MS SQL Server by using SQL Server Integration Services (SSIS) and DTS utility.
• Efficiently involved in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Drilldown / DrillThrough Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Proficiency in creating different types Parameterized Reports such as Cross-Tab, Drill-down, Drill-Through, Summary, Graph, Chart and formatting those using SSRS 2005/2008/2012 .
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Excellent communication skills, analytical skills, understand business requirements in various domains.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSISPackages.
• Experienced in handling Slowly Changing Dimensions while loading data into data warehouse.
• Experience in Building cubes using SSAS

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista/7, Windows Server 2003/2003 R2/2008/2008 R2

Database Tools: SQL Server Management Studio (SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard.

GUI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2005/2008/2010

Languages: T-SQL, PL-SQL, XML, VB Script, HTML

OLAP Tools: SSIS, SSRS

Source Control Tools: Visual Source Safe 2005, Team Foundation Server 2010

PROFESSIONAL EXPERIENCE

Confidential, Dallas Texas

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Created, implemented and maintained a reporting suite of over 60+ standard reports while also customizing many reports to meet individual client needs.
• Migrating SQL Server 2000 DTS packages to SSIS packages for uploading various formats of files and data from the legacy databases and SQL Server 2000 to MS SQL Server 2005 Data warehouse using SQL Server Integration Services (SSIS).
• Used DTS migration wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures and Scripts.
• Deployed reports to report manager and troubleshooting for any error occur in execution.
• Scheduled the reports to run on daily and weekly basis in report manager and also email them to managers and analysts to review in excel spread-sheet.
• Worked with Business analyst, Data architect and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications
• Creating promotion request plan documents, ETL standards templates to resolve issues for SSIS jobs.
• Created drill down, drill through, Matrix reports, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created dashboards for Trading Division, Portfolio Manager and Control Division to provide the latest Holdings.
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Converted MS SSRS 2005 and Excel based reports to MS SSRS 2008 based reports.
• Created Tables, Views and Indexes

Environment: SQL Server 2012/2008(SSMS), SQL Server Business Intelligent Development Studio 2008(BIDS), .NET Scripting, Team Foundation Server 2008, MS Excel 2016.

Confidential, Laurel Maryland

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Create and modify all the needed stored procedures, user defined functions, scripts, and SSIS packages to extract, transform and load (ETL) the data from several data sources to MS-SQL Server Data Warehouse.
• Responsible for enhancements, maintenance and monitoring of the data warehouse on SQL Server and the daily ETL Process.
• Analyze source system data to determine the data model and ETL solution that will meet business requirements.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Create packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, data conversion, fuzzy grouping, script components.
• Create complex scripts to massaging, scrubbing and cleansing of legacy data in staging area.
• Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.
• Create various Stored Procedures to validate the data from the source and update/insert the records into target tables.
• Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans.
• Create technical specifications, test plans and test data to support ETL processes.
• Work closely with Report analysts and operation staff for support in problem resolution and root cause analysis
• Create/monitor scheduled data warehouse jobs using SQL Server Agent jobs.
• Designed and developed report with running value, interactive sorting as well as conditional formatting, Created sub-reports to present more detailed information about the summary.
• Experience in creating reports using stored procedures. Involved in scheduling, creating snapshot and subscription for the reports and triggers to facilitate consistent data entry into the database.
• Created SSRS report model projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Work with users and business analysts to design and develop tabular, matrix, gauges, chart, and drill down reports as well as interactive reports according to business requirements.
• Render reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscriptions.
• Integrate with TFS for version control, build documentation, and workflow tracking
• Participate in Quality processes such as design reviews, peer code reviews, version control and documentation.
• Generated periodic lockbox reports for various banks and clients using SQL Server Reporting Services (SSRS).
• Created Drill reports which give all the details of various transactions like Lockbox transactions, Batch details, and summary of transactions and scheduled this report to run on daily basis.
• Deployed and configured the reports in the Report Server.
• Extracted Data from various Heterogeneous Databases such as Access database, flat files to SQL server 2008 using SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible. Schedule the packages to keep extracting the data from OLTP at specific time intervals.

Environment: SQL Server 2008(SSMS), SQL Server Business Intelligent Development Studio 2008(BIDS), .NET Scripting, Team Foundation Server 2008, MS Excel 2005.

Confidential, Washington DC

SQL SERVER Developer

Responsibilities:

• Generated database SQL scripts and deployed databases including installation and configuration.
• Design and Build Extract Transform Load procedures in SQL Server 2005 to import/export data feeds to/from data warehouse.
• Worked with SSIS to import, export and transform the data between the linked servers.
• Involved in Migration of few objects from SQL Server 2000 to SQL Server 2005 using Migration Wizard.
• Worked on Stored Procedures and Database Triggers and business analytical functions.
• Tuned the database to perform efficiently by managing databases using the option grow or shrink database files and monitor the size of transaction log.
• Responsible for data transfer and replication over internet between the offshore development site and onsite implementation site.
• Developed various DTS packages to export and import data between databases.
• Wrote various T-SQL stored procedures and Triggers to carry out various tasks
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Used Microsoft Source Safe for version control and configuration management

Environment: SQL Server 2012/2008/2005 , Windows 2003, SQL Server Management Studio, T-SQL, DTS, SSIS, Visual Source Safe, VB.net, ASP.net, SQL Profiler, Query Analyzer, Microsoft Source Safe.