SUMMARY:

• Overall 7+ Years’ experience analysis profession with excellent business knowledge and technology skills. Concentrating in Data analysis and data mining in different business domains like Finance, Retail, Manufacturing, Consulting and Academic Research.
• 4+ years of Experience in Database Design, Development and Support of Microsoft SQL Server 2005/2008/2012/2014 in Development, Test and Production Environments.
• 6+ years of Experience in data analysis, mining, modeling, visualization, reporting with various tools, such as R programming, Tableau, Excel, SSRS. Generating Business insight for strategical operation and decisions.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012/2014.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Hands on experience in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency. Efficient in creating joins and sub - queries for complex queries involving multiple tables.
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Expert in Data Extraction, Transforming and Loading (ETL) w/ SQL Server Integration Services (SSIS).
• Hands on experience with performing various SSIS data transformation tasks, Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues. Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008 R2.
• Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards. Worked on moving Tableau Dashboard from Development to Production Live Environment.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards in Tableau.
• Developed data transformation, manipulation and missing data imputation with R for different data sources and types, such as XML, JSON, web-scraped and sensor data.
• Good Statistical knowledge in Predictive modeling, such as linear regression, logistic regression, step-wise regression, auto regression, LASSO, SVM(support vector machine), knn, LDA/QDA(Linear and Quadratic Discriminant Analysis), CART (Classification and regression trees), Random Forest, Naive Bayes classifier.
• Developed time series analysis project on stock market trend analysis and operational sales forecast.
• Used market basket analysis for sales improvement and customer purchasing, generate weekly promo plan.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box. Responsible employee, also Self-motivated and detail-oriented, also a good team leader and fast-learner.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence tools

Languages: R, SQL, T-SQL, PL/SQL, Visual Basic 6.0, My SQL, VB.NET, HTML, XML

Operating Systems: Windows 95/2000/2003/ XP/VISTA/7/8/8.1/10,UNIX, LINUX

Databases: MS-SQL Server 2012/2008 R 2/2008/2005/2000, MS-Access 2007/2010

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), dashboards tools, web tools.

Reporting Tools: SSRS, SSAS, Tableau

DB Utilities and design tools: SQL Server Management Utility, SSAS Cubes, Query Analyzer, MDX scripting.

Application Software: Visual Studio, SQL dialect, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Data Analyst / SQL Server BI Developer

Responsibilities:

• Developed key insights into customer needs to support and guide corporate strategy, Analyzed and built analysis plan and push to execution.
• Found and Collect suitable data from various databases with ETL tools such as SSIS. Transformed and loaded into operational data for further analysis. Scheduled and automotive ETL packages.
• Created Complex Stored procedures, user defined Functions, Schema Binding Views. Extensively used CTE's for complex coding. Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Used Tableau to generate weekly/ monthly business insight report with various data visualization formats. Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Used Association rules in R to analyze weekly promo items and combination recommendation. Also applied other predictive modeling algorithm as required.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes specifically waterfall and Agile Scrum methodology including Analysis, Design, Programming, Testing and technical Documentation.

Environment: SQL Server, SQL Server 2012 Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), Tableau, R, MS Excel, MS Access, MS visual Studio, MS Power Point 2012.

Confidential, San Antonio, TX

Data Analyst/ SQL Server BI Developer/ Data Modeler

Responsibilities:

• The goal of this Program is to comply with Federal Reserve's annual Comprehensive Capital Analysis and Review (CCAR).
• Build & perform data mapping, data logic, data calculation, and data enrichment to create CCAR monthly, quarterly, and yearly regulatory reporting.
• Responsibilities:
• Assisted the implementation of CCAR Project Plan to predict fee revenues as part of internal forecasting and Fed’s bank stress testing.
• Built a companywide CCAR model, helping the team for building the bank's revenue projection model for internal budgeting, target and incentive setting purposes.
• Assisted delivery of business and IT aspects of the program, ensuring the projects are delivered on time and within budget, having realized the benefits to the business (Regulatory Compliance).
• Managed multiple projects in Data Sourcing and Regulatory Reporting domain. Collected consolidate & standardize data from various sources and data warehouses. Integrated data and transformed into operational form with SQL Server Management Studio and SSIS.
• Performed pre-modeling data mining and data visualization with R and Tableau to discover the modeling capability of data. Selected variables with high priority and impact to the model building.
• Managed Change Management Process, ensuring quality impact analysis is performed and that standardized methods and procedures are used for efficient and prompt handling of all changes.

Environment: R, Tableau, SQL Server Management Studio (SSMS), SSIS, OLAP, OLTP, SSRS, SQL Server Profiler, Visual studio, SQL Analyzer, Enterprise Manager and SQL Server Agent.

Confidential, New York, NY

Data Analyst / SQL Server BI Developer

Responsibilities:

• Focused on Customer behavior Analysis and Social Media Research for multiple clients with different industry such as IT software, online media and TV.
• Built theory and designed research methodology and pushed to achieve.
• Gathered and analyzed customer data from various sources like social media API, Customer survey raw file, client data warehouses via tools like SSMS, SSIS.
• Perform quantitative and qualitative market analysis with R and Tableau, provide operational support and solutions to improve efficiency and organization of the data collection process, recruitment process, client relations, and project on boarding.
• Analyze data to assess capabilities/data quality/market relevance based on prospect inquiries that come in through sales
• Review advertising trends alongside consumer insights to identify prospective media opportunities for brands and clients
• Generate market research report and presentation for clients, to present in industry-related conferences, workshops and events.
• Producing data visualizations and presentations for use by TV analytics Manager to promote the understanding of local ratings trends.

Environment: R, Tableau, SQL Server Management Studio (SSMS), SSIS, OLAP, OLTP, SSRS, SQL Server Profiler, Visual studio, SQL Analyzer, Enterprise Manager and SQL Server Agent.

Confidential

SQL Server BI/ SAS Data Analyst

Responsibilities:

• Work closely with management and end-users to create and evaluate business requirements.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
• Experience in writing custom code expressions in SSRS.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Created Report Models for Business Users to create their own reports.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or other ETL jobs didn't interfere with each other.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Monitoring the scheduled SSRS and Crystal reports. Re-running the reports in case of any failures or data mismatches.
• Involved in deploying the changes to QA, Staging and Prod environments.
• Managed off shore team in Report migration project.
• Followed agile methodology and coordinated daily scrum meetings.
• Involved in Product Releases and support calls.

Environment: SQL Server 2005/2008, Windows, T-SQL, SSRS, Share Point, BIDS

Confidential

SQL Server Developer

Responsibilities:

• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
• Wrote complex stored procedures to process employee requirement and generating records between front End and back end.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Experience in Data Modeling
• Created Users and Roles, and managed security and permission of database.
• Managed and resolved design issues during development
• Worked to establish connectivity between VB applications and MS SQL server by using ODBC

Environment: T-SQL, SQL Server, MS Access, SSMS, Windows, Visual Basic.