We provide IT Staff Augmentation Services!

Quant Analyst Resume

Columbus, OH

SUMMARY:

  • 7+ years of IT Experience in Analysis, Design, Development, Implementation, troubleshooting and Support of Microsoft SQL Server 2012/2008R 2/2008/2005/2000 suite of products like SSRS, SSISand SSAS with various business domains like Financial, Insurance, Banking, Taxation, Utilities.
  • Excellent skills in Designing, Development, Maintenance, Implementation and Troubleshooting of applications using SQL, TSQL, PL/SQL.
  • Experience in Data migration with SSMS, Database Replication, Database Mirroring, database Recovery Models.
  • Experience in database administration, data privileges, roles, logins, Permissions, restores and backups.
  • Experience in SQL Server Agent, Monitoring jobs, SQL Server Logs and DB Email.
  • Good experience in creating Databases, Tables, Stored Procedures, Triggers, Views, User defined functions, Types, Cursors and Indexes using T - SQL.
  • Experienced in generating on-demand and scheduled reports for business analysis /management decisions using MS SQL Server Reporting Services 2012/2008R2/2008/2005 (SSRS).
  • Proven ability in generating Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals in SSRS 2008R 2/2008/2005.
  • Experience in administrating the reports and assigning permissions to the valid users for executing the reports.
  • Extensive experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Windows Performance Wizard.
  • Experience in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
  • Experience defining and building audits and controls to ensure the accuracy of the data.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Good knowledge in various stages of SDLC(Software Development Life Cycle), Software Testing Life Cycle (STLC) and QA methodologies from project definition to post-deployment documentation.
  • Strong understanding of the Agile Software Development Life Cycle Methodologies
  • Worked in an onshore-offshore project team set-up
  • Ability to work well independently and effectively in teams
  • Ability to prioritize tasks, organize, negotiate, and make important decisions.
  • Self-motivated and ability to master new technologies
  • Ability to work under pressure, meet deadlines and work extra hours when needed

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor SSIS, SSRS, Crystal Reports, Business Intelligence Development Studio, Data Transformation Services

Languages: T-SQL, JavaScript, VBScript, XML, PHP, C#, C

Database: SQL Server 2008R2/2008, 2005, 2000, MySql, MS Access

Front End: MS Visual Basic 6.0

Web Technologies: HTML, XML, JavaScript

Version Control Tools: SVN, Total Commander

Data Modeling Tools: ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1, MS Visio

Operating Systems: Windows XP, 2000, NT, Windows 2003

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization

Database Design Tools: Microsoft Visio, Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Quant Analyst

Responsibilities:

  • Operationalize existing quantitative team data analytic solutions.
  • Designed, created, developed, documented, tested and operationalize data reconciliation solutions and reports supporting quantitative investments.
  • Developed operational architectures and processes by working directly with IT systems teams.
  • Assisted the quantitative team in completing projects as needed.
  • Developed custom functions, manual running totals and complex formulas for reports.
  • Developed ETL packages with different data sources (SQL Server, Flat files, Excel source files, XML files) and loaded the data into target tables by performing different kinds of transformations using SSIS.
  • Developed SAS coding and table templates for preparing, processing and analyzing data.

Environment: MS SQL Server 2016, Visual Studio 2015, Control-M Workload Automation Tool 9.0, SAS 9

Confidential, Madison, WI

Technical Lead

Responsibilities:

  • Create technical specifications for developers.
  • Conduct peer reviews of Developers code and provide recommended changes.
  • Provide status updates on all managed projects.
  • Assisted the quantitative team in completing projects as needed.
  • Lead the design/development of new applications or modifications to existing applications.
  • Responsible for guiding the development team.
  • Assists developers in the analysis and debugging of application issues quickly and effectively.
  • Perform other duties as assigned.

Environment: MS SQL Server 2016, Visual Studio 2015, SAP BO 4.2, Power BI, SSAS, SSRS, Master Data Management

Confidential, Columbus, OH

Quant Analyst

Responsibilities:

  • Operationalize existing quantitative team data analytic solutions.
  • Designed, created, developed, documented, tested and operationalize data reconciliation solutions and reports supporting quantitative investments.
  • Developed operational architectures and processes by working directly with IT systems teams.
  • Assisted the quantitative team in completing projects as needed.
  • Developed custom functions, manual running totals and complex formulas for reports.
  • Developed ETL packages with different data sources (SQL Server, Flat files, Excel source files, XML files) and loaded the data into target tables by performing different kinds of transformations using SSIS.
  • Developed SAS coding and table templates for preparing, processing and analyzing data.

Environment: MS SQL Server 2016, Visual Studio 2015, Control-M Workload Automation Tool 9.0, SAS 9

