PROFESSIONAL SUMMARY:

• Highly motivated Business Intelligence Professional using SQL Server and Microsoft Technologies.
• 9 years of experience in the analysis, design, development, implementation, testing, maintenance, and documentation of Database and Client Server applications.
• Experienced in creating ad - hoc reporting in SSRS. Excellent command with MS SQL Server 2005/2008/2012, worked on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, StronUnderstanding of BI application design and development principles.
• Excellent command with MS SQL Server 2005/20 ; worked on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Expertise in Extraction, Transformation, Loading data from Oracle, DB2, Teradata, SQL Server, Access, Excel, Flat Files and XML files using DTS and SSIS
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in ETL from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT alsoKnowledge on other tools like Data stage.
• Analyzed the source data, coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Expert in Microsoft SQL Server 2014, 2012, 2008 and 2005 backend programming.
• Outstanding skills in using Client/Server architecture in implementing MS SQL Server based applications.
• Experience with Backup and Recovery of MS SQL 2 Server Databases.
• Expert in creating SQL objects like Tables, Complex Stored Procedures, Triggers, Views, Indexes, and User Defined Functions to facilitate efficient data manipulation and consistent data storage.
• In-depth knowledge of T-SQL (DDL and DML).
• Experience in Database design, Development, Data Modeling, Administration, ETL packages using DTS / SSIS, Performance Tuning, Stored Procedures for Database applications using MS SQL Server 2012/2008/2005/2000/7.0
• Well experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel
• Experienced in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
• Installed, configured and maintained SSRS server.
• Experience working with Data Cleansing technique in ETL process.
• Excellent hands on experience in creating groups and measures, KPIs.
• Designed and developed DS data flows and ETL components.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Experienced in merging data from various heterogeneous data sources, Populating Dimension and Fact tables in data warehouses and data marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in creating configuration files to deploy the SSIS packages across all environments.

TECHNICAL SKILLS:

RDBMS/Databases: MSSQL Server 2000/ 2005/2008/2012, Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007, MYSQL.

Programming Languages: T-SQL, PL/SQL, Dynamic SQL,C, JAVA, MDX, XML, HTML, DHTML, Shell Scripting, JavaScript, Visual Basic 6.0, ASP .NET.

Data Modeling: MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-normalization Techniques, MS- Access.

ETLTools: DTS, SQL Server Integration Services (SSIS).

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) SQL Server Analytical Services (SSAS 2005/2008/2012 ), Data Transformation Services (DTS), Visual Studio, BIDS, Power BI.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0,Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2.

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007/2010.

PROFESSIONAL EXPERIENCE:

Confidential

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008.
• Installed and configured SQL Server 2008 successfully.
• Involved in designing technical specifications for building Data Warehouse.
• Contributed in creating ETL designs and provided end users an easy accession to data marts.
• Troubleshot and resolved data models issues and formulated reports and analytical programs
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business.
• Extensively worked on performance tuning of the ETL process and SQL optimization on a large database.
• Developed data Mappings between source systems and warehouse components
• Analyzed the existing data and performed the migration steps to SQL Server 2008.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Lookups, Aggregations, and Multicasting.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extract data from access, excel, flat file, and different data base and load in SQL data base Using SSIS packages.
• Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
• Verified different packages using Views using SQL Integration services 2008.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2005/2008
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Performance testing on Store procedures, Indexes.
• Business function knowledge of ERP including Financials, Project Management, Human Resources, Payroll, etc.
• Involved in generating summary reports like Tabular, Matrix using SSRS.
• Expertise in using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2008 R2 Management Studio, SSIS, SSRS, SSAS, T-SQL, Power BI, MS Access.

Confidential, IRVING, TX

SQL BI/SSIS/ETL Developer

Responsibilities:

