Amulya

609-***-****

act8hg@r.postjobfree.com

PROFESSIONAL SUMMARY:

●8+ years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2012/2008R2/2008/2005/2000 system in OLTP and OLAP environment.

●Excellent experience in SSIS, SSAS and SSRS of MS SQL Server.

●Highly expert in translating Business System Design document into technical design document

●Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.

●In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.

●Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.

●Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008R2/ 2008/2005/2000.

●Experience in scheduling SSIS packages using SQL Server Agent.

●Strong knowledge of using variables and expressions in packages.

●Experience in enhancing and deploying the SSIS Packages from development server to production server.

●Excellent skills in implementing ETL Packages using DTS and SSIS 2012/2008R2/2008/ 2005.

●Proficient in implementing all transformations available on the SSIS toolbox.

●Expert in resolving the performance issue of SSIS packages.

●Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).

●Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.

●Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

●Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.

●Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data

●Proficient in Creating business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.

●Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012.

●Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.

●Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.

●Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

●Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high pressure environment.

EDUCATION QUALIFICATION:

Bachelors

SKILL SET:

MS-SQL Server 2012/2008R2/ 2008/2005/2000, SQL Server BI Development Studio (BIDS), MS Visual Studio 2008/2005, SQL Server Integration Services (SSIS) 2012/2008R2/ 2008/2005/2000, SQL server Analysis Services(SSAS)2012/2008R2/2008/2005/2000, SQL server Reporting Services(SSRS)2012/2008R2/2008/2005/2000, Oracle 10g/9i/8i, MS Access, T- SQL,C,C++,C#,HTML, XML, Java, ASP .NET, VB6 .NET, Crystal Reports, Erwin7.2/4.5/4.0, MSVisio2007/2003, ClearQuest, Autosys, DTS, Windows7/Vista/NT/XP/2003/2000/98, Rational Clear Case, Windows 2000Advanced Server.

WORK EXPERIENCE:

Cardinal Health Care, Dublin, OH

April 2015 -Till date

SSRS/SSIS/SSAS Developer

Cardinal Health, Inc. is a health care services company based in Dublin, Ohio. The company specializes in distribution of pharmaceuticals and medical products. . My project is about analyzing the functional specs provided by the business users and created technical specification documents and involving in generating reports.

Responsibilities:

Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Developing Tableau Desktop reports & dashboards both as standalone and as secure Tableau Server reports.

Experience with SQL Server Installation, Configuration, Migration, SSIS, SSRS and administration, apply periodic Service packs and hot fixes (cumulative updates)

Expert in creating database objects and including databases, tables, indexes, views, stored procedures, triggers, functions and cursors.

Identified business objectives and the corresponding business requirements.

Extensive experience in performance tuning/analysis, troubleshooting and query optimization using native tools.

Expertise in creating, managing and delivering Server based reports using SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) in BI.

Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert from heterogeneous databases like MS Access and DB2.

Implemented complex business logic with Store procedures, User Defined Functions, Views and wrote T-SQL batches with CTE (Common Table Expressions) for recursive operations.

Proficient with SQL Server Analysis Services (SSAS).

Extensive knowledge on Relational Database Management Systems

Responsible for SQL Server logical and physical database design, implementation, and maintenance.

Migration of databases from SQL Server 2008R2 to SQL Server 2012.

Implement database refresh using SSIS packages and automated backup/restore jobs.

Data Migration to and from various sources using SQL Server Integration Services (SSIS).

Modeling or statistical analysis experiences.

Strong knowledge and ability to use SQL and other tools to support analytical methods and database management.

Developing Tableau Desktop reports & dashboards both as standalone and as secure Tableau Server reports.

Knowledge of data integration processes.

Knowledge of data mining.

Perform data research, analysis, and logical data modeling to validate and document the usage of business data artifacts.

Strong knowledge of SQL and other querying languages.

Demonstrates strong time management and organizational skills.

A team player, flexible, creative, and eager to learn.

Customer first mind set and experience engaging with clients and partners.

