Senior BI/DW Consultant & Software Developer #NA-1395429507

This candidate has over 16 years of in-depth, hands-on Experience in the full software development lifecycle. This candidate has extensive working knowledge as a database designer, report and ETL developer, Solid T-SQL coding, and developer skills on outstanding communications and project management experience.

With the extensive professional qualification, this candidate has been a Senior BI/DW consultant with 13 years of Experience in MS SQL Server 2012/2008 R2/2008/2005/2000 with Business Intelligence in MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS). This candidate has Excellent working experience in various industries/domains such as Financial Services, Manufacturing, Telecommunication and Construction, Retail, and IT Consulting industries. Additionally, this candidate has Experienced in interacting with Business users to perform Business Process Analysis, Re-engineering, Business Requirement gathering (BRD), System Requirement Specs (SRS) documentation, and system analysis. Excellent ability in writing specifications and gathering requirements from the user to develop Reports as per the client’s needs and maintain documentation of the reports for future reference. This candidate has unlimited expertise, including but not limited to:

• Involve in the full System Development Life Cycle (SDLC) of a Data Warehouse and responsible for designing, coding, testing, implementing, and supporting the ETL processes for data warehouse solutions
• Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server, Access, Oracle, and MYSQL Databases.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Excellent Experience in creating Indexes, Indexed Views in observing Business Rules and developing Effective Functions and appropriate Triggers to assist in efficient data manipulation and data consistency
• Experience in Logical and Physical Database design and development, Data Conversion, Normalization, and Data modeling using Erwin and SQL Server Enterprise manager
• Create T-SQL scripts to load the data to and from production servers and to the development servers
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS), and SSIS
• Experience in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services (SSIS)
• Expert in SSIS and T-SQL stored procedures to transfer data from OLTP databases to the staging area, then used various SSIS tasks such as Conditional 
• Split, Derived Column, data validation checks during Staging, and finally transfer into the data warehouse

In a recent role, this candidate Analyzed the existing Limited Partnership Control Application (LPCA) system and developed a technical specification document based on the BRD and FS. Created several database Backups, developed SQL scripts with Grant Access permission, and Updated several Stored Procedures, Functions (UDF), Views, and Tables using SQL Server 2016 / 2008 R2. This candidate was responsible for creating several data marts in SQL Server 2016. Worked on Online Portfolio (OLP) and Online Statement (OLS) applications and created several reports based on the specs and prototypes. Created Data Mapping documents to map the existing LPCA system (SQL Server 2008 R2) to the new system (SQL Server 2016). Developed several database scripts, tables, stored procedures, view and complex queries, and Migrated SQL jobs and SSIS packages from SQL Server 2008 R2 to SQL Server 2016

This candidate has Certification in:

• Certificate in Project Management
• Scrum Master Technical

This candidate also has Skills in :Windows, UNIX, TSQL, PL/SQL, XML,  MDX, Toad, MS SQL Server 2016/2014/2012/2008/2005/2000, DB2, Oracle 10g/9i/8i, SAS 9.4/9.3, Sybase, InforMaker, MS Access, Mercury Quality Center 8.2, SSIS, SSRS, SSAS, DTS, SAS, Informatica 8.2, Micro  strategy 8, SQL Query Analyzer, DQ  Analyzer, Microsoft  Share Point  2007 /  2010, Omniture 13.5/14, Discover 2.8/3.0, Site Catalyst,  SAS  –   9.1/9.2, My Eclipse 3.1, MS Visio  2003, SmartLink, ICM, Microsoft Office Suite 2002/2003/2007/2010, MS Project, MS Visio, JIRA, Service Now