SUMMARY:

• 10+ years of experience in analysis, design, and development of Business Intelligence solutions. Expert in developing Confidential SSIS package to Extract Transfer and Load data between databases and different external data sources using T - SQL, SSIS, XML and SharePoint. Extensive experience in creating reports using SSRS.
• Knowledge and experience on Big Data Technologies: Hadoop, HDFS, Spark, Hive, Pig, Impala, Sqoop, Flume, Kafka, NiFi, Hbase, Predictive Analytics
• 6+ years of experience in development and testing Confidential SharePoint Server 2007/2010/2013 with in depth technical background with the SharePoint MOSS platform and WSS 3.0, including users permissions, Content types, Web Parts, Workflows, Layout and Master pages.
• Expertise in developing T-SQL (DDL, DML) queries, T-SQL programming, stored procedures, and triggers using all major SQL Server versions.
• Expertise in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS).
• Good working knowledge in designing Use Case, Class, Sequence, Collaboration, State, Component, Deployment, Activity diagrams using UML.
• Worked extensively with Language-Integrated Query (LINQ) with .NET Framework collections, SQL Server databases, ADO.NET Datasets, and XML documents.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.
• Excellent documentation skills.
• Excellent knowledge and understanding of .Net Framework.
• Reliable, efficient and experienced in working with medium to large scale teams.
• Fast learner, work well with teammates, passionate to learn new technologies and open to feedback.
• Ability to work well in a team in collaboration with developers, testers, project managers, and customers.

TECHNICAL SKILLS:

System Development Life Cycles Exposure: Rapid Application Development, Agile, Scrum, Rational Unified Process(RUP)

Enterprise Architecture: Confidential Visio for Enterprise Architects

Design: Confidential Office Visio, UML

Web Services Technology/Platforms: .NET

Programming Languages: C#, VB.NET, Java, DAX, JavaScript, HTML Transact-SQL (T-SQL).

Programming IDE: Confidential Visual Studio 2003/2005/2008/2010/2012/2013/2015, Confidential SQL Server Management Studio 2005/2008/2012/2014/2016, Eclipse

Database Platforms: Confidential Access, SQL Server 2000/2005/2008/2012/2014

BI Platform: SSIS/SSAS/Tabular Model/SSRS/Power BI

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Intelligence/Developer

• Responsibility includes in gathering requirements, creating ETL process (SSIS), creating script based business logic, loading data into data warehouse and report databases, creating SSRS reports, creating data driven subscriptions, automating the ETL process, unit tests, creating dashboard using SharePoint.

Confidential

Sr. Business Intelligence/SharePoint Developer

• Worked on Credit and Collateral Summary platform called CCMS, designed to help credit and collateral system make better use of information coming from multitude of sources.
• Supporting internal stakeholders by providing business reporting, analysis of results, identification of opportunities & successes and updates on progress toward goals and strategies.
• Analyze & validate data in partnership with the business owners to identify trends, problems areas, and opportunities for improving customer experience.
• Customizing CCMS portal site using master pages, page layouts, site definitions, and list templates. The provider portal site provides system integrators with a starting point for creating sites which enable clients to view member’s data.
• Re-engineered various features to improve product reliability and compatibility.
• Contributed to the redesign and redevelopment of various systems and scripts.
• Identified performance bottlenecks in script execution.
• Performed upfront performance and stress testing on real customer scenarios.
• Collected feedback from internal partner team members (test, development, and program management) as early as possible and looped back the feedback.
• Created and customized internal SharePoint site to track project specific activities. Created a web template and site pages, and also customized the layout of Web Part zones.
• Created a custom Report Viewer Web Part in a SharePoint application that can display data from CCMS data source.
• Installed and configured SQL Server Reporting Services in order to generate the Project status reports, and dashboards.
• Created a new SharePoint site for our team project after enabling SharePoint integration with TFS.

Confidential

Sr. Business Intelligence/SharePoint Developer

• Responsibility includes in gathering Tower data(voice and data) nationwide, creating ETL process (SSIS), creating script based business logic, loading data into data warehouse and report databases, creating SSRS reports, creating data driven subscriptions, automating the ETL process, unit tests, creating dashboard using SharePoint.
• Created a dashboard and Scorecard system which shows trend and live data about all tower information. (eg: Bottleneck time for each tower, Call drop, passing capacity limit for each tower)
• Provide in-depth analysis on the tower data and give critical and accurate information for core engineers to team for planning and forecasting purpose.

Confidential

Sr. Business Intelligence/SharePoint Developer

• Responsibility includes in architecting, designing and implementing Confidential Volume License subscription and consumption system on the back end. Creating many stored procedures, Performance tuning, fixing bugs.
• Help in designing and implementing Customer face license benefit subscription and consumption customer face applications.

Confidential

Sr. Business Intelligence Developer

• Responsibility includes in architecting, designing and implementing Confidential Volume License subscription and consumption system on the back end. Creating many stored procedures, Performance tuning, fixing bugs.
• Help in designing and implementing Customer face license benefit subscription and consumption customer face applications.

Confidential

SharePoint Developer

• Responsibility includes in preparing development, test and production Portal farm environments.
• Worked in Installing, Configuring, administrating and maintaining distinct MOSS 2007 Production and QA farms.
• Management of global rights and permissions.
• Operations support for SharePoint sites in the production environment.
• Extensive involvement in developing and maintaining Confidential Library created using SharePoint.

Confidential

Database Developer

• Responsibility includes in gathering requirements, creating ETL process (SSIS), creating script based business logic, loading data into data warehouse and report databases, creating SSRS reports, creating data driven subscriptions, automating the ETL process, unit tests.