• Created ETL packages using SSIS to extract data from different data sources, reformats the data and load the reformatted data into destination tables.
• Responsible for transferring the data using SSIS packages from excel/flat file sources to database.
• Responsible for deploying/scheduling SSIS packages as per schedule.
• Developed Stored Procedures, Functions, Tables, Views and other T-SQL code and SQL joins for applications.
• Published migrated data using SSIS (SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.
• Developed, Prepared Unit Test documents for all SSRS reports.
• Developed several stored procedures to handle large amount of data manipulation.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2005/2008
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: MS SQL Server 2008 Management Studio, SSIS, SSRS, SSAS, T-SQL, MS Access, Windows Server

Confidential

SQL Server/BI Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Functions and Queries with best execution plan.
• Extensively worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Extensively used Joins and CTE’s for complex queries involving multiple tables from different databases.
• Worked with Exception handling with @@error and with Try/catch.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Modifying existing SSIS packages and Stored-Procedures which are used in revenue data ETL process.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Creating SSIS package to load data from Flat file to data warehouse databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate and Pivot Transformation.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems by adding or enhancing relevant entities/ tables, columns etc.
• Enhancing performance of SSIS packages and SQL queries using optimization techniques.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Created reports which include Matrix, Drill Down, Drill Through, Cascading, parameterized and chart Report types from data mart databases using SSRS.
• Deploying SSRS reports to report server and managing report subscriptions.
• Involved in report snapshots to improve the performance of SSRS.
• Worked on Excel 2010, Power Pivot for providing ad-hoc reporting.
• Creating and scheduling new SQL Server Agent Jobs to execute new data load process steps.
• Modifying existing Facts and Dimensions in SSAS cubes based on new requirements from users.
• Created User Defined Hierarchies depending on the business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different measure groups and calculations using SSAS.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: Microsoft SQL Server 2008, 2008 R2, Visual Studio 2008, T-SQL, SQL Server Analysis Services, SQL Server Integration Services, Business Intelligence Development Studio (BIDS), Power Pivot, SQL Server Reporting Services, Net (Asp .Net, VB.net C# .Net), SQL server profiler, Team Foundation Server, Visual Source Safe.

Confidential, NY.

SQL SSAS/SSRS/SSIS Developer

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Created functions and developed procedures to implement application functionality at the database side for performance improvement.
• Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
• Created DTS and SSIS packages.
• Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created ETL package for data conversion using various transformations tasks.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
• Created dash board to show the business performance.
• Created partitions and designed aggregations in Cubes.
• Created perspectives in SSAS and configured security levels for the Cubes.
• Designed KPI’s in SSAS and imported them to Excel.
• Created custom reports which had cascaded parameters using SSRS/SQL Server BI studio.
• Created Ad hoc reports using SSRS.
• Created reports that call Sub reports in SSRS.
• Created datasets for reports using T-SQL and stored procedures
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Responsible for Query optimization and Performance tuning

Environment: SQL Server 2000/2005 Enterprise Edition,.NET Framework, XML, T-SQL, SSIS 2005, SSRS, SSAS,VisualStudio.NET IDE, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access. Visual Studio 2005.

Confidential, Louisville, KY

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked with Business Analysts and Users for gathering requirements and implemented logical Design into Physical Design.
• Wrote the complex queries using joins, Sub-queries, common table expressions (CTE) in T-SQL.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Created and Modified tables, Views, Indexes, User Defined Functions and Stored Procedures.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File and vice versa.
• Implemented the concepts of Incremental Data Load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Used complex transactions and Validations to make sure the data is correctly loaded into the warehouse
• Used Configuration files to deploy and install a package from one environment to another.
• Used SSIS features like event handlers, property expressions, package configurations, transaction option and protection levels in the packages.
• Created Charts, Tabular and Matrix reports using SSRS, with Drill Down and Dill Through features.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
• Created cubes and dimensions and defined the d Relationships with the measure groups and fact tables.
• Implemented calculations to aggregate physical measures.
• Responsible for identifying KPIs in SSAS 2008.
• Created jobs and scheduled jobs using SQL Server Agent.
• Integrated Database Maintenance jobs to perform Full, Differential and transaction log Backups and scheduled them with SQL Server agent job scheduler.

Environment: MS SQL Server 2008, T-SQL, MDX, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS 2008), ETL, Business Intelligence Development Studio (BIDS), MS Excel, Advanced Windows 2005 Server, VB Script, Oracle 10g/9i, XML, SharePoint Servers, Team Foundation Server (TFS).

Confidential

SQL Server Developer

Responsibilities:

• Interacted with end users to gather Requirements. Created technical, user documentation.
• Studied and designed the system.
• Install, Update, Configure and Maintain the MS SQL Server.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.
• T-SQL queries for the retrieval of the data.
• Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
• Tuning front-end applications like Visual Basic, which query the SQL Server databases.
• Written Various ASP codes for user interactions.
• Written Java Script for different validations
• Used SQL Statements to Present Query responses.

Environment: SQL Server 2000, T-SQL, UNIX, .NET, VB Script, JavaScript, ASP, Microsoft Excel, FrontPage 2000.