We provide IT Staff Augmentation Services!

Predictive Analytics Analyst (ms Sql) Resume

2.00 Rating

Blue Bell, PA

SUMMARY

  • Over 5+ of IT Experience in Software Analysis, Design and Development in Client/Server systems, Data warehousing and Business Intelligence applications.
  • Experience in requirement analysis, designing, coding, testing and evolution phases in a software development life cycle.
  • Experience in creating Indexes, Views, Triggers, Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.
  • Experience in writing Complex SQL Queries involving multiple joins.
  • Strong Knowledge of Relational Database Management System (RDBMS), OLAP&OLTP, Data Warehouse Concepts and experience wif MS SQL Server in writing T - SQL, working on SSIS, SSRS, SSAS, Data Analysis, Data Cleansing and Data Migration.
  • Highly experienced working on SQL server integration services packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing ETL Purposes across different servers.
  • Excellent 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 Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Created SSIS packages to transfer data between OLTP and OLAP Databases.
  • Experience in creating and optimizing cubes on data warehouse using SQL Server Analysis Services (SSAS) of SQL Server 2008 using star and snowflake schemas for fact and dimension tables.
  • Involved in writing MDX queries and manipulating teh multidimensional data in OLAP cubes.
  • Expertise in generating reports usingSQL Server Reporting Services (SSRS)andscheduling and deployingreports on report manager.
  • Good noledge in developing and designing reports through SSRS and Excel.
  • Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
  • Designed and developed matrix and tabular reports wif drilldown, drill through, parameterized reports, sub-reports using SQL Server Reporting Services (SSRS).
  • Enhancing teh Reports visually by adding teh visual elements like charts, graphs in SSRS reports.
  • Experience in creating Ad-hoc reports, data driven subscription reports by using report builder in SSRS 2008.
  • Good Knowledge of Normalization/De-Normalization and Data Modelling.
  • Proficient in Database Query performance optimization, debugging and performance tuning using teh Query Analyzer, SQL Profiler and SQL Server Debugger.
  • Expert in working wif trace files and execution logs.
  • Expert in database activities like database creation and maintenance, Performance Monitoring and Troubleshooting.
  • Demonstrated leadership abilities and teamwork skills as well as teh ability to accomplish tasks under minimal direction and supervision.

TECHNICAL SKILLS

Databases: MS SQL Server (2008, 2008R2, 2014), ORACLE

DWH/BI Tools: SSIS (2005, 2008, 2014), SSRS (2005, 2008, 2012), Crystal Reports, Business Intelligence Development Studio (BIDS), Visual Studio, Erwin Data Modeler.

Development skills: T-SQL, PL/SQL, SSIS/SSRS/SSAS

Languages: CICS, PL/SQL, T-SQL, OLAP, C#.NET, C++, ASP.Net. VBScripting, HTML

Reporting Tools: SQL Server Reporting Services, MS Excel

Tools: /Methodologies: MS Visio, MS Project, SQL Profiler, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Blue Bell, PA

Predictive Analytics Analyst (MS SQL)

Responsibilities:

  • Developed MS Access VBA code and SQL for teh claiming compliance application.
  • Created Technical design specification documents based on teh functional design documents and teh physical data model.
  • Supported data extraction from legacy systems into flat files for loading into Puddle claims database.
  • Developed Stored Procedures in SQL for extracting and performing data transformations on teh legacy data and load into teh claims database.
  • Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Responsible for Migrate Data from multiple sources like flat file and Excel to Single SQL Server table.
  • Used Stored Procedures, DTS packages, BCP for updating Servers.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Automated messaging services on server failures, for task completion and success.
  • Leveraged dynamic SQL for improving teh performance, and efficiency.
  • Managed teh migration of SQL Server 2012 databases to SQL Server 2014.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Developed highly efficient, complex batch T-SQL procedures and functions for serving ad hoc reports.
  • Created triggers on teh tables enforcing data validation for better quality.
  • Used different type of transformations for data conversion, sorting and cleansing teh data from different sources.
  • Used FTP and SFTP servers to transfer files to vendors.
  • Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
  • Query Optimization and Performance tuning.
  • Performed backup/ restore, database objects such as tables, procedures, triggers, constraints, Indexes and views.

Environment: MS SQL Server 2014, VBScript, HTML, Version One, JIRA, Excel Application

Confidential, Atlanta, GA

MS SQL Server Developer/ Analyst (SSIS/SSRS)

Responsibilities:

  • Installation and configuration of SQL Server 2012.
  • As aBIDeveloperanalyzed teh requirements and systematically designed teh data mart for teh online Services. Identified teh dimensions, Fact tables and designed teh data mart using star schema.
  • Worked wif end users, business analysts and application developers to identify business needs and transforming business rules to database specifications.
  • Worked in creating complex Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for teh application.
  • Partitioned Tables and Indexes to load data from OLTP to an OLAP system to transfer teh data quickly, efficiently and maintaining Integrity.
  • Developed ETL Processes using SQL Server 2012 Integration Services to migrate data from Oracle data source into a SQL Server 2012 database.
  • Created SSIS Packages by using different kind of transformations (me.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast).
  • Created Packages by testing and cleaning teh Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
  • Deployed SSIS packages across development, test and production environments using project deployment model.
  • Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data. Multi-Dimensional Expression (MDX) to access them.
  • Generate KPI for customer satisfaction survey results and disease management.
  • Created various reports like financial, audit and monitoring reports using Parameterized, Drill down and Drill through reports, Sub Reports, and charts using SSRS.
  • Generated multi parameterized reports in MS SSRS 2008 allowing users teh ability to make selections before executing reports; thus, making them user friendly.
  • Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
  • Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual client needs.
  • Deployed and scheduled Reports using SQL Server 2012 Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.

