SUMMARY

• Highly motivated Business Intelligence Professional using SQL Server and Microsoft Technologies.
• Over 7 years of professional experience as MS SQL Server Database Design, Development and Analysis related to Retail, Banking and Health Insurance domains.
• Extensive experience in Database development for bothOLTP (Batch Processing, Online Processing)&OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2005/2008/2010
• Worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema and Entity relationship diagrams from business requirements
• Played a role as SQL Database Administration.
• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance
• Expertise in scripting T - SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designingand implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.
• Efficient, in creating Sub-Queries and Joins for complex queries involving multiple tables, using Exception Handlers.
• Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Expert in Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
• Good noledge of Normalization/De-normalization, data design methodology and building Referential Integrity for the relational Database Model implementing as per business requirement.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.
• Expertise 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.
• Involved in Full Life Cycle Implementation of Data Warehouse.
• Extensive noledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Expertise in upgrading or migrating Analysis Services.
• Good experience in building Starschema and Snowflakeschema depending on the business data requirements.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies wif SSAS.
• Expert in creating Cell Level Security and DesignAggregations in cubes using SSAS
• Knowledge in creating Perspectives, Partitions using SSAS
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup&Recovery, user and application table management, upgrades, creating databases/Filegroups/files/Transactionlogs.
• Excellent noledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Good team player, strong interpersonal and communication skills combined wif self-motivation, initiative and efficient time management skills.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, Export & Import(DTS), SSIS, SSRS, SSAS.

RDBMS: MS SQL Server 2012/2008/2005/2000, MS Access 97/2003/2005

Data Modeling: Erwin

ETL: DTS, SSIS

Programming Languages: T-SQL, VB scripts, C, Java

Application Development: HTML, XML, CSS,.NET, C#

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

Operating Systems: Windows 2000/NT 4.0, Windows 2003 Advanced Server/Windows 95/98/200/XP-pro, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NY

SQL SSAS/SSRS 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.
• CreatedSSISpackage 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 designedaggregations 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 wif 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, Des Moines, IA

SQL SSAS/SSRS Developer

Responsibilities:

• Involved in the support the specific needs of hedge funds, fund-of-funds and private equity funds and registered investment products.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Provided SQL Server Database Administration and Development at Confidential in support of a financial distributed and replicated storage system wif a multi-terabyte data store, installation of Oracle Financial accounting package, and evaluation of SQL Server 2000.
• Involved in design, development and implementation of SSIS, SSRS and SSAS.
• Developed SQLSSIS Packages to extract data from various data sources such as Excel and flat files into SQLserver 2005 using different transformations like derived column, sort, and aggregate transformations.
• Worked on the Reinsurance vendor product SungardiworksProcede8.5.6 for creating the Reinsurance contracts.
• Integrated Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them wif the SQL Server agent job scheduler.
• Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitor the size of the transaction log.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler.Involved in database and log backups & restoration, backup strategies, scheduling.
• Worked on upgrading/changing all the database objects from 2000 to make them compatible to the schema changes in 2005.
• Created SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used TSQL to manipulate and architect to produce results for users.
• Used multiple join statements to retrieve data from multiple tables.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS TEMPeffective.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Created various DTS packages for data transfer and migration.
• Designed and implemented parameterized reports, Drill down reports for Confidential Mortgage Loan organization.
• Managing various mortgage processes across different reports and provided primary Admin and production support for these reports.
• Developed SQL mortgage reports using SSRS. Developed optimal stored procedures and queries to create data sets for reports. Designed Drill through Ad-hoc Reports.
• Developed Ad-hoc reports using Crystal Reports.
• Developed Star schema using SSAS cubes.
• Created parallelperiod, filter, ancestors and crossjoinMDX queries.
• Developed Aggregations, partitions and calculatedmembers for cube as per business requirements.
• Involved in analyzing and designing disaster recovery / replication strategies wif business managers to meet the business requirements.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Responsible for testing to optimize the procedures and triggers to be used in production. Involved in project planning also schedule for database module wif project managers.

Environment:Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), C#, XML, Sungard iworks Procede 8.6, SSMS, MS Excel, Windows 97/2000/XP, Oracle

Confidential, Kansas City, KS

SQL Server Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries wif best execution plan.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2000/2005
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Used Try catch and @@error for exceptional handling.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Managed up gradation of DTS packages to SSIS packages
• Responsible for developing, monitoring and deploying SSIS packages.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Created queries for generating drill down reports in SSRS 2005. Formatted the reports using the Global variables, expressions and Functions.
• Created Linked Servers to connect OLE DB data sources and providers.

Environment: SQL 2000/2005, DTS/SSIS, SSRS, ERWIN, MS Access

Confidential, Louisville, KY

SQL/SSIS Developer

Responsibilities:

• Create User Defined Functions, Stored Procedures, and Triggers.
• Performed data conversions from Flat filesinto a normalized database structure.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Responsible for creating constraints, Indexes, and Views.
• Optimized the performance of queries wif modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Created triggers, views, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS TEMPeffective.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Managed upgradation ofDTS packages to SSIS packages.
• Identified and worked wif Parameters for parameterized reports in SSRS.
• Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels.
• Configured Server for sending automatic mails to the respective people when a DTS process fails or succeeds.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Created Crystal Reports on daily, weekly and monthly basis for manger’s review.
• Responsible for MS SQL Server 2000 in Production, Test, Development and Replication&Cluster Server Environments

Environment:SQL Server 2000, Windows 2000 Advance Server, Windows 2003 Server, XML, T-SQL, MS Excel, MS Access, VB.NET 3.0 and DTS.

Confidential

SQL Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2000.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules wifin development team.
• Modified database structures as directed by developers for test/develop environments and assist wifcoding,designandperformance tuning.
• Managed user access. Created and managed new security accounts.
• Backupandrestoredatabases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created theDTSPackagethroughETLProcess to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Assisted wif various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment:SQL Server 2000, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS