SUMMARY:

• Over 7 years of experience in Design and Development of Database and Business Intelligence with SQL Server 2005/2008/2012.
• More than 6 years of experience in SQL server Installation, Configuration, Administration and Performance tuning of the databases.
• Extensively worked on Data Extraction, transforming the data by using SSIS.
• Hands on experience in scheduling and deploying reports on report manger.
• Adept in creating ad - hoc, drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports
• Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data
• Experience in extracting, loading data to/from sources like OLEDB, Excel, flat files etc. using SSIS.
• Experience in reports scheduling and subscription processing using SQL server Reporting services manager.
• Experience in query optimization & performance tuning, used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experience creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, managing indexes and locks, troubleshooting deadlocks.
• More than 5 years of experience with database Authentication Modes, Creation of users, Configuring Permissions and assigning roles to users.
• Over 4 years hands on experience in Migrating SQL 2000 DTS packages to SQL 2005 SSIS and converting data from source to destination systems.
• Proficient in Creating SQL Server Integration services Package configuration files, implementing logging in packages and error handling.
• Hands-on experience and strong knowledge of high availability SQL Server solutions, including SQL Server Log shipping and SQL Server clustering.
• Strong knowledge of Setting up Backup/Restore and disaster recovery procedures to ensure minimal downtime and data loss.
• Expertise in design and development of Reports, generating on-demand and scheduled reports for business analysis.
• Proficient in creating Matrix, Tabular, Drilldown, Drill through and Graphic reports using SQL Server Report Services.
• Good team player, strong interpersonal and communication skills combined with self-motivation and initiative.
• Highly skilled in analyzing information from various data sources to fully functional databases. Built comprehensive systems for AP, AR, HR and payroll functions.
• Implemented the databaseoptimization techniques, documented the process change, and trained subordinates on the tools developed
• Expertise in creating Complex Stored Procedures, Queries for the application team and for the end users based on the business requirement.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating SSIS Packages.
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008R2/2008/2005/2000, Oracle 8i/9i/10g, MS-Access 97- 2007

Operating Systems: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

ETL Tools: SQL Server Integration Services(SSIS) 2005/2008, Data Stage, DTS, SQL Server Reporting Services (SSRS), Crystal Reports 8/10, SQL Server Analysis Services (SSAS)

Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front

Programming languages: C, C#, VB.NET, Visual Basic for Applications (VBA) and ASP.NET, SQL, PL/SQL

Other Tools: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize, Erwin, Microsoft Visio 2000/2003.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Sr. SQL Server BI Developer

Responsibilities:

• Build SSIS package to handle data from Oracle 10 g, Mainframe system applications and external files.
• Code scripts to build the stage and relational tables for new requests.
• Added operational metrics for direct fulfillment stores channel.
• Added dimensions and measure group to the cube.
• Write MDX scripts for Catalog, Direct Order, Web reporting
• Created SSIS packages to load insurance data received from different insurance agents and other locations into consolidated data warehouse using Derived column, Lookups, Fuzzy Lookups, Conditional split, Execute SQL Task, Data Flow Task, and Execute Package Task.
• Used MDX queries for pre calculated measures and created report model on SSAS cubes as well as changing default configuration on existing cubes.
• Created report Model using T-SQL queries on SSAS Cubes as well as changing default configuration on existing Cubes.
• Involved in setting up hierarchies and defined scope of analysis for providing drill down/ drill through options in the reporting environment.
• Develop snapshot report for dashboard and add enhancements.
• Validate data in reports by cross checking the metrics built.
• Support production issue and code fix to the existing processes.
• Designed ETL packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Document development approach and the move code to version control as per code standards meeting DEV, UAT and Production system.
• Developed parameterized .bat jobs to process SSIS packages and written Autosys jobs for scheduling.

Environment: SQL Server 2008 R2, SSIS, SSAS, SSRS, SharePoint server 2007, Visual studio 9.0, ASP.NET, VB.Net, Business Intelligence development Studio R2; Autosys.

Confidential, King of Prussia, PA

Sr. SQL/BI Developer

Responsibilities:

• Responsible for installation, configuration, security, maintenance, restoration of SSRS on Windows Server 2008.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Worked with database objects like Tables, views and indexes.
• Created ad-hoc reports using SQL server 2008 Reporting Services (SSRS).
• Uploaded SQL Server 2008 Reporting Services (SSRS) RDL files to SQL Server 2008.
• Migrated all DTS packages to SSIS and modified the packages accordingly using the advanced features of SQL Server Integration Services like Execute DTS 2000 package task.
• Played a major role in production support of SSIS jobs.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SSIS data flow tasks like Data conversion, Conditional Split, Derived Column, Multicasting.
• Provided Full Reporting Life Cycle support using MS SQL Server Reporting Service 2008.
• Created parameterized, drill down and aggregation type of reports in SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Gauged the effectiveness and efficiency of existing reporting systems. Developed and implemented strategies for improving and further leveraging these reports in order to transfer/convert existing Reports to SQL Server Reporting Service.
• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Applied Security to Web Server and Database Server that affects Report server installation. Managed role-based security to reports and reporting resources.
• Responsible for back up and Restoration of SQL Reporting Service.

