SUMMARY

• Around 8 years extensive IT experience in MS SQL Server 2000/2005/2008/2008 R2 and 2012 in Strong and In - depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics in Production, Dev and Test environment.
• Ensured on-time, quality release of systems and components.
• Provided technical direction to development teams.
• Expert in Table Design, Schema Design and T-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Expert in writing stored procedures, temporary tables, views, indexes, and triggers as per business requirements.
• Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Experience in writing complex SQL queries involving multiple tables, inner and outer joins and stored procedures.
• Good knowledge in RDBMS concepts, data models, Star/ Snow Flake Schemas.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups and Used containers for repetitive control flow tasks
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.
• Good understanding data warehousing concepts (OLTP and OLAP).
• Experience in Data Warehouse Modeling withSQL Server Analysis (SSAS).
• Experience in Creation and deployment of cubes onSSAS.
• Created extensive reports using SSRS (Tabular, Matrix) and Crystal reports.
• Good Hand on Resolving complex issues and Error Handling in SSIS and SSRS and good knowledge in scheduling and deploying reports.
• Experience in developingUser reports and management reports using MS SQL Server Reporting Services (SSRS).
• Experience in developingCustom Reportand different types of Tabular Reports, Matrix Reports, Crystal reports and drill down reports in multiple formats usingSQLServerReporting Services(SSRS) in Business intelligence development studio (BIDS).
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000, 2003, 2008 and 2008R2. Unix, MS Windows (95,98,NT,2000,XP)

SQL Server Tools: Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Analysis Services, OLAP (Online Analytical Processing)-Cubes, Storage, Data Mining Models, Visual Source Safe, BCP, Enterprise Manager, Profiler and Data Transformation Services.

Languages: MDX/DMX, VB.Net, VB Script, Transact-SQL, PL/SQL, HTML, DHTML, XML, ASP, C and C++.

ETL Tools: SSIS (SQL Server Integration Services), DTS.

Reporting Tools: SQL Server Reporting Services, Import Export Data, Bulk Insert, and Business Objects 6.5/XI/XIR2, Crystal reports, MS Excel.

RDBMS: MS SQL Server 2008R 2/2008/2005/2000/7.0 , Oracle 9i/8i, MS Access, DB2, Teradata V2R6/V2R5.

Data Modeling and Configuration Tools: Erwin, MS Visio.

Methodologies: RUP (Rational Unified Process), Agile, SCRUM, Waterfall.

Testing Tools: Quick Test Pro, Mercury Quality Center, TOAD (Tool for Application Developers).

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. BI Developer

Environment: Microsoft SQL Server 2012, Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), SQL Server Integration Services(SSIS), SSAS, SQL Server Business intelligence Development Studio(BIDS), Report Builder, T-SQL, Oracle 10g,11g, MS Excel.

Responsibilities:

• Involved in all the aspects of the project development like - system analysis, database design, requirements analysis, high level and detail design, integration/system testing.
• Led team of developers in the delivery of technical systems and components
• Ensured on-time, quality release of systems and components
• Provided technical direction to development teams
• Oversaw design of applications from functional and technical specifications
• Installed SQL 2000/2005/2008 and 2008R2 on development and production servers setting up databases, users, roles and permissions.
• Designed Database Objects like Tables, Stored Procedures, Triggers, and user defined functions and as per the project requirement.
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups and used containers for repetitive control flow tasks
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS, creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
• Created the DTS, SSIS packages to import the data from different data source like MS Access/Excel/ Oracle/Sybase/My SQL server to SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Created Views and table for specific columns on a table to maintain privacy of a customer data. Created Indexes to get the high level performance.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Created various Tabular and Matrix Reports using SSRS. Created various drill down reports using SSRS. Involved in the post deployment maintenance of reports.
• Designed SSIS packages for synchronizing the data between two different servers.
• Expert in Creating and scheduling SSIS and SQL server jobs for various tasks.

Confidential, FL

Sr. BI Developer

Environment: Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), Management studio, SQL Server Business intelligence Development Studio(BIDS), SSAS, T-SQL, Oracle 10g,11g, MS Excel.

Responsibilities:

• Designed Database Objects like Tables, Stored Procedures, Triggers, and user defined functions and as per the project requirement.
• Created Cluster and Non- cluster Indexes for table and database to get the high level performance.
• Modified the database by removing unwanted columns and also adding proper constraints, rules and defaults to tables.
• Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Create and Modify Stored Procedures, According to the business. Fine Tuning of Stored Procedures and SQL Queries. Worked with Control Flow tasks, Data flow tasks and Data flow transformations using SSIS 2005.
• Developed various reports to validate the data between source and the target systems. Involved in providing security to the reports by restricting various users through Roles.
• Experience in writing and debugging Stored Procedures and triggers. Designed, Developed and managed the reports using Reporting Services.
• Expert in creating the MDX cubes and dimensions (SSAS).
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Responsible for gathering Business Requirements and System Specification from users.
• Designed numerous ad-hoc, crystal reports and custom reports using SQL Reporting Services.
• Extensive experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP, Bulk Insert, ActiveX).Involved in the post deployment maintenance of reports
• Implemented logical design into Physical design. Involved in the normalization of databases in the OLAP.

Confidential, Bloomington, IL

BI Developer

Environment: SQL Server 2000/2005, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC, VBScript, Windows 2000/XP, IIS 5.

Responsibilities:

• Table Design, Schema Design and T-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Merged Data from Heterogeneous Data stores (Oracle, Access and Excel) to SQL Server 2005 using SSIS packages.
• Participated in to Design ETL architecture and processes insurance and policies related record from different locations. Successfully met challenges of very high volume of data.
• Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
• Implemented the Indexing making the Transaction in SQL 2005 faster nearly three times as compared to the SQL Server 2000.
• Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Wrote complex T-SQL queries, stored procedures, triggers, cursors and user defined functions (UDF’s).

Confidential, San Jose, CA

BI Developer

Environment: SQL Server 2000/2005, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC, VBScript, Windows 2000/XP, IIS 5.

Responsibilities:

• Installed SQL Server 2005 on development and production servers setting up databases, users, roles and permissions.
• Upgraded all SQL Server 2000 to SQL Server 2005 without any service interruption.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• Involved in the normalization and de-normalization of the databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2005.
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2005.
• 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 SSIS packages to transfer data from different data sources load it to data warehouse.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
• Used MDX expressions to define calculated members in cubes to calculate values at run time.
• Created copies of operational Databases using the Import/Export Wizard
• Migrated DTS packages to SSIS packages using package migration wizard.
• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS). Created jobs and scheduled jobs using SQL Server Agent.
• Developed parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and prepare for Web publishing.
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services (SSAS).
• Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services.
• Wrote MDX queries according to the business requirements.
• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2005 Reporting Services (SSRS).
• Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies.