PROFESSIONAL SUMMARY

• Over 8+ years of extensive experience in database design, development, and administration wif MS SQL Server versions 2012/2008R2/2005/2000 using SSIS, SSAS, SSRS in Financial, Retail, Healthcare, Insurance, and Banking industries.
• Experienced wif all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Experienced in designing high level ETL architecture for overall data transfer from teh OLTP - Online Transaction Processing to OLAP - Online Analytical Processing wif teh halp of SSIS.
• Strong experience in designing and developing large number of reports in SSRS using teh data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources.
• Worked wifT-SQL, DDL,andDMLScripts and established relationships between tables usingPrimary KeysandForeign Keys.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• In depth Knowledge inER ModelingandDimensional modeling(Star and Snowflake Schema) building Dimension and Fact tables.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS)
• Good Knowledge on creatingscorecardsanddashboardsusing MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them wif SharePoint Web Services.
• Expert in Creating and Deploying SSRS Reports on teh portal for user accessibility.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Highly proficient in teh use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS 2005.
• Efficient in upgrading and migration from SQL Server 2000 to SQL Server 2012/2008R2/2005.
• Excellent inter personal skills and communication skills and ready to take challenges wif proven ability.

TECHNICAL SKILLS:

SQL Server/BI Tools: SQL Server Management Studio(SSMS),MS Visual Studio 2010/2008, Business Intelligence development Studio(BIDS), Export & Import (DTS), Query Analyzer, SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), SharePoint 2010/2007

Databases: MS SQL Server 2012/2008R2/2008/2005/2000, MS Access, Oracle11g/10g/ 9i

Languages: T-SQL,PL/SQL, C#,VB.Net, HTML, CSS, XML

Operating Systems: MS-DOS, Windows 7/XP/NT 4.0/2000/2003/2008 Server, UNIX

Database Design Tools and Data Modeling: MS Visio 2008/2011, ERWIN r7/r4/r3.5, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

Database Tools and Utilities: SQL Server Management Studio, Enterprise Manager Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor

Version Control Tools: VSS, Sub version, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Miramar FL

Sr. SQL Developer/BI Developer

Responsibilities:

• Worked wif Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in teh analysis and profiling of source data, creating prototypes and sample reports to halp wif requirements and design.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
• Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
• Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables
• Using SQL Server Integration Services (SSIS) to design and maintain ETL Solutions.
• Generated Reports using Global Variables, Expressions and Functions for teh reports usingSSRS2012.
• Participating in defining ETL strategies, preparing transformation rulesand mappingdatafrom source to target
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented security to restrict teh access to users and to allow them to use only certain reports.
• Designed and developed efficientSSISpackages for processing fact and dimension tables wif complextransformations.
• Extracted large volumes of data from various data sources and loaded teh data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
• CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into teh SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Experienced using Visio database design.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints
• SQL Server Index Maintenance and Performance Tuning for Large Tables
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Experienced working wif Autosys scheduler for reporting and monitoring jobs.
• Experience inETL Data Warehouseenvironment. Created Jobs inSSISand was responsible for ETL job scheduled to run daily.
• Designing and implementing a variety ofSSRSreports such asParameterized,Drilldown, Ad hoc and Sub-reports using Report Designer andReport Builder based on teh requirements.
• DesignedSSRSreports wifsub reports, dynamic sorting, defining data source and subtotals for teh report.
• Developed, monitored and deployedSSISpackages.
• CreatingReportsas per user requirements usingSQL Server Reporting Services 2012.
• Written complexT-SQLqueries and created Stored Procedures, Triggers, Functions and Views.
• Experience in SQL DBA.

Environment:MS SQL Server 2008 R2/2012, Excel 2010, Microsoft Integration Services (SSIS), Microsoft Reporting Services (SSRS), Visual Studio 2010, Windows 7, ASP.Net, C#, UNIX

Confidential, Washington, DC

Sr. SQL Server Developer

Responsibilities:

• Worked wif Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in teh analysis and profiling of source data, creating prototypes and sample reports to halp wif requirements and design.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
• Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
• Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables
• Generated Reports using Global Variables, Expressions and Functions for teh reports usingSSRS2008.
• Participating in defining ETL strategies, preparing transformation rulesand mappingdatafrom source to target
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented security to restrict teh access to users and to allow them to use only certain reports.
• Designed and developed efficientSSISpackages for processing fact and dimension tables wif complextransformations.
• Extracted large volumes of data from various data sources and loaded teh data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
• CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into teh SQL Server data warehouse using SQL Server Integration Services (SSIS).
• SQL Server Index Maintenance and Performance Tuning for Large Tables
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Used Script task to write custom code using C#
• Experience inETL Data Warehouseenvironment. Created Jobs inSSISand was responsible for ETL job scheduled to run daily.
• Designing and implementing a variety ofSSRSreports such asParameterized,Drilldown, Ad hoc and Sub-reports using Report Designer andReport Builder based on teh requirements.
• DesignedSSRSreports wifsub reports, dynamic sorting, defining data source and subtotals for teh report.
• Developed, monitored and deployedSSISpackages.
• CreatingReportsas per user requirements usingSQL Server Reporting Services 2008 R2.
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP andSub reports, and formatting them using bothSSRS2008 R2.
• Written complexT-SQLqueries and created Stored Procedures, Triggers, Functions and Views.
• Created data driven subscriptions for different users using Report Manager.

