SUMMARY

• 8+ years of IT Experience in Database Design, Development and Implementation of Microsoft SQL Server 2005/2008/2008 R2 in Development, Test and Production Environments with various business domains
• Experience in working on full Software Development Life Cycle (SDLC).
• Experienced in working in cross - functional teams and tight schedules.
• Worked in tandem with the end users for understanding the business requirements and recommending feasible solutions.
• Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker with excellent communication and interpersonal skills.
• Ability to grasp new technologies/concepts. MS-BI Stack (SSIS, SSRS, SSAS):
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
• Experience in working with row, partially blocking and fully blocking transformations and adept at performance tuning of SSIS Packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server..
• Experienced in working with C#.Net in SSIS.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Strong experience in generating drill-down, drill-through and cascaded-parameterized reports on top of relational databases and cubes.
• Experience in Migration and Upgrading fromSQLserver from 2008R2 to 2012 by using In-Place upgrade process and as well as side-by-side upgrade process.
• Expertise in creatingCell Level Securityin cubes usingSSAS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Knowledge on .Net 3.0 framework and Microsoft Azure IaaS, PaaS, DBaaS Technologies
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Expertise in creating indexed tables with Primary, Foreign key constraints to maintain referential integrity.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS)..
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports using Cognos.
• Excellent experience in implementing Key Performance Indicator (KPI) objects in SSAS and creating calculate members in MOLAP cube using MDX in SSAS.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Migration of application code and objects from development/test environments to production.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Experience in deploying created reports to report server.
• Experience in developing cubes using SQL Server Analysis Services (SSAS) Database Development and Performance Tuning:
• Experience in developing optimized SQL using best practices.
• Expertise in writing dynamic-SQL, complex stored procedures, functions and views.
• Hands on Experience in performance tuning using execution plans, SQL Profiler, Index tuning wizard and DMVs.
• Incorporated complex business logic into stored procedures and functions for reusability.
• Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.
• Strong debugging skills and the ability to solve complex problems.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance. Data Warehousing:
• Experienced in designing and developing ETL logic for moving data into data warehouses.
• Strong experience in logical and physical database design and development using Erwin and SQL server enterprise manager.
• Involved in collaborating with Database Architects for basic Data Warehouse Design.
• Good understanding of star schema and snowflake schema.

TECHNICAL SKILLS

Programming Languages: C, SQL, TSQL, PL/SQL,C, C++,.Net/C#,Core Java

RDBMS: MS-SQL Server 2000/ 2005/2008/2012, Oracle 9i/10g, Microsoft Access

IDE Tools: Visual Studio.Net 2005/2008/2012

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008/2012, SSDT/BIDS - DTS

OLAP Tools: SQL Server Analysis Services (SSAS) 2000/ 2005/2008/2012

Reporting Tools: SQL Server Reporting Services (SSRS) 2000/ 2005/2008/2012, Cognos 10, 8 (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Transformer),Crystal Reports, Cognos Framework Manager, Report Studio

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Teradata, Query Analyzer

Markup Languages: XML, HTML, DHTML

Data Modeling: ERWIN, MS Visio, Informatica

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

SQL Server SSIS SSRS Developer

Responsibilities:

• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions.
• Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and management about the table structures that are to be defined and the data structure that is to be collected from the clients.
• Created functional requirement specifications and supporting documents for business systems. Experience in database design process and data modeling process for Billing Method using Erwin.
• Designed Enterprise reports using SQL Server Reporting Services (SQL Server2008R2/2012.) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Built Drill Down, Drill through, linked and sub reports using SQL Server2008R 2/2012/2014.
• Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries withMDX, Data Mining Models, developing reports usingMDXand SQL.
• Defining relationships betweenDimensionsandMeasure groups. Involved in the design and development of the SSAS cubes andMDXqueries.
• Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Created Data-driven Packages in SSIS as part of the automating the process for billing method.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Responsible for maintaining the MS SQL Environment’s Architecture (Database Design Plan, Job Maintenance Plan, Archival Plan, Auditing & Security Policy Plan and Disaster Recovery/High Availability Plan)
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Identified and Defined Fact relationships in SSAS.
• Created Report Snapshots to improve the performance of SSRS.
• Worked on the Existing (legacy) SSIS packages and modified the same packages to match it for different sources for integration.
• Analyzed the data to implement incremental load.
• Set Subscriptions on report server to deliver reports on daily weekly and monthly basis to email and shared folders.
• UsedConfigurationfiles to deploy and install a package from one environment to another.
• Implemented Complex Logging in SSIS Packages.
• Used agile methods to promote a disciplined project management process that encourages frequent inspection and adaptation.
• Attended functional testing anduser acceptancesessions and worked on the feedback provided by them.

