SUMMARY

• 5+ years of IT experience in Analysis, Design, Development, Implementation of software applications to support Reporting and Business Intelligence initiatives
• Experience in developing and modifying Cubes and Dimensions in cubes using SSAS
• Experience in creating different types of reports such as drill down, drill through reports, linked reports, Click through reports, Snapshot reports.
• Experience in integrating SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Experience in creating traditional as well as web - based interactive reports using SQL server reporting services sourcing OLAP cubes and Data warehouse, Data marts as well as transactional systems
• Experience in analysis, modeling, design and development of Tableau reports and Data modeling.
• Extensive experience in Tableau desktop, Tableau server and Tableau reader in various versions of Tableau.
• Expert in designing and scheduling complex SSIS packages for transferring data manually from multiple data sources to SQL server
• Experience with Data Transformation Services(DTS) an Extract Transform Load(ETL) tool of SQL server to populate data from various data sources by creating packages for different data loading operations of each application
• Developed SSIS packages to ETL/DTS data into the data warehouse from heterogeneous databases such as Excel, MS Access, MS SQL, Oracle
• Very proficient in working with large databases in DB2, Oracle, SQL and Teradata
• Excellent knowledge in RDBMS and Data warehouse concepts

TECHNICAL SKILLS

Databases: SQL server 2005/2008/2008 R2/2012, MS Access, Excel

Database Utilities: SSIS, SSRS, SSAS, Data Transformation Services(DTS), Business Intelligence Development Studio(BIDS), Enterprise Manager, Query Analyzer, BCP, DTS Analysis Manager, SQL profiler

Languages/Scripting: C, C++, C#, Java, HTML, CSS, PHP, SQL, T-SQL

Operating Systems: Windows XP/ 2000/2003/2008, Windows 7/8

PROFESSIONAL EXPERIENCE

Confidential, NYC

MS Access/BI Developer

Responsibilities:

• Participated in Requirement Analysis study and Involved in requirements gathering.
• Worked with functional teams to define and implement migration strategies from legacy systems to new architecture and technologies.
• Designed and created a custom MS Access Application to track and report Employee data.
• Created VBA Modules and custom forms to automate the import of Vendor provided MSExcel Spreadsheets.
• This task automation reduced their Monthly Report processing from 10 days to less than a day.
• Created VBA Modules and custom forms produce weekly Excel reports for Maintenance Vendor status updates.
• Standardized Weekly Excel Reporting across multiple Vendors by using a custom Excel template that MS AccessAutomation would produce on demand.
• Created, modified existing Stored Procedures, Views, and Functions in SQL Server 2008.
• Created custom document libraries, content types and web parts for web content management in the portal sites.
• Written various Unit Test methods for testing the application.

Environment: Visual Studio 2008, ASP.NET3.5, SQL SERVER 2008, MS Access 2010

Confidential, Dallas, TX

SQL BI Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• .Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, cross tabs and charts.
• Design, deployment and maintenance of various SSRS in SQL Server 2005.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Developed complex T-SQL code for the application.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created and edited views on Tableau Server directly in the browser without the desktop tool.
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.
• Used server to Share Server Views and subscriptions
• Participated in admin activities including improving the scalability of the Tableau Server environment by distributing server components across several machines.
• Generated reports using SSRS, Powerview, and Power BI that could be used to send information to diverse group of u4sers, clients, and managers.
• Used Power BI to create PowerPivot data model and PowerView reports and dashboards and calculated

Environment: SQL Server 2005/2008R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSRS, SSAS, OLAP, XML, Tableau Server 8.3, Tableau Desktop, Power BI, Power Pivot, Power Query, SharePoint, Microsoft Visual Studio 2005, Windows XP

Confidential, Redmond, WA

SQL BI Developer

Responsibilities:

