PROFESSIONAL EXPERIENCE:

• Over 7+ yearsof IT Experience in Database Design, Development and MSBI development in SQL Server 2005/2008 R2/2012 and deployed in various environments like development, testing and production.
• Had great experience with several business domains like Financial, Healthcare and Banking.
• Hands on experience in installing, managing, migrating, monitoring and troubleshooting SQL Server 2005/2008R2/2012.
• Good knowledge ofData Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling,Star Schema Modeling, Snow - Flake ModelingforFACTand Dimensions Tablesusing Analysis Services.
• Experience inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS).
• Experience in TSQL-DDL/DML/TCL/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Scripts.
• Experience in report designing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading parameterized, and drill through, Table, Matrix, ad-hoc and Sub Reports.
• Developed VB utilities for data export and import
• Experience indeveloping,monitoring, extractingandtransformingdata usingSSIS, Import Export Wizard, and Bulk Insert.
• Good Experience and understanding of SSAS, OLAP Cube and Architecture
• Experience in deploying created reports in various sources like Web browser, exceland PDF.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Experience in designing and developing user interface using Visual Basic 5.0
• Experience in Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating datausingOLEDBconnection from heterogeneous sources like (Excel, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSISsuch asData Conversion,Conditional Split,Bulk Insert,MergeandUnion All.
• Good understanding of Normalization/De-normalization and database design methodology.
• Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, UDFs and Triggers on Microsoft SQLServer.
• Good knowledge in Database backup, Replication, recovery, restoration.
• Experience in maintaining database,re-indexing, index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.
• Managed indexes and tunedqueries by using execution plan for optimizing the performance of the databases.
• Worked in a team environment using, Transact-SQL,SQL-PLUS Oracle and Unix scripting.
• Delivered work product that meets specifications, are defect free, and have optimal performance.
• Driven detailed definition of feature requirements through discussions with Product Management team and Involved in Production support whenever required.
• Had good experience on developing error checking and resolution routines and Experience with SQL replication methodologies.
• Ability to work in groups and an open attitude towards learning.
• A team player and have the ability to work effectively with senior management in accomplishing objectives and able to deliver results and meet deadlines.

TECHINCAL SKILLS

RDMS: SQL Server 2005/2008/2008 R2/2012, MS Access

Languages: SQL, T - SQL, HTML, Cand C#

Operating Systems: Windows XP/2003/2008

OLAP/Reporting Tools: SSAS, SSRS

ETL Tools: SQL Server Integration Services (SSIS).

Other Tools: Microsoft Visual Source Safe (VSS), TFS, Microsoft Office

Data Modeling Tools: Microsoft Visio 2000/2003

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, BCP and SQL server profiler.

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, VB scripting, SQL Server2008/2012 Analysis Services and SQL Reporting services, ProClarity, PPS-2007

PROFESSIONAL EXPERIENCE

Confidential, Dublin, OH

SQLBI Developer (SSIS/SSRS)

Responsibilities:

• Worked with BA’s and other Developers to understand the existing system.
• Make analysis and development plan accordingly.
• CreatedER diagramsusing Microsoft Visio2010.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL in SQL Server 2008 R2.
• Created SSIS Packages to load data from sources likeFlat files, excel, OLEDB, XML, and Oracle to SQL Server.
• Involved inMigrationof Databases fromSQL Server 2008 to SQL Server 2012 using SSIS.
• UsedSSISto createETL packagesto validate, extract, transform and load data todata warehousedatabases and data mart databases.
• As a part of Merging and Migration process, client requires stored procedure development using SQL server.
• Migrated SLIMdatafrom various heterogeneous sources todatamarton 2008 and then from 2008 to SQL 2012
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created SSIS Packages using Derived Columns, etc. in SQL Server Integration Services 2008 (SSIS).
• Designed and developed user interface using Visual Basic 5.0
• Experience in creating complexSSISpackagesusing proper control and data flow elements with error handling.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Designed Data flows, Workflows and jobs to load data from source to target.
• Integrated disparate technologies with Microsoft PowerShell
• Enhancing and deploying the SSIS packages from development server to production server.
• Involved in creating jobs, Alerts and schedule SSIS packages using SQL Server Agent.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS).
• WorkedwithTechnicalArchitects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Experience in configuring and deployingSSRSreportsontoMicrosoft Office SharePoint Server.
• Recommended, schedule, and perform software maintenance, improvements and upgrades.
• Participated in a 24x7 on-call rotation for the systems supported by the Risk Mgmt. Group.
• Utilizing Visual Basics 5.0, data could be passed from Microsoft Project into Microsoft Access and vice versa
• Participated in the aspects of the software development process including, requirements, designing, coding, unit testing, quality assurance, and deployment.
• Identifying improvements to existing systems or processes to reduce occurrences of system issues.