Environment: Windows XP, MS SQL Server 2008, MS SQL SSRS 2008, MS SQL SSIS 2008, BIDS, Excel, Acrobat Reader.

Confidential

Sr. SQL/BI Developer

Responsibilities:

• Worked on the analysis of the Design Specification documents for the Packages and coordinated with team members at the time of changes in Business requirements and changes in Data Mart Schema.
• Designed, reviewed, and created primary objects based on logical design models, user requirements and physical constraints.
• Upgraded the data from one server to another server (SQL Server 2008 to SQL Server 2012) for the SSIS Packages and SSRS reports.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Implemented the changes in the existing ETL process to move data back and forth from ODS to all the integrated systems.
• Developed SSIS Packages to extract data from Excel spreadsheets, Microsoft Access database and flat files, load them onto SQL server 2012 for Data Analysis and Reporting by using multiple data flow transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Created Clustered and Non-Clustered Indexes for Query Optimization and also involved in Database Tuning.
• Created triggers that capture the customer updates and made the required transformations to move the customer preferences to ODS.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Performed daily tasks including backup and restore from disaster recovery in SQL Server 2008/2008R2 using SQL Server Management Studio.
• Configured Replication methods like snapshot replication, transactional replication and Merge replication for two environments.
• Worked on the performance optimization of the ODS import jobs.
• Worked on the analysis of test cases with the team members and make the necessary changes.
• Designed, developed the customer comparison reports in MS SQL Server environment using SSRS 2008.
• Performed the Unit testing for packages developed to ensure that it meets the requirements.
• Used the SQL Profiler, query execution plans to trace the performance of TSQL Statements, procedures and functions.

Environment: MS SQL Server 2012/2008, SQL Server Reporting Service (SSRS) 2012/2008, SQL Server Integration Service (SSIS) 2012/2008, T-SQL, PL/SQL, Excel.

Confidential, Los Angeles, CA

SQL Server BI Developer

Responsibilities:

• Involved in design and development of technical specifications of the project and developed the prototypes.
• Developed T-SQL queries for table creation, wrote stored procedures, views, triggers, and tested tables in company’s BI star schema structure.
• Designed, developed, and debugged stored procedures in MS SQL Server 2005 to load the data into consolidated data warehouse.
• Created SSIS packages to load insurance data received from different insurance agents and other locations into consolidated data warehouse using Derived column, Lookups, Fuzzy Lookups, Conditional split, Execute SQL Task, Data Flow Task, and Execute Package Task.
• Used MDX queries for pre calculated measures and created report model on SSAS cubes as well as changing default configuration on existing cubes.
• Created report Model using T-SQL queries on SSAS Cubes as well as changing default configuration on existing Cubes.
• Involved in setting up hierarchies and defined scope of analysis for providing drill down/ drill through options in the reporting environment.
• Developed reports out of the consolidated data warehouse for the business users using MS SQL Server Business Intelligence Development Studio (BIDS) 2005 (SSRS).
• Involved in migrating data from Windows Server 2005 to Windows Server 2008 environment.
• Implemented security for the reports, user tabs, report models and folders in the report manager at the application, database and the report manager level.
• Tested, debugged and developed the technical documentation for the company reporting applications.

Environment: MS SQL Server 2005/2008, T-SQL, MS SQL Server Reporting Services, SSRS Report Builder, ASP.Net 2.0, Visual Studio 2005, Window Server 2005/2008, MS SQL Server Integration Services, SSAS, XML.

Confidential

SQL Server BI Developer

Responsibilities:

• Involved in designing logical model and physical model and do the normalization to minimize redundancy and dependency.
• Created Stored Procedures, Functions, Packages, Triggers, Indexes and Views using Transact-SQL in development and production environment for SQL server.
• Created database objects like Triggers, Constraints, View to enforce data integrity and additional referential integrity.
• Developed SQL queries to fetch data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created stored procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: MS SQL Server 2000/2005, MS Access, T-SQL, Management Studio, SQL Profiler and SSRS, Windows 2000/NT, Visual Source Safe 6.0, Visual Basic 6.0.

Confidential

Associate Analyst

Responsibilities:

• Attended several business sessions with the business users and created Views and altered some of the dimensional tables to satisfy their reporting needs.
• Involved in the Requirement Analysis and Preparation of System Requirement Specification Document.
• Involved in the database design and preparing data dictionary.
• Designed forms, Reports and Query layouts. Involved in Coding Using Developer/2000 (Forms 6.5 and Reports 6.5), PL/SQL Stored Procedures and Database Triggers.
• Designed dynamic LOV s, multiple form and MDI applications, implemented menu rules security features.
• Designed complex reports using placeholders, formula columns, conditional report layouts, group filters for the sales and distribution package such as sales analysis reports, product analysis reports etc.
• Gave up-to-date status on inventory items availability, usage, receipts, on-order, pending inspection, committed quantities, etc.
• Involved in Unit Testing and Integration Testing.
• Involved in Acceptance Test by the Customer.

Environment: Oracle 8i, PL/SQL, Oracle Forms 6i, Reports 6i, Windows NT