Environment: SQL Server 2005/2008R2/2012/2014 Enterprise Edition, Business Intelligence Development Studio (BIDS), SSIS,SSRS, Visual Studio, SSMS, SSAS Windows Server 2003/2008R2/2012,T-SQL, Oracle 10g,SAP, .NET Framework, C#

Confidential, NYC, NY

SQL Server SSIS SSRS Developer

Responsibilities:

• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data from various Databases and into Siemens servers using SQL Server Integration Services (SSIS).
• Used Script task component and established iterative load for faster retrieval & to improve performance.
• Used different transformations like lookup, condition split, and row count Transformation, Derived Column, Data Conversion etc.
• Created Stored Procedures for package Initialization and end package information to update the package log table.
• Expertise in developing Ad-Hoc, Drill down, Drill through and Dashboard reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS).
• Worked on the Existing (legacy) SSIS packages and modified the same packages to match it for different sources for integration.
• Involved in power pivot modeling such as building and maintaining power views
• Created Package Configuration file with connection information source, staging and destination databases and send mail task connection information and log directory path value.
• Prepared technical documentation for every stored procedure and updated those stored procedures with new data elements.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.

Environment: MS SQL Server 2008/2008R2/2012, Business Intelligence Development Studio (BIDS), SSIS, Visual Studio 2010/2008,SSMS(SQLSERVER Management Studio),T-SQL, Oracle 10g,Windows 7,Siebel,SAP, .NET Framework, C#2008

Confidential, Minneapolis, MN

SSIS Developer

Responsibilities:

• In this agile project all tasks are assigned to the team members using the Share point priority Tasks. The tasks are completed as per the priority hierarchy.
• Responsible for development of stored procedures, functions and database Triggers.
• Imported data from Cache Monitor using SQL Server Integration Services (SSIS) package Involved in migrating from cache to SSMS.
• Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts formerly in Cognos 10.1.
• Involved in creating stored procedures, Indexes in MS SQL Server environment using 2012/2008/2005.
• Created Complex ETL Packages using SSIS to extract data from Cache Monitor to SSMS with execute SQL Task and Incremental Load and even created and dropped indexes in execute SQL task.
• Created SSIS packages for Migrating from one Database to the other using Data Reader Source.
• Used VB scripting in SSIS.
• Access SQL Server using front end applications like VB.
• Writing C# code in SSRS.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL Task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.
• Performed remote and onsite application system design, development and ongoing maintenance on multiple AS/400s
• Managing and scheduling daily jobs relating to data transfers, backup and recovery.
• Helped in creating the clustered/non-clustered indexes on right columns of the tables; trace out for any tables that require for any indexes and determine the type of index on it. Even used special field casting and data conversion in Data Reader Source.
• Wrote PL/SQL packages to calculate Missing Information and Determining Eligibility in the processing of a Medical/Health Families Application.
• • Managed the migration ofSQLServer 2000 databases toSQLServer 2005/2008.
• Created reports based on the format specified in the design document.
• Involved in creating Sub reports in MS Reporting services (SSRS).
• Passed parameters to the Reports using Report parameter menus.
• Used Deployment wizard for deploying the Reports.

Environment: SQL Server 2012/2008R2/2008/2005,SQL Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005,IBM AS/400.

Confidential, Chicago, IL

SSIS /SSRS/TSQL Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked on SSIS Script component using Visual Basic Applications, VB.NET and C#.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Created Dashboards and reporting services web parts using Moss 2007.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Data Migration - Migrated and converted data to be sent across different servers and databases to accomplish database mirroring.
• This involved setting up automated Unix Shell Scripts to extract and massage data from Informix and Oracle databases into text files.
• These text files were then FTP’ed to destination servers where another automated process was executed to load the text files into the desired target tables
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.

Environment: SQL Server 2005/2008/2005 R2, T-SQL, SQL Server Integration Services, Microsoft azure SQL Server Analysis Services, CrystalReports8.5, Business objects, VB.NET, ASP.NET, .NETFramework2.0, C#, SQL Profiler, MS Access 2003, Agile methodologies, Business Objects X1,Visual Studio.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP)
• And SQL Server Analysis Services Database (OLAP) and included various reporting features such as Group by, Drilldowns, Drill through, Sub-reports, Navigation reports etc.
• Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed user requested reports using Crystal Reports and Excel.
• Data migration (import & export - BCP) from Text toSQLServer.
• Optimized stored procedures and indexed query using Index Tuning Wizard.

Environment: SQL Server 2000/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS),Windows XP/2000, Crystal Reports, MS Excel.