• Created Tables, Views, Indexes, Stored Procedure. Used multiple join statements to retrieve data and update the tables.
• Used SSIS to produce a Data Mart for reporting.
• Strong experience in working withBCP,SSIS(DTS,DTSX)packages forData Integration Services.
• Extensive knowledge of usingSystem Variablesand creatingUser-Defined VariablesforSSISPackages.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies using ETL tools.
• Developed and tested extraction, transformation, and load (ETL) processes
• Involved in change data capture (CDC) ETL process
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created ad-hoc reports using power BI.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services (SSRS).
• Implemented the complex query techniques of Passing Multi-Valued Parameters and cascading parameters in MDX.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Worked with Report Builder 2.0, Report Models and Ad Hoc Reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.
• Raising defects in HP ALM and analyzed the defects to assess whether code, environment, or data is the root cause.
• Implement COSMOS and migrate the current ETLs to consume big data

Environment: SQL Server 2012/2008R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS, SSAS, ProClarity, OLAP, XML, SharePoint, Agile, COSMOS/Scope, Microsoft Visual Studio 2008 w/.NET Framework 3.5, Windows XP

Confidential, Renton, WA

SQL BI Developer

Responsibilities:

• Gathered requirements from Business and documented them based on functional specifications.
• Designed and implemented complex SSIS package to migrate data from multiple data sources.
• Created SSIS package to extract, validate and load data into Data warehouse. (ETL)
• Created Stored procedure, Views, Cursors and functions to support application
• Extensively created SSRS reports (Executive Summary report for Annual and Quarterly) and Configured Report Server on all the environments.
• Also automate deployment for SSRS reports for all the environments.
• Implemented multiple grouping into several reports using visibility and toggle options.
• ETL Job daily verification.
• Good knowledge on Informatica administration work.
• Modifications to existing ETL Code and document the changes.
• Actively supported Business users for change requests and provide support to team members.
• Provided support by troubleshooting and solving the issues.
• On call for various PostgreSQL assistance.
• Wrote application for backing up a Linux operating system on a cloud virtual machine
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Configured and managed Informatica MDM
• In-depth knowledge on MDM architecture and business processes

Environment: MS SQL Server 2008 R2,SSMS 2008, Netezza,DB2, Excel, Windows 2003 Server, Windows XP Professional, Visual Studio 2008, 2010, MS Visio 2010, Informatica Power Center 8.1.1

Confidential, Chicago, IL

SQL Developer

Responsibilities:

• Determined the MS SQL Server 2005 installation options. Installed SQL Server Management tools using SQL Server Setup Program.
• Test the Installation of SQL Server and implemented different security modes.
• Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances
• Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2005.
• Experience in DTS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper mapping.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
• Migrated access objects to SQL Server 2005.
• Created Tables, Indexes and Constraints.
• Customized page layouts for Salesforce standard and custom objects.
• Configured security and organizational hierarchy for sales for salesforce implementation.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Developed DTS Packages to transform data to MS SQL Server from Excel for further analysis
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Designed DTS package, with DTS Import/Export wizard for transferring data
• Data migration (Import & Export - BCP) from text to SQL Server

Environment: MS SQL Server 2005 Enterprise Edition, Enterprise manager, MS Analysis Services 2005, MS Access 2000 & Windows NT platform, Reporting Services, DTS, Business Objects 6.5, Windows Active Directory

Confidential

Jr. SQL Server Database Administrator

Responsibilities:

• Involved as part of a team for gathering and analyzing the end User Requirements.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints.
• Created Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration, Query Performance tuning.
• Worked with DTS packages to load the data into Data warehousing system.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Trouble shooting Problems by using SQL server profiler.
• Used DBCC commands for maintaining the databases.
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Export & Import data from Flat file, CSV file to/from SQL Server Database using SSIS
• Export & Import data from/to databases like Oracle, MySQL, and Access to/from SQL Server
• Responsible for capacity planning and disaster recovery
• Scheduled jobs to automate different database related activities including backup,
• Monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Monitored Server Activity, and solved problem as needed

Environment: Microsoft SQL Server 2000/2005, DTS, Windows 2000, XP