We provide IT Staff Augmentation Services!

Sr. Smsbi/ssis/ssrs/ssas Developer Resume

Frisco, TX

SUMMARY

  • Over 8 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008/2008 R 2/2012/2014.
  • Involved in all the phases of software development life cycle (SDLC) process.
  • Strong working experience in SQL Server and constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
  • Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
  • ETL implementation using SQL Server Integration Services (SSIS).
  • Thorough understanding of Kimball’s’ theory, KPIs, SQL Architecture.
  • Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs, database design solutions in collaboration with programming team.
  • Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
  • Strong knowledge of star schema, snowflake schema in dimensional modeling and their usage in different data modeling design.
  • Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)
  • Experienced in performing Incremental Loads and Data cleaning in SSIS. Expert in handling errors, logging using Event Handlers using SSIS.
  • Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
  • Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages.
  • Experience in creating Sub Reports, Tabular Reports, Matrix Reports, Parameterized Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS) and web reporting by customizing URL Access.
  • Worked on Reporting Services (SSRS).Created multiple reports like Drill Down, Drill through, Cascaded parameterized, parameterized, ad hoc reporting
  • Developed Crystal reports.
  • Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
  • Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C, C++, JavaScript, C++RDBMS SQL Server 2008/2005/2000 , 7.0, MS-Access, Oracle Database 11g/10g/9i, DB2, MySQL, and Teradata V2RX, Mainframes.

Front End: MS Visual Basics 6.0

Web Technologies: HTML, XML, PHP, Shell Scripting.

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista/2008, MS DOS, UNIX

Version Controlling Tools: Visual Source Safe, Clear Case

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

Web Server Technologies: IIS 5.1/6.0

Version Control: Team Foundation Server (TFS), Visual SourceSafe (VSS)Subversion.

Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

Packages: Microsoft Office 2007/2003/2000

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

PROFESSIONAL EXPERIENCE

Confidential, Frisco, TX

SR. sMSBI/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Perform data Analysis and data validation by writing SQL queries using SQL Server Management Studio, Netezza.
  • Responsible for development of the UAT scripts/ control M jobs, code fixing.
  • Obtain end user sign off and approval on captured results before deploying the code to production.
  • Analyze user requirements, functional and technical specifications, preparing test plans and writing test cases.
  • Work withBusiness users in understanding, documenting and testing their requirements.
  • Work closely with the Business Intelligence (BI) team to test reports.
  • Conduct Post deployment analysis on production server for the new code changes.
  • Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, and send mail task) and migrated data using SSIS, DTS wizard (Data Transformation Services) tool through Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot). Wrote SQL scripts using Script task to insert/update and delete data in SQL database, in creating configuration packages using C# Scripting.
  • Present defect report to the higher management.
  • Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, and expression transformations in extracting data in compliance with the business logic.
  • Create SSIS packages with error handling.
  • Deploying packages on different servers by configuring it.
  • Contribute to the test and production environment of the project after the completion of the development work assigned.
  • Managed Business Executives and met document requirements on time.
  • Create several batch files for scheduling the SSIS packages through ESP Scheduler.

Environment: MS SQL Server 2008 R2, Windows Server 2003, Enterprise manager, Query Analyzer, SSIS, SQL profiler, Performance Monitor, Query Optimizer, IIS 6.0, ETL, MS Visual Studio 2008 SAP, Netezza, BMC Control M, Microsoft Excel

Confidential, NY

Sr.SQL Server BI/ETL/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Created SSIS packages for importing the Excel layouts into the database using SSIS.
  • Loaded data from ODS to Data Warehouse using SSIS packages
  • Requirement gathering & analyze user requirements. Functional and technical specifications and writing test cases.
  • Responsible for report authoring, report management, report delivery and report security in prod and QA servers.
  • Writing adequate queries and stored procedures and other SQL server 2008 tasks to perform analysis of the industry.
  • Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Improved data load performance by analyzing database design and query plans.
  • Experience with SQL Server Reporting Services(SSRS)to author, manage, and deliver both paper-based and interactive Web-based reports.
  • Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
  • Provide database coding to support business applications using T-SQL
  • Involved in Performance Tuning using SQL Server Profiler and SQL server Hints. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.

Environment: SQL Server 2012,SQL Server R2 2012, SSIS, SSRS, SSAS, Visual Source Safe 2012, Erwin 4.0, MS Excel 2007, C#, VB.Net, Windows Server 2010.

Confidential, Deerfield, IL

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

  • Responsible for documentation of system related activities.
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
  • Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Environment: MS SQL Server2005/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, Minneapolis, MN

SQL Server Developer/SSIS Developer

Responsibilities:

  • Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
  • Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
  • Used to work on Installation, Configuring, Managing, Monitoring, Troubleshooting SQL Server 2008R2/2008/2005 on VM Ware Clustered and Standalone Environments
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
  • Used ASP.Net coding and C# to call the Stored Procedures created with T-SQL
  • Used XML and XSLT
  • Extracted data from Txt/CSV/XML/Oracle/Sybase/DB2 to SQL server.
  • Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
  • Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house by using BIDS.
  • Built Cubes with Multi Dimensions and made proper Hierarchy Relationships on Attributes. Made Partitions on Cubes with Aggregates for better Performance.
  • Worked in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Prepared various Reports by using Queries and the Data existed in the Cube for Analysis Purposes of the Organization.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
  • Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
  • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports in BIDS. Deploying and scheduling Reports using SSRS/Crystal to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Expert in automating process by Using SQL Server Agent in creating jobs and error report using Alerts, SQL Mail Agent and SMTP.
  • Handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs, Backups and restores.
  • Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: Windows 2005 R2, 2007, 2008 MS SQL Server 2003/2005/2005 R2, BIDS, Oracle, .net, Power Designer, Microsoft Outlook, Red Gate, Team Foundation Server.

Confidential

SQL Developer

Responsibilities:

  • Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
  • Handled migrations from DTS to SSIS 2005 and 2005 to 2008.
  • Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
  • Designed T-SQL scripts to identify long running queries and blocking sessions.
  • Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
  • Data migration (import & export - BCP) from Text to SQL Server
  • Error handling using Try-Catch Block
  • Normalization and De-Normalization of tables
  • Developed Backup and Restore scripts for SQL Server 2005
  • Installed and Configured SQL Server 2005 with latest service packs.
  • Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions
  • Written T-SQL queries for the retrieval of the data.
  • Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
  • Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
  • Prepared daily and weekly status reports and collaborated with other team members
  • Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
  • Customized the stored procedures and database triggers to meet the changing business rules.
  • Implemented indexes for performance tuning.
  • Data loaded into the database using SSIS 2005 from flat files.

Environment: SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, Excel, R, Tableau, SPSS.

Hire Now