Skills

Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

MS BI Developer/Architect

Responsibilities:

• Involved with all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing and documentation.
• Created ER Diagram database design and demonstrated business process modeling and requirements definition into it.
• OLAP design SSAS 2008R2 for different cloud services and service items. Implemented OLAP cube and connecting using Excel PowerPivot.
• Created ETL SSIS process to transfer data from OLTP Files to data warehouse, scheduled and monitored jobs.
• Involved in Reporting Services SSRS forms authentication configuration /Single Sign On SSO and Analysis Services cross-domain authentication using HTTP access.
• Performed T-SQL tuning and optimizing queries for reports that take longer execution time.
• Integrated SSRS with Liferay Iframe to configure different roles for Single Sign On.
• Enhanced and built different reports using SSRS 2008R2 by discounts, service items, cloud node, usage, invoice etc. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Involved with various databases integration and data migration, such as NewScale, Liferay, VMware Center databases.
• Worked on different cloud services, such as Infrastructure as a Service IaaS , Platform as a Service PaaS , Software as a Service Saas , Cloud Backup Services, Disaster as a Service DraaS .
• Administered and configured SQL Server Installation and firewall port for outside domain access.
• Writing MDX queries for cube calculated members to meet business requirements.
• Documented and presented the process and architecture flow of data warehouse and tools used.
• Trained the end-users to access OLAP cube using Excel PowerPivot.

Environment: MS SQL Server 2008R2, MS SQL Server Reporting Services 2008R2, Analysis Services SSAS , Integration Services SSIS , T-SQL, MS Excel PowerPivot, Liferay, VMware Center, Jasper Report, SSO, SVN, Agile Environment.

Confidential

MS SQL Server /SSRS/ SSAS Developer

Responsibilities:

• Build a data cube around the existing offer click, impression and revenue statistics from redirectors
• Construct different hierarchical dimensions suitable for offer analyst to use.
• Build a set of reports which includes historical same-period comparisons.
• Enhance and build selected redirect reports with the flexibility of an OLAP service
• Created SSIS packages to load data into staging table and data mart and also Performed logging in SSIS packages to capture error data and for error handling.
• Used the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.
• Performed T-SQL tuning and optimizing queries for reports that take longer execution time.
• Extract data from flat files which comprised of header and input files to SQL server 2008R2 and Created Testing scripts for staging validation, generated the MapForce file for mapping between flat file and database.
• Involved in Installation, configuration of SQL Server 2008R2 on Windows 7.
• Created different kind of reports like cascading reports, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports and charts in SSRS 2008R2.
• Excellent command on subscriptions, report snapshot and report cache.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Monitored the system utilization and checking the execution plan to improve the performance.

Environment: MS SQL Server 2008R2, MS SQL Server Reporting Services 2008R2, Integration Services SSIS , Analysis Services SSAS , T-SQL, MS Access, MS Excel, MapForce, XML Spy, Version Control, Agile Environment.

Confidential

MS SQL Server /SSAS/SSIS Developer

Responsibilities:

• Created Logical and Physical design of the data warehouse and Operational Database Store ODS in SQL Server 2008.
• Involved in requirement gathering, analysis, design, development and deployment.
• Created, deployed, and scheduled SSIS packages to run SQL tasks and make data transfer. Involved with various databases integration and data migration, such as NewScale, Liferay, VMware Center databases.
• Used the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.
• Used Event Handlers and logging for Exception Handling in SSIS packages.
• Created Data Warehouse schema to deploy fact and dimension table and defined Referenced relationships with the measure groups and fact tables.
• Created and deployed cubes in star and snowflake schema. Performed and worked with dimensions, measures, generating KPI, MDX queries.
• Designed and developed SSIS packages for loading data from ODS to Data Warehouse. Performed various SSIS transformations before loading such as Derived Column, Slowly Changing Dimension etc., which was for data scrubbing, and included data validation checks during staging.
• Created Views to reduce database complexities for the end users. Created Stored Procedures to load data in different tables.
• Performed T-SQL tuning and optimizing queries for reports that take longer execution time.
• Scheduled Jobs to run SSIS package during night time to feed DSS system for fresh day data.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.

Environment: MS SQL Server 2008, T-SQL, SQL Server Integration Services SSIS , MS Excel 2007, MS Access 2007, SQR, ACR/FCR, Management Studio, MS SQL Query Analyzer, SQL Profiler.

Confidential

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Maintained data integrity all over the database and performed normalization.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Indexes, Views, Stored Procedures, Triggers, User Defined Functions, and Jobs.
• Performed DBA roles like backups and created jobs in SQL Server.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Developed many Tabular Reports, Matrix Reports, and Drill down Reports, Sub-Reports, Drill Through, and Parameterized Reports using SQL Server Reporting Services SSRS .
• Performed T-SQL tuning and optimizing queries for reports that take longer execution time.
• Deployed the generated reports directly on the client's AT T workstation.
• Preformed QA Testing for all the Store Procedures to validate the CRM Customer Relationship Management supported by AT T.

Environment: MS SQL Server 2008, SQL server Reporting Services 2008, SQL Analysis Server 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin, Visio, C .Net, SQL Profiler.

Confidential

MS SQL Server SSRS/SSIS Developer

Responsibilities:

• From one standard database for loans created diversified destinations for auto loans, student loans, home loans using SSIS packages.
• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular loan type. Created report models for ad hoc reports when the end user wants to see the reports.
• Performed T-SQL tuning and optimizing queries for reports that take longer execution time.
• Calculates loan details for existing customers applying for a second loan based on payment history and remaining amount of loan.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler. Established backup and recovery of SQL reporting services.

Environment: MS SQL Server 2005, MS Server Integration services, DTS, SSRS, and SQL Server Profiler, T-SQL.