Confidential

SQL Server Developer /BI Developer

Responsibilities:

  • Analyze, modify and create sql server agent jobs using ActiveX and T-SQL
  • Evaluate existing database structure and data and build solutions (including tables, Views, queries and stored procedures) for the new application.
  • Create Zena jobs forautomated batch processing.
  • Provide technical documentation on any modified system components.
  • Complete configuration tasks within applications admin function.
  • Implement and maintain java application components.
  • Installation, configuration and deployments to tomcat.
  • Provide support for the current system including research, system updates and validation tasks.
  • Complete configuration tasks within a web based application.
  • Assist with installation, configuration and deployment functions onTomcat server.
  • Complete research and development tasks for the Business Banking Loan Origination System replacement project as well as provide support for the current system.

Environment: MS SQL Server 2016, ASG - Zena, ActiveX, SQL Server Data Tools, T-SQL, VB.NET, C#, Windows 2000/2003 Server, XML, ADO.NET

Confidential

SQL Server Developer /BI Developer

Responsibilities:

  • Create VB macro to automate refresh of the excel reports and saving copies to the PWA (Share Point).
  • Optimize the stored procedures/views to enhance performance of SSRS/Excel/Tableau reports.
  • Verifying the SSIS connections from the local DB to PWA, and optimize the packages.
  • Design SSIS package that performs Incremental Load to update Project Web App (PWA) reporting data in a local SQL Server Database.
  • Create Databases, Tables, Stored Procedures, Triggers, Views, User Defined Functions, Cursors and Indexes using T-SQL.
  • Design and develop complex ETL structures to extract, transform, and load data from Project Online using SSIS.
  • Perform metadata validation, reconciliation and appropriate error handling in ETL processes.
  • Worked with Type 1 and 2 SCD’s, Fact Tables, Star Schema design, Operational Data Store (ODS), and other Data Warehouse concepts.
  • Create ad-hoc reports.
  • Participate in all phases of the Software Development Life Cycle - requirements, design, implementation, testing, release and maintenance.

Environment: MS SQL Server 2012, Office 365, SQL Server Data Tools, T-SQL, VB.NET, C#, Windows 2000/2003 Server, Share Point, WinSQL, XML, ADO.NET,CRM

Confidential

SQL Server Developer ETL/Report Developer

Responsibilities:

  • Develop stored procedures in SQL Server. Have extensive knowledge of SQL Server development concepts such as CTE’s, nested sub queries, indexed views, triggers.
  • Well versed in creating Dynamic SSIS packages, using containers, and variables, configuring and scheduling the packages.
  • Modified existing SSIS packages to meet current business needs.
  • Developed/Monitored ETL packages with different data sources (SQL Server, Flat Files, Excel files, Oracle, SharePoint etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Implement logging in SSIS packages.
  • Deploy SSIS packages on SSMS and schedule jobs.
  • Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven formulas, summarized and conditional formatting) using SSRS.
  • Generated different types of Reports (Tabular/Matrix) using SSRS.
  • Deploying and schedulingReports using SSRS to generate daily, weekly, monthly and quarterly reports including current status.
  • Deployed and generated reports on to the server using the Reporting Services Report Manager.
  • Created subscriptions to provide a daily basis reports.
  • Played Active part in the development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and troubleshooting.

Environment: MS SQL Server 2012, SQL Server Data Tools, Visual Studio 2012, SQL Server Reporting Services (SSRS), IntegrationServices (SSIS),T-SQL, VB.NET, C#, Windows 2000/2003 Server, Share Point

Confidential

SQL Server Developer /Report Developer

Responsibilities:

  • Develop complex PL/SQLcode for creating operational reports in Pentaho Report Designer.
  • Create core/standardized reports from reporting database(s).
  • Validating the report data and count against the legacy database and existing reports.
  • Worked on the tickets assigned and make the Operational Reports for the End-users.
  • Created report models and published on report server.
  • Prepared SQL scripts for initialization, documented the SQL scripts.
  • Wrote PL/SQL queries for data retrieval
  • Participated in staff, team, and planning meetings as needed.

Environment: Pentaho Report Designer 5.4, Navicat, Git, PL/SQL, Amazon Red Shift, Golden Gate.

Confidential

SQL Server Developer /BI Developer

Responsibilities:

  • Re-create excel reports (repoint existing report connections from PWA to local SQL DB)
  • Create VB macro to automate refresh of the excel reports and saving copies to the PWA (Share Point).
  • Verifying the SSIS connections from the local DB to PWA, and optimize the packages.
  • Design SSIS package that performs a deltasync to update Project Web App (PWA) reporting data in a local SQL Server Database.
  • Create Databases, Tables, Stored Procedures, Triggers, Views, User Defined Functions, Cursors and Indexes using T-SQL.
  • Design and develop complex ETL structures to extract, transform, and load data from Project Online using SSIS.
  • Generate data model in excel using PowerPivot table.
  • Perform metadata validation, reconciliation and appropriate error handling in ETL processes.
  • Reviewing and validating the reports after flipping to local data mart.
  • Participate in all phases of the Software Development Life Cycle - requirements, design, implementation, testing, release and maintenance.