Environment:MS SQL Server 2008 R2/2012, Team Foundation Server, Microsoft SharePoint Server(MOSS 2007), Crystal Reports, SQL Server Integration Services (SSIS), C#, SQL Server Reporting Services (SSRS), Visual Studio 2010, Windows 7,T-, Erwin v8.0, ASP.Net, C#.

Confidential, Tulsa,OK

Sr. SQL Developer/BI Developer

Responsibilities:

• Worked on Migration from SQL Server 2000/2005 to SQL Server 2008R2 and SQL Server 2012.
• Worked on upgrading SQL Server 2000 and 2005 databases to SQL Server 2008 R2 and SQL Server 2012.
• Experience in moving data from heterogeneous data sources to SQL Server usingDTS/SSIS.
• Experience in Bulk Copy (BCP), Script task and Script component for complex SSIS transformations.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad hoc, Sub Reports and created report subscriptions.
• Created Reports wif complex formulas and to query teh database for business Intelligence.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for teh Business Users
• Experience in Designing and Building teh Dimensions and cubes wif star schema using SQL Server Analysis Services(SSAS).
• Migrated DTS packages into SSIS packages.
• Experience in working and fixing defects on upgrades to systems from SQL Server 2005 to SQL server 2012.
• MS SQL Server Configuration,Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Experience in using profilers, IndexTuning Wizard and performance monitor to monitor SQL Server.
• Experience inCreating and Updating Clustered and Non-Clustered Indexesto keep up teh SQL Server Performance
• Worked wif test and production teams to Promote Stored Procedures, SSIS packages and Reports into production.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

Environment: SQL Server 2012/2008R2 Enterprise Edition, Windows Enterprise Server 2008R2, IIS 7.5, C#, SSRS, SSIS, Excel 2007/2010

Confidential, Atlanta, GA

SQL/SSRS/SSIS Developer

Responsibilities:

• Participate in being a member of ICIS team halping users create data, monitoring and resolving issues in teh area of Data Management and Integration Services.
• Perform System and Requirement Analysis, design and writing technical design documents and test plans.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Design and develop mappings, sessions and workflow as per teh requirement and Wells Fargo standards
• Design and develop SQL Server 2008 Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Develop teh application based on Wells Fargo enterprise architecture framework, which includes Understanding and implementing teh Enterprise Architecture Best Practices, Guidelines and Standards, ETL framework and Enterprise Scheduling.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS in SSIS and T-SQL (SQL Server).
• Review code delivery and manage teh version in Team Foundation Server.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Technical Documentation and Perform reviews, design and data manipulation.
• Production Support and resolving teh issues.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

SQL Server Developer

Responsibilities:

• Implemented a well-planned backup and restore strategy that protects databases against data loss
• Responsible for design, development and implementation of mappings/transformations based in source-to-target specifications, definingETL(extract transform, load).
• Developed complexSQL queries,stored procedures, andDTSpackages
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation
• Involved in designing and writingStored Procedures,functionsand packages using T-SQL for SQL Server 2005
• Used DBCC utilities to fix data corruption in application databases
• Development of Business rules implemented asConstraints, Triggersand orStored Procedures
• Actively involved in Normalization & De-normalization of database.
• Installed and ConfiguredSQL Server 2005on servers.
• Designed DDL and DML for MS SQL Server 2005.
• UsingSQL Server Integration Services (SSIS)to populate data from various data sources
• Optimized query performance by creating indexes.
• Involved in writingSQL batch scripts.
• Created scripts for tables,stored procedures andDTS.
• WritingT-SQLstatements for retrieval of data and Involved inperformance tuningof TSQL
• Involved in merging existing databases and designed new datamodels to meet teh requirements.
• Createjoinsandsub-queriesfor complex queries involving multiple tables.
• Used DML for writingtriggers, stored procedures, and data manipulation.
• Taking Databasefull Backup, Transaction log backup & differential backupin daily Routine
• Monitor production Server Activity
• Worked wif DTS packages to load teh massaged data into Data warehousing system
• Tuned teh SQL queries using SQL profiler and involved in tuning teh database

Environment:SQL Server 2005 Enterprise, Windows Enterprise Server 2003, Erwin, Microsoft Visio, DTS, SQL Profiler, Query Analyzer.