| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Sql Server Power Bi Coatesville, PA Data Analysis,Business Analysis,ProjectManagement,Python,SQL,Pow Lawrenceville, NJ Power Bi Sql Server Princeton, NJ Power Bi Sql Server Trenton, NJ Oracle PL/SQL Developer Woodbury Heights, NJ Data Warehouse Sql Server Poplar Grove, PA Data Visualization Power Bi Sewell, NJ |
|
Click here or scroll down to respond to this candidateCandidate's Name
Sowjanya. TPHONE NUMBER AVAILABLEEMAIL AVAILABLESUMMARY:Over 14+ Years of IT experience in design, development in various roles with excellent experience in Business Intelligence(Reporting, Dashboards, Apps) and Data Engineering(ETL,ELT using ADF,SSIS, Azure Synapse,ADB).Hands-on experience in developing Azure Data factory(ADF) pipelines using components such as linked services, Datasets, Dataflows, Activities and Logical Apps.Strong experience of RDBMS concepts as well as Data Modeling ConceptsExtensive experience in implementing HADR solutions.Experienced in developing Power BI reports using DAX and dashboards from various Data Sources like Cube, Databases, Excel files.Good Experience in database design, data modeling, development, implementation, ETL and reporting in SQL Server 2016/2014/2008 R2.Reporting Services (SSRS), Analysis Services (SSAS) & Power BI (Power View, Power Pivot)Practical understanding of data modeling (dimensional & amp; relational) concepts like star-schema modeling, snowflake schema modeling, and fact and dimension tables.Used Power BI to prepare dashboards to create attractive visualizations.Hands-on experience in AWS cloud services like S3,EMR,EC2,RDS and Redshift.Experience and skills in Behavior Modeling, Predictive Modeling for Insurance.Experience in handling business and technical issues & communicating with both business users and technical users.Good experience in building reports with Business Objects XI 2/XI3/4.0/4.1 and Tableau desktop. Good knowledge in Spark Apache.Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.Knowledge in writing T-SQL (DDL, DML, and DCL) statementsExperience and working knowledge with Microsoft Azure Infrastructure as a Service platform, including planning, configuration, optimization, and deployment. Understands unique differences in customer/departmental needs. Used IDERA, JAMS for monitoring and automation. Used microstrategy for creating dashboards.Providing on-call support 24/7 on rotational basis for production databases on mission critical systems. Knowledge on Educational data like CDS, IPEDS, CEDS on secondary data.Developed reports using Microsoft Power BI (Desktop, Service, Mobile)Developed dashboards with Power BI which display key KPIs for business analysis and decision making. Responsible for providing SAS programming and analysis support for different phases of clinical study. Experience in building CI/CD pipelines.Used Jira as a ticketing tool to work on the assigned tasks.Azure PaaS Solutions like Azure Web Apps, Web Roles, Worker Roles, SQL Azure and Azure Storage. Expert in Implement deploy and configure Azure websites, configure diagnostics, monitoring and analytics on Azure Synapse and azure Platform along with scale and resilience for Azure Web sitesGood knowledge in Snowflake Schema concepts. Created view in snowflake and pulled into power bi to create dashboards. Good knowledge in SAP HCM and power Integration. Experience in Fog light and CIS Tools, Experience in Team Foundation Server(TFS)TECHNICAL SKILLS:Operating SystemWindows 7/Vista/XP/2000/NT, Server 2012/2008R2/2003, Exchange 2003, Linux, UNIXRDBMSMS SQL SERVER 2005/2008/2008R2/2012/2014, DB2, MS AccessLanguagesTransact-SQL, SQL and Visual BasicDatabase ToolsEnterprise Manager SQL Profiler, I-SQL, T-SQL, PL/SQL, SSIS, SSRS, SSAS, ODBC, OLTP, SQL OLEDB, ERWIN, JIRA, PSSDIAG, VISIO, IIS,HP SAN SCSI, LITE SPEED, RED GATE, VSS, BMC(MAGIC Help Desk),TFS, Double Take, SQLMON, Quest Lite speed, SQL Safe, Red gate, Tivoli, Azure.ETL ToolsSSIS, Azure Data Factory(ADF), Azure Data BricksOLAP ToolsSSAS 2008/2012/2017Reporting ToolsSSRS 2012/2017 Crystal Reports, BO-Universe, Web Intelligence, MS Excel, Tableau, Power BI.SAPBusiness Objects Lumira, HANACERTIFICATIONS:Fabric Analytics Engineer Associate [DP-600]Data Engineering on Microsoft Azure [DP-203]Querying Microsoft SQL Server 2012/2014 [70-461]Administering Microsoft SQL Server 2012/2014 Databases [70-462]Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 [70-463]Masters in Tech in DSCE from JNTU 2008.B.Tech in ECE from JNTU 2006.Linkedin - https://LINKEDIN LINK AVAILABLEPROFESSIONAL EXPERIENCE:FISCandidate's Name , Data Engineer April 2024 to PresentCreate views/DBs in snowflake. Analyze data in snowflake and ingest the data through various data sources.Developed Notebooks in Databricks for data extraction of various file formats and transforming and loading the detailed, aggregate data into Azure Data Lake and transmitting data into external data warehouses.Involved in Documentation to provide the scope of data to users.Created Tableau/Power bi reports for different campaigns. Using snowflake and Azure as different data sources to create analytics.Created Flow charts/diagrams, documentation to understand the architecture of data. Moves the data from development to production after the data/tables are approved.Good hands in use case and User story basis requirement discussion and documentations.Chess Health Solutions, NCPowerBi, Data Engineer May 2022 to Mar 2024Scheduling the pipelines based on tumbling windows for automation jobs in ADF pipeline.Worked on creating Azure Data bricks Notebooks, dataflows and integration runtimes.Created Power bi reports for different payers. Using snowflake, postgres as different data sources to create powerBi visualizations.Created Tableau reports for different Value Partners. Using snowflake, Postgres as different data sources to create tableau visualizations.Worked on SSIS packages for One health data. Developed source and analysis datasets to support the analysis of clinical trials data.Created views in snowflake dbs to improve the performance in the dashboards.AT & T Direct TV, AtlantaPowerBi, Tableau Dev Nov 2021 to April 2022Collaborated with business users, collected requests and updated the set of existing BI reports to accommodate business needs. Used snowflake, Teradata, Vertica as different data sources to create powerBi/tableau visualizations.Migrated the SAP BOBJ reports to the Powerbi paginated reports and exported these into different sources based on the user requirements.Worked on various tableau dashboards to show the AT &T mobile data usage information by using different visualization charts.Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts, Bar charts, Page Trails etcProvided production support to Tableau users and wrote custom sql to support business requirements.Worked on AWS Data pipeline to configure data loads from S3 into Redshift.Created views in snowflake dbs to improve the performance in the dashboards.Staples, MA Mar 2021 to Nov 2021MSBI, Power BIResponsibilities:Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL server. Involved in creating Azure data pipelines.Collaborated on ETL and also designed azure blob storage to retrieve and store data.Good Knowledge in Salesforce Demand Tools and the Maintenance tools.UPS, Atlanta Sep 2020 to Feb 2021MSBI, Power BIResponsibilities:Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile appsExperience in Power BI (DashBoard Reports), Power BI using MS SQL Server and in supporting services like tabular analysis services. Created custom dashboards and deployed using power bi. Involved in performance tuning and worked with sps and complex queries to analyze the data.Created stories for the tableau reports.LandrumHR Dec 2019 to August2020MSBI, Power BIResponsibilities:Worked on Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.Experienced in BI Development and Deployment of SSIS packages from MS - Access, Excel.Caterpillar, IL Nov 2018 to Nov 2019Power BI DevResponsibilities:Imported data from SQL Server DB, Snowflake DB to Power BI to generate reports. Created Dax Queries to generate computed columns in Power BI. Generated computed tables in Power BI by using Dax.Assurant, PA July 2018 to Nov2018SQL DBA/BI DevResponsibilities: Good Experience in SQL Database Administrator working on 2017 version. Involved in Migration project from 2008 to 2017 changes related to sps, views, triggers etc. Monitoring the sql health, database changes affecting during normal conditions and at time of migration. Prepared project plan, related activities. Worked on .Net and HTML scripting.Involved in migrating the reports from microstrategy to power Candidate's Name and web.GVR Greensboro, NC April 2017 to Jun 2018BI Dev/SQL DBAResponsibilities:Expert in performing installation, configuration (32bit/64bit), optimization, server builds, patches, service packs, upgrading and troubleshooting of SQL Servers in Clustered and Non-Clustered Environments. Designed, developed the customer comparison reports in MS SQL Server environment using SSRS 2012.ABA, New York, NY July 2016 to Mar 2017SAP BOBJ DevResponsibilities:Lead the development of SAP Business Objects Performance Management Solutions with Xcelsius and Design Studio.Medtronic, Edison, NJ Apr 2013 to July 2016SAP BOBJ DevResponsibilities:Worked as a BOBJ developer in developing web intelligence reports and published to the client, also analyzed existing Universe and database based on financial databases.Toyota Technical Center, Ann Arbor, MI Sep2010 to Mar 2013SAP Business Objects DevResponsibilities:Performed all data managing, data storage activities related to the development of the Business Objects solutions. |