Environment: MS SQL Server 2012\2008R2, SQL Server Reporting Services(SSRS)2012, Tableau SQL Server Integration Services(SSIS),Visual Studio 2010, TFS, Erwin, Agile Methodologies, Visio, Enterprise Manager, Crystal Reports 10, SQL Server Management Studio (SSMS),T-SQL,PL/SQL.

Confidential, Austin, Texas

MS SQL Server Developer (SSIS/SSRS)

Responsibilities:

  • Worked wif end users, business analysts and application developers to identify business needs and transforming business rules to database specifications.
  • Worked in creating complex Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for teh application.
  • Partitioned Tables and Indexes to load data from OLTP to an OLAP system to transfer teh data quickly, efficiently and maintaining Integrity.
  • Created SSIS Packages by using different kind of transformations (me.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast).
  • Created Packages by testing and cleaning teh Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
  • Deployed SSIS packages across development, test and production environments using project deployment model.
  • Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Connected Tableau server wif share-point portal and setup auto refresh feature.
  • Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
  • Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data. Multi-Dimensional Expression (MDX) to access them.
  • Implementing Facts and dimensions for providing views of large sets of data.
  • Created drill down, drill through, cascading parametric and sub reports from SSAS cubes dat can be browsed on web.
  • Developed report specifications, created and modified reports using SSRS 2012.
  • Deployed and scheduled Reports using SQL Server 2012 Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.

Environment: MS SQL Server 2012\2008R2, SQL Server Reporting Services(SSRS)2012, SQL Server Integration Services(SSIS), Visual Studio 2010, TFS,ErWin,Agile Methodologies, Visio, Enterprise Manager, Crystal Reports 10, SQL Server Management Studio (SSMS),T-SQL,PL/SQL, Tableau, tableau server.

Confidential, Chantilly, VA

SQL BI Developer

Responsibilities:

  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
  • Created partition table for very large database for good performance.
  • Involved in creation of Data Warehouse Cubes in SQL Server Analysis Service (SSAS).
  • Maintained system monitoring jobs and provide high availability support.
  • Participated Databases Architecture and data modeling design.
  • Performing DBA functions, installing, configuring and supporting database systems.
  • Reported all events and requirements through established reporting mechanisms in SSRS.
  • Expertise in developing web applications in Microsoft Visual Studio 2008 using ASP.Net, C#
  • Reviewed and developed data models and database designs wif development teams
  • Wrote store procedures for some job automations.
  • Generated test data and tested database to meet teh functionalities deliverables in teh project documentation and specifications.
  • Designed and developed OLAP using MS SQL Server Analysis Services (SSAS).
  • Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2005

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, ProClarity, C#, ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential, Berkeley Hills, CA

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

  • Involved in Database maintenance plan and Implemented replication. Designed and implemented data access stored procedures and triggers for automating tasks.
  • Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve teh customer details, connection details, payment history by giving teh related parameters.
  • Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
  • Developed Stored procedures, Views, User defined functions in line wif business requirements.
  • Developed SSIS packages to automate data retrieval data from Oracle, SQL Server, Excel and Flat Files using MS Business Intelligence (BI) tool.
  • Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
  • Scheduled SSIS packages to automate incremental load of DataMart.
  • Developed, scheduled and generated variety of reports like List, Matrix, Chart and Sub Report and standard template by implementing SQL Server Reporting Services (SSRS).
  • Deployed and scheduled reports using SSRS to generate weekly and monthly reports.
  • Managed and coordinate wif remote users for change request and optimization of application.
  • Scheduled SQL Server Agent jobs, alerts and designed and implemented user log in and security.
  • Prepare technical specifications and involve in end user training during hands off phase.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS),SQL Server Analysis Services, SQL Server Reporting Services (SSRS),Business Intelligence development Studio(BIDS), HTML, PL-SQL, Visual studio 2008, SVN.

Confidential

SQL Server Developer

Responsibilities:

  • Involved in installation and configuration of SQL server 2000 on Servers.
  • Applied patches and service packs to keep teh database at current patch level.
  • Learned to Implement database standards, naming convention for teh database objects and maintain database security.
  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and functions.
  • Implemented trigger and stored procedures and enforced business rules via checks and constraints.
  • Involved in data conversions and data loads from various databases and file structures.
  • Monitor failed and long running MS SQL Server jobs.

Environment: SQL Server 2005, DTS, T-SQL, Crystal reports7, ASP.Net.

We'd love your feedback!