Environment: MS SQL Server 2012, Office 365, SQL Server Data Tools, T-SQL, VB.NET, C#, Windows 2000/2003 Server, Share Point, WinSQL, XML, ADO.NET

Confidential, North Carolina

SQL Server Developer /BI Developer

Responsibilities:

  • Involved in planning, designing, and implementing application database code objects, such as stored procedures and views.
  • Participated in Source to Target mapping.
  • Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development for SQL Server 2008R2.
  • Responsible for building and maintaining SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Well versed in creating Dynamic SSIS packages, using containers & variables, configuring and scheduling the packages.
  • Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy Grouping etc. for creating many SSIS packages.
  • Designed and developed SSISpackages which transfers the data from Share Point to SQL server instance.
  • Developed/Monitored ETL packages with different data sources (SQL Server, Flat Files, Excel files, Oracle, SharePoint etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Implemented best practices to maintain optimal performance.
  • Participated in study and analyzing business requirements.

Environment: MS SQL Server 2008R2, Micro Strategy, Visual Studio 2008, T-SQL, VB.NET, Windows 2000/2003 Server, XML, ADO.NET, MS-Excel

Confidential

SQL Server Developer /BI Developer

Responsibilities:

  • Interact with the Team Lead and Team Members in understanding the business requirements.
  • Generated reports using SSRS (Sql Server Reporting Services).
  • Developed complex stored procedures, T-SQL functions, triggers and views using SQL Server Management Studio.
  • Develop complex T-SQL code for the application conversions.
  • Wrote and integrated Stored Procedures to generate the Reports.
  • Generate different types of Reports (Tabular/Matrix) using SSRS.
  • Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS .
  • Used various report items like tables, sub report and charts to develop the reports in SSRS and upload into Report Manager
  • Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
  • Created data sources, connection strings and defined the datasets for generating the report.
  • Designed and written the queries in the query builder for retrieving the data.
  • Provide production support for Reports.
  • Responsible for the analysis, design, development, debugging and successful delivery and maintenance of the proprietary application

Environment: MS SQL Server 2008R2, SSRS, Visual Studio 2008, T-SQL, VB.NET, Windows 2000/2003 Server, XML, ADO.NET, MS-Excel

Confidential, NC

SQL Server Developer /BI Developer

Responsibilities:

  • Migrate databases from Oracle to SQL Server 2012 using SQL Server Migration Assistant (SSMA).
  • Create Databases, Tables, Stored Procedures, Triggers, Views, User Defined Functions, Cursors and Indexes using T-SQL.
  • Create and update Stored Procedures, Functions, Views, Reports, SQL Jobs, SSIS Packages.
  • Work with Business Users and analysts to design and develop data requirements.
  • Developed Dynamic SQL and extensively worked on avoiding SQL injection.
  • Design and implement logical and physical databases.
  • Perform data profiling tasks in SSIS (ETL) using the Data Profile Viewer and then clean and standardize the data as appropriate for the databases.
  • Design and develop reports using TSQL hard coding and also SQL Server Reporting Services (SSRS) from a variety of data sources including Integration Services and Relational Databases.
  • Participate in all phases of the Software Development Life Cycle - requirements, design, implementation, testing, release and maintenance.

Environment: MS SQL Server 2012/2008R2 SSIS, SSRS, SSMA, Visual Studio 2008, T-SQL, C#, VB.NET, Windows 2000/2003 Server, XML, ADO.NET, ER/STUDIO, PL/SQL, MS-Excel

Confidential, Raleigh, NC

SQL Server Developer /BI Developer

Responsibilities:

  • Performed Migration of databases from SQL Server R2.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Implemented Functions, views, triggers, stored procedures, User Defined Types and enforced business rules via checks and constraints.
  • Worked on fragmentation of indexes and maintaining database size and disc space.
  • Designed SSIS (ETL) Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2008R2.
  • Performed Data profiling tasks In SSIS (ETL) using the Data Profile Viewer and then clean and standardize the data as appropriate for the Databases.
  • Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: MS SQL Server 2008R2/2005, SSIS, SSRS, Visual Studio 2008, T-SQL, Windows 2000/2003 Server, Visual Source Safe, XML, ADO.NET, ERWIN, PL/SQL, MS-Access, MS-Excel

Hire Now