Sql Server Data

SUMMARY:

Highly motivated Business Intelligence Professional with over 7 years of experience in Data Integration (ETL), Analysis (Cubes), Reporting and Database Development along with 3 years of data visualization using Tableau and BIRST.

Hands on experience in requirement gathering/analysis, design, development, testing, and production rollover, post-production support/maintenance, documentation and end-user training.

Expert in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL DDL/DML statements for various applications.

Experience in Data warehousing such as dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables.

TECHNICAL PROFICIENCY:

Programming Languages: C#, CSS, HTML, Java Script, T-SQL, PL/SQL, MDX

Databases: MS SQL Server 2014/2012/2008 R2, MS Access, Oracle 10g/11g, MySQL

BI Tools: Tableau Desktop 9,10,10.2 Business Objects 4.0, 4.1 and SAP BI 7, SSRS, BIRST

ETL Tools: SQL Server Integration Services(SSIS), Wherescape Red

EDUCATION:

MIS,

Cameron University, OK, USA (2009)

PROFESSIONAL EXPERIENCE:

Primescape, Washington DC March 2016 – Present

BI/ Tableau Developer

Primescape deliver software applications, data services, and project management support for 21st century Digital Government initiatives domestically and to posts around the globe.

Duties and Responsibilities:

Design, develop, test, and maintain Tableau functional reports based on user requirements.

Successfully convert existing BO and SSRS reports to Tableau Dashboards using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Enhance report performances by tuning the derived tables, join structures and aggregations.

Utilize Tableau server to publish, take backups and restoration, user access and share the reports with the business users.

Hands on experience on building Groups, Hierarchies, Sets to create detail level summary reports and Dashboard using KPI's.

Manage and develop existing and new ETL processes for SQL Server reports and refreshed staging tables with ETL.

Environment: Tableau 9, 10, Business Object 5x, SQL Server 2012. SQL Server Data Tools for SSRS, Jazz source control, Github, JIRA

Leidos, Bethesda, MD September 2014 – Feb 2016

BI/ Data Warehouse Developer

Previously known as Science Applications International Corporation (SAIC), is an American defense company headquartered in Reston, Virginia, that provides scientific, engineering, systems integration, and technical services.

Duties and Responsibilities:

Implemented Slowly Changing Dimension (SCD) type 2 to maintain historical data in data warehouse using SSIS.

Created Parent SSIS Package that handles the launching of packages, the sequencing of package execution and populates global project variables used within child packages.

Successfully developed front end web based dashboard with trending data, animated pipeline charts, and demographic charts with drill downs functions that displays a breakdown of Regional/States sales, utilizing data aggregation from SQL statements using BIRST BI.

Designed and implemented a Star-Schema Data Warehouse in SQL Server that is used as a source for Reports.

Trained Business Analysts and Data Analysts on basic T-SQL query writing.

Environment: SQL Server 2012/2008 R2, T-SQL, ETL, C#, SSIS, SSRS, SSAS, MS Excel, Visual

Studio 2012/2010/2008, TFS, JIRA, Github, BIRST

Union Bank, San Diego, CA March 2012 – Aug 2014

BI/ Data Warehouse Developer

Union Bank is a full-service commercial bank providing an array of financial services to individuals, small businesses, middle-market companies, and major corporations.

Duties and Responsibilities:

Involved in complete SDLC including requirement specifications, analysis, design and development & testing of application.

Implemented Event Handlers, Error Handling and Environmental Package configuration in SSIS packages.

Analyzed database performance with SQL query manager and Optimize indexes to significantly improve queries.

Documented all packages and apply Naming Standards for future references.

Environment: SQL Server 2012/2008, T-SQL, ETL, C#, SSIS, SSRS, SSAS, MS Excel, Visual

Studio 2012/2010/2008, TFS, WhereScape Red

Ellucian, Fairfax, VA Nov 2009 – Feb 2012

SQL Server/ ETL Developer

Ellucian offers comprehensive solutions that help institutions automate the entire student lifecycle: from when a student is first recruited by an institution to relationship management after graduation.

Duties and Responsibilities:

Designed and developed the Staging Database and load sources to staging and from staging to the Destination (Entity) tables.

Developed complex T-SQL queries and design SSIS packages to load the data into warehouse.

Extracted data from Flat files, Excel, SAP, RDBS sources like Oracle and SQL Server.

Created Store Views, Stored Procedures, Functions and Triggers for retrieval and update of data in the database.

Environment: SQL Server 2008/2005, ETL, SSIS, SSRS, SSAS, MS Excel, Visual Studio 2008, TFS

Contact this candidate