Used Team Foundation Server (TFS) for central repository as a versioning control.

Creating Back up Strategies and implementing Disaster Recovery

Tools & Technologies:

MS SQL Server 2005/2008 R2/ SQL Server 2012, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL server Analysis Services 2008, Tableau Desktop(Desktop, Server), Microsoft Visual Studio, Tableau, SQL Server Management Studio, MS Excel, T-SQL, ERWIN, Microsoft Visual Basic, team foundation server(TFS).

Eco Labs Inc., ST.Paul, MN

Aug 2014 - April 2015

SQL/SSIS/SSAS/SSRS Developer

Ecolab Inc., headquartered in St. Paul, Minnesota, is an American global provider of water, hygiene and energy technologies and services to the food, energy, healthcare, industrial and hospitality markets.

Responsibilities:

●Created SSIS packages to migrate data from different data sources to data warehouse.

●Successfully extracted transformed and load data into data warehouse.

●Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.

●Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

●Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.

●Involved in enhancing and deploying the SSIS Packages from development server to production server.

●Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.

●Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.

●Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.

●Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.

●Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.

●Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.

●Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.

●Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard

●Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Tools & Technologies:

SQLServer2012,SQLServerBIDevelopment Studio (BIDS) 2012, Oracle 9i/10g,ClearCase,Clear quest, SQL LiteSpeed, Visual SourceSafe, T-SQL, Autosys, MS Access, Windows XP/2007 Server.

Client: JC Penny, Plano, TX

July 2013 – June 2014

SQL/SSIS/SSAS/SSRS Developer

JC Penny makes it easy to make more happen with more products and more ways to shop. Through its world-class retail, online and delivery capabilities, JC Penny lets customers shop however and whenever they want, whether it's in store, online or on mobile devices. It offers more products like clothing, cosmetics, electronics, footwear, furniture and jewelry.

Responsibilities:

●Installed SQL Server 2008R2 with the latest service packs.

●Migrated Database from SQL Server 2008 to 2008R2 by using side by side migration.

●Created tables, indexes and designing constraints.

●Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.

●Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

●Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.

●Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

●Enhanced and deploying the SSIS Packages from development server to production server.

●Wrote stored procedures for report generation in SQL Server2008R2.

●Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

●Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.

●Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.

●Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data

●Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

●Administrated the created Reports by assigning permission to the valid user for executing the reports.

●Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.

●Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.

●Created and Maintained Database Maintenance Plans.

●Strong team player and self-motivated

Tools & Technologies:

SQL server 2008R2, Windows XP/2007. BIDS 2008R2, Windows 2000 Advanced Server, Microsoft Share point Portal Server, Lumigent Log Explorer, VSS, SQL Diagnostic Manager, SQL LiteSpeed, and Dell Power Edge 2650, 1750, and 2600.

Computer Aid, Harrisburg, PA

Sep 2012 – July 2013

SQL/SSIS/SSAS/SSRS Developer

The aim of the project was to design and develop Data Marts from Oracle Data Warehouse, to migrate the data from different sources into the databases using SSIS in generating customer profile reports, customer transaction reports, compliance reports, Audit reports, and HR reports using SSRS.

Responsibilities:

●Responsible for creating logical and physical model using ERWIN.

●Built a package to transfer data between OLTP and DW databases.

●Created Views to reduce database complexities for the end users.

●Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.

●Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

●Created a table to save dirty records.

●Performed SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

●Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.

●Set up Alerts for successful or unsuccessful completion of Scheduled Jobs.

●Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.

●Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 200R2 and in adding calculations using MDX.

●Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

●Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

●Generated Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

Tools & Technologies:

SQL Server 2008R2, BIDS 2008R2, Integration Services 2008R2, Oracle 9i, Visual SourceSafe, TSQL, Autosys, Rational Clear Case, Clear quest, MS Access, Windows XP/2003 Server.

IMS Health, Parsippany, NJ

Aug 2011 – July 2012

SQL Server Reporter and Developer

