SUMMARY

• Highly skilled professional with deep knowledge of maintaining, organizing, implementing and developing information systems and software for training and supervising operations
• Experience in project management, personnel management and customer service in high tech environments
• Microsoft certified training in SQL Server 2008 and SSIS/SSRS/SSAS
• Proven knowledge in extracted and transformed data using SSIS in SQL Server 2008/2005, DTS in SQL Server 2000, Import, Export Data, Bulk Insert and BCP
• Substantial experience implementing data warehouse and data mart solutions with data analysis, and data modeling concepts and techniques

TECHNICAL SKILLS

Operating Systems: Linux, Unix, MS Windows, Mac

SQL Server and Database Tools: Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Analysis Services, OLAP (Online Analytical Processing), Cubes, Storage, Data Mining Models, Visual Source Safe, Enterprise Manager, Profiler and Data Transformation Services

Languages: MDX/DMX, VB.Net, VB Script, Transact - SQL, PL/SQL, XML, Python, ASP, C and C++

ETL Tools: SSIS (SQL Server Integration Services), DTS, Actian Pervasive Data Integrator (V.10), Informatica Power center 9.5

Reporting Packages: SQL Server Reporting Services (SSRS), Tableau, PowerBI, Crystal Reports, MS Excel

PROFESSIONAL EXPERIENCE

Sr. SQL Server BI Developer/Tableau Developer

Confidential, Tampa, FL

Responsibilities:

• Designed and developed theSSIS packagesto import and export data fromMS Excel, SQL Server 2005,2008,2014 and flat files like claims, membership, PCP files in MMR format and text format
• Worked on processes to load EDI 278 type files
• Developed SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 and created interface Stored Procedures used in SSIS to load/transform data to the database
• Deployed SSIS packages into production and used package configuration to export various package properties to make the package environment independent
• Worked on both project deployment and package deployment
• Created the automated processes for activities such as database backup processes and SSIS packages which ran sequentially using the SQL server agent job
• Created Error and performance reports on the SSIS Packages, Jobs, Stored Procedures and Triggers
• Worked on Tableau reports for higher data visualization
• Designed, developed and deployed reports in the MS SQL Server environment using SSRS-2008
• Flattened tables using Pivot and the Unpivot table
• Designed and created report templates, bar graphs and pie charts
• Created data driven and regular email subscriptions to send the reports to the clients via email as well as the FTP site
• Combined all the data sources into one and built Tableau dashboards based on the requirements from the users
• Implemented different functionalities using Tableau like Dual Axis, Actions, Filters, Calculated Fields and Parameters etc.
• Created server based Tableau workbooks (TWB), packaged workbooks (TWBX) and dashboards
• Worked with the end users to explain Tableau workbooks
• Trained business users on the different dashboards which were built using Tableau
• Created mail merge reports to generate and send form letters to the users
• Created reports from Web services and used MDX on Cubes in SSAS to create reports in SSRS
• Experience using tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Worked on sub reports, graphing, data drill down and data sorting/grouping and Crystal Report designs
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the reports
• Responsible for application testing, data modeling, data migration and data

Environment: MS SQL Server 2008/2005/2014 , BIDS (SSRS, SSAS, SSIS), T-SQL, DB2, MS Visio 2007/2003, Tableau, Windows 2003/2000 Advanced Server, TFS, ERwin 7.2, C#.Net 2005

SQL Server BI Developer/Tableau Developer

Confidential, Solon, OH

Responsibilities:

• Developed T-SQL queries, Triggers, Functions and Cursors
• Implemented change tracking for new features in SQL Server 2008 as per the business requirements
• Defined check constraints, Indexes, Synonyms and Views
• Developed SSIS packages to import/export data from the flat files/Excel to Excel, SQL Server and vice versa
• Implemented the package configuration using parent package variables
• Designed SSIS packages for synchronizing the data between two different servers
• Migrated data from MS SQL Server 2005 database to MS SQL Server 2008 database
• Restored development and staging databases from production backups when needed
• Used checkpoints in packages to enable the packages to run from the point of failure and also used Event Handlers
• Enhanced and deployed SSIS packages from the development server to the production server and scheduled jobs for executing the stored SSIS packages which were developed to update the database on a daily/weekly/monthly basis
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS
• Generated reports using global variables, Expressions and Functions based on the requirements in SSRS 2008
• Developed Cube from Facts and Dimensions
• Defined granularity within a measure group and Drill Through actions using SSAS
• Created calculated measures and Dimension members
• Created data visualization worksheets and dashboards as per the customer requirements
• Published Tableau extracts using SSIS
• Implemented individual Axis, Axis Blending and dual axis in Tableau
• Created Aggregates, Hierarchies, Formatting and sorting in Tableau

Environment: MS SQL Server 2008/2005, BIDS (SSRS, SSAS, SSIS), T-SQL, DB2, MS Visio 2007/2003, Windows 2003/2000 Advanced Server, TFS, ERwin 7.2, C#.Net 2005

SQL BI Developer

Confidential, Houston, TX

Responsibilities:

• Worked as part of a team for gathering and analyzing the business requirements and participated actively in designing the system database structure
• Generated reports using Global Variables, Expressions and Functions for the reports
• Created Cross-Tab, Drill-Down and Sub-reports using RDL. Promoted RDLs to reporting service server
• Worked with Report Builder to generate canned reports for the users
• Designed reports using pivot tables, bar charts, line charts and pie charts on data from cubes and SQL Server in Excel 2007
• Optimized SQL queries which resulted in substantial performance improvement for the conversion processes
• Generated multiple enterprise reports using SSRS from SQL Server database (OLTP) and included various reporting features such as groups by, Drill Downs, Drill Through, Sub-reports and navigation reports (Hyperlink) etc.
• Managed logins, roles, assigning rights and permissions
• Report parameters included single valued parameters and multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters)
• Tested the Business Objects reports and fixed any ETL issues if existed

Environment: SQL Server 2008/2005, T-SQL, ASP.NET, Windows XP/2003, Visual Studio 2010/2008/2005 , Report Builder 2.0, SQL Profiler, Team Foundation Server 2005, Erwin, SQL Server Reporting Services, SQL Server Analysis Services, Visio, VB.NET, PL/SQL

Jr. SQL Server Developer

Confidential

Responsibilities:

• Determined MS SQL Server 2000 installation options. Installed SQL Server management tools using the SQL Server setup program. Tested the installation of the SQL Server and implemented different security modes
• Created databases and objects like Tables, Views, Stored Procedures and Triggers
• Worked on client/server tools like MS SQL Server 2000 Enterprise Manager and Query Analyzer to administer SQL Server
• Worked with DTS for data movement from one or more source files like Excel, Tables, and Views to other databases or files with proper mapping
• Monitored server performance, created user logins and granted security privileges
• Wrote Stored Procedures, Functions, Triggers and called them in the Packages
• Maintained and modied tables and constraints for premium database using MS SQL Server
• Developed quality assurance strategies and test plans
• Created DTS packages using Active X tasks to migrate data from heterogeneous data sources such as MS Access and Excel etc.
• Worked extensively on BCP utilities for bulk data and image file uploading

Environment: MS SQL Server 2000 Enterprise Edition, EnterpriseMmanager, MS Access 2000 and Windows 2000 platform, DTS, Windows Active Directory