Environment: SQL SERVER 2008 R2/2008/2012, Visual Basic 5.0,Business Intelligence Development Studio, SSIS 2012, SSRS 2012, Microsoft Visio 2010 and TFS,T-SQL

Confidential, NY

MS SQL SERVER DEVELOPER

Responsibilities:

• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created Subscription of Reports in different formats like pdf, excel etc to be executed automatically on daily, weekly or monthly basis using MOSS (Microsoft Office SharePoint Server) tool.
• Created reports from complex SQL queries and MDX queries.
• Created and implemented the staging database prior to the final data warehouse.
• Developed processes to populate the Data Mart for specific projects.
• Created complex procedures to perform Index maintenance, data profiling, for loading data marts.
• Involved in Migration of different DTS packages to SSIS packages.
• Created and scheduled SSIS packages to load the data form OLTP source system to data staging environment and then to data warehouse environment.
• Created and maintained data model/architecture standards, including master data management (MDM)
• Designed the SSIS Package for the Scheduling the task for the different operations like extracting the data, to perform appropriate transformation and Loading purposes.
• Created data validation routines to identify and solved discrepancies on data values, ensure data integrity, also created various data marts for various group of users
• Created Data Mart by taking into various business processes by identifying different dimensions and facts.
• Performed data mapping tasks, data profiling, data cleansing, data validation and quality assurance, including intensive data migration and the creating, executing, and documenting of test cases in SSIS and ETL processes to bring data from diverse sources.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Involved in the performance tuning for the OLAP Cube.
• Involved in the SSAS partitions and calculation of queries with MDX, developing reports using MDX and T-SQL.
• Visual Basic in code was used for massive updating of records.
• Worked with SharePoint Server 2007 while deploying SSRS reports.
• Used Team foundation server (TFS) as a source control.
• Used Performance Point Server 2007
• Responsible for maintaining UAT (User Acceptance Testing) and Production environment.

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005,T-SQL, SQL Server Analysis Services 2005/2008/2012, Windows XP, VB.NET, Excel, Acrobat Reader, Microsoft Office SharePoint Server, Team Foundation Server, Tableau.

Confidential, NY

SQL Server Developer/ BI Developer

Responsibilities:

• Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
• Reviewed old table structures and used Erwin to design new tables which adhered to the new database design standards.
• Created and maintained database mapping document which mapped the old tables to the new ones.
• Developed stored procedures, user-defined functions, triggers, indexes and views.
• Developed Interactive Reports and Dashboards. Implemented Dynamic Dashboard Prompts for easy navigation of reports
• Involved in query optimization for faster processing of queries.
• Created allocation and other reports using SQL Server Reporting Services (SSRS).
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Integratingdatafrom variousdatasources using SSIS & developingdatacubes for analysis.
• Analyzed impact of newdatamodels on various legacy systems. Formulated recommendations and options based upondataanalysis from SSAS and input from users
• Loaded flat files into SQL Server tables and vice versa using SSIS.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Created XML configuration files(.dtsconfig files) to dynamically alter package properties.
• Developed error handling routines for packages using both script tasks as well as in the error handling tab.
• Developed Unit Test Plans for SSIS packages.
• Responsible for allocating responsibilities and coordinating ETL efforts among team members to ensure best practices are used.
• Involved in regular code inspections to ensure business and system requirements are met.
• Scheduled package execution using SQL Server Management Studio to execute packages on a daily/weekly basis.
• Documented ETL processes and prepared project status report updates/audit reports/ list of issue items that need to be reviewed.
• Involved in project scope, schedule planning and project impact assessments.

Environment:MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005/2008, MS SQL Server Analysis Services 2005/2008, T-SQL, MS SQL Server Integration Services 2005/2008, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v7.2, ASP.Net, C#.

Confidential

MSBI Developer

Responsibilities:

• Implementation and delivery of BI platform solutions to develop and deploy ETL, reporting services on SQL server 2008 using SSIS, SSRS.
• Monitored full/Incremental/Daily Loads and support all scheduled ETL jobs for processing.
• Involved in Migration of Databases from SQL server 2005 to SQL server 2008 using SSIS.
• Designed, Developed and Deployed reports inMS SQL Serverenvironment usingSSRS-2008.
• Configured Database Mail and Reporting Services on the production server.
• Formatting the reports using the Global variables, expressions and deployed the generated reports on to the server.
• Worked withT-SQLto create Tables, Views, andStored Procedures.
• Developed MDX queries for Analysis Services. Designed SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Worked on SSAS, developed Cubes, deployed Cubes on the server, pulled data from various data sources and thus developed Cubes.