IMS Health provides information, services and technology for the healthcare industry. IMS Health’s products and services are used by companies to develop commercialization plans. The firm uses its own data to produce syndicated reports such as market forecasts and market intelligence.

Responsibilities:

●Worked as a developer in creating complex Stored Procedures, Triggers and Functions.

●Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.

●Implemented Performance tuning to optimize SQL queries using query analyzer.

●Tested to optimize the procedures and triggers to be used in production.

●Involved in project planning, scheduling for database module with project managers.

●Created the reports based on the requirements using SSRS 2008.

●Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.

●Formatted the reports using the Global variables and expressions.

●Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.

●Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.

●Identified and defined the Datasets for the report generation.

●Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

●Developed, monitored and deployed SSIS packages.

●Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.

●Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.

●Responsible for automation of maintenance jobs, locks and indexes configurations.

●Administered SQL Server security, SQL Server automatic e-mail notification.

●Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.

●Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

●Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server.

Tools & Technologies:

MS SQL Server 2008, DTS, Windows 2003, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Query Analyzer, Erwin, MS Visual Source Safe, FTP Communication, MS-Visual Studio, MS Access, Oracle 10g, UNIX, XML,XSLT, ADO.Net.

McKesson, Richmond, Virginia

Jan 2010 – July 2011

SQL Server BI Developer

McKesson is the largest healthcare services company which provides pharmaceuticals, medical supplies, and information technologies to customers in every segment of the industry. They work with Medicaid and Medicare, among other government programs. This is the complete solution for Mckesson which includes modules like patient registration system, doctor scheduling, lab track system, discharge system billing system and deposit system. It has a dynamic facility for adding the registration type for each patient. An advanced search facility has helped clients, patients and doctors to search their desired records easily.

Responsibilities:

●Maintained databases, performed software installations and monitored Database Performance.

●Involved in reverse and forward loading of the schema of a database using Erwin.

●Responsible for gathering Business Requirements and System Specification from users.

●Studied detail changes that need to be made to each business process that is performed by all the systems impacted.

●Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.

●Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.

●Implemented automated backup and database maintenance / cleanup jobs.

●Generated Views 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.

●Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through SQL Server Agent.

●Designed SSIS packages for loading data from ODS to Data mart.

●Created SSIS packages for synchronizing the data between two different servers.

●Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.

●Experience in the design, development and maintenance of different cubes using SSAS.

●Involved in the post deployment maintenance of canned reports and cubes.

●Experience in designing the reports in ProClarity for SSAS cubes.

●Managed Logins, Users, Roles and User permissions.

●Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services(SSAS)

●Designed numerous ad-hoc and custom reports using SQL Reporting Services.

●Created various Tabular and Matrix Reports using SSRS.

●Generated Ad-hoc reports and cascading reports for historical data using SSRS.

●Involved in the implementation of Performance Point Server (PPS).

Tools & Technologies:

SQL Server 2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), Windows 2000/XP, ProClarity, SSAS, SharePoint services, Erwin

Laser Soft Infosystems Ltd, Chennai, India

Feb 2008 – Dec 2009

SQL Server/BI Developer (SSIS)

Laser Soft Infosystems Ltd., Main Branch is in Valasaravakkam, Chennai. Software Company dealing with BFSI. Software for Andhra Bank, CSB (Catholic Syrian Bank) and others are developed.

Responsibilities:

●Gathered functional requirements and written the technical specifications

●Designed logical / physical data models and defined primary key, foreign key using Erwin tool.

●Wrote T-SQL statements using DML and DDL for retrieval of the data.

●Created complex stored procedures, triggers and cursors in SQL Server.

●Developed source to target specifications.

●Generated stored procedures, functions, views and triggers.

●Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.

●Created DTS package to schedule the jobs for batch processing.

●Performance tuning to optimize SQL queries using query analyzer.

●Created indexes, constraints and rules on database objects.

Tools & Technologies:

MS SQL Server 2005, MS Access, DTS, Erwin 4.1, SQL Query Analyze, VB, Crystal Report.